What belongs in an RFQ comparison template (most templates miss half of it)
Most "RFQ templates" you find online are empty grids with a header row. They look fine until you try to compare five quotes from four countries in three currencies with different MOQs. Then the grid either breaks or quietly misleads, and you pick the wrong supplier.
A template that survives real use has three layers, not one.
Layer 1: Raw data capture. One row per supplier, columns for every field a supplier might quote: unit price (with tier), MOQ, lead time, payment terms, Incoterms, certifications, sample cost, tooling cost if any, warranty, quoted validity period, currency. If a field is blank, show it as blank, do not force conversion here. This is the source-of-truth layer. Anything you do later must trace back to a cell in this tab.
Layer 2: Normalization. A derived tab where every quote is translated to a common basis: "price per unit at your target annual volume, delivered to your dock, in your currency, at the FX rate on a specified date, after adjusting for payment-term cost at your internal cost of capital." One row per supplier, same columns, different numbers. This is the layer where comparison becomes valid.
Layer 3: Weighted scoring. Your criteria weights applied to the normalized data, producing a 0-100 score per supplier plus a decomposition showing which criteria contributed what. The final ranking lives here; the negotiation levers (which supplier is weak on which criterion) also live here.
Most templates collapse these three layers into one. That is why they feel fine with three suppliers and break at eight. The discipline of keeping raw → normalized → scored separate is what makes a comparison audit-defensible when finance or legal asks why you picked the number-2 price.
Our template (downloadable below) has the three layers split into three tabs, with formulas wired so the only thing you update is the raw-data tab. Everything else recomputes.
| Criterion | Wt. | Supplier A | Supplier B | Supplier C |
|---|---|---|---|---|
| Unit price | 30% | 7 | 9 | 6 |
| Lead time | 20% | 8 | 6 | 9 |
| MOQ fit | 15% | 9 | 5 | 7 |
| Certs/quality | 20% | 8 | 7 | 9 |
| Payment terms | 15% | 6 | 8 | 7 |
| Weighted total | 7.55 | 7.25 | 7.50 |
Scores 1-10 per criterion · weighted totals pick Supplier A · tweak weights to reflect your priorities.
The 10 criteria that actually matter (and why not 50)
Academic templates list 30-50 criteria. Nobody uses them. The ten below are what buyers actually compare in real sourcing decisions.
1. Price per normalized unit. Landed cost at your volume, your dock, your currency. Not the headline quote.
2. MOQ and tier structure. Minimum order and how unit price changes with volume. A supplier with a €0.50 quote at 50k MOQ is not cheaper than €0.55 at 10k if your annual volume is 15k.
3. Lead time (production + shipping). Days from PO to your warehouse. Include realistic shipping, not promised. Ask for a range, not a point estimate.
4. Payment terms. Net 30 vs 100% in advance is a cash-flow difference worth 2-5% of quote value at normal cost of capital. Calculate it.
5. Quality certifications. Which the supplier holds, verified against the issuing registry. Pass/fail per certification.
6. Production capacity fit. Supplier's declared capacity vs your annual volume. A supplier at 80% utilization against your demand is a delivery risk.
7. Geographic and logistics factors. Port of origin, customs processing time, tariff/duty exposure, Incoterms offered. For EU buyers sourcing Turkey, customs-union status eliminates duty on most industrial goods; for China, full duty plus 2-3 weeks of EU customs clearance.
8. Financial health of supplier. Credit bureau rating or at least filed financial statements inside 18 months. Weight this higher for strategic relationships.
9. Warranty and quality cost coverage. Defect-rate guarantees, replacement terms, shared cost of quality escapes. A 5% higher quote that includes 2% scrap coverage is cheaper than a low quote with no coverage.
10. Responsiveness and communication. Soft, but real. How many business days to reply to RFQ? Did they answer the questions asked? Did they proactively flag ambiguities? A supplier who goes silent during quoting is going silent during delivery.
Keep it to ten. Every criterion you add dilutes the signal and adds review time. If a criterion is not going to move a decision, cut it.
| # | Criterion | Basic Excel grid | Procurea's template |
|---|---|---|---|
| 1 | Price per normalized unit | Manually typed | Auto: volume × FX × Incoterms |
| 2 | MOQ & tier structure | Single column | Tier-aware formula per volume |
| 3 | Lead time | Days only | Production + shipping + variance |
| 4 | Payment terms | Text field | NPV at your cost of capital |
| 5 | Quality certifications | Typed list | Pass/fail gate + IAF registry link |
| 6 | Weighted scoring | None or broken | 3 presets, locked weights, audit log |
| 7 | Incoterms normalization | Ignored | Freight + duty added per origin |
| 8 | Financial health | Not captured | D&B / Creditsafe field + threshold |
| 9 | Warranty coverage | Text notes | Defect % × annual volume cost |
| 10 | Responsiveness | Subjective | Days-to-first-reply, auto-timestamped |
A missing certificate never drops a good maker. It lowers a score, and the score is a number you can argue with.
How to weight the criteria, three preset templates
Weights are where templates go wrong most often. Equal weights (10% each across 10 criteria) seem fair and are almost always wrong, not every criterion is equally load-bearing for every decision. Three preset weightings cover 80% of real sourcing scenarios:
Cost-first (commodity, high volume, low risk). Price 40%, MOQ fit 10%, Lead time 10%, Payment terms 10%, Certifications 10% (pass/fail gate), Financial health 5%, Capacity 5%, Logistics 5%, Warranty 3%, Responsiveness 2%. Use for standard commodity purchases where the goods are interchangeable and the margin pressure is high.
Quality-first (regulated industries, critical components). Price 20%, Certifications 20% (weighted scoring beyond pass/fail), Quality/warranty 15%, Financial health 10%, Capacity 10%, Lead time 10%, Responsiveness 5%, MOQ 5%, Payment 3%, Logistics 2%. Use for medical devices, automotive safety-critical parts, pharma, aerospace.
Risk-first (new suppliers, geopolitically sensitive categories). Financial health 20%, Certifications 15%, Logistics/geographic 15%, Price 15%, Capacity 10%, Lead time 10%, Warranty 5%, Responsiveness 5%, MOQ 3%, Payment 2%. Use for new supplier qualification, China+1 entries, or any category where a supplier failure is more expensive than a few percent price premium.
Important: weights are internal decision inputs, not conversation points with the supplier. Sharing specific weights invites gaming, suppliers will optimize their quote to hit your known scoring function rather than to offer their genuine best price. Share the criteria you are looking at; keep the weights private.
One more rule: weights should total 100%. If you cannot make ten criteria sum to 100% with intuitive numbers, you are overweighting something. Force the discipline.
Handling non-comparable quotes (different MOQ, currency, Incoterms)
The hardest part of comparison is when quotes are structurally different. Four normalizations handle 90% of the mess.
MOQ and tier normalization. Translate every quote to "price per unit at your target annual volume." Supplier A: €0.50 at 50k MOQ (you buy 15k, so effectively you are locked to an unused 35k worth of capacity or you do not qualify for the price). Supplier B: €0.55 at 10k MOQ, €0.52 at 25k. Your 15k buys at €0.55 from B or at €0.50 from A only if you commit to 50k annual volume. In the comparison template, show both numbers: price at quote MOQ and price at your actual volume. The gap reveals the real cost.
Currency normalization. Pick a reference currency (usually your reporting currency), a reference FX date, and a reference rate source (ECB daily rate is the EU standard). Apply consistently to all quotes. Then, and this is the subtle part, apply a volatility haircut to non-reporting-currency quotes. A Turkish lira quote should be scored with a 3-5% discount on "price" to reflect the near-certain renegotiation pressure at 6-12 months. A US dollar quote for a euro buyer gets a 1-2% haircut. Your CFO will respect you for this.
Incoterms normalization. Translate every quote to DAP (Delivered at Place) at your dock, or to DDP if you want duty-inclusive. An FOB Istanbul quote needs shipping, insurance, inland EU transport, and customs clearance added; an EXW quote adds the same plus export handling. Get real logistics estimates, not "4% of invoice" shortcuts, from your freight forwarder for each origin port.
Payment-terms normalization. Translate payment terms to net-present-value at your cost of capital. 100% advance vs Net 60 on a €100k order at 8% cost of capital is worth about €1 200 of real cash-flow value. Not huge per order but material across a category. Add this as a line in the normalized tab.
Once all four normalizations are applied, the scoring formula actually reflects reality. Before them, you are comparing apples to oranges in a spreadsheet that pretends they are both numbers.
When Excel breaks (and what replaces it)
Three specific breaks happen, reliably:
Break 1: Supplier count above 15-20. Manual quote entry into the raw tab is 20-30 minutes per supplier. At 20 suppliers that is a full work day of data entry before you have done any analysis. Copy-paste errors compound; one wrong decimal and the whole scoring is wrong. If your campaigns regularly land 20+ quotes, you have outgrown Excel.
Break 2: Multi-round negotiation. The first round of quotes is fine in Excel. The second round (after you ask each supplier to revise) means another 20 suppliers × 20 minutes. The third round is usually when buyers give up on comparison and just pick someone. Real procurement platforms handle quote versioning natively, every revision is timestamped and the comparison updates automatically.
Break 3: Audit trail requirements. "Why did we pick supplier 3 over supplier 1 if supplier 1 had a lower price?" is a legitimate finance question. In Excel, the answer lives in someone's head or in comments in a spreadsheet. Under CSDDD and procurement policy requirements in 2026, you need dated, signed, versioned decision trails. A spreadsheet cannot provide that without heroic discipline.
Replacement options: (a) full S2P platforms (Ariba, Coupa, Jaggaer) for enterprise scale; (b) AI sourcing platforms with built-in comparison (Keelvar, Vendr) for mid-market; (c) dedicated e-sourcing tools (Scanmarket, Market Dojo) for pure RFQ use. For mid-market, option (b) is usually the rational pick because you get discovery plus comparison in one tool rather than maintaining two.
The template below is the right tool for 5-15 suppliers per campaign with manageable round counts. Past that, migrate.
472 suppliers across 8 briefs, 1053 rejections still on the record with the reason each one was given.