Performance review template
Fill in the employee’s details, their goals for the period and the competencies you want to review. The final score and rating category update as you type. When you’re done, download it as Excel (with formulas ready to use for your whole team) or as Word to print and sign.
What you type is saved on this device.
Review details
How the final score is calculated
How much goals and competencies weigh.
Goals for the period
What the person had to achieve and how much they achieved.
Goal 1
Goal 2
Goal 3
Competencies
Rate each one from 1 to 5. Tap the rating again to clear it.
Suggested competencies by type of role
1 = Needs improvement · 2 = Fair · 3 = Good · 4 = Very good · 5 = Excellent
Comments and development plan
Result
Goals (60%)
—
Competencies (40%)
—
Final score
—
Category
—
5 competency(ies) missing a rating.
Exceeds expectations: 95+ · Meets expectations: 80+ · Developing: 60+ · Does not meet: <60
The Excel file keeps the formulas so you can reuse it. Leave the ratings empty and the Word file is ready to print and fill in by hand.
Reviewing your whole team?
In SurvIQ each person opens their link and does a self-review, their manager reviews them and the score is calculated automatically. HR sees who is missing and downloads everything to Excel.
See Performance ReviewsThe calculation runs in your browser. We don’t store what you type.
How it’s calculated
Each goal’s achievement: result ÷ target × 100 when higher is better (sales, new customers), and target ÷ result × 100 when lower is better (complaints, days late). For yes/no goals, met is 100% and not met is 0%. Each goal is capped at 120% so one very high goal can’t hide the others.
Goal achievement = average of each goal’s achievement weighted by its weight. Weights must add up to 100.
Competencies: each one is rated 1 to 5. The average becomes a percentage with 5 = 100%. For example, an average of 4 is 80%.
Final score = goal achievement × goal weight + competencies × competency weight. The most common split is 60% goals and 40% competencies, but you can change it. Without goals, the score is just the competencies.
Rating category: 95 or more, exceeds expectations; 80 to 94.9, meets expectations; 60 to 79.9, developing; under 60, does not meet.
How to read the result
- The final score organizes the conversation; it doesn’t replace it. What helps the person most are the comments and the development plan.
- If goals and competencies are far apart (say goals at 110% and competencies at 60%), it’s worth talking about how the results are being achieved.
- A goal at 120% hit the cap: check whether the target was set right for next period.
- Before sharing the reviews, compare scores across the team. If one manager gives everyone a 5 and another gives everyone a 3, calibrate between managers.
- Ask the person to write their comments before signing. A review that only flows top-down is quickly forgotten.
Frequently asked questions
- Does the Excel file have formulas?
- Yes. Each goal’s achievement, the weight total, the competency average, the final score and the category are calculated automatically. There are spare rows to add goals or competencies, and to review someone else you copy the sheet.
- Can I print it blank?
- Yes. Leave ratings and results empty and download the Word file: competencies show 1 to 5 to circle by hand, and signatures are at the end.
- Which competencies should I review?
- Between 4 and 8. Use general ones for everyone (results orientation, teamwork, communication) and add 2 or 3 specific to the role. Below the competencies you’ll find suggestions for sales, customer service, managers and operations.
- How many goals should I set?
- 3 to 6 is most common. Each goal needs a measurable indicator and a weight: the ones that matter most for the role weigh more.
- Is what I type saved?
- Only in your browser, so you don’t lose your work if you close the page. Nothing is sent to any server.
- What if I need to review a whole team?
- Excel gets heavy fast: one file per person, emails and versions. In SurvIQ performance reviews run online: each person opens their link, the manager reviews, the score is calculated automatically and HR sees everyone’s progress.
Know what you want to ask?
Build the survey in SurvIQ, share it by link, WhatsApp or QR code, and watch results come in live. The Free plan is free forever.
Create a free survey