Compare Supplier Quotations and Build a Comparative Statement

What is a comparative statement of quotations?

A comparative statement of quotations lines up the rates quoted by each vendor for the same list of items, side by side, so the lowest comparable rate per item — and the vendor offering it — is easy to see at a glance. It's a format widely used by departments, public institutions, and purchase committees when tabulating quotations received from multiple vendors for the same purchase, alongside the broader purchase-committee procedures many organizations already follow.

CostRift builds the same kind of comparison from the files you already have — it doesn't certify or approve the result for any specific department's or tender's requirements; see what CostRift doesn't do.

What a comparative statement usually contains

• Item number, item code/description, and quantity required
• Unit of measure
• Each supplier's quoted unit rate
• Lowest comparable rate, and which supplier quoted it
• Extended cost (rate × quantity) per supplier, where quantities are known
• Remarks — missing quotes, unit mismatches, or anything needing a manual decision

How to compare multiple quotations

1. Gather the quotations you've already received — as files, or entered into a spreadsheet if they arrived by email or on paper.
2. List every item with a consistent item code or description, so the same item can be recognized across each supplier's quotation.
3. Record each supplier's quoted rate for every item, leaving it blank — not zero — for any item a supplier didn't quote.
4. Identify the lowest comparable rate per item, and flag anything that isn't directly comparable: a different unit, a different currency, or only one supplier having quoted it at all.
5. Total the extended cost once quantities are known, so the comparison reflects the actual purchase, not just unit rates.

Example comparative statement

Fictional example — three vendors (A, B, C) quoting on the same three stationery items. Vendor C didn't quote item 3, and items 1-2 show a clear winner or a tie rather than a guess.

Excel vs. an online comparison

A spreadsheet works well for a short item list and a handful of vendors — see the free Excel template for exactly that. It gets harder to maintain once the item list runs into the hundreds, more vendors need comparing at once, the same comparison has to be rebuilt for every new round of quotations, or vendors' files use different item codes and column layouts that need reconciling by hand each time. CostRift does the same matching and comparison automatically, at any list size, without rebuilding formulas.

Common issues when comparing quotations

Missing quote

A vendor didn't quote an item at all. CostRift leaves it blank and excludes that vendor from the comparison for that item — it never treats a missing quote as zero.

Inconsistent item codes

Vendors use different internal codes for the same item. CostRift matches on the identifier column you map, exact or normalized — it doesn't guess a match from a similar-sounding description.

Different units

One vendor quotes per piece, another per box or per dozen. CostRift flags the mismatch instead of silently comparing incompatible rates.

Currency differences

Vendors quote in different currencies. CostRift does not convert currencies — the item is flagged for manual review rather than shown with a false winner.

Incomplete vendor coverage

Not every vendor quotes every item. CostRift shows exactly how much of your item list each vendor actually covers, not just a single blended total.

What CostRift doesn't do

CostRift compares the quotation files you provide. It does not:

• Send requests for quotation or invite vendors
• Collect quotations from vendors on your behalf
• Read PDF, scanned, emailed, or photographed quotations
• Integrate with an ERP or government procurement system
• Generate or certify a government-compliant tender document
• Create purchase orders
• Score vendors on quality, lead time, or certification
• Convert currencies or units of measure automatically

Frequently asked questions

Prefer to start with a spreadsheet? Download the free comparative statement Excel template. Want to try it on a couple of quotations first, with no signup? Use the free supplier quote comparison tool.