Salary Bands Template
📈

Salary Bands Template

Create salary bands in minutes, not hours

Intro

A salary band shows how a salary grows within each level, defined by a minimum, midpoint and maximum.

Salary bands may also be referred to as:

  1. ‘Pay bands’
  2. ‘Pay ranges’
  3. ‘Salary ranges’
Example job family consisting of 8 levels and salary bands
Example job family consisting of 8 levels and salary bands

Why are salary bands so useful?

Salary bands support you in making structured and equitable pay adjustments.
image

1. They can be tied to growth

A salary band is a great way of giving an employee an idea of their earning potential within a level as they grow. As they pick up new responsibilities and increase their impact, they can being rewarded accordingly by moving through the salary band and being assigned a ’sub-level’ or ‘% of progress made within a level’.

Assigning someone a sub-level can provide clarity on their position within a level and motivate them to set appropriate development goals. This is particularly important for more senior roles, since employees may spend a significant amount of time within one level. Therefore it's critical they understand their standing within that level to prevent feelings of stagnation.

To determine a person’s position in a salary band we ask ourselves:

“How established are you in the role within your organisation?”

i.e. what is the employee's proficiency in a level?

New (min) 0%
Established (mid) 50%
Advanced (Max) 100%
• Learning the skills and responsibilities • New to that level or the company
• Matching the skills and responsibilities • Strong experience at that level, takes on delegation • Starting to take on c.50% of the level above
• Exceeding in the skills and responsibilities • Excelling at that level, pushing to develop • Comfortable with c.80% in the level above.
👉

These salary band positioning descriptions are examples that align closely with the concept of low, medium, and high TRM (task-relevant maturity). You can read more about TRM here.

Remember to adapt these descriptions to match your organization's unique culture and performance approach.

2. Help drive pay equity

Salary bands help ensure that employees at the same level are being paid within the same range, which help lessen the gender pay gap.

In addition to this, by having a minimum and maximum rate for every job, and then placing employees into this range by selecting a sub-level, you can easily explain to employees why one is earning way more than the other despite having the same role and level.

3. Critical for financial planning

Having a clear pay structure that all roles are aligned to allows for accurate financial planning for future roles and salary raises.

4. Helpful for hiring

You can put a salary band on a job advert. I’m not going to go into why this is the right thing to do, but let my friends at Otta do the talking here.

It helps guide conversations with new hires by showing them their potential starting point within the band, typically between the minimum and midpoint. For internal moves or transfers, the bands provide guardrails while allowing flexibility to start higher in the range based on experience and expertise.

3 essential building blocks for salary bands

1. Job architecture aka 'common language'

You need to organise your company into the following elements. This structure provides a foundation for building your salary bands and ensures you're comparing equivalent roles when mapping back to the market.

Job Families
Tracks
Levels
image

2. Relevant and reliable 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!

3. 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 🙂

With these three elements in place, you're ready to determine the salary figures for each level, track, and role in your organisation and construct your salary bands.

How to use the spreadsheet

I've built salary bands for over 70 organisations and have compiled the 4️⃣ most common salary band models into a single spreadsheet, plus a personal model that I use on all my projects.

A quick note about the models

  • The model you select typically depends on the amount of market data available for a specific role.
  • You have the flexibility to use different models for various teams; you don’t have to use the same model across the entire organisation.
  • This spreadsheet is designed to function exclusively in Google Sheets. I don’t support Excel.

I've don’t have much data ☹️

✅ Create instant bands from minimal data, fill gaps accurately, and ensures logical progression between levels.

Model 1 - Lowest Level + Midpoint Progression Model + Pay Range Spread %
Model 2 - Exponential Regression using the Growth function + Pay Range Spread %

I've got plenty of salary data 😀

✅ These models use raw market data directly, without smoothing or adjusting between levels. This makes them ideal when you have reliable data and don't need to fix gaps or inconsistencies.

Model 3 - Spread on Either Side of Midpoint
Model 4 - Salary Min & Max Points

The ultimate combination 🤩

✅ Frustrated with traditional models, I created my own that takes the best elements from the models above and unifies them into one.

Model 5 - Manual smoothing + Pay Range Spread + Band Overlap

Key compensation formulas explained

Explore the industry-standard HR formulas used in this spreadsheet to calculate salary bands, including the pay range spread formula detailed below.

Midpoint differentials
Minimum point
Maximum point

Top tips for designing your salary bands

Here are essential tips for crafting effective salary bands. Learn how to set competitive midpoints, determine optimal band widths, and choose between stepped or overlapping structures to support your organisation's compensation strategy.

Setting your midpoint i.e. competitive market position
Setting the width of your salary bands
Deciding on a stepped or overlapping band structure

Bonus: Global pay converter

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.

FAQs

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?
Why don’t you use polynomial regression?
Something is breaking. Help!

There are 3️⃣ ways that I can help you

1️⃣
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️⃣
Clarity call

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.

3️⃣
Customising a template

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

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

👀What I do

🧑‍💻About

💬Testimonials

🪜Free Guide to Salary Benchmarking

🤿Templates

📖Reading

🌳Trees

☎️Contact