Free Google Sheets Payroll Template
For a small team paid weekly or every two weeks, where the owner runs payroll by hand and wants regular pay, overtime, deductions and net pay worked out the same way each period.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Payroll, Employees, Hours and Pay Periods, no typing needed. |
| Payroll | Columns Payroll ID, Pay period ID, Employee ID, Employee, Regular hours, Overtime hours, Regular rate override (optional), Regular rate (USD/hr), Overtime rate override (optional) and 14 more. |
| Employees | Columns Employee ID, Employee name, Role, Default regular rate (USD/hr), Default overtime rate (USD/hr), Status, Email and Notes. |
| Hours | Columns Hours ID, Work date, Employee ID, Employee, Pay period ID, Regular hours, Overtime hours, Total hours, Approval status and 2 more. |
| Pay Periods | Columns Pay period ID, Period name, Start date, End date, Scheduled pay date, Frequency, Status and Notes. |
| Settings | Your own dropdown lists (employee roles), so the choices match how you work. |
How to fill it in
- Set up your pay periods with start date, end date and pay date.
- Enter each person’s approved hours on Hours, split into regular and overtime.
- On Payroll, add other earnings and the deductions your payroll provider or accountant gives you.
- Mark each row paid, with the date and a payment reference, once the money goes out.
A tip from the field
The sheet does the arithmetic, not tax law. Take withholding amounts from your payroll service or your accountant.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Payroll (5 sample rows)
- Employees (4 sample rows)
- Hours (16 sample rows)
- Pay Periods (2 sample rows)
Related templates
- Free Google Sheets Timesheet Template
- Free Google Sheets Time Tracking Template
- Free Employee Handbook Template
When you outgrow it
Smarfle keeps timesheets per person and day, and its accountant export hands them over ready for payroll. See how it works on smarfle.com.