In short

A supplier comparison sheet is one table that holds every supplier's offer against a single frozen specification, so that price, scope, lead time and evidence can be read across rows instead of argued across emails. It is a procurement document first and a scorecard second: the sheet exists to make two offers comparable, and only then to rank them.

Quotes rarely arrive comparable. One supplier prices per piece and includes packing; another prices per square metre and excludes crating; a third quotes in a different currency on a different Incoterm and calls the lead time thirty days from an order that has not been placed. Read side by side, the numbers look like a spread. They are not. Each figure covers a different purchase, and the meeting that compares them settles on the number with the most zeros missing.

01Freeze the specification before the first quote arrives

A sheet written after the quotes arrive records opinions; one written before records a specification. Put the item number, drawing revision, dimensions in millimetres, material and grade, finish, hardware and quantity into the row, then send it to every supplier.

One row per item, one column per supplier, cells short enough that a substitution cannot hide inside a sentence. When a supplier answers in prose, transcribe the answer into the cell and keep the email: the transcription makes the row comparable, the email proves what was said.

The failure this prevents is quiet. An 18 mm plywood carcass can be met by several board grades, and 'solid timber' can be met by a veneered panel with a solid lipped edge. Neither claim is false on its face; both are unverifiable until the goods land.

Decision rule: if a field cannot be defined yet, mark it open and stop the comparison at that row. A supplier who fills the blank has written your specification, and will price the version that suits their stock.

02Normalise the unit, the currency and the price basis

A price is comparable only when the unit, the currency and the delivery basis match. Fix all three in the sheet header, which travels with the row, not in the covering email, which does not.

Units are the commonest mismatch. Furniture is quoted per piece or set, tiles and slabs per square metre, worktops per square metre of slab or per finished running metre, cabinetry per running metre or per unit. State the unit and whether packing sits inside it.

The five numbers behind a quoted price, the unit each must carry, and the question that fixes it
Line Unit the sheet must state Question that fixes the row
GoodsPer piece, set, m² or running metreDoes the unit include packing, and what happens to offcuts?
PackingPer carton, crate or palletIs crating priced per item or per shipment?
ExportPer shipmentWho files the export declaration, and is it inside the price?
Freight and insurancePer shipment, named placeWhich Incoterm, and what value is insured?
Duty and destinationPer HS lineIs duty charged on goods value or on goods plus freight?

Duty rates and destination charges depend on the HS code and the importing country. Ask for the code, then confirm the rate with a customs broker in your market.

Currency needs a basis as well as a name. Quote every column in one currency, state whether the rate is fixed at order or at shipment, and print a validity date. An offer with no validity date is an opening position, not a price.

Decision rule: convert every offer to one Incoterm and one unit before comparing any figure, using a freight quote rather than an estimate.

Catalogue reference: sourcing, inspection and consolidation coordination — models, dimensions and finishes for the directions discussed above.

03The scope matrix is where quotes stop being comparable

Two quotes usually differ by an exclusion, not a discount. The unit price covers the object; the matrix covers everything around it.

Build the matrix as yes, no or not quoted for each line outside the object: crating and pallets, export declaration, certificate of origin, ISPM 15 marking on solid-wood packing, test reports, spares, drawings, the sample charge, freight and duty.

Scope lines that move a price, with what inclusion and exclusion mean in practice
Scope line If it is included If it is excluded
Crating and palletsPriced per item and listed on the packing listThe forwarder invoices the buyer later
Export declarationThe seller files and is named as exporterThe buyer needs a broker at origin before booking
Certificate of originIssued and sent with the shipping documentsA separate fee and a delay at the counter
Test reportA report number covering the exact model and thicknessThe claim is the salesperson's, not a laboratory's
Spare partsListed with quantities per cartonThe first missing hinge comes from a local merchant
Installation drawingsDimensioned and issued before productionSite work is priced again by the installer

Silence is not an exclusion. A blank cell is not quoted, and not quoted is a gap in the offer.

Decision rule: price the exclusions yourself, in the same currency, before ranking anything. An offer that leaves out crating, the export declaration and the certificate of origin is incomplete, not lower.

