Skip to the content.

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

  1. Set up your pay periods with start date, end date and pay date.
  2. Enter each person’s approved hours on Hours, split into regular and overtime.
  3. On Payroll, add other earnings and the deductions your payroll provider or accountant gives you.
  4. 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.

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.

All free templates