Skip to main content

Free Excel supplier evaluation tool

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.

What is a supplier scorecard?

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.

That discipline matters when importing from China because buyers often evaluate a supplier before they can visit the facility, observe a full production run, or verify how the company handled previous export orders. Time-zone differences, translated technical details, unfamiliar payment terms, and confusion about factory versus trading-company status create risks that a generic domestic-vendor form does not capture.

This supplier scorecard template adds those cross-border checks without pretending that a spreadsheet can prove a supplier is safe. Its purpose is to organize due diligence, expose missing evidence, and help a small importing team make the same decision consistently across candidates.

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 scoreDecision bandPractical meaning
4.20–5.00PreferredStrong evidence; suitable for preferred status subject to commercial approval.
3.50–4.19ApprovedAcceptable supplier with ordinary controls and documented follow-up.
2.80–3.49ConditionalUse only with specific corrective actions, limits, or a controlled pilot order.
Below 2.80AvoidRisk and missing evidence outweigh the current commercial case.

Step-by-step workflow

How to use this supplier scorecard template

Complete the process in order. The most important rule is to define the decision and evidence standard before seeing the final prices. Otherwise the scorecard becomes a way to justify a supplier you already prefer.

  1. 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.
  2. 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.
  3. Collect evidence from each supplier: Gather licenses, certificates, sample records, quotes, payment terms, shipment history, audit responses, and inspection evidence before assigning scores.
  4. 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.
  5. 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.
  6. 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.

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 result such as 3.87 is a structured comparison, not a scientific probability of success. Record the assumptions behind each score and discuss large differences between reviewers. Also watch for double counting: sample consistency belongs primarily under quality, while sample lead time belongs under delivery. Increasing both rows because sampling is important can unintentionally distort the model.

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.

Free template

Download the China import supplier scorecard

Enter your email and we'll send the editable Excel workbook with weighted scoring, five-supplier comparison, and bilingual instructions.

We'll send occasional import tool updates. Unsubscribe anytime.