Salary Bands Template
📈

Salary Bands Template

Create salary bands for every role 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).

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
Minimum point
  • The lowest point in the range.
  • Employees here are typically new to the role.
  • Formula: Minimum = Midpoint / (1 + (range spread/2))
  • This formula is an industry-standard HR mathematical equation that organisations use.
Midpoint
  • This is the exact middle of the salary range aka the ‘Midpoint’
  • The midpoint is set to provide a market competitive and fair salary for the organisation.
  • The data you input here, is used as the ‘anchor’ from which to create the min and max salaries in the range.
  • This is sometimes referred to as the ‘market rate’ and will differ from business to business based on their compensation philosophy and the strategic importance of a particular job family.
  • If your policy is to meet the market, your target percentile will be 50.

Critical vs non-critical roles

Adopting a differentiated pay strategy based on the criticality of roles, your company can allocate its compensation resources effectively, attract, motivate and retain top talent where it matters most, and maintain competitiveness in the job market while managing costs in non-critical areas.

1. Critical Job Families
  • Strategic Importance: Start by identifying the critical job families that are essential to achieving your company's strategic goals. These roles typically include positions that directly impact the company's growth, innovation, customer satisfaction, or overall success. Examples might include product development, sales leadership, or specialised technical roles that are unique to your industry.
  • Market Competitiveness: These critical roles should be paid competitively, ideally within the 75th to 90th percentile of the market. Paying at this level ensures that you can attract top talent in a highly competitive job market. It also helps retain key employees who are vital to the company's success.
  • Implications of not paying competitively: If you choose not to pay these critical roles competitively, several implications can arise:
    • Attrition: Key talent may leave for better-paying opportunities elsewhere, leading to a loss of institutional knowledge and skills.
    • Recruitment Challenges: It will be difficult to attract top-tier candidates, potentially delaying important projects or goals.
    • Decreased Performance: The quality of work and the company's ability to meet strategic objectives may suffer.
2. Non-Critical Job Families
  • Identification: Identify the job families that are non-critical to your core business operations. These roles may include support functions such as administrative, facilities management, or certain back-office positions that do not directly drive revenue or innovation.
  • Pay Below 50th Percentile: For these non-critical roles, you can typically afford to pay below the market i.e. 50th percentile. This is because these positions may not be in high demand, and there may be a larger pool of qualified candidates available.
  • Market Conditions: Paying below the 50th percentile should be done with consideration of current market conditions. It's essential to monitor labor market trends and adjust your compensation strategy accordingly. If demand for specific non-critical roles increases, you may need to adjust salaries to remain competitive.
  • Cost Management: Paying these roles at a lower percentile allows you to allocate more resources to critical roles. This cost management strategy can help optimize your budget and invest in areas that directly impact your company's strategic objectives.
Maximum point
  • The max salary in the range.
  • Employees here are typically advanced in their role and ready for promotion.
  • Formula: Minimum x (1+ Desired pay range spread %)
  • This formula is an industry-standard HR mathematical equation that organisations use.
