Salary Bands Template
📈

Salary Bands Template

Streamline Your Compensation Strategy: Create Equitable 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

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 • Management Approach = Direct
    • Matching the skills and responsibilities • Strong experience at that level, takes on delegation • Starting to take on c.50% of the level above • Management Approach = Delegate
    • Exceeding in the skills and responsibilities • Excelling at that level, pushing to develop • Comfortable with c.80% in the level above. • Management Approach = Develop

    The salary band positioning descriptions above are examples and are closely aligned to the concept of low, medium and high TRM (task-relevant maturity). You can read more about TRM here. N.B. These are just examples and can be modified based on your unique culture and approach to performance.

🤔

Is it possible for someone to be a high performer while being at the lower end of their salary band?

  • Absolutely. Your position in the salary band reflects your experience level and growth potential in the role, not your performance. For instance, an employee who has recently been promoted may be performing excellently while still being at the lower end of their new band as they develop expertise in their new position.
  • Conversely, you could be at the top end of the band but be a poor performer because of declining output or not keeping up with evolving role requirements despite having extensive experience.

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.

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.

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.
  • Giving you some flexibility on where to pay a new hire as you can objectively place them in the range, and not necessarily always at the bottom. For example they could be moving internally within the organisation and not start at the min point.

To build salary bands you need 3 essential components

1. Job architecture

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 salary bands spreadsheet

I’ve built salary bands for 70+ organisations and I've compiled the 6️⃣ most common salary band models into a single spreadsheet.

These models offer

  • ✅ Instant salary band creation from a single data point
  • ✅ Comprehensive salary structure generation across all levels
  • ✅ Logical progression for inconsistent market data
  • ✅ Accurate gap-filling when market data is incomplete

Before you begin

  • 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're not required to use the same model across the entire organisation.
  • This spreadsheet is designed to function exclusively in Google Sheets.
  • Expand the toggle below for detailed information on how each salary band model works and to identify the most suitable one for your situation.
  • Finally, re-watch the video at the top of this page.
Model 1 - Raw market data + Pay Range Spread %
Model 2 - Exponential Regression using the Growth function + Pay Range Spread %
Model 3 - Lowest Level + Midpoint Progression Model + Pay Range Spread %
Model 4 - Salary Minimums + Salary Maximums
Model 5 - Raw market data + % band overlap
Model 6 - Raw market data + Direct Percentage Above and Below Midpoint

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.

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

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.

image

FAQs

What are midpoint differentials?
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!

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