04Lead time needs a trigger, not a number

A lead time without a start date cannot be compared with another. Thirty days from what, counted how, paused by whom. Ask for calendar days, because two suppliers counting in working days will appear to disagree by a week.

Give each stage a trigger and a document. The trigger starts the clock; the document proves the event happened when the date slips.

Lead-time stages, the trigger that starts each one, and the evidence that fixes the date
Stage Starts when Evidence in the file
DepositFunds clear in the seller's accountBank advice with a value date
Drawing and sampleWritten approval is signed and datedApproval record with a revision number
Material releaseThe specified board or stone is booked to the orderMaterial list with a batch reference
ProductionThe line is scheduled, not merely promisedProgress note naming the start date
InspectionThe lot is complete and packedReport with lot size, sample size and AQL
ShipmentThe booking is confirmed and the cut-off is metBooking confirmation and packing list

A stage with no document is a stage with no date. The sheet should show the blank rather than accept a promise.

One interruption deserves its own row. The Spring Festival shutdown moves each year with the lunar calendar, and every factory in Foshan knows the dates months ahead. A quote issued in autumn for spring delivery should carry those dates explicitly.

Decision rule: convert every offer to calendar days from cleared deposit, then add the inspection window and the booking cut-off. Compare totals, not the production figure.

05Payment terms and Incoterms belong in the same row

Two offers on different Incoterms are two different contracts, whatever the totals say. Incoterms 2020 sets eleven rules for delivery, cost and risk; it does not set title, product compliance or packing quality.

FCA suits containerised goods handed to a carrier at a named place; FOB is written for goods loaded on a vessel and is often used loosely for containers. DDP puts duty inside the seller's number and makes the seller the importer of record, which leaves the duty line unauditable.

Payment needs the same precision. A 30% deposit with 70% before shipment by T/T is a common structure; state the percentage, the trigger for the balance and who pays the bank charges at each end. A letter of credit under UCP 600 shifts risk towards documents, adds cost and fails on the smallest discrepancy.

A clause that fits in two lines: 30% on signing, 70% against a copy of the bill of lading, bank charges shared at each end, documents issued in the names on the proforma invoice.

Decision rule: one Incoterm with one named place for every column, and a payment schedule that names the trigger, not only the percentage.

06Attach the evidence to the row it supports

A claim in a cell is worth the document behind it. A compliance claim with no document number is an unverified row, however plausible the sentence reads.

The first document is the business licence: 18-character unified social credit code, registered capital, business scope, address. It proves a registered company exists, not that it owns the factory. Check the code on the national credit register and record the date.

The second is ISO 9001, useful only with the scope line, the site address and the expiry date. A certificate for a parent company at another address says nothing about the workshop that will cut your panels.

The third is the test or inspection report. A test report must name the model, thickness and finish; a report for a series does not cover a variant. An inspection report under ISO 2859-1 must state lot size, inspection level and AQL.

Decision rule: every compliance claim carries a document number, issuing body and date, and every row carries the manufacturer's name and address even when you buy through a trading company.

07Score the sheet, then verify the two that survive

The sheet narrows the field to two. A sample, a factory visit or a pre-shipment inspection decides between them.

Compliance is pass or fail, never a mark out of ten: a supplier who cannot meet the specification does not become acceptable by being cheap or quick. Averaging a failed item into a good price gives a decision nobody can defend.

  1. Compliance: pass or fail against each specification row.
  2. Landed cost: goods, packing, export, freight and duty, in one currency.
  3. Lead time: calendar days from cleared deposit, against your delivery date.
  4. Evidence: a document number behind every compliance claim.

Mark the incomplete offers. An offer missing three or more fields ranks last whatever its total, because the missing fields are where the cost appears later. That rule holds in a meeting without weighting.

What the sheet cannot show is the factory on a bad day: the idle line, the substituted board, the packing rushed before a holiday. That is why the shortlist is two and the next step is physical. The sheet hands the purchase order its own numbers, so the inspection has something to fail against.