Midpoint differential
  • This is the difference between the midpoints of each adjacent level i.e. the % jump in salary from one level to another.
  • Formula:
    • (Midpoint of level above - Midpoint of level below) / Midpoint of level below
    • image
  • Typically, lower-level jobs tend to have a smaller midpoint differential as the progression from one level to another is quicker. The differential increases for higher-level positions, but this does depend on the market data being used.
  • Level
    Typical midpoint progression
    Support position
    10%-15%
    Professional, Managerial
    15%-25%
    Executive
    20%-35%
  • Using pure market data for the midpoint, may well result in inconsistent midpoint differentials. These uneven midpoint differences happen unintentionally over time and very common when you use data submitted and aggregated from 1,000’s of companies.
  • Midpoint progression will also determine the overlap between adjacent levels.
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
    • The job families you map to and create will vary depending on the data sources you choose to use. For example each salary benchmarking provider will have a description for each job family that you can read and then decided which one matches your role most accurately.
    • Job Families ensure you can identify the compensation data that most closely matches the job or team you are looking for, therefore giving you a more accurate data.
    • The Job Family relates to the specific type of work or skillset (’Talent Acquisition, Human Resources, L&D etc’), while Departments are broader (’HR’)
      1. image
      2. You can group by departments should you wish, however…
      3. “If you use Departments you’re essentially comparing apples to apples regardless of whether it’s an eating apple or a cooking apple; when using Job Families you’re comparing Granny Smith apples to Granny Smith apples.”
    Tracks
    • The most common structure among scaling tech companies is a two-track structure as shown in the diagram below.
    • You either take a track managing people or becoming a specialist managing projects and processes.
    • Separate tracks for ICs and people managers allows employees to develop according to their interests and skillsets and ensures people are working where they will be most effective.
    • Typically both tracks are valued equally, so the same base salary is used at each level, regardless of whether someone is on the IC or People Manager track in the same department. If this isn’t the case in our organisation then it’s not a problem.
    Levels
    • Levels define how senior / experienced the role is.
    • Job levelling criteria is used to define the overall ‘profile’ and ‘size’ of every role and level in the organisation. This is sometimes referred to ‘scope’, ‘responsibility’ and ‘influence’ depending on the levelling framework you are using.
    • Choosing your levelling framework - Each salary benchmarking provider has their own levelling framework. You can view some of the most popular ones here.
  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 model you choose typically depends on the amount of market data available for a role and any particular challenges you face such as

Toggle below for videos and instructions on how each of the salary band models work and find the right one for you situation.

👉
Hint: 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.

You have lots of data 😀

Model 1 - Raw market data + Spread %
Model 5 - Salary Minimums + Salary Maximums
  • Got a min and max for a level but not sure what the mid point is or how this connect with the other levels? This model will help you figure all of this out for you.

You don’t have much data or the data doesn’t make sense 😐

Model 2 - Exponential Regression using the Growth Function + Spread %

This model takes your existing market data and applies exponential regression to it which helps:

  1. Fill in the gaps where data doesn’t exist ✅
  2. Adjusting for when pay doesn’t progress ✅
  • Where data is higher for level 5 rather than level 6, the model takes the highest amount as the max value.
  • Where data doesn’t exist for level 1, it will forecast data for level 1 using data from the levels where it exists.
  • Where data doesn’t exist at all, the model will fill that hole.
  • The model needs a minimum of two data points.
  • The model uses the =GROWTH function to carry this operation out.
  • In simple terms, the growth function calculates Y values on the basis of an exponential growth rate of given X values. In our case salary is our response variable (y) since it is our target predicted value, and levels are our explanatory variable (X).
  • You can learn more about how the Growth function works here.
Model 3 - Linear regression using Forecast Function + Spread %
  • Like exponential regression in model 2, linear regression analysis shows the relationship between an independent variable, such as the Level (x-axis), and a dependent variable, such as Salary Range Midpoint (y-axis).
  • In linear regression, the function is a linear (straight-line) equation.
  • Linear regression has been a traditional approach used in the past to predict salaries, however this infers that salaries and levels increase in a linear format which is typically not always the case.
Model 4 - Lowest Midpoint + Midpoint Differential % + Spread %
  • Unlike the other models, this one only requires one data point for level 1. This is very useful when you have no robust data at all.
  • You create you range by modifying the midpoint progression from one level to another.
  • See the FAQs for more information on the typical midpoint progression %’s.

Why are these models useful?

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

Filling in the data for missing levels
Filling in the data for missing levels

✅ These models will help make sense of market data when it doesn’t ‘progress’ in a logical manner i.e. a lower level job is paid more than a higher level job (this can happen a lot!)

Solving for when pay doesn’t progress
Solving for when pay doesn’t progress

Tips for designing your salary bands

How wide should I make my salary band?
  • To determine the width of your band, you need to modify the 'pay range spread'. This percentage that denotes the difference between the minimum and maximum salaries in a particular role. You can control the width of the salary band for each level by adjusting this percentage.
  • image
  • Establishing the width of your salary band is critical as it influences growth opportunities for your employees at their current level and future levels. There should be sufficient width to provide significant base salary increases, ideally between 5-10% bumps in salary, as employees progress within a level
  • In the following image, an individual receives three pay increases over three years, leading up to a substantial salary boost upon their promotion in year 4.

