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

SpreadsheetPayroll & CompensationFree

Payroll Register

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

Shown with sample data

Colour

Payroll Register

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

Gross payroll
$39,747
Net to pay
$26,952
Transfer to employees
Taxes to remit
$12,878
Income tax plus employee and employer social security
Total employer cost
$44,378
Employer cost by department
  • Sales$17,752.3540%
  • Engineering$14,908.7034%
  • Operations$7,697.1617%
  • Admin$4,019.409%

How to use it

  1. 1Set tax, social security, retirement and overtime rates on the Rates sheet (use your official tables).
  2. 2For each employee, enter department, base pay for the period, hourly rate, overtime hours, bonus and benefit deductions.
  3. 3Review net pay and total employer cost.
  4. 4Approve, pay and file with your payroll provider or tax authority.

In this workbook

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

About this template

A clear payroll worksheet for small teams. For each employee it works out overtime pay at your multiplier, gross pay, pre-tax retirement contributions, taxable pay, income tax, social security and benefits, then net pay. Employer social security and retirement match give the true cost of each person, and a department summary shows where payroll money goes.

Who it’s for

  • Small teams running payroll in-house
  • Checking a payroll provider's figures
  • Budgeting the real cost of staff

What’s included

  • Pay run sheet: Gross to net for each employee this pay period.
  • By department sheet: Headcount and payroll cost by department.
  • Rates sheet: Rates used in the pay run (estimates).

How to use it

  1. 1Set tax, social security, retirement and overtime rates on the Rates sheet (use your official tables).
  2. 2For each employee, enter department, base pay for the period, hourly rate, overtime hours, bonus and benefit deductions.
  3. 3Review net pay and total employer cost.
  4. 4Approve, pay and file with your payroll provider or tax authority.

Tips

  • Lock the Rates sheet once checked so nobody changes them by accident.
  • Keep one copy of the workbook per pay period for your records.

Questions

Are the tax figures exact?

No. Income tax here is a flat estimate. Real withholding uses brackets and allowances, so use official tables or your provider for the final figures.

What is employer cost?

Gross pay plus the employer's social security and retirement contributions: what each person really costs you.

Related searchespayroll registerpayroll templategross to netemployer costovertime calculatorpay run

Details

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

Download a copy

Downloads need a free account.

SpreadsheetPayroll & CompensationFree

Payroll Register

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

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
3
Setup
10 min
Level
Intermediate
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 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

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