Employee KPI scorecard template (Excel)
A ready employee KPI scorecard in Excel: up to 10 KPIs with percentage weights, target and actual figures, a 1–5 rating scale, automatic weighted score formulas per row and in the total row, plus manager and employee signatures. Free, no signup.
Need attendance and punctuality data for your review cycle?
Dawmly handles employee records, attendance, shifts, leave and payroll in one app (it does not do performance reviews, which is why we built this free KPI sheet). Attendance is free for up to 3 employees, no card needed.
Start freeNext step: HR software · Employee data register · Daily attendance sheet
What's in the file
- Header row: company name, evaluation period, employee name and job title.
- 10 KPI rows: KPI/objective, Weight %, Target, Actual, Score (1–5), automatic Weighted score (
Weight × Score) and Notes. - Totals and scale: automatic sum for Weight % (target 100%) and Total weighted score (out of 5), a 1–5 rating legend, manager and employee signature lines, and a How to use instructions sheet.
How to use the KPI template
- Enter the company name, evaluation period, employee name and job title at the top.
- List up to 10 KPIs and enter each weight as a percentage (such as 25% or 0.25) so the Total weight equals 100%.
- Record the target and actual results, then enter a score from 1 to 5 in the Score column.
- Review the automatic Total weighted score out of 5 with the employee, sign, and save a PDF copy to their file.
Using attendance data in KPI reviews
If punctuality or completed shifts are part of an employee's KPIs, pull the exact figures from Dawmly HR software or export your monthly attendance report instead of guessing from memory.