image
  • Band widths will differ from level to level, job family to job family and company to company.
  • Below are some example ranges:
    • Levels 1-3 (narrower bands)
      • Pay range spreads of: 15%-25% for lower levels.
      • Typically your bands will be narrow in the lower levels where progression through a level is quick e.g. a person might only expect to sit in level 1 for 1-1.5 years and expect two pay increases of 5% during that time.
      • Smaller range spreads can benefit lower level positions where the market rates are also closer.
    • Levels 4-8 (wider bands)
      • Pay range spreads of: 30-40% for mid/snr levels.
      • Pay range spreads of: 40-50% for execs.
      • More senior roles will have wider bands, where time spent in a level becomes longer. Role responsibilities skills and expectations and therefore take longer to master and excel in. That being said, if the band is too wide, people may start to stagnate within that level as it takes too long to progress through it.

Narrow vs wide salary bands

Pros
Cons
Narrow band
✅ Leads to a quicker sense of progression which is useful in the lower levels.
❌ Narrower bands mean less probability to reward performance outside of promotions.
Wide band
‘Flexibility’ is the key word here. ✅ They give you room for placing new hires in a salary band. ✅ More room for growth in a level and performance based raises without having to promote someone. ✅ Wider bands will also allow you to create overlapping bands - more on this topic below.
❌ If the range spread is too large it becomes harder to ensure the internal progression of entry hires to the next level, unless your making salary increases of 8-10% on a regular basis. ❌ May lead to overlapping salary bands which is something you may not want - see below for more on this.
Should I have overlapping salary bands?

The amount of band overlap is dictated by two factors:

  1. Market data - How the market data varies one level to the next level i.e. the midpoint progression.
    • Band overlap is minimal when midpoint differentials are large and range widths are small.
    • Band overlap is significant when midpoint differentials are small and range spread is wide.
  1. Pay range spread - How wide or narrow you set your band.
    • If you set wide bands, then the likelihood of overlap increases, and conversely narrower band widths results in less overlap or none at all.

How much band overlap do I have?

You can see how much band overlap you have between levels (or lack of it), by viewing the ‘Band over’ columns (displayed as both a % and absolute number).

It can be a positive or negative number

  • Positive = this means you have overlapping salary bands
  • Negative = there is no overlap and you have a stepped structure

Negative = Stepped structure
Negative = Stepped structure

What does this look like in reality?

image

What are the pros and cons with overlapping salary bands and stepped structures?

Pros
Cons
Stepped structure
✅ Some people prefer this as it’s neater, and there is a clear step in salary from one level to the next. ✅ Easier to build and maintain.
❌ You would need to promote someone to the next level in order to increase their salary even if they are not ready which is risky.
Overlapping bands
✅ Raises without promotions: Employees can receive raises and be rewarded at the level above without taking on promotions they’re not ready to tackle e.g. Level 1 (£40,000 - £50,000) Level 2 (£45,000 - £55,000) If an employee's performance and experience exceed the requirements of Level 1 but fall slightly below the requirements of Level 2, they can be placed in an overlapping region between the two bands. ✅ New vs Existing employee: Overlapping bands recognise the greater value from a highly experienced/skilled employee at the top of their level compared to a newly-appointed employee on the lower end of the level above, who is on a learning curve and unproven in their role. ✅ Overlapping bands allow for greater band widths, and therefore give more room for growth within a level when compared to a stepped structure.
❌ Promotions: When you promote someone to the next level but their pay may not go up as much as expected (dependent on the degree of overlap), which isn’t particularly motivating for the employee. You’ll need to set a policy where a promotion is accompanied by a specified minimum percentage increase. ❌ Too much overlap: This can lead to pay inequity. ❌ Communication Challenges: Explaining the concept of overlapping bands and that an employee one level below can be paid the same as the level above can be confusing. ❌ Complexity: Managing overlapping salary bands can be complex and requires careful monitoring.