Decision rule: shortlist two suppliers, order a sample from both against the same drawing, and copy the sheet's dimensions, materials and packing lines into the purchase order.

What your RFQ should state

  1. One specification per row: item number, drawing revision, dimensions in millimetres, material and grade, finish and hardware.
  2. One unit per column, stating whether packing is inside the price: per piece, set, square metre or running metre.
  3. One currency for every column, with the exchange-rate basis and a validity date printed on the offer.
  4. One Incoterm 2020 rule with its named place, applied to every supplier, plus the payment schedule and the bank-charge split.
  5. A yes, no or not quoted cell for crating, export declaration, certificate of origin, test reports, spares and installation drawings.
  6. Lead time in calendar days from cleared deposit, with the inspection window and booking cut-off as separate lines.
  7. A document number, issuing body and date against every compliance claim, and the manufacturer's name and address even for a trading company.

Where this guidance stops

Questions buyers ask

What is a supplier comparison sheet?

It is a single table that holds several suppliers' offers against one frozen specification, with one row per item and one column per supplier. Each cell carries the same unit, currency and delivery basis so the offers can be read across. Its purpose is to make offers comparable before it ranks them.

How many suppliers should one comparison sheet hold?

Two is enough to test whether a specification is being read the same way, and three gives a fallback if one drops out. Beyond four, sample costs, drawing reviews and site visits multiply without changing the decision. Keep three or four active columns and record the rest as a reserve list.

Should I compare unit price or landed cost?

Landed cost, converted to the same Incoterm and the same unit. Unit price ignores packing, export documents, freight, insurance and duty, which are exactly the lines where offers diverge. Build the landed figure from the five cost rows, and keep the unit price beside it so you can see which supplier is cheap for the goods and expensive for the shipment.

What if a supplier will not fill in the template?

Record the missing cells as not quoted and treat the offer as incomplete. A supplier who will not state what the price excludes has not quoted; they have started a negotiation. You can still buy from them, but only after converting their offer yourself and confirming the conversion in writing before the deposit.

Which Incoterm should the sheet use?

One rule, named with its place, applied to every column. FCA with a named place suits containerised goods handed to a carrier; FOB is written for goods loaded on a vessel and is often used loosely for containers. DAP keeps duty and import formalities with you, which keeps the duty line auditable. Mixing rules across columns measures the terms, not the supplier.

How do I compare lead times quoted in different ways?

Convert each to calendar days from cleared deposit, then add the inspection window and the booking cut-off as separate lines. Ask which stage the supplier is counting from: order, deposit, drawing approval or material arrival. A date that starts at drawing approval depends on you, so the sheet should show that stage separately rather than folded into the factory's number.

Does a comparison sheet replace an inspection?

No. The sheet compares offers; an inspection checks goods against the approved sample, the drawing and the purchase order. A visual inspection under ISO 2859-1 confirms quantity, workmanship, dimensions, packing and marks, and cannot confirm material composition or hidden performance. Those need a laboratory test, which is a separate scope with its own cost and lead time.

Sources

  1. Incoterms 2020 rules — International Chamber of Commerce
  2. UCP 600 and letters of credit — International Chamber of Commerce
  3. ISO 2859-1 — Sampling procedures for inspection by attributes — International Organization for Standardization
  4. National Enterprise Credit Information Publicity System — State Administration for Market Regulation, China
  5. Basic importing and exporting — US Customs and Border Protection
  6. ISO 9001:2015 — Quality management systems — International Organization for Standardization
  7. GB 32100-2015 — Unified social credit code — State Administration for Market Regulation, China
  8. ISPM 15 — Wood packaging material in international trade — International Plant Protection Convention

Pages related to this guide

How this guide was checked

FS

Foshan Supply editorial team · Catalogue indexMethodology

Written in Foshan and reviewed against the catalogue and public standards on 2026-11-05. This page is a buying guide, not a quotation or a warranty. How we work.

How to cite this page: Foshan Supply, “A supplier comparison sheet that survives a meeting”, 2026-11-05, https://foshansupply.com/blog/supplier-comparison-sheet/