Skip to main content
Dawmly

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 free

Next step: HR software · Employee data register · Daily attendance sheet

What's in the file

How to use the KPI template

  1. Enter the company name, evaluation period, employee name and job title at the top.
  2. List up to 10 KPIs and enter each weight as a percentage (such as 25% or 0.25) so the Total weight equals 100%.
  3. Record the target and actual results, then enter a score from 1 to 5 in the Score column.
  4. 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.

Frequently asked questions

Is the employee KPI template free?

Yes, completely free with no signup. It opens in Microsoft Excel, Google Sheets and LibreOffice Calc.

How is the weighted KPI score calculated?

Each row multiplies Weight % by Score (1–5) using plain arithmetic, and the Total row adds every row's weight and weighted score to give a final score out of 5.

What should the weights add up to?

100% (or 1.00). The Total row sums the Weight % column automatically so you can verify it equals 100%.

Does Dawmly include KPI reviews inside the app?

No. Dawmly covers employee records, attendance, shifts, leave and payroll — not performance reviews. This free Excel template fills that gap alongside Dawmly.

Track attendance and shifts automatically with the Dawmly attendance app, free for up to 3 employees.

Keep reading