Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementPayroll & CompensationMerit Increase Planner

SpreadsheetPayroll & CompensationFree

Merit Increase Planner

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

Shown with sample data

Colour

Merit Increase Planner

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

Eligible payroll
$964,000
Merit pool
$33,740
Budget % × eligible payroll
Increases allocated
$34,445
Pool used
102%
Aim for 100% or less
Pool remaining
-$705
Average increase
3.6%
Merit increases by department
  • Engineering$12,630
  • Sales$6,585
  • Operations$6,400
  • Marketing$5,200
  • Finance$3,630
Increase by employee
  • Jordan Lee$5,880
  • Asha Patel$5,720
  • Tom Reyes$4,840
  • Raj Mehta$3,630
  • Marco Diaz$3,550
  • Priya Raman$3,360
  • Lena Park$2,880
  • Ines Duarte$2,320

How to use it

  1. 1Set the merit budget as a % of eligible payroll on the Settings sheet.
  2. 2Edit the Matrix: higher ratings and lower compa-ratios earn bigger increases.
  3. 3List eligible employees with salary, band midpoint and performance rating (1–5); the recommended % calculates.
  4. 4Enter a manager-proposed % only where you want to depart from the guideline, then check budget used and any rows flagged Above guideline.

In this workbook

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

About this template

Run the annual merit cycle with a defensible, budget-aware method. Each employee’s performance rating and compa-ratio (salary ÷ band midpoint) look up a recommended increase from your merit matrix. Managers can propose a different figure; the planner shows the final increase, new salary and new compa-ratio, flags anything outside guidelines and tracks spend against the merit pool by department.

Who it’s for

  • Annual merit and pay review cycles
  • Giving managers clear increase guidelines
  • Keeping total increases within the approved budget

What’s included

  • Employees sheet: One row per eligible employee.
  • Matrix sheet: Guideline increase by performance rating and compa-ratio.
  • By department sheet: Spend against each department’s share of the merit pool.
  • Settings sheet: Merit budget for the cycle.

How to use it

  1. 1Set the merit budget as a % of eligible payroll on the Settings sheet.
  2. 2Edit the Matrix: higher ratings and lower compa-ratios earn bigger increases.
  3. 3List eligible employees with salary, band midpoint and performance rating (1–5); the recommended % calculates.
  4. 4Enter a manager-proposed % only where you want to depart from the guideline, then check budget used and any rows flagged Above guideline.

Tips

  • Lower compa-ratios get more of the pool so employees move towards the midpoint over time; that is the point of the matrix.
  • Keep 5–10% of the pool unallocated for equity fixes and retention cases.
  • Run a pay equity check on the final increases by gender and ethnicity before letters go out.

Questions

What is a merit matrix?

A grid that sets a guideline increase for each combination of performance rating and position in the pay range (compa-ratio). Strong performers low in their range get the most; weak performers high in the range get little or nothing.

What is a typical merit budget?

In recent years many US employers have budgeted around 3–4% of payroll for merit increases. Use current salary survey data for your market and industry.

How is compa-ratio calculated?

Salary divided by the midpoint of the pay band for the role. 1.00 means paid exactly at midpoint.

Should a low performer get a raise?

Most matrices give 0% for “Does not meet” so pay stays linked to performance. Address the performance issue separately.

Related searchesmerit increase matrixmerit increase plannersalary increase calculatorannual pay raise planningmerit budget spreadsheetcompa ratio merit matrix

Details

Format
Spreadsheet
Category
Payroll & Compensation
Sheets
4
Setup
30 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPayroll & CompensationFree

Merit Increase Planner

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

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
4
Setup
30 min
Level
Advanced
Price
Free

Your copy is private to you.

More payroll & compensation templates

View all
Salary Bands & Pay Equity Review2 sheets

Average compa-ratio

1

Below band

2

Above band

1

ABCD
1EmployeeDepartmentLevelSalary
2Asha PatelEngineeringL3$104,000
3Marco DiazEngineeringL2$71,000
4Priya RamanEngineeringL4$152,000
5Jordan LeeSalesL2$82,000
Employees
SpreadsheetPayroll & Compensation

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.

10 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