Salary Bands Template
📈

Salary Bands Template

Create salary bands for every role and location in your organisation

Why salary bands?

Implementing a structured approach to pay offers numerous benefits for organisations of all sizes. From ensuring fairness and transparency to aiding in talent retention and attraction, salary bands lay the foundation for a well-managed compensation system - learn more about the benefits of salary bands here.

A quick intro to salary bands

Before jumping into the spreadsheet, it’s important to understand what a typical salary structure looks like, and the terminology.

A salary structure and corresponding bands for one job family

image

A deep dive into one salary band

image

Salary band terminology aside, you need 3 things in order to build salary bands

  1. A job architecture for your organisation. This is comprised of the following elements listed below and gives you a structure from which to build your salary bands from and also ensure you’re comparing apples to apples when mapping back to the market.
  2. Job Families
    Tracks
    Levels
  3. Reliable and relevant market data This could come from various sources such as ‘Give to get’ salary benchmarking providers like Radford, Figures, Pave, Mercer, Ravio, Figures, job boards, recruitment surveys, and not forgetting your recruitment team who speak to candidates every day!
  4. A compensation philosophy Your North star for making comp decisions. How competitive will you be in the market? Will you set the same market position for all of your roles? How will you pay in different locations? How wide will you set your salary bands? Do you want your salary bands to overlap between levels or not? Lots of decisions to make here 🙂
image

How the spreadsheet works

I’ve built salary bands for 70+ organisations and I've compiled the five most common salary band models into a single spreadsheet. The models help make sense of messy market data by smoothing it and filling in gaps.

✅ The models will fill in the gaps for you when you don’t have market data for every level

image

✅ These models will help make sense of market data when it doesn’t ‘progress’ in a logical manner

image

Introducing the 5 models

Before jumping in…

  • The model you choose typically depends on the amount of market data available for a role and any particular challenges you face such as
  • You can use different models for different teams and don’t have to use the same model for the whole organisation.
  • When you download the spreadsheet you have the option to use it in both Google Sheets and Excel.
  • Toggle > below for videos and instructions on how each of the salary band models work and find the right one for you situation.
Model 1 - Raw market data + Spread %
Model 2 - Exponential Regression using the Growth Function + Spread %
Model 3 - Lowest Midpoint + Midpoint Differential % + Spread %
Model 4 - Salary Minimums + Salary Maximums
Model 5 - Market data + % band overlap

Industry standard formulas

Learn more about the industry-standard HR mathematical equation that the spreadsheet uses to calculate the…

Minimum point
Midpoint
Maximum point
Midpoint differentials

Top tips for designing your salary bands

Setting the width of your salary bands
Deciding on a stepped or overlapping band structure

Convert you salary bands into another location and currency

If you employ people in more than one country, you'll probably want to convert the salary bands into different currencies and cost of labour rates. The sheet called ‘Location salary band converter 🌍’ allows you to do just that. By entering details such as the currency and location differential (i.e. the differences in cost of labour vs your baseline market), you can quickly convert your salary bands, ensuring equitable compensation across different regions.

image

FAQs

Why salary are bands useful?
I need help with exec pay. Do you have a model for that?
What are levels and do I really need them?
Do you have any more information on tracks?
How do I place employees in a salary band?
Where do I get the data for the models?
How should I sense check the output?
How do I choose which model to use?
How do I add / remove levels to the models?
Why don’t you use polynomial regression?
Something is breaking. Help!

Whenever you're ready, there are 3️⃣ ways I can help you

1️⃣
Custom project Work directly with me to help set your pay strategy, build salary bands and a compensation philosophy so that you can benchmark your organisation at scale.
2️⃣
Help with customising a template

If you’ve downloaded a template and would like help customising it, then you can book in a 30min session with me as a jumpstart to using it.

30mins = £90

3️⃣
Give you clarity

Whether you’re unsure where to begin or you have some comp ‘stuff’ in place but lack confidence, book some time to chat it through with me.

This website was built without code using Notion + Super ⚡️ by Alistair

👀What I do

🥽Compensation Strategy Deep Dive

🧑‍💻About

💬Testimonials

🪜Justly Guide

🤿Templates

📖Reading

🌳Trees

☎️Contact