How to Run a Monthly Sales Target Tracker: A Practical Guide
A sales target tracker compares what each salesperson (or team) was supposed to sell against what they actually sold, month by month. It turns “we need to do better” into exact numbers: who is ahead, who is behind, by how much, and where the gap is. Without it, targets are wishes; with it, they are manageable. The tracker also protects good salespeople: when the numbers are visible and fair, strong performers get recognised and struggling ones get help early instead of a surprise conversation at quarter-end.
When to Use This
Set targets before the month begins, never halfway through, and track progress against them weekly so there is time to react. Use the tracker for the whole sales team, for individual salespeople, and broken down by product line or region if those matter to your business. It is a management tool first: it tells you where to help, not just who to praise.
How to Fill It Out
Targets per person. Write each salesperson’s monthly target as a single clear number. Example: “Amara: $40,000. Dev: $35,000. Sofia: $25,000 (part-time, pro-rated).” Targets should be challenging but reachable, a target nobody can hit teaches people to ignore targets.
Actual sales to date. Record confirmed sales as they happen: invoiced or signed orders, not verbal promises. Example: “Amara: $28,500 confirmed by 18 Oct.” Be strict about what counts, a “definitely buying next week” is not a sale until it is signed.
Percentage achieved. Show progress as a percentage of target. Example: “Amara: $28,500 / $40,000 = 71% with 13 days left.” Percentages let you compare a part-timer and a full-timer fairly at a glance.
Pipeline coverage. Note the value of open opportunities each person has that could still close this month. Example: “Dev has $22,000 in proposals awaiting decision, enough to cover his $12,000 gap twice over.” A salesperson at 60% with strong pipeline is fine; one at 60% with an empty pipeline needs help now.
Variance notes. For anyone significantly ahead or behind, write one line on why. Example: “Sofia behind: two expected orders delayed to November by customer budget freeze, not a performance issue.” This stops the numbers from being misread and turns the review into problem-solving.
Actions agreed. End each review with concrete actions, owners and dates. Example: “Dev to re-quote Harbor Road with revised delivery by 25 Oct (Manager to review pricing first).” Actions without owners don’t happen. Write them where everyone can see them, on the sheet itself or in shared meeting notes, so there’s no debate next week about what was agreed.
Lost-deal lessons. For every deal marked Lost, record the reason in one line: price, timing, competitor, went quiet. Example: “Harbor Road, Lost: chose incumbent supplier on price; our response-time advantage didn’t outweigh 12% gap.” Over a quarter, these lines reveal patterns, if “went quiet after proposal” keeps appearing, your follow-up process needs fixing, not your pricing.
Common Mistakes
1. Setting targets mid-month or changing them quietly. Moving the goalposts destroys trust in the whole system. Set targets before the month starts, and if you must revise one (a territory change, a lost key account), do it openly and note the reason.
2. Counting unconfirmed deals as sales. Logging “expected” revenue as actual makes the tracker look healthy right up until month-end, when the gap appears all at once. Only confirmed orders count; everything else lives in the pipeline column.
3. Tracking the team total but not individuals. A team hitting 100% can hide one person at 140% carrying another at 60%. Track both, the team number tells you about the business, the individual numbers tell you who needs coaching.
4. Reviewing monthly but never weekly. A monthly review of a missed target is an autopsy. Weekly check-ins while the month is still live let you shift effort, reassign leads, or adjust activity before it’s too late.
Who Needs to Sign Off
The business owner or sales director sets and approves the targets, ideally with input from the salespeople, who will work harder for a number they helped shape. Weekly progress reviews are run by the sales manager. Individual salespeople don’t “sign off” on the tracker, but they should see their own numbers and agree the recorded sales are accurate; disputes about what counts should be settled by a written rule, not argued each month.
How Often to Review and Update
Update actual sales as deals confirm, daily or as they happen. Hold a short weekly progress check (15–20 minutes per team) to review percentages, pipeline coverage and agreed actions. At month-end, close the month, record final numbers, and set next month’s targets before the new month starts. Quarterly, step back and check whether targets are still realistic: consistently missed targets usually mean the target is wrong, not the team.
Download the free Monthly Sales Target Tracker.