Average compa-ratio
1
Below band
2
Above band
1
Salary Bands & Pay Equity Review
Compare each employee’s pay with the band for their level and find who is under, over or out of line.
SpreadsheetPayroll & CompensationFree
Recommend each pay rise from a performance × compa-ratio matrix and track spend against the merit budget pool.
Shown with sample data
Recommend each pay rise from a performance × compa-ratio matrix and track spend against the merit budget pool.
Run the annual merit cycle with a defensible, budget-aware method. Each employee’s performance rating and compa-ratio (salary ÷ band midpoint) look up a recommended increase from your merit matrix. Managers can propose a different figure; the planner shows the final increase, new salary and new compa-ratio, flags anything outside guidelines and tracks spend against the merit pool by department.
A grid that sets a guideline increase for each combination of performance rating and position in the pay range (compa-ratio). Strong performers low in their range get the most; weak performers high in the range get little or nothing.
In recent years many US employers have budgeted around 3–4% of payroll for merit increases. Use current salary survey data for your market and industry.
Salary divided by the midpoint of the pay band for the role. 1.00 means paid exactly at midpoint.
Most matrices give 0% for “Does not meet” so pay stays linked to performance. Address the performance issue separately.
Download a copy
Downloads need a free account.