Performance tracking sheet
A scorecard to track one person's performance in a period. List each goal with its target, the actual result, whether higher or lower is better and its weight. The sheet works out the achievement of every goal (capped at 150 percent), the weighted score, the overall score and a rating taken from bands you can edit on the Ratings sheet. There is room for comments from both sides. Download it as Excel, OpenDocument, PDF or CSV.
Scorecard
Performance tracking sheet
List each goal with its target, the actual result and its weight. Achievement, the weighted score and the overall rating follow.
Employee Rafael Mendes
Role Customer support lead
Review period Q2 2027
Manager Priya Nair
| Goal or metric | Target | Actual | Better when | Weight (%) | Achievement | Weighted score |
|---|---|---|---|---|---|---|
| Tickets solved per week | 120 | 134 | Higher | 30 | 112% | 0.34 |
| First reply time in minutes | 30 | 24 | Lower | 25 | 125% | 0.31 |
| Customer satisfaction score | 90 | 87 | Higher | 25 | 97% | 0.24 |
| Training sessions given | 4 | 3 | Higher | 10 | 75% | 0.07 |
| Escalations to engineering | 10 | 14 | Lower | 10 | 71% | 0.07 |
| Total | 100 | 1.04 | ||||
| Overall score | 104% | |||||
| Rating | Meets expectations | |||||
| Weights check | Weights add up to 100 | |||||
| Manager comments | Strong response times and steady quality. Plan more peer training next quarter. | |||||
| Employee comments | Happy with the targets. I would like to lead the onboarding session. |
Ratings
Rating bands
An overall score at or above the number in column A gets the rating beside it. Change the numbers and words to suit your organisation. Keep the numbers in rising order.
| Score from | Rating |
|---|---|
| 0% | Below expectations |
| 70% | Partly meets expectations |
| 90% | Meets expectations |
| 110% | Exceeds expectations |