Payroll Generator
Build a payroll sheet with deductions and net pay formulas.
Generate a payroll workbook for any team size: gross pay, overtime, allowances, tax and statutory deductions, and net pay — all as formulas you can audit. Includes a per-employee payslip sheet ready to print or email.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
· up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Configurable deduction rules including tiered tax bands
- Overtime at a multiplier you set, applied past a threshold
- Per-employee payslip sheet generated from the register
How to use Payroll Generator
- 1
Set your pay period, currency and deduction rules.
- 2
Add employees, or import them from a CSV.
- 3
Enter hours or fixed salaries.
- 4
Download the workbook with the payroll register and payslips.
Watch a walkthrough
Common problems and fixes
Net pay is negative.
The deduction rules exceed gross pay — usually a rate entered as 30 instead of 0.30. Check the rate cells at the top of the rules sheet.
Overtime is not calculated.
The threshold hours cell is blank, so nothing counts as overtime. Set it to your standard week length.
Frequently asked questions
More templates tools
Invoices, payroll, timesheets, budgets and dashboards — every template ships with real formulas, not screenshots, and downloads as a native .xlsx.
Browse Templates