Skip to content

Performance tracking sheet

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

Performance tracking sheet template, first page

Fill it in and preview

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 nerixA 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 All free Excel and spreadsheet templates

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

  • Roleoptional

    For example: Customer support lead

  • Review period

    For example: Q2 2027

  • Manageroptional

    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 commentsoptional

    For example: Strong response times and steady quality.

  • Employee commentsoptional

    For example: Happy with the targets.

People and HR

What is inside

The parts of this document, in order.

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

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 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

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.