Employee review template

This scores a performance review in the open. It takes the rating scale, the number of competencies rated and the average rating given, the number of goals set and the percentage achieved, the weight placed on goals against competencies, the employee's salary and the merit budget a fully met review earns, and returns the competency score, the overall score as a percentage and on the scale, the number of ratings on the form, and the merit increase in percent and dollars. The weights are decided before the period; the score is what falls out at the end.

Competencies and goals are scored differently on purpose

A competency is a judgement on a scale: reliability, quality of work, communication, teamwork, initiative, job knowledge. A goal is achieved or it is not. Averaging six competency ratings and then converting to a percentage of the scale puts them on the same footing as a percentage of goals achieved, and the weight you set decides how much each contributes. The page shows the competency score on its own before the weighted total, so the employee can see which half moved the result.

Merit follows the score, pro rata

If the budget for a fully met review is three percent, the page pays that at a score of 100 and pro-rates below it: a 76% review earns 2.28%. Whether you round, band or floor that is a policy choice to write into the form; the point is that the raise is a consequence of the score, stated on the same sheet, rather than a separate conversation the employee cannot see the basis of.

Keep the last review where the next one starts

A review form is also a record, and the most useful line on this year's form is last year's score next to it. Printing this one and filing it against the employee, with the weights and goals that were set, is what makes next year's conversation start from evidence.