Template

Supplier quote comparison template

Copy this structure into Excel, Google Sheets, or QuoteLevel. The goal is to compare the same scope, the same terms, and the same risk — not just the same total row.

Columns

ColumnWhat to enter
SupplierLegal name and quote reference.
Quote date / valid untilWhen the quote was issued and when it expires.
IncotermsEXW, FOB, CIF, CFR, DDP, DAP, plus named place.
Payment termsDeposit %, balance timing, Net 30/60.
MOQMinimum order quantity and price break.
Lead timeDays/weeks from PO to delivery.
Product subtotalMaterial, printing, finish, assembly, testing.
One-time chargesTooling, molds, plates, setup, sampling.
FreightIncluded or quoted separately; named destination.
Duty / clearanceIncluded, excluded, or estimated.
PackagingInner box, master carton, pallet, crate.
WarrantyLength and coverage.
Landed totalSubtotal + charges + freight + duty + financing.
Risk scoreMissing scope, unclear terms, lead time, warranty, validity.
Risk-adjusted totalLanded total × risk premium.
SourcePage number and snippet for every number.

Minimal version

If you only have ten minutes, use these six columns:

  1. Supplier
  2. Scope included / excluded
  3. Incoterms + freight + duty
  4. Payment terms + MOQ
  5. Landed total
  6. Open questions

How to score

Do not average your way to a decision. Use the landed total first, then apply a risk allowance for missing scope and weak terms. If two suppliers are within 3%, the decision should be about lead time, warranty, and supplier reliability — not another spreadsheet row.

Skip the spreadsheet. QuoteLevel builds this table from the supplier PDFs you already have, with source links and a printable approval report. Add it to Chrome.

Related: Comparison checklist · Landed cost formula