HR template
Payroll register
Calculate gross pay, withholdings, deductions and net pay for each person on a pay run. Rates live in one box so a change updates every row.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Register
74 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 182 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Named ranges
- Frozen headers
- 1 chart
A look at the Register sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Payroll register | |||||||
| 2 | Biweekly pay run. Salaried rates are annual (paid over 26 periods); hourly rates are per hour with 1.5x overtime. | |||||||
| 3 | Period start | Nov 1, 2026 | Income tax | 12.0% | Employees | 8 | ||
| 4 | Period end | Nov 14, 2026 | State tax | 4.5% | Total gross | $16,792.09 | ||
| 5 | Pay date | Nov 20, 2026 | Social security | 6.2% | Total net | $11,369.84 | ||
| 6 | Medicare | 1.5% | Employer cost | $18,076.68 | ||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | Employee | Role | Pay type | Rate | Hours | Overtime hours | Gross pay | Income tax |
| 10 | Casey Morgan | Warehouse lead | Hourly | $26.50 | 80.0 | 6.0 | $2,358.50 | $283.02 |
| 11 | Drew Alvarez | Picker | Hourly | $19.75 | 80.0 | 0.0 | $1,580.00 | $189.60 |
| 12 | Emerson Hale | Picker | Hourly | $19.75 | 72.0 | 0.0 | $1,422.00 | $170.64 |
- payroll
- wages
- taxes
- net pay
More hr templates
HRWeekly timesheetRecord time in, lunch and time out for each day of the week. Hours over 40 become overtime and pay is calculated at your rates.
HREmployee shift schedulePlan a week of shifts with a dropdown in every cell. Hours per person and coverage per shift add up as you fill the grid.
HREmployee directoryKeep contact details, teams, managers and start dates in one tidy list. Look anyone up by name and see headcount by department.
HRVacation and PTO trackerAccrue paid time off by month, log requests, and see each balance at a glance. Request days count working days only and skip holidays.
Start your payroll register now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.