Skip to main content
GullyHR

Free template

Salary band worksheet

A working sheet for setting bands, not a set of figures. Fill in your own grades, market reference and amounts. Adapt the method to your business, and have any change to pay structures or terms reviewed by your legal adviser before you apply it.

Download for WordFree. No sign-up.
Workplace scene for Salary band worksheet

Steps

  • List your roles and group them into grades by the size of the job, not by the person who holds it.
  • Collect market reference points for a few benchmark roles in each grade and write down the source and date for each.
  • Set the midpoint of each grade from your pay philosophy, for example [match / below / above] the market reference for the benchmark roles.
  • Set the minimum and maximum around the midpoint. Spread = (maximum − minimum) ÷ minimum.
  • Check that adjacent grades overlap by a sensible amount and that midpoints rise from grade to grade.
  • Place every employee in a band and review those who sit outside it.

Band table

GradeRoles in the gradeMinimum (₹ per year)Midpoint (₹ per year)Maximum (₹ per year)Spread
[G1][Examples]    
[G2][Examples]    
[G3][Examples]    
[G4][Examples]    
[G5][Examples]    

Market reference log

Say which pay element each figure covers (fixed pay, total cash, CTC) and compare like with like.

Benchmark roleGradeSourceDate of dataReference figure (₹ per year)Note
[Role]     
[Role]     
[Role]     

Placing employees

Compa-ratio = employee's annual pay ÷ band midpoint. Position in band = (pay − minimum) ÷ (maximum − minimum).

EmployeeRoleGradeAnnual pay (₹)Compa-ratioPosition in bandAction
[Name]     [None / Review / Hold]
[Name]      
[Name]      

Rules to write down

Use pay figures only within the people who have a need to see them, and talk to your legal adviser if bands change the terms in existing contracts.

  • Pay for new hires is offered within [lower part / the whole] of the band, with approval above [level].
  • How people below the minimum are brought up, and over what period.
  • How people above the maximum are handled: pay held, one-time payments or a move to the next grade.
  • Who owns the bands and when they are reviewed: [Owner], every [number] months.
  • How exceptions are approved and recorded.

A starting point, not legal advice. Check the final wording against your contracts and the rules of your state, and have a qualified professional review it before you issue it.

How to use this template

  1. HR and the finance head list the roles and group them into levels or grades.
  2. Collect market references from salary surveys, recruiters and recent offers, and log each source and date.
  3. Set a minimum, midpoint and maximum for each band, then check them against the budget.
  4. Place current employees in their bands and mark those above or below the range.
  5. Write down the rules for how a person moves within and across bands.
  6. Review the bands once a year, and after a big hiring or market shift.

A filled example (illustrative)

This example is invented for illustration. Replace every value with your own.

BandRolesMinMidMax
Band 1Trainee, HelperABC
Band 2Executive, OperatorDEF
Band 3Senior Executive, SupervisorGHI

Common mistakes

  • Building bands from the current pay of existing staff alone, and carrying old unfairness forward.
  • Using one survey as the whole truth with no date or source in the log.
  • Setting ranges so wide that they do not guide any decision.
  • Ignoring people placed outside the band, which causes quiet resentment.
  • Not writing down the rules, so each manager reads the bands differently.

Adapt it to your business

  • Factory: build bands by skill grade and shift allowance, and keep contract and permanent staff separate.
  • Shop: separate fixed pay and incentive, and set bands for store level, not just role.
  • Clinic: set separate tracks for clinical and non-clinical roles.
  • Office: add a career track for specialists as well as managers.

Questions about this template

Some firms share the band for a person's own level. Decide this before rolling out.

Start with your business need

What does your HR team need to solve?

Tell us your industry, team size and the issue you want to address. Bring one example of where work gets delayed or ownership is unclear, and the deadline or decision you are working towards.

  • A free first conversation with an HR practitioner
  • A clear scope and fee before any paid work
  • A practical next step for your business

Let’s start with your business

Share your contact details and the HR challenge on your mind. We’ll help you find the right starting point.

Include your country code, for example +44 or +1. Indian numbers can be 10 digits.

Your details stay private. Privacy policy