# Performance Tracking Spreadsheet, Free

Source: https://nerix.ai/templates/performance-tracking-sheet

Score an employee against weighted goals and get an overall result and rating.

Before you send it

A score is one input to a performance review, not the whole of it. Agree the targets and weights with the employee in advance, and follow your employment rules and your own policy on ratings.

## Fill it in and preview

You are signed in. Fill it in your workspace and it is kept as a document you can send, share and have signed. [Open in your workspace](https://app.nerix.ai/documents/templates/performance-tracking-sheet)

### 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 |

[Open this spreadsheet in nerix](https://app.nerix.ai/documents/templates/performance-tracking-sheet) A preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

People and HR

## What this template is for

A performance tracking spreadsheet: set goals with targets and weights, enter actual results and get each achievement, a weighted overall score and a rating.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. [See all People and HR templates](https://nerix.ai/templates/people-hr) [All free Excel and spreadsheet templates](https://nerix.ai/templates/spreadsheets)

People and HR

## What you fill in

The form asks for 7 details. The document fills itself in as you type.

- ### Employee For example: Rafael Mendes
- ### Role optional For example: Customer support lead
- ### Review period For example: Q2 2027
- ### Manager optional For example: Priya Nair
- ### Goals One row for each goal. Better when: Higher if a bigger result is better, Lower if a smaller one is (for example reply time). Weights should add up to 100.
- ### Manager comments optional For example: Strong response times and steady quality.
- ### Employee comments optional For example: Happy with the targets.

People and HR

## What is inside

The parts of this document, in order.

- 1 A scorecard to track one person's performance in a period. List each goal with its target, the actual result, whether...

Templates

## How it works

- 01 ### Open Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.
- 02 ### Change Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.
- 03 ### Download Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

### Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

[Adapt it with nerix](https://nerix.ai/try?template=performance-tracking-sheet)

### Was this template helpful?

People and HR

## Questions people ask

### What details does this template ask for?

The form asks for 7 details, starting with Employee, Review period, Goals. 4 more are optional.

### Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

### Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

### What should I check before I use this template?

A score is one input to a performance review, not the whole of it. Agree the targets and weights with the employee in advance, and follow your employment rules and your own policy on ratings.

### Are these HR templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

### Do the HR templates follow my country's employment law?

They assume no country's law. Employment rules differ a lot, so each template says where to check local requirements before you use it.

### Can a small team use them too?

Yes. They work for a team of two or a company of two thousand, and you can cut any section you do not need in the Word version.

Templates

## More in People and HR

- [30 60 90 day plan Turn the first three months of a new role into clear goals, people to meet and check-ins. People and HR](https://nerix.ai/templates/thirty-sixty-ninety-day-plan)
- [360 degree feedback form Gather ratings and comments about one person from the people who work with them, then use them to grow. People and HR](https://nerix.ai/templates/360-degree-feedback-form)
- [New Award nomination letter Nominate a colleague, volunteer or neighbour for an award with a clear case and real examples. People and HR](https://nerix.ai/templates/award-nomination-letter)
- [Business travel policy Set clear rules for work trips: who approves, how to book, what is covered and how to claim. People and HR](https://nerix.ai/templates/travel-policy)
- [Casual work agreement Hire someone by the hour, with no fixed weekly hours, and set out how shifts are offered and paid. People and HR](https://nerix.ai/templates/zero-hours-casual-work-agreement)
- [New Certificate of achievement Recognise a win or a standout result with a framed certificate, made one at a time or for a whole list of names. People and HR Certificate](https://nerix.ai/templates/certificate-of-achievement)

[See all People and HR templates](https://nerix.ai/templates/people-hr)

Templates

## More kinds of documents

Every category has its own page, so you can see all of its templates at once.

## Use it in nerix

### Use it in nerix

- [Templates](https://nerix.ai/product/templates)
- [People and HR](https://nerix.ai/product/people)
- [E-signatures](https://nerix.ai/product/e-signatures)

### Learn more

- [How to Make a Document From a Template](https://nerix.ai/help/make-a-document-from-a-template)
- [People and HR](https://nerix.ai/templates/people-hr)