How do you calculate band overlap?

The formula for calculating band overlap:

(Max of lower level - Min of higher level) ÷ (Max of higher level - Min of higher level)

image

What are the typical band overlap %’s?

These will vary on job type and company to company, but below are some typical rates:

  • Levels 1-4 = Typical band overlap of 10%-20%
  • Level 5-6 = Band overlap of up to 40%
  • Exec levels = Some organisations allow for a higher degree of overlap in the higher levels, where there can be a lot of variance in incumbent pay i.e. pay might be the same for an ‘Advanced’ VP and ‘New’ C-Level employee.

FAQs

Why salary are bands useful?
Salary bands support you in making structured and equitable pay adjustments.

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’.
  • This compensation clarity will also help motivate employees to set development goals in order to grow within their level.
  • For more senior roles, it’s likely that employees will spend a lot of time within one level (5+ years), so giving them clarity on where they sit within that level is critical, so they don’t feel like they are stagnating (there are more details on band widths in ‘Step 4 - Set the width of your bands’ below.

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.
I need help with exec pay. Do you have a model for that?
What are levels and do I really need them?
  • Yes, you need them. Like it or not, they play a critical role in salary benchmarking.
  • I regularly meet orgs who feel that they are too small for levels or that they’ve managed to date without them and introducing them would damage the culture. I’m not going to dismiss these challenges, however if you want to carry out a salary benchmarking exercise you will need levels in some shape or form. If you don’t want to introduce levels or some form of seniority/hierarchy into the the organisation, then you won’t be able to carry out salary benchmarking. There is no halfway house.

  • An organisation can have any number of levels. There is no magic number, however most of the salary benchmarking providers have between 8-12 levels, and these will depend on the size of your org.
  • Below is a typical organisation structure consisting of:
    • Two tracks
    • 8 levels (IC1 - C-Level)
    • Sub-levels - This is just another way to talk about the min, mid and max of a range. I personally find it as an easy way to objectively place an employee into either the min, mid or max point of a range. To determine a person’s sub-level we ask ourselves: “How established are they in the role within your organisation?”
    • image
📕
Have a read of this great article here which outlines what levels are.
What are the other benefits of using a job levelling framework?
  1. It helps ensure you have the right mix of junior, intermediate, senior and executive talent to reach your organisational goals
  2. Can aid career progression when used in conjunction with a skills based framework by helping define the routes to progression through the organisation.
  3. Helps solidify performance management processes by providing something meaningful to anchor conversations to
  4. Bring teams together - When levels across departments match one another’s scope of influence on product and people, it clarifies roles, suggests natural counterparts, and brings together employees from different disciplines to take ownership over shared problems and solve them together.
  5. Reduces subjectivity - Employees, regardless of role, are evaluated on the same criteria allowing for similar standards across all teams reducing subjectivity.
  6. Ease of building a career progression framework - Having standardised levelling framework makes expanding to a skills based framework a lot easier as level expectations for a role will have been defined already, meaning people can concentrate on building the skills that matter and not defining the size and reach of the level.
What’s the difference between a levelling framework and a career progression framework?
Levelling framework
Career progression framework
• Defines the scope and responsibilities associated with the different levels. • Not values or performance based. • Definitions are role agnostic which allows for the evaluating and levelling employees on the same criteria. • A levelling system that can be linked to external market compensation data to ensure objective based salary benchmarking so you can compare apples to apples
• Outlines key skills and competencies expected at a certain level. • These are skills an individual can work to attain or improve (vs. a job scope which is defined) • These can be both role agnostic e.g. communication, teamwork and role specific e.g. product knowledge, technical focus
How many levels should a company have?
  • We recommend implementing 8 levels (6 levels for IC/Management + 2 exec levels).
  • This number of levels is also the most common number with the external salary benchmarking tools use. Therefore, introducing the same number of levels will allow for a quick and easy mapping exercise for the purpose of tying your levels back to pay.
  • 8 levels will feel like too many levels at 20 people but by 100 people you will be glad you have that many.
    • Even if you have no plans to hire an IC5 or IC6 soon, it’s important to show people already in that team that there is room for growth i.e. a path ‘may’ exist one day when there is a business need.
    • It also enables future hiring, as if you do need to hire IC5/IC6’s you will need criteria to measure them objectively against. Having the levels from day one, even if no one fits into them allows you to build for future scale.
“We don’t need 6 levels in Customer Support”
  • You don’t have to! Sometimes a department like Customer Support will not use the last 3 levels and have most people in IC1. Inversely the Engineering team may have no IC1’s or IC2’s. Both are fine, however across the organisation you need levels that run from 1-6 to account for both depts.
  • Just because the levels exist, doesn’t mean you have to fill them up!
What are the bigger companies doing?
  • Google and Facebook have ~14 levels, where they have more granularity within their exec function given their size and global reach.
Do you have any more information on tracks?

Here are some short descriptions about tracks.

Track 1 - "IC" (Individual Contributor)

  • Focus: Becoming a specialist in their role
  • IC will suit people if they enjoy:
    • Building bigger and better systems and processes
    • Knowing and understanding the micro details of how we get things done (and why)
    • Quickly identifying how to solve problems in their team
    • Getting creative with their technical knowledge
    • Working collaboratively with more experimental colleagues to apply their knowledge to improve our ways of working
    • Iterating and improving
    • Looking for new opportunities and testing them out

Track 2 - "M" (People Manager)

  • Focus: Hiring, team organisation, and helping people progress in the business
  • Manager will suit people if they enjoy
    • Managing others, delegating work, building a team
    • Team organisation, including holiday management, role forecasting, and performance documentation
    • Guiding others through complex interpersonal and communication challenges
    • Mentoring, training, and leading others
    • Coaching and supporting others through their careers, difficult situations, and day-to-day work
How do I place employees in a salary band?

To place someone in a salary band, you need to have a strong conviction on their performance i.e. you have a fair and objective performance review process in place. I recommend not using sub-levels until you have robust measures of performance in place.

New (min) 0%

  • Learning the skills and responsibilities
  • New to that level or the company
  • Management Approach = Direct

Established (mid) 50%

  • 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

Advanced (Max) 100%

  • 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 descriptions in the examples above are just examples and can be modified based on your unique culture and approach to performance.
Where do I get the data for the models?
  • Before using any of these models, you will need some market data. I have populated the models with sample data in order to demonstrate how they work.
  • If you don’t have any market data, then you are welcome to schedule a call with me to discuss how to choose a salary benchmarking provider using the link here. There are lots of salary benchmarking providers out there, and below are a few that I have worked with:
    1. Pave / Option Impact
    2. Ravio
    3. Figures
    4. Radford
    5. Willis Tower Watson
    6. Salary.com
    7. Mercer
    8. TalentUp
How should I sense check the output?
  • I always recommend checking the data with the hiring managers and any in-house recruiters who will know the role and market best.
How do I choose which model to use?
  • Key decisions:
    • Which model best suits your needs? (FWIW, I personally favour Model 2 😃)
    • Do you have plenty of market data to feed into the model you’ve chosen?
    • Do you want overlapping bands at some levels and not others?
    • How wide do you want your bands? i.e. the distance from the min to the max point at each level?
    • 💡
      You can visually compare and contrast the affect each model has on your raw data by viewing the line graph sheet. Make sure you plug in the same raw data, so you are comparing apples to apples.
      image
How do I add / remove levels to the models?
Why don’t you use polynomial regression?
  • The main disadvantage of the polynomial models is their sensitivity to outliers in the data set. Even a single outlier can significantly impact the results and render analysis useless.
Something is breaking. Help!
  • Email me at alistair@justly.company and I’ll do my best to help you.

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

1️⃣
Custom project Work directly with me to help set your pay strategy and 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

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

👀What I do

🧑‍💻About

💬Testimonials

🤿Templates

📖Reading

🌳Trees

☎️Contact