Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementPayroll & CompensationSalary Bands & Pay Equity Review

SpreadsheetPayroll & CompensationFree

Salary Bands & Pay Equity Review

Compare each employee’s pay with the band for their level and find who is under, over or out of line.

Shown with sample data

Colour

Salary Bands & Pay Equity Review

Compare each employee’s pay with the band for their level and find who is under, over or out of line.

Average compa-ratio
1
1.00 = midpoint
Below band
2
Above band
1
Cost to bring into band
$5,000
Salary by employee
  • Priya Raman$152,000
  • Asha Patel$104,000
  • Lena Park$96,000
  • Tom Reyes$88,000
  • Jordan Lee$82,000
  • Marco Diaz$71,000
  • Grace Lim$52,000
  • Sam Carter$47,000

How to use it

  1. 1Define bands on the Bands sheet from market data.
  2. 2List employees with level and salary.
  3. 3Review everyone flagged Below band first.
  4. 4Compare compa-ratios across groups for unexplained gaps.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Fair pay needs a structure. Set a minimum, midpoint and maximum for each level; the sheet calculates each employee’s compa-ratio and position in the band, flags anyone below the minimum or above the maximum and totals the cost of bringing everyone into range.

Who it’s for

  • Annual pay reviews
  • Checking pay equity before it becomes a complaint
  • Making consistent offers to new hires

What’s included

  • Employees sheet: One row per employee.
  • Bands sheet: Pay band for each level.

How to use it

  1. 1Define bands on the Bands sheet from market data.
  2. 2List employees with level and salary.
  3. 3Review everyone flagged Below band first.
  4. 4Compare compa-ratios across groups for unexplained gaps.

Questions

What is a compa-ratio?

Salary divided by the midpoint of the band. 1.00 means paid at midpoint; most employees should fall between 0.85 and 1.15.

Related searchessalary bandspay equitycompa ratiocompensation reviewpay scale

Details

Format
Spreadsheet
Category
Payroll & Compensation
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPayroll & CompensationFree

Salary Bands & Pay Equity Review

Compare each employee’s pay with the band for their level and find who is under, over or out of line.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Payroll & Compensation
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More payroll & compensation templates

View all
Merit Increase Planner4 sheets

Eligible payroll

$964,000

Merit pool

$33,740

Increases allocated

$34,445

ABCD
1EmployeeDepartmentJob titleRating 1-5
2Asha PatelEngineeringSenior Developer5
3Marco DiazEngineeringDeveloper4
4Priya RamanEngineeringHead of Engineering3
5Jordan LeeSalesSales Manager4
Employees
SpreadsheetPayroll & Compensation

Merit Increase Planner

Recommend each pay rise from a performance × compa-ratio matrix and track spend against the merit budget pool.

30 min setupPreview
Payroll Budget and Labor Cost Forecast4 sheets

Total labour cost

$1,843,105

Salary cost

$1,565,986

Taxes and benefits

$277,119

Labour cost by month
$134k
$134k
$145k
$157k
$157k
JanFebMarAprMay
SpreadsheetPayroll & Compensation

Payroll Budget and Labor Cost Forecast

Forecast salary, employer taxes and benefits for every role by month and department, including new hires, leavers and merit.

40 min setupPreview
Payroll Register3 sheets

Gross payroll

$39,747

Net to pay

$26,952

Taxes to remit

$12,878

Employer cost by department
40%
  • Sales
  • Engineering
  • Operations
  • Admin
SpreadsheetPayroll & Compensation

Payroll Register

Gross to net for each employee, with overtime, pre-tax retirement, deductions, employer costs and totals by department.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