Salary benchmarking template (Excel) with pay bands and compa-ratio
Record market pay for your benchmark roles, turn it into a pay band for each grade and see where every employee sits in their band. This salary benchmarking template is one Excel workbook with room for 15 grades, 50 market data rows and 200 employees.
Finance teamsGet this pack and 51 more for $79
Want every pack, for every region? Global library, 110 packs, $99
What the workbook looks like

When you need it
Salary benchmarking compares what you pay with what other employers pay for similar roles. Finance teams use it to set pay bands, price new roles and plan the pay review. Use this workbook when:
- You are setting pay bands for the first time, or the old ones no longer match the market
- You are budgeting a pay review and need the cost of moving people up to their band
- You are pricing a new role before it goes into the headcount plan
- You employ people in the EU and need pay ranges you can explain to applicants and staff
How to use the salary benchmarking template
- Collect market data. For each benchmark role, enter the lower quartile, median and upper quartile from your salary survey, job adverts or recruiter data, with where it came from and when.
- Set the bands. Enter the market median, your pay policy and a range spread for each grade. Minimum, midpoint and maximum calculate.
- Load your employees. Enter each person with their grade, FTE and full-time salary. For part-time staff, enter the full-time equivalent salary.
- Work through the Check column. It names anyone below the minimum or above the maximum, and any row with a missing grade or department.
- Take the Summary to the pay review. Put the cost to reach minimum in the pay budget and use the band midpoint as the salary for new roles.
Questions
What is salary benchmarking?
Comparing the pay for each role in your company with what other employers pay for similar roles in the same market. The result is a market median for each role, which you then use to set pay bands.
How do you do salary benchmarking?
Match your main roles to roles in salary surveys, job adverts or recruiter data and record the lower quartile, median and upper quartile for each. Set a band for each grade around the median, then compare each employee's salary with their band and list anyone outside it.
What is a compa-ratio?
Salary divided by the midpoint of the pay band. A compa-ratio of 1.00 means the person is paid at the midpoint, 0.90 means 10% below it and 1.10 means 10% above it.
How wide should a pay band be?
The range spread is the gap from minimum to maximum. The workbook's examples use 30% for junior grades and 40% to 50% for senior grades, and it accepts any spread between 10% and 100%. The midpoint sits halfway between the minimum and the maximum.
How often should you benchmark salaries?
Once a year, before the pay review, and again when you open a new role. Market data goes out of date, so the workbook records the date of every figure.
Do pay bands matter under the EU Pay Transparency Directive?
Yes. Directive (EU) 2023/970 gives job applicants the right to information on the starting pay or its range, based on objective, gender-neutral criteria, and stops employers asking about pay history. Employers must also make the criteria for pay, pay levels and pay progression easy for workers to find. Member States had to bring it into national law by 7 June 2026.
Also in the headcount planning
Who it's for
Finance teams and HR leads in small and mid-sized companies that set pay bands and plan pay reviews in Excel.
Last checked
Checked against the EU Pay Transparency Directive (EU) 2023/970 in November 2026.
