Supplier Quote Comparison: Template + Method for Small Businesses
To compare supplier quotes properly, normalize the scope first so every supplier is pricing the same thing, then compare unit prices on a like-for-like basis, then weigh the non-price factors (payment terms, validity, lead time, warranty, tax treatment) that routinely outweigh a few percent on price. The full method is below, with a copy-paste comparison table you can drop straight into Excel or Google Sheets, and a worked example where the cheapest unit price loses.
Most small businesses compare quotes by opening three PDFs side by side and looking at the totals. That's also how they overpay: the cheapest-looking quote and the cheapest quote are often different documents.
In this guide:
- Why comparing quotes is harder than it looks
- Step 1: Normalize the scope first
- Step 2: Compare unit prices, not totals
- Step 3: The non-price factors that decide it
- The copy-paste comparison template
- Worked example: three suppliers, one job
- When to automate this
- FAQ
Why comparing quotes is harder than it looks
If every supplier answered the same RFQ with the same layout, comparing quotes would be a two-minute job. In practice, you get a formal PDF from one supplier, a two-line email from another, and a spreadsheet with a logo on it from the third, all describing slightly different things. Three problems show up every time:
- Inconsistent formats. One quote is itemized to the bolt; another is a lump sum. One includes delivery in the unit price; another buries it at the bottom; the third says "ex-warehouse" in the terms and prices freight at zero.
- Different scopes. Supplier A has quoted the premium equivalent because that's what they stock. B has quoted what you asked for. C has quietly quoted a smaller quantity or lower spec, which is why their total looks so good.
- Hidden exclusions. The important number is often in the fine print: "excluding GST", "unloading by others", "prices firm for 7 days", "payment with order". None of these change the number at the top of the quote. All of them change what it costs you.
This is why experienced buyers don't read quotes top to bottom. They extract each one into the same set of columns, force every quote through the same template, and only then compare.
Step 1: Normalize the scope first
Before you look at a single price, confirm each supplier has quoted the same job. Open each quote and check, line by line:
- Same item and spec? Model numbers, grades, dimensions, standards. "Equivalent" does a lot of work in some quotes: decide whether it's genuinely acceptable before it counts as comparable.
- Same quantity? Suppliers quote in different units (per length vs per metre, per box of 50 vs per each). Convert everything to a common unit first.
- Same inclusions? Delivery, unloading, installation, consumables. Anything one quote includes and another excludes needs a dollar figure added to the cheaper-looking one.
- Same currency and tax basis? And "excluding GST/VAT" vs "including" is a 5–20% difference hiding in one word.
Where a quote is ambiguous (no lead time stated, no validity period, unclear whether freight is included), email the supplier and ask. Two sentences: "Can you confirm this price includes delivery to {site}, and confirm your lead time and how long pricing is held?" Suppliers answer these quickly. If one can't or won't clarify scope, that is itself a comparison result: a quote you can't normalize is a quote you can't safely accept.
Step 2: Compare unit prices, not totals
Totals lie. A quote for 10 units and a quote for 12 units have different totals for a reason that has nothing to do with which supplier is cheaper. Once the scope is normalized, compare on unit price, and where inclusions differ, on effective unit price: (subtotal + freight + any other charges) ÷ quantity, before tax.
Two rules here:
Use pre-tax prices for the comparison. GST, VAT and sales tax are recoverable or pass-through for most businesses, so they don't decide between suppliers, but they do muddy the totals when some quotes include them and some don't. Compare ex-tax, and record the tax treatment in its own column.
Price the whole basket, not the headline line. Suppliers know which line you'll anchor on. It's common to see the main item priced razor-thin while the accessories, consumables or freight carry the margin. If you're buying a basket, compare the basket per supplier, line by line, not the one line everyone knows you're watching.
Step 3: The non-price factors that decide it
Once quotes are normalized and unit-priced, the prices are usually within a few percent of each other. This is where the comparison is actually won or lost: the factors below routinely outweigh 2–5% on price.
| Factor | What to capture | Why it matters |
|---|---|---|
| Payment terms | Deposit required? Net 7/30/60? Payment with order? | Net-30 terms mean your customer may pay you before you pay the supplier: zero working capital. "50% deposit with order" is a cash loan from you to them. |
| Validity period | How long is pricing held? | A 7-day validity on a job your client won't approve for three weeks isn't a quote, it's a maybe. Price increases on expiry go straight to your margin. |
| Lead time | Days/weeks to delivery, and is it confirmed stock? | A supplier who's 4% cheaper but delivers in 3 weeks can cost you a penalty, a delay claim, or the job itself. |
| Warranty & returns | Duration, who handles claims, who pays freight | "Claims direct to manufacturer, freight at buyer's cost" makes you the unpaid middleman for every defect. |
| Tax treatment | GST/VAT included or excluded, registered or not | An unregistered supplier's price has no input credit to claim, so factor that into the real cost. |
| Minimum order / rounding | MOQ, pack sizes, cutting charges | Quoted per-metre but sold in 6m lengths? You're buying the offcut. Round every quote up to what you'd actually have to purchase. |
Score these alongside price, not after it. The simplest honest approach: for each supplier, write down the effective unit price and one line per factor above. The winner is usually obvious from that sheet, and it's often not the cheapest number on it.
The copy-paste comparison template
Here's the comparison table in full. Select it, paste it into Excel or Google Sheets, and fill one row per item per supplier: a three-line quote from three suppliers is nine rows. One row per line item (rather than one per quote) is what lets you spot a supplier who's cheap on the headline item and expensive on everything else.
| Vendor | Quote # | Date | Item / Description | Qty | Unit Price | Subtotal | Tax / GST | Total | Currency | Payment Terms | Validity | Lead Time | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acme Supplies | Q-1042 | 2026-01-12 | 5.5kW split system | 12 | 685.00 | 8,220.00 | 822.00 | 9,042.00 | AUD | 50% deposit, balance on delivery | 14 days | 2–3 days | Delivery $180 extra |
| Bayside Trade | BT-2210 | 2026-01-13 | 5.5kW split system | 12 | 698.00 | 8,376.00 | 837.60 | 9,213.60 | AUD | Net 30 account | 30 days | 4–5 days | Free delivery over $5k |
| Coastline Wholesale | CW-0891 | 2026-01-13 | 5.5kW split system | 12 | 672.00 | 8,064.00 | 830.40 | 8,894.40 | AUD | Full payment with order | 7 days | 2–3 weeks | Ex-warehouse; freight $240 |
A few setup notes for the spreadsheet version:
- Make Unit Price the pre-tax, delivered-equivalent price where possible (add freight into it) so it's genuinely comparable, or add a computed effective unit price column: (Subtotal + freight + extras) ÷ Qty.
- Use the Notes column for exclusions and fine print; that's the column that reads back as money six weeks later.
- One tab per job or RFQ. Over a year, those tabs become your pricing history: what you paid, from whom, and whose validity promises held up. That history is worth real money at renegotiation time.
Worked example: three suppliers, one job
Say you're an HVAC contractor and you've won a 12-unit install. You need twelve 5.5kW split systems, and three suppliers come back with the quotes from the template above. Here's how the comparison runs.
Round 1 — the totals. Coastline at $8,894.40 looks cheapest. Bayside at $9,213.60 looks dearest. Stop here and you'd order from Coastline, pleased about saving $319.
Round 2 — normalize. Coastline's quote says "ex-warehouse", so add the $240 freight: pre-tax subtotal $8,064 + $240 = $8,304, tax $830.40, real total $9,134.40. Acme adds $180 delivery: real total $9,240. Bayside's $9,213.60 stands as quoted. The spread is now $106, not $319.
Round 3 — effective unit price. Divide through by 12:
- Acme: $8,400 ÷ 12 = $700.00 per unit, delivered
- Bayside: $8,376 ÷ 12 = $698.00 per unit, delivered
- Coastline: $8,304 ÷ 12 = $692.00 per unit, delivered
The "cheapest" quote is now $6 per unit cheaper than Bayside: 0.9%. And here's what that 0.9% costs:
- Cash flow. Coastline wants full payment with order: $9,134 out of your account before anything ships. Bayside's net-30 account means you install, invoice your client, get paid, and then pay the supplier. For a small contractor, that's the difference between the job funding itself and you funding it.
- Validity. Coastline's pricing is held 7 days. Your client's variation approval will take longer than that, and if the quote expires, the re-quote can move against you after you've already committed to your price.
- Lead time. Coastline quotes 2–3 weeks. Your install is booked. A slip here doesn't cost 0.9% — it costs a rescheduled crew, a penalty conversation, or the client's confidence.
- Warranty. Coastline pushes claims back to the manufacturer with freight at your cost. Bayside handles claims in-house. One dead compressor in year two and the 0.9% is gone several times over.
Bayside wins at the second-highest headline total. This isn't a contrived edge case — it's what comparison looks like once quotes are normalized. The cheapest unit price lost on terms, and it wasn't close.
When to automate this
The method above is honest work, and for two or three quotes a month it's fine as-is. The breaking point isn't the comparing — it's the retyping. Every quote arrives as a PDF or an email, and before the method can start, someone has to key twenty fields per quote into the sheet, including the fine print. That's the part that quietly stops happening when you're busy, and it's where transcription errors creep in: a transposed digit in a unit price is a decision made on wrong data. Past a few comparisons a month, or quotes with more than a handful of line items, the manual extraction costs more time than the comparison itself.
That's the specific problem ProcureMind was built for. It's a Chrome extension that reads supplier quotes, POs, BOMs and RFIs directly from your Gmail (Outlook and OneDrive too), extracts 23 structured fields (vendor, quote number, dates, line items, quantities, unit prices, tax, totals, payment terms, validity, lead time) with a confidence score on every field so you can see what needs a second look. You review and edit everything before it's saved, then it appends clean rows to your Google Sheet or Excel Online, in the same columns as the template above. The fine-print fields that decided the worked example (terms, validity, lead time) land in the sheet instead of staying buried in a PDF. The Gmail integration takes about two minutes to set up, and the free plan covers 25 extractions a month, no credit card. If you want to see the extraction itself first, we wrote up how to extract data from supplier quotes in detail.
The comparison method stays the same either way. Automation just removes the part that was never a good use of your evening.
FAQ
What is a supplier quote comparison template? A standardized table that forces every quote into the same columns (vendor, quote number, date, item, quantity, unit price, subtotal, tax, total, currency, payment terms, validity, lead time and notes) so quotes in different formats can be compared line by line. The point isn't the spreadsheet; it's that no quote gets to hide a difference in scope, freight or terms behind a friendlier layout.
How do I compare quotes from suppliers fairly? Normalize first, compare second. Confirm every supplier quoted the same item, spec, quantity and inclusions; convert to a common unit and a pre-tax basis; compare effective unit prices including freight; then weigh the non-price factors: payment terms, validity, lead time, warranty and minimum orders. Comparing totals before normalizing scope is how the wrong supplier wins.
Should I always take the cheapest quote? No — the cheapest unit price is regularly the most expensive decision. A supplier who's 2% cheaper but demands payment with order, holds pricing for 7 days, and delivers in 3 weeks can cost you more in cash flow, re-quotes and delays than the 2% saves. Compare on effective delivered price, then let the terms decide between quotes within a few percent of each other.
What's the difference between comparing unit prices and comparing totals? Totals mix price with scope: different quantities, inclusions and tax treatment. Unit prices strip that out, especially effective unit price, which adds freight and charges back in and divides by quantity. Compare totals only after confirming the scopes are identical, which in practice means comparing unit prices first.
How do I handle quotes in different currencies or tax treatments? Convert everything to one currency at the same day's rate, and compare all quotes pre-tax, since GST, VAT and sales tax are usually recoverable and don't differ between suppliers economically. Record tax treatment as its own column anyway: an "excluding GST" quote looks artificially cheap next to an inclusive one, and an unregistered supplier offers no input credit to claim.
When is it worth automating quote comparison? When the retyping costs more than the thinking. If you compare quotes more than a few times a month, or they arrive with dozens of line items, extraction tools that read the quote from your inbox and write structured rows straight to your comparison sheet pay for themselves in the first week, and they don't transpose digits.
Stop retyping supplier quotes. ProcureMind reads quotes from your Gmail, extracts every field, including the payment terms, validity and lead time that actually decide comparisons, and appends clean rows to your Google Sheet or Excel Online for you to review first. Free plan: 25 extractions a month, no credit card. Start free.