Accountio / Templates / Headcount planning / Salary benchmarking

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 teams
$15
In the pack
Headcount planning
Files
3, Excel and Word
Buy the pack · $15
US library · 52 packs

Get this pack and 51 more for $79

Headcount planning · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What the workbook looks like

Salary benchmarking template
What the workbook coversSheet or column in the workbook
Market pay for each benchmark role
✓
Market dataLower quartile, median and upper quartile, with where the figures came from and their date
Your band midpoint against the market
✓
Market data: Midpoint against medianFlags any band further from the median than the gap you set
A pay band for every grade
✓
BandsMinimum, midpoint and maximum worked out from the market median
Paying above or below the market
✓
Bands: Pay policy against market0% pays at the median; 5% pays 5% above it
The width of each band
✓
Bands: Range spreadFor example 30% for junior grades and 50% for senior grades
Grades that sit too close together
✓
Bands: Midpoint step from grade belowWarns when a midpoint is not above the grade below
Each employee against their band
✓
EmployeesRole, department, grade, location, FTE and full-time salary
Compa-ratio and position in range
✓
Employees: Compa-ratio, Position in range1.00 is paid at the midpoint; 0% is at the minimum and 100% at the maximum
Who is outside their band
✓
Employees: Where in the bandBelow minimum, lower, middle or upper third, or above maximum
Cost of bringing pay up to the minimum
✓
Employees: Cost to reach minimumThe gap to the minimum times FTE, for each person below their band
Results by grade and by department
✓
SummaryEmployees, average salary, average compa-ratio and people outside their band
Company, currency and departments
✓
SettingsThe currency label and the market gap that triggers a flag

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

  1. 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.
  2. Set the bands. Enter the market median, your pay policy and a range spread for each grade. Minimum, midpoint and maximum calculate.
  3. Load your employees. Enter each person with their grade, FTE and full-time salary. For part-time staff, enter the full-time equivalent salary.
  4. Work through the Check column. It names anyone below the minimum or above the maximum, and any row with a missing grade or department.
  5. 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

Headcount plan

See the whole pack →

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.