Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementPayroll & CompensationPayroll Budget and Labor Cost Forecast

SpreadsheetPayroll & CompensationFree

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.

Shown with sample data

Colour

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.

Total labour cost
$1,843,105
Salary cost
$1,565,986
Taxes and benefits
$277,119
On top of salary
Loading on salary
18%
Average FTE
12.6
Months employed ÷ 12
Cost per FTE
$146,472
Annual budget
$1,868,000
Forecast vs budget
$24,898
Negative means over budget
Labour cost by month
  • Jan$133,815
  • Feb$133,815
  • Mar$145,159
  • Apr$157,107
  • May$157,107
  • Jun$157,107
  • Jul$159,832
  • Aug$159,832
  • Sep$159,832
  • Oct$159,832
  • Nov$159,832
  • Dec$159,832
Headcount by month
JanDec

Latest: 13

Total labour cost by department
  • Technology$487,11826%
  • Finance$485,17426%
  • Sales$410,95922%
  • Operations$317,53717%
  • People$142,3178%

How to use it

  1. 1Set the employer tax rate, monthly benefits cost per head, merit increase and its effective month on the Settings sheet.
  2. 2List every employee and planned hire on the Roster with annual salary, start month and end month (1–12).
  3. 3Enter your approved monthly budget on the Monthly sheet to see the variance and status each month.
  4. 4Use the By department sheet to agree budgets with department heads, then update the roster as hires and leavers happen.

In this workbook

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

About this template

Build next year’s people budget from the bottom up. List every current employee and planned hire with salary and start and end month; the model applies the merit increase from its effective month, adds employer payroll taxes and benefits per head, and produces the fully loaded labour cost for each person, each month and each department, with month-by-month headcount and variance against your budget.

Who it’s for

  • Annual budgeting and reforecasting
  • Modelling the cost of a hiring plan
  • Explaining the gap between salary and true employment cost

What’s included

  • Roster sheet: Every employee and planned hire with their cost this year.
  • Monthly sheet: Headcount and labour cost for each month.
  • By department sheet: Salary cost and Total labour cost and the number of entries for each department.
  • Settings sheet: Rates used across the model.

How to use it

  1. 1Set the employer tax rate, monthly benefits cost per head, merit increase and its effective month on the Settings sheet.
  2. 2List every employee and planned hire on the Roster with annual salary, start month and end month (1–12).
  3. 3Enter your approved monthly budget on the Monthly sheet to see the variance and status each month.
  4. 4Use the By department sheet to agree budgets with department heads, then update the roster as hires and leavers happen.

Tips

  • Employer costs typically add 20–35% on top of salary once taxes, benefits and retirement contributions are included.
  • Use a blended tax rate on the Settings sheet; social security caps and unemployment tax wage bases make exact taxes vary by person.
  • Budget hires a month or two later than the hiring manager expects; most roles start later than planned.

Questions

How do I calculate fully loaded labour cost?

Salary plus employer payroll taxes plus employer-paid benefits (and other on-costs such as retirement contributions or equipment). This model uses salary × (1 + tax rate) + benefits per head × months employed.

What employer tax rate should I use?

In the US, FICA is 7.65% up to the social security wage base, plus federal and state unemployment taxes and workers’ compensation. Many employers use a blended 9–12%. Other countries differ widely; use your payroll provider’s figure.

How does the merit increase work?

Each salary rises by the merit % from the effective month to the end of the year, so an April increase affects nine months of cost.

What do start and end month mean?

The first and last month the person is on payroll this year: 1 to 12 for a full year, a later start for new hires and an earlier end for planned leavers.

Related searchespayroll budget templatelabor cost forecastsalary budget spreadsheetfully loaded employee costpersonnel budgetworkforce cost model

Details

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

Download a copy

Downloads need a free account.

SpreadsheetPayroll & CompensationFree

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.

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
40 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
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 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