A sales scorecard is a one-page sheet that scores each rep on a few measures against targets set in advance. For a field rep, build it monthly from three groups: activity (visits done against planned, A accounts seen on schedule, prospect visits), results (sales against last year, new accounts, accounts at risk) and quality (notes written, follow-ups done). Give each measure a weight, mark it red, amber or green, and add the points to a score out of 100. The template below does all of that.
Most scorecards online were written for desk sellers and count calls, demos and quota. A rep who drives to customers has a different job. Their month is a set of visits to accounts that buy again and again, and the score should show whether those visits happened, whether the accounts grew, and whether the rep left a record behind. The numbers in this article, the weights and the limits, are worked examples. Change them to fit your business before you use them.
What a sales scorecard is, and what it is not
A scorecard is not a report. A weekly sales report tells the manager what happened this week, in the rep's words. A scorecard shows only the measures tied to targets, in numbers anyone can recheck. One guide defines it as a tool used to track reps' progress toward specific sales goals and targets, and it advises against tracking more than ten metrics. Eight is plenty for a field rep.
A scorecard is also not a verdict on a person. It shows where the month went well and where it did not. The conversation that follows, covered below, is the part that changes the next month.
The scorecard: three groups, eight measures
The groups follow the order in which a month goes wrong. First the visits do not happen (activity). Then the accounts stop growing (results). Then nobody can tell why, because nothing was written down (quality). Results carry the most weight because they are the point. Activity and quality carry the rest because they are what a rep controls, and they show up before sales do.
| Measure | Weight | How to count it | Green | Amber | Red |
|---|---|---|---|---|---|
| Visits done against planned | 10 | Visits checked in divided by visits on the month's routes | 90% or more | 75% to 89% | Under 75% |
| A accounts seen on schedule | 20 | A accounts visited inside their cycle plus grace, divided by all A accounts | 90% or more | 75% to 89% | Under 75% |
| Prospect visits | 6 | Visits to prospects, against the monthly target (6 in this example) | Target met | At least half | Under half |
| Sales against last year | 20 | This month's sales to the rep's accounts, against the same month last year | At or above last year | Up to 5% below | More than 5% below |
| New accounts | 10 | Accounts that placed a first order this month | 2 or more | 1 | 0 |
| Accounts at risk | 10 | Accounts buying less than usual, divided by the rep's accounts | Under 5% | 5% to 10% | Over 10% |
| Notes written | 14 | Visits with a note, divided by visits done | 80% or more | 60% to 79% | Under 60% |
| Follow-ups done | 10 | Follow-ups completed by the date set, divided by follow-ups set | 90% or more | 70% to 89% | Under 70% |
The weights add to 100: activity 36, results 40, quality 24. A green measure earns its full weight, an amber one earns half, a red one earns nothing. That is coarse on purpose. A rep can read it in a minute, and nobody argues about whether a 76% deserves 7.6 points or 8.
The red, amber and green scheme is common in scorecards. The guide above describes green as the target met or beaten, yellow as slightly short and red as well short. Your numbers for each color are the part to get right. They are in the next section.
Why these eight
- Visits done against planned shows whether the rep works the routes you set. It is the one number a manager can check against a plan. Field sales KPIs explains how to count it.
- A accounts seen on schedule has the biggest activity weight. A month with every C account visited and two A accounts missed is a bad month. The measure is the share of A accounts visited within the interval you set, plus a few days of grace.
- Prospect visits keeps new business from being the first thing to go when a route runs full.
- Sales against last year compares a month with the same month a year ago, so season does not distort it. It works for a rep with accounts that reorder. It is a poor fit for a rep in their first year, who has no last year to match.
- New accounts counts first orders, not first visits. A prospect who got a visit and never ordered does not count.
- Accounts at risk is the share of the rep's accounts buying less than usual. You need your invoice records for it. It is the early warning that sales against last year only shows a quarter later.
- Notes written is the share of visits with a note. A visit with no note is a visit the next rep, or the manager, learns nothing from.
- Follow-ups done checks that what the rep promised the customer happened by the date given.
Set the limits from your own year
The limits above are examples built to show the shape. Set yours in three steps.
- Pull last year's monthly figure for each measure for each rep. For a measure you have never counted, count it for one month first and score no one on it.
- Set green near what your best two reps reach in a normal month, not their best month. Set red at the level where you would raise it with any rep. Amber is the gap between.
- Check the weights with one question: if a rep scored green on the heaviest measure and red on the rest, would you be content? If not, the weights are wrong.
A filled-in example
Here is the scorecard for a hypothetical rep, Dana, for one month. She has 58 accounts and a monthly prospect target of 6. None of these figures is real.
| Measure | Result | Color | Points of weight |
|---|---|---|---|
| Visits done against planned | 84 of 96, 87.5% | Amber | 5 of 10 |
| A accounts seen on schedule | 11 of 12, 92% | Green | 20 of 20 |
| Prospect visits | 3 against a target of 6 | Amber | 3 of 6 |
| Sales against last year | $144,000 against $150,000, 4% below | Amber | 10 of 20 |
| New accounts | 1 | Amber | 5 of 10 |
| Accounts at risk | 4 of 58, 6.9% | Amber | 5 of 10 |
| Notes written | 62 of 84 visits, 73.8% | Amber | 7 of 14 |
| Follow-ups done | 9 of 10, 90% | Green | 10 of 10 |
| Total | Amber | 65 of 100 |
Dana scores 65, which sits in amber if you call 80 and above green, 60 to 79 amber and under 60 red. Read the card the way a manager would. Her A accounts are covered, so the territory is not neglected. But she missed 12 planned visits, wrote notes after fewer than three in four of them, and sales are 4% under last year with four accounts buying less. Those lines are linked. The missed visits may be the accounts now buying less, and the thin notes mean nobody can tell why.
Rep: Dana Month: May Manager: ______ Accounts: 58 ACTIVITY (36) Visits done against planned: 84 of 96 = 87.5% amber 5 / 10 A accounts seen on schedule: 11 of 12 = 92% green 20 / 20 Prospect visits: 3 of 6 amber 3 / 6 RESULTS (40) Sales against last year: $144,000 vs $150,000 = -4% amber 10 / 20 New accounts: 1 amber 5 / 10 Accounts at risk: 4 of 58 = 6.9% amber 5 / 10 QUALITY (24) Notes written: 62 of 84 = 73.8% amber 7 / 14 Follow-ups done: 9 of 10 = 90% green 10 / 10 TOTAL: 65 / 100 amber Floor measure (A accounts): green Best line: A accounts all covered but one Biggest gaps: 12 planned visits missed, 4 accounts buying less Two changes for June: ______ / ______
Where the numbers come from
A scorecard fails when a rep can dispute the count. Take every figure from records that existed before the review: check-ins for visits done, the routes for visits planned, invoices for sales and accounts buying less, and the visit notes themselves. If a number comes from the rep's memory or the manager's impression, mark it as an estimate or leave it off.
How to run the monthly review conversation
Give the rep the scorecard two working days before. Plan 30 minutes, in person or on a call, with no phones. The scorecard is the prompt for the talk, and the talk is where the value is. The same discipline as in sales coaching for field reps applies: ask first, then tell.
- Rep first (5 minutes). Ask what went well and what got in the way. Reps often name the real cause before you get to the numbers.
- Greens next (3 minutes). Say what you saw in the green lines. A rep who only hears about the reds starts to hide their numbers.
- The two biggest gaps (15 minutes). Pick the two lines that lost the most points, not every red. For each, ask what happened, and look at specific visits and notes. Do not move on until you both can say the cause.
- Two changes with dates (5 minutes). Agree on two actions the rep will take before the next review, in the form the rep can check themselves, such as visit the four accounts buying less in the first two weeks.
- Write it down (2 minutes). Put the two changes on the scorecard. Next month's review opens with them.
Do not change a target during the month. Do not bring a new measure without a month of notice. And if a number is wrong, say so and fix it for everyone. A rep who finds one error in the card will doubt the rest.
A quarterly sales performance review template
Once a quarter, the three monthly scorecards go into a longer review. A good one is built on objective information on each employee's performance, and centers on whether the rep reached their goal and, if not, what needs to change. Use the template below. It adds the trend across three months, evidence from visit notes, and the rep's own view, which a scorecard cannot hold.
Rep: ______ Quarter: ______ Manager: ______ Date: ______ 1. Scores: month 1 ____ / 100, month 2 ____ / 100, month 3 ____ / 100. Direction: up / flat / down 2. Quarter against goal: sales ______ vs target ______ vs same quarter last year ______ 3. Activity: visits done vs planned ____%, A accounts on schedule ____%, prospect visits ____ 4. Results: new accounts ____, accounts at risk at start ____ and at end ____, accounts won back ____ 5. Quality: notes on ____% of visits, follow-ups done on time ____% 6. Evidence: two visits or accounts from the quarter that show the rep at their best (name, date, what happened) 7. Evidence: two visits or accounts that show what to change (name, date, what happened) 8. Strengths to build on: ______ 9. One skill to develop, and how: ride-along, practice, shadowing a peer (____) 10. Territory and tiers: accounts to move up or down, call cycles to change, anything that made the numbers unfair ______ 11. Goals for next quarter (three at most, each with a number and a date): ______ 12. Rep's own view of the quarter, in their words: ______ 13. Support the manager will give, and by when: ______ Signed off by rep ______ and manager ______
Section 10 matters most and gets skipped most. If a rep's territory has two accounts that closed, or a route that is 90 minutes from the rest, the numbers are not the rep's fault, and the review should say so. Call cycle planning shows how to retier accounts when the review turns up a mismatch.
Mistakes that spoil a scorecard
- Too many measures. Past ten, no one knows which to move.
- Weighting what is easy to count. Visits are easy to count. Results matter more. Weigh them that way.
- Scoring a measure you have never counted. Count it for a month first.
- Comparing reps with unlike territories. A rep with 12 A accounts and a rep with 30 are not on the same footing. Compare each rep with their own last year and their own targets.
- Using the score to decide pay before it has run for a quarter. The first month finds the errors in your counts and your limits.
- Holding the review and changing nothing. If the two changes are not on next month's card, the review was a talk.
Start with one rep and one month
Pick one rep, copy the scorecard, and fill it in from last month's records. Where a count is hard to get, you have found the first thing to fix before the card goes to the team. Then run the review conversation once. After one month, you will know which limits are too loose, which are too tight, and which measure you cannot count, and you can roll the card out to the rest.
