How to Build a Google Sheets Payroll Template for Small Teams and Freelancers

Most payroll software costs $20–$50 per employee per month. For a freelancer paying one or two contractors, or a small team of three to five people, that subscription cost often exceeds the complexity of the actual payroll. A Google Sheets payroll template does the same job — employee records, time tracking, gross pay, taxes, and year-end summaries — for free, in a tool you already know.

Here's how to build one from scratch, tab by tab.

---

Section 1: The Employee/Contractor List Tab

This is your source-of-truth tab. Every formula in the rest of the sheet will reference it. Create a new tab named Employees and set up these columns:

| Column | Header | Notes | |--------|--------|-------| | A | Name | Full legal name | | B | Pay Type | Hourly / Salary / Per-Project | | C | Rate | Hourly rate, annual salary, or project fee | | D | Std Hours | Standard hours per pay period (for hourly workers) | | E | Pay Period | Biweekly / Semimonthly / Monthly | | F | Tax ID | SSN for W-2 employees; EIN or SSN for 1099 contractors | | G | Start Date | Hire date or contract start |

In column H, add a Gross Pay (Per Period) formula:

=IF(B2="Hourly", C2*D2, IF(B2="Salary", C2/26, C2))

This handles all three pay types automatically: hourly workers multiply Rate × Standard Hours, salaried workers divide their annual salary by 26 biweekly periods, and per-project contractors use their flat fee directly. You can also add a Role column (Developer, Designer, VA) as a descriptive field — it doesn't feed into any formula but helps when you're managing a mix of contractors and employees at a glance.

Pro tip: Add a dropdown to column B using Data → Data Validation → Dropdown from a list: Hourly, Salary, Per-Project. This prevents typos that silently break the formula logic.

---

Section 2: The Timesheet Tab

For hourly workers, you need to track hours. Create a Timesheet tab with these columns:

| Column | Header | Formula / Notes | |--------|--------|-----------------| | A | Employee Name | Match spelling in the Employees tab exactly | | B | Week Start | Date of the Monday that starts each work week | | C–I | Mon–Sun | Hours worked each day (leave blank for 0) | | J | Total Hours | =SUM(C2:I2) | | K | Rate | =VLOOKUP(A2,Employees!A:G,3,0) — pulls Rate from Employees tab | | L | Gross Pay | =J2*K2 |

The VLOOKUP in column K saves you from entering rates manually. When a rate changes in the Employees tab, every Timesheet row updates automatically. Lock column K to prevent accidental edits: select the column, then Format → Protected Ranges and restrict editing to yourself only.

For salaried and per-project workers, you don't need to fill out the Timesheet — their gross pay is calculated directly from the Employees tab formula. Keep the Timesheet strictly for hourly workers to avoid confusion.

---

Section 3: The Pay Run Tab

Staying on top of your own finances while running payroll for a team is a two-system challenge. The Personal Finance Tracker (Google Sheets) — $19 → tracks personal income, expenses, and savings goals separately from your business payroll — so both pictures stay clear.

---

The Pay Run tab is your per-period payroll ledger. Each time you run payroll, you add a block of rows — one per employee — and record gross pay, estimated taxes, and net pay.

| Column | Header | Formula | |--------|--------|---------| | A | Employee | Name (match Employees tab) | | B | Gross Pay | Pull from Timesheet L column or Employees H column | | C | Federal Tax (est.) | =B2*0.22 — flat 22% estimate | | D | State Tax (est.) | =B2*0.05 — adjust to your state rate | | E | Net Pay | =B2-(C2+D2) | | F | Pay Period Date | Date of the pay run |

For YTD (year-to-date) totals, add a summary section at the bottom of each pay run block using SUMIF:

=SUMIF(A:A,"Employee Name",B:B)

This sums every gross pay entry for a specific employee across all rows in column A — cumulative YTD gross without a separate tracker. Keep all pay run data on one tab, stacked chronologically, so the SUMIF always scans the full year automatically.

---

Section 4: The Annual W-2 Summary Tab

At year-end, you need totals for each worker to prepare W-2s (employees) or 1099s (contractors). Create a W-2 Summary tab with one row per person:

| Column | Header | Formula | |--------|--------|---------| | A | Employee Name | List each person once | | B | Annual Gross | =SUMIF(PayRun!A:A,A2,PayRun!B:B) | | C | Federal Withheld | =SUMIF(PayRun!A:A,A2,PayRun!C:C) | | D | State Withheld | =SUMIF(PayRun!A:A,A2,PayRun!D:D) | | E | Net Paid | =SUMIF(PayRun!A:A,A2,PayRun!E:E) |

The SUMIF formula looks up the employee name in the Pay Run tab and sums the corresponding column — annual gross, federal withheld, state withheld, or net paid — across every pay run entry for that person. For W-2 filers: Box 1 = Annual Gross (column B), Box 2 = Federal Withheld (column C), Box 16/17 = State Withheld (column D). For 1099-NEC filers: Box 1 = Annual Gross. Keep this tab locked — it's a reporting document, not a working sheet.

---

Section 5: Tips for Running Payroll in Google Sheets

Use dropdown validation for Pay Type. A typo in column B ("Hourlly" instead of "Hourly") will silently break your gross pay formula without an error message. Dropdown validation from a fixed list prevents this entirely.

Freeze header rows on every tab. Select row 1, then View → Freeze → 1 row. When you're scrolling down to week 20 of timesheets, frozen column labels save constant confusion.

Protect formula columns. Lock the Gross Pay, Rate, Total Hours, Federal Tax, State Tax, Net Pay, and all SUMIF columns. You want to edit inputs — hours, employee names, dates — without accidentally deleting a formula that runs everything.

Export to PDF after each pay run. File → Download → PDF. Name it "PayRun-2026-07-01.pdf" and save it in a folder for that year. This creates an audit trail that's easy to produce if questions come up at tax time.

Review the Employees tab quarterly. Contractors end, rates change, new people join. A quarterly 5-minute review prevents stale data from corrupting pay calculations all year.

---

Frequently Asked Questions

Can I run payroll in Google Sheets? Yes — Google Sheets handles the math, formulas, and year-end summaries that small-business payroll requires. It won't file taxes or send direct deposits automatically, but for teams of one to ten people where you're manually initiating transfers, a well-built spreadsheet covers everything you need to calculate correctly and document thoroughly.

Is a Google Sheets payroll template free? Building your own is completely free — you just need a Google account. Pre-made payroll templates are also widely available as free downloads, though they vary widely in quality. A template that includes the Employee List, Timesheet, Pay Run, and W-2 Summary tabs in a connected structure is more useful than a single-tab sheet.

What's the difference between W-2 and 1099 in a payroll template? W-2 workers are employees: you withhold federal and state income tax, Social Security, and Medicare from each paycheck and remit those to the IRS throughout the year. 1099 workers are independent contractors: you pay their full gross amount with no withholding, and they handle their own taxes. In your payroll template, W-2 workers live in the Pay Run tab with tax deduction columns; 1099 contractors get their own section where you track total payments for 1099-NEC filing at year-end.

---

A payroll spreadsheet isn't glamorous, but it's the kind of system that protects you when tax season arrives. Get the structure right once, run it the same way every pay period, and year-end reporting becomes a one-hour task instead of a fire drill.

Get the Ultimate Notion Productivity System ($27) → — the complete Notion workspace for productivity, task management, and project tracking, built for freelancers and small teams who want everything in one place.