Supplier scorecard template in Excel

Supplier scorecard template in Excel

Buying from a supplier who lets you down is buying twice: once when you pay, and again when the customer returns the goods, complains or walks away. Yet in most small businesses the decision to keep a supplier or drop it is made from memory, from how likeable the sales rep is, or from the last problem that happened. Deciding that way leaves the business at the mercy of chance: a cheap but unpunctual supplier can cost more than a slightly pricier one that never fails, and without a scorecard that proves it with numbers, the argument turns into one opinion against another. Evaluating suppliers is nothing more than grading them with clear rules that are always the same, so that the decision to keep, renegotiate, look for an alternative or suspend rests on data instead of gut feeling.

In this article we explain why it pays to score suppliers with a scorecard rather than an impression, what the downloadable template includes, which are the eight criteria and how to score each one from 0 to 5, how the final score is calculated and what each rating means, a worked example with its weighted values, how to compare two suppliers of the same product, the step-by-step to use it, the most common mistakes, and when it makes sense to move up to inventory software.

Why evaluate suppliers with rules instead of gut feeling

A gut feeling cannot be compared, cannot be argued with data and cannot be repeated the same way next period. If the decision to keep buying from someone depends on how you felt about the rep or on what you remember from the last order, any change of mood or memory changes the decision. A scorecard works the opposite way: the criteria are always the same, the weights are always the same, and the result can be shown to the owner and to the supplier without anyone having to take your word for it.

Grading with rules has very concrete effects. First, it forces you to look at full performance and not just price: a cheap supplier that delivers late, invoices badly or ignores an emergency ends up costing more than a slightly pricier one that delivers. Second, it turns a complaint into evidence: when you call the supplier with numbers in hand, the conversation stops being a grievance and becomes an improvement plan. And third, it leaves a record: if you later have to change suppliers, there is a history that justifies the change to the boss, the partner or anyone who asks.

What the template includes

The template is an Excel file with two sheets: one for carrying out the evaluation and one with the instructions. Everything fits on a single A4 portrait page in business grey tones, so you can print it and sign it as part of your internal control. Here is what you find in each part:

The eight criteria and how to score each one from 0 to 5

The weights that come with the template add up to one hundred percent and are spread like this: the first four criteria weigh fifteen percent each, and the next four weigh ten percent each. That split is your business policy: you can adjust it, but it is best to keep it the same for every supplier of the same product, because otherwise the scores stop being comparable.

How the final score is calculated and what each rating means

The calculation is simple and the template does it on its own. Each row multiplies the score you entered by the criterion's weight and shows the result in the Weighted column. The sheet then adds up the weighted values and divides that sum by the sum of the weights; that quotient is the final Score, which always falls between 0 and 5. Since each criterion score runs from 0 to 5, dividing the total weighted value by the one hundred percent of the weights returns the weighted average on that same scale.

With the final score ready, the sheet assigns the rating by bands. The scale that comes with the template is this:

A worked example: the supplier who landed on Good

To see the scorecard at work, picture a local business evaluating the supplier that provides one of its fast-moving products. These are the scores the purchasing manager gave, based on the deliveries, invoices and complaints of the period:

Adding the weighted values: 0.75 + 0.60 + 0.45 + 0.75 + 0.40 + 0.30 + 0.40 + 0.30 = 3.95. Because the weights add up to one hundred percent, the final score is simply 3.95 out of 5. That value falls in the band from 3.5 to less than 4.5, so the rating the sheet shows is Good. With that result, the decision chosen from the drop-down list is to renegotiate price terms and improve deliveries: the supplier stays, but with a written action plan and a date to evaluate it again.

Notice what the exercise reveals: the supplier scores five on quality and service, but loses points on price, emergencies, returns and deliveries. Without the scorecard the conversation would be "it's a good supplier" or "it's a bad supplier"; with the scorecard you know exactly what to ask for and in what order.

How to compare two suppliers of the same product

The template pays off most when you have two or more suppliers offering the same product and you have to choose. The rule is simple: use the same scorecard, with the same criteria and the same weights, for each of them, and compare the final scores. It looks like this:

Watch out for the most common trap: changing the weights for the supplier you like. If you lower the weight on deliveries for Supplier A and raise it for Supplier B, the scores stop being comparable and the scorecard loses all its value. Weights are set once, the same for everyone, and only reviewed when the business's purchasing policy changes — never to favour anyone.

Step by step to evaluate a supplier

Putting the template to work takes a few minutes if you gather the evidence before opening it. The recommended order is this:

1. Fill in the header: Supplier, Document, Period evaluated, What they sell us, who evaluates and the Date, so the evaluation is identified and not confused with another one.
2. Check that the weights add up to one hundred percent. If the total row does not balance, the warning cell will read "check the weights" and you cannot draw conclusions from the result.
3. Gather the evidence before scoring: on-time deliveries, late deliveries, complaints, invoices with errors, returns and claims from the period.
4. Score each criterion from 0 to 5 with that evidence in front of you, not with the impression of the last order or how pleasant the rep was.
5. Read the final Score and the Rating the sheet calculates on its own, and note in the Observation column the evidence that supports each score.
6. Choose the Decision from the drop-down list: Keep, Renegotiate terms, Look for an alternative or Suspend.
7. Write the action plan with this supplier in the four rows of the block: what must improve, how it will be measured and by when.
8. Sign as the evaluator and get the approval of purchasing or management, so the decision is approved and not merely noted.

Common mistakes when evaluating suppliers

• Scoring without evidence. If the score cannot be backed by deliveries, invoices or complaints, it becomes an opinion and the supplier will argue it down to nothing.
• Evaluating on price alone. A cheap supplier that fails, delivers late or ignores an emergency costs more than a slightly pricier one that always comes through.
• Not telling the supplier the result. If it never learns where it failed, it has no way to improve and the problem repeats period after period.
• Evaluating only once a year. By the time the report lands, the damage is done; such a long period lets problems slip by uncorrected.

How often to evaluate and what to do with the result

For a critical supplier — the one that provides the product your sales depend on, or the only one carrying a key item — evaluate every quarter, and six months at the very most. For suppliers of secondary products, an annual evaluation is enough. The key is not the exact frequency but that it is regular, and that the supplier knows when the next evaluation arrives.

The result is not filed away and forgotten: a concrete decision comes out of it. If the rating is Excellent, keep it and protect the relationship; if it is Good, keep it with a written improvement plan and follow-up; if it is Acceptable, negotiate firmly and start looking for an alternative; and if it is At risk, find a replacement or suspend it, depending on how much the operation relies on that supplier. In every case, the score is shared with the supplier: the evaluation is there to improve the relationship, not to keep secrets.

When to move from the template to software

The Excel template handles supplier evaluation well for a business with few suppliers or that reviews performance from time to time. It falls short when you have dozens of suppliers and want to see how each one evolves over time, when the scores should come from data already in the system — goods received, returns recorded, payments made — instead of being typed by hand, or when several people need to consult the same history without working on different copies of the file.

That is where Kardex Tauro comes in. With inventory and purchasing in the system, much of the data you type by hand today is recorded on its own: what came in, when it arrived, what was returned and how much was paid. On that base, supplier evaluation no longer depends on what someone remembers and starts resting on the real movement of the business, with each supplier's history in view when decision time comes.

If you currently keep purchasing on loose papers or in several spreadsheets that do not talk to each other, start by downloading this template and leave the first evaluation done and signed. With that orderly habit in place, the move to Kardex Tauro later on will be quick and painless.