A scorecard condenses many measures into one view of performance. Done well, it focuses attention. Done badly, it creates arguments about the formula instead of the results. These steps help you build one people accept.
1. Choose few, controllable KPIs
Pick four to seven measures that reflect the goals of the role and that the person can influence. Include a mix of outcome measures (such as sales achievement) and driver measures (such as coverage or calls completed).
2. Define each KPI precisely
Write down the formula, the data source, the owner and how often it is refreshed. “Collections” should specify whether it is cash received or invoices cleared, and by which date.
3. Set weights that reflect priorities
Weights are a statement of what matters. If sales achievement is the main goal, give it the largest share, but avoid a single KPI above about half the total, or the rest will be ignored. Weights should add up to 100%, or be normalised automatically.
4. Handle direction correctly
For measures where higher is better, achievement is actual ÷ target. For measures where lower is better, such as returns or complaints, use target ÷ actual. Mixing these up is the most common arithmetic mistake in scorecards.
5. Cap over-achievement
Without a cap, one exceptional KPI can compensate for failing the others. Many organisations cap individual scores at around 120%, and some cap lower. Whatever you choose, document it up front.
6. Publish the rules before the period starts
People accept a result more readily when they knew the rules in advance. Share the KPI definitions, targets, weights and caps at the start, and change them only through a clear process.
7. Add commentary, not just a score
A score of 87% tells a manager little. A line explaining which KPI pulled it down, and what is planned, turns a number into a conversation.
A worked example
Here is a scorecard for a fictional regional sales role with four KPIs. The score for each line is its achievement multiplied by its weight.
| KPI | Weight | Target | Actual | Achievement | Score |
|---|---|---|---|---|---|
| Sales value | 40% | 1,000 | 1,100 | 110% | 44.0 |
| Outlet coverage | 25% | 400 | 360 | 90% | 22.5 |
| Collections | 20% | 500 | 500 | 100% | 20.0 |
| Returns (lower is better) | 15% | 2.0% | 2.5% | 80% | 12.0 |
| Total | 100% | 98.5 |
Returns are calculated as target ÷ actual, so 2.0 ÷ 2.5 = 80%. Had the same formula been used as for sales, the result would have been 125%, wrongly rewarding the person for a worse outcome.
What a cap does in practice
Suppose sales value in the example had reached 150%. Without a cap it contributes 60 points and the total rises to 114.5, even though coverage and returns are still below target. With a 120% cap it contributes 48 points and the total is 102.5. The cap keeps a strong result rewarding without letting it hide weak areas.
Edge cases to decide in advance
- Zero actuals on a lower-is-better KPI. Target ÷ 0 cannot be calculated, so state that zero returns earns the maximum score.
- Zero targets. A new territory may have no target for one measure. Remove the KPI for that person and redistribute its weight, rather than leaving it as an error.
- Partial periods. Decide how to treat someone who joined mid-quarter, typically by prorating targets.
- Disputed data. Name who has the final say on a number and by which date, so results are not reopened indefinitely.
Turning scores into ratings
Many organisations convert the total into bands, such as "exceeds" at 100 and above, "meets" from 90 and "below" under 90. Bands make conversations simpler, but people just below a boundary will naturally challenge the data. Publish the bands in advance and keep them stable for the whole period.
Common mistakes
- Including so many KPIs that each carries too little weight to change behaviour.
- Scoring people on results they cannot influence.
- Choosing KPIs because the data is easy to obtain rather than because they matter.
- Rewarding one measure in a way that harms another, such as pushing volume at the expense of returns or collections.
- Never reviewing the design, even after the business priorities have changed.
Review the scorecard itself
Once or twice a year, check whether the scorecard is doing its job. Do high scorers match the people leaders regard as strong performers? Is any KPI always at 100%, suggesting a target that is too easy? Is another always missed, suggesting a target that is unrealistic or outside the person's control? Small, well-communicated adjustments keep the tool credible.
You can test a scorecard design with the KPI Performance Calculator: set your weights, enter targets and actuals, and see how caps and direction change the result.
Want this ready-made? The Team KPI Scorecard Excel template applies the method in this article to up to 50 people, with ratings and rankings built in.
This article is general information, not professional advice. See the disclaimer.