Free Supplier Scorecard Template for China Importers
Compare Chinese factories and trading companies with a weighted,
evidence-based supplier scorecard. The downloadable Excel workbook
evaluates quality, communication, delivery, cost, trade capability,
and inspection cooperation—then calculates the result automatically.
A supplier scorecard is a repeatable way to evaluate vendors against
criteria that matter to your business. Instead of choosing a supplier
because its quote is lowest or its salesperson replies fastest, you
assign a 1–5 score to defined criteria, multiply each score by its
weight, and compare the weighted results. The score does not replace
judgment; it makes the evidence and trade-offs visible.
When importing from China, record translated specifications, payment
terms, production location, and export responsibilities alongside the
score. These details help you assess a supplier before a factory visit
or production run is possible.
The spreadsheet organizes due diligence and exposes missing evidence;
it cannot prove that a supplier is safe.
Weighted evaluation model
The six supplier evaluation dimensions
The default model uses six dimension groups and 20 individual criteria.
Weights total 100%, but they remain editable because a food-contact item,
custom electronic product, and standard packaging order should not use
identical priorities. Change weights before reviewing supplier names so
a favored quote does not influence the model.
25% default weight
1. Quality
Quality covers defect and return performance, the supplier's quality
system, sampling discipline, corrective action, and control of
materials and specifications. Ask for records tied to comparable
products rather than accepting a certificate as proof of current
production performance.
Scoring guidance: A 1 means quality evidence is unavailable or recurring failures remain unresolved. A 5 requires verified records, traceability, controlled changes, and timely root-cause correction.
20% default weight
2. Communication
Communication includes written English, time-zone response coverage,
transparency about the legal entity and production role, and clear
ownership when problems occur. Fast sales replies alone are weak
evidence; technical questions and bad-news escalation are better tests.
Scoring guidance: A 1 reflects unclear answers, hidden identity, or delays beyond 48 hours. A 5 means technical details survive translation, urgent channels exist, and named owners raise problems early.
15% default weight
3. Delivery
Delivery measures on-time shipment history, production lead-time
reliability, and sample lead time. A promised date has little value
unless it is supported by capacity, material availability, and a
record of notifying buyers before a delay becomes unavoidable.
Scoring guidance: A 1 means dates routinely move after deposit or no history can be shown. A 5 requires accurate lead times, documented performance, and proactive recovery plans.
15% default weight
4. Cost and payment
This group looks beyond unit price to quotation accuracy, price
stability, tooling, packaging, and payment safeguards. Compare the
total cost under the same Incoterm and named place; otherwise a low
EXW quote can appear better than a more complete FOB offer.
Scoring guidance: A 1 includes hidden charges, unrelated beneficiary accounts, or demands for unsafe full prepayment. A 5 requires transparent quote scope, stable assumptions, and practical milestone protection.
15% default weight
5. Trade capability
Trade capability covers Incoterms knowledge, commercial invoices,
packing lists, origin documents, destination-market experience, and
shipping or packaging accuracy. Manufacturing skill does not
automatically mean the supplier can manage an export order correctly.
Scoring guidance: A 1 means unclear Incoterms and repeated document errors. A 5 requires accurate paperwork, relevant export history, and documented packaging and labeling controls.
10% default weight
6. Cooperation
Cooperation evaluates access for a factory audit, willingness to
accept product-specific pre-shipment inspection, closure of findings,
and flexibility for a safe pilot order. Resistance matters more than
polished promises because an importer needs independent verification.
Scoring guidance: A 1 means the supplier blocks inspection or demands a risky MOQ. A 5 means open access, prompt corrective action, and a realistic path from trial order to scale.
How the weighted supplier score is interpreted
The workbook multiplies each 1–5 score by its row weight and adds the
results. It waits until every criterion is completed before displaying
a final score, which prevents blank high-risk areas from disappearing
inside an apparently strong total.
Weighted score
Decision band
Practical meaning
4.20–5.00
Preferred
Strong evidence; suitable for preferred status subject to commercial approval.
3.50–4.19
Approved
Acceptable supplier with ordinary controls and documented follow-up.
2.80–3.49
Conditional
Use only with specific corrective actions, limits, or a controlled pilot order.
Below 2.80
Avoid
Risk and missing evidence outweigh the current commercial case.
Step-by-step workflow
How to use this supplier scorecard template
Define the decision and evidence standard before reviewing prices, so the
scorecard does not simply justify a supplier you already prefer.
Define the sourcing decision: Write down the product, order stage, decision owner, and whether the scorecard will approve a sample, pilot order, or ongoing supplier relationship.
Adjust weights before scoring: Keep the default weights or change them for your product risk, then confirm that all 20 criterion weights still total 100 percent.
Collect evidence from each supplier: Gather licenses, certificates, sample records, quotes, payment terms, shipment history, audit responses, and inspection evidence before assigning scores.
Score every criterion from 1 to 5: Use the same evidence standard for every supplier: 1 means high risk, 3 means acceptable with controls, and 5 means strong verified performance.
Compare suppliers side by side: Enter up to five suppliers on the Comparison sheet and review both the weighted totals and the specific criteria creating each difference.
Record the decision and review date: Document approval conditions, unresolved red flags, corrective actions, and the next review date instead of treating the score as a permanent supplier label.
Revisit the score after the sample, pilot production, first shipment,
and any serious corrective action. Supplier performance changes as order
volume, staff, materials, and production schedules change. Keep the
evidence and date with each review so a new score does not overwrite the
reason for an earlier decision.
Get comparable supplier quotes with one RFQ
Send every candidate the same request for quotation (RFQ) before scoring
cost or communication. Keep blank answers as unresolved items; a quick
“OK” does not tell you which specification the factory priced.
Copy these fields into your supplier inquiry
Your requirement
Supplier must confirm
SKU, drawing and sample version
Quoted revision; dimensions, tolerances and materials; every proposed deviation.
Trial quantity and variants
MOQ per SKU, color or size; sample price; separate trial and bulk prices.
Packaging and named delivery place
Unit/carton packing, Incoterm, included charges and exclusions.
Payment and production milestones
Deposit, balance trigger, sample approval, inspection access and quote expiry.
Example follow-up: “Please return the table with the exact values you
quoted, list any differences from drawing R2, and name the person who
will confirm open items before production.” Save the reply with the quote
date. Carry unresolved items into the scorecard decision and the
production inspection plan.
China sourcing cautions
Common supplier scorecard mistakes
Factory vs. trading company: score transparency, not the label
A trading company is not automatically a poor supplier, and a factory is
not automatically reliable. A capable trader may coordinate several
specialized factories, communicate well, consolidate orders, and manage
exports better than a small producer. The risk is misrepresentation. Ask
which legal entity signs the contract, who owns or controls production,
who buys materials, and which name appears on the payment account.
Review the Chinese business license for the legal name, Unified Social
Credit Code, registered address, and business scope. Manufacturing terms
in the scope support a factory claim, but they do not prove that your
product will be made at the location shown during a call. Score the
consistency and verifiability of the answer rather than rewarding the
word “factory.”
An audit is a snapshot, not ongoing quality control
A factory audit can verify that a facility exists, review systems, and
identify obvious capability or social-compliance gaps. It does not prove
that current materials meet specification or that your finished order is
acceptable. Old reports may cover another address, production line, or
customer scope. Confirm the report owner, date, facility, auditor, and
corrective-action closure.
Use a product-specific inspection plan for the actual order. Define
defects, sampling method, approved sample, packaging, labels, and release
conditions before production. Score audit cooperation and inspection
performance separately so a clean facility tour cannot mask failed goods.
Do not score the sample as if it were mass production
A good sample proves that someone could make one acceptable unit. It does
not prove repeatability, production capacity, incoming-material control,
or packaging performance. Keep an approved golden sample, lock the written
specification, and ask how the supplier transfers sample requirements to
production and inspection teams. Update the score only when evidence from
the pilot or bulk order supports it.
Avoid false precision and duplicated weighting
A score such as 3.87 is not a probability of success. Record assumptions
and resolve reviewer disagreements. Avoid counting the same evidence
twice: sample consistency belongs under quality; sample lead time under
delivery.
Use the scorecard before and after supplier selection
During sourcing, use the Comparison sheet to shortlist candidates on
the same evidence. Before issuing a purchase order, move the selected
supplier into the detailed Scorecard sheet and document approval
conditions. After production begins, replace assumptions with observed
sample, delivery, inspection, and corrective-action results.
For ongoing suppliers, review quarterly or after a meaningful event:
late shipment, failed inspection, material change, payment-account
change, new factory, or major volume increase. Trends matter more than
one isolated score. A supplier moving from Approved to Conditional
deserves a written recovery plan before the next deposit.