Free Vendor Scorecard Template | Evaluation Excel

What is a vendor scorecard?

Let's be honest: most companies evaluate their suppliers based on gut feeling. Someone in procurement "knows" that Supplier A is reliable and Supplier B is a headache. But ask them to prove it with data and you'll get a blank stare.

A vendor scorecard changes that. It's a structured system for measuring supplier performance across the dimensions that actually matter — quality, delivery, pricing, responsiveness. Instead of relying on whoever shouted loudest in the last meeting, you make decisions based on numbers.

The best part? Suppliers who know they're being scored tend to perform better. It's human nature.

Why you need to start scoring your suppliers

Say you're sourcing packaging from 5 different suppliers. Two of them are constantly late, but they're also 10% cheaper than the rest. Without a scorecard, the procurement team keeps using them because the price looks good on paper. Meanwhile, late deliveries are disrupting production schedules and the operations team is furious.

A scorecard would have flagged this months ago. Here's what it gives you:

• Objectivity — you remove personal bias from vendor decisions and let the performance data drive the conversation
• A feedback loop — suppliers who receive their scores have concrete targets to improve on
• Early warning signals — a downward trend in quality or delivery shows up before it becomes a crisis
• Negotiation ammunition — "Your on-time rate dropped to 82% last quarter" is a much stronger argument than "We feel like you've been late"
• Audit-ready documentation of how and why you select the suppliers you do

Evaluation criteria that actually matter

You don't need 20 criteria. You need 4 to 6, chosen carefully and weighted based on what your business actually prioritizes.

The most common ones:

• Price competitiveness — not just the quoted price, but price stability over time, volume discounts, and whether invoices match quotes
• Quality — rejection rates, spec compliance, certifications held
• Delivery reliability — on-time delivery percentage, average lead time, consistency
• Responsiveness — how fast they reply to inquiries, how they handle problems, communication quality
• Financial health — payment terms offered, invoicing accuracy, overall stability
• Innovation — do they proactively suggest improvements, new products, better processes?

Our template lets you assign custom weights to each criterion. If quality is non-negotiable in your industry, give it 35%. If delivery speed matters most, weight that higher.

How to build your evaluation matrix

Here's how to set it up so it actually works:

1. Pick your criteria. Stick to 4-6. More than that and nobody will fill it out consistently.
2. Assign weights that add up to 100%. Example: Quality 30%, Price 25%, Delivery 25%, Service 20%.
3. Define a scoring scale — 1 to 5 is plenty. A 5-point scale forces clear differentiation without overcomplicating things.
4. Write score descriptions. What does a "3" mean for delivery? Be specific. "Delivers on time 80-90% of orders" is useful. "Average" is not.
5. Run evaluations quarterly. Annual reviews miss too much. Quarterly keeps suppliers accountable and gives you trend data.

Key KPIs to track

These are the numbers you should be pulling into your scorecard regularly:

• On-Time Delivery Rate — target above 95%. Below 90% and you have a serious problem.
• Quality Rejection Rate — anything above 2% needs investigation. Above 5% and you should be shopping for alternatives.
• Price Variance — the gap between what was quoted and what was invoiced. Surprises here erode trust fast.
• Response Time — how many hours or days to get a reply on quotes and inquiries.
• Lead Time — order to delivery, measured consistently.
• Invoice Accuracy — percentage of invoices correct on first submission. Low accuracy creates extra work for your AP team.

These KPIs also feed directly into decisions about which suppliers to invite to future requests for quotation (RFQs).

Common mistakes in supplier evaluation

The biggest one? Making it all about price. The cheapest supplier who delivers late and sends wrong specs is costing you more than you think — in rework, delays, and internal frustration.

Other pitfalls to avoid:

• Running evaluations once a year. That's a snapshot, not a trend. You need quarterly data to spot patterns.
• Using vague criteria. "Good service" isn't measurable. "Responds to inquiries within 24 hours" is.
• Not sharing results with the supplier. If they don't know their score, they can't improve. And you're missing a free performance improvement lever.
• Having no historical data to compare against. The first evaluation sets a baseline — the value comes from tracking change over time.

Download your free template

Fill in the form and get a professional vendor scorecard template in your inbox. Includes the weighted evaluation matrix, KPI tracking, and automatic charts.

Managing 50+ suppliers?

At that scale, manual scorecards become a full-time job nobody wants. See how Sourced automates supplier management — collecting performance data automatically and generating scorecards without the manual grind.