how-to
Google Sheets Payroll Template for Small Business: Free Setup Guide
Last Updated: October 27, 2026
Quick Summary
A payroll template in Google Sheets tracks employee details, hours, pay rates, and deductions in one place so you do not rebuild the math every pay period. Start with an employee register keyed by Employee ID, add a timesheet tab, then use formulas for gross pay, overtime, deductions, and net pay.
- Keep one row per employee in a register tab, with a consistent set of columns.
- Use Employee ID rather than name to link tabs, since names change and duplicate.
- Add dropdown data validation to pay type, frequency, and status to prevent formula-breaking typos.
- Calculate overtime as overtime hours times pay rate times 1.5, checking your state's rules.
- Verify tax rates against IRS Publication 15 before each pay run, because a spreadsheet will not update them for you.
Table of Contents
- What a Google Sheets Payroll Template Should Include
- Setting Up Your Payroll Register and Employee Records
- Tracking Hours and Building a Timesheet Template Google Sheets
- Payroll Spreadsheet Formulas for Gross Pay, Overtime, and Net Pay
- Adding Tax Withholding, Deductions, and Year-to-Date Totals
- Protecting Payroll Data and Catching Spreadsheet Errors
- Choosing a Free Payroll Template Google Sheets Download or Moving to Payroll Software
- Frequently Asked Questions
Running payroll in a spreadsheet can save a small business real money, but only if the setup is right from the start. A good Google Sheets payroll template tracks employee details, hours, pay rates, and deductions in one place, so you are not rebuilding the math every pay period. This guide walks through what to include, how to set it up, and when a spreadsheet stops being the right tool. The steps below show how to set up a payroll spreadsheet and what to check before you rely on it.
Many small teams start with a simple sheet and add columns as they grow. That approach works for a few employees, but errors creep in fast. A missed overtime formula or a wrong tax rate can cost you in corrections and employee trust. The sections below help you build a template that stays accurate.
What a Google Sheets Payroll Template Should Include
A useful payroll template has a few core parts. It needs an employee register, a timesheet area, calculation columns, a deductions section, and a summary for each pay period. Keep these on separate tabs or clearly labeled blocks so you can find things quickly.
Look for these elements in any template you download or build:
- Employee records: name, ID, pay type (hourly or salaried), pay rate, and start date
- Pay period settings: pay frequency and pay date
- Hours tracking: regular hours, overtime hours, and paid time off
- Calculations: gross pay, net pay, and year-to-date totals
- Deductions: tax withholding, benefits, and any reimbursements
- Summary view: one row per employee for each pay run
Before you use any template, confirm it matches how you actually pay people. A template built for salaried staff will not handle hourly overtime well.
Setting Up Your Payroll Register and Employee Records
Your payroll register is the master list of everyone you pay. Put one row per employee and keep the columns consistent. Keep personal data limited to what you need for payroll.
A practical layout puts the register on its own tab named Employees, with headers in row 1 and data starting in row 2. A tested column order looks like this:
| Column | Header | Example entry | Notes |
|---|---|---|---|
| A | Employee ID | EMP-001 | Text, not a number, so leading zeros survive |
| B | Last name | Rivera | |
| C | First name | Dana | |
| D | Pay type | Hourly | Dropdown: Hourly, Salary |
| E | Pay rate | 22.50 | Format as currency |
| F | Pay frequency | Biweekly | Dropdown: Weekly, Biweekly, Semimonthly, Monthly |
| G | Start date | 03/04/2024 | Format as date |
| H | Status | Active | Dropdown: Active, Inactive |
| I | Filing status | Single | Matches the employee's Form W-4 |
| J | Notes | Free text for exceptions |
Start with these fields and add columns to the right, never in the middle. Inserting a column in the middle shifts every formula reference to its right and is one of the most common ways a working template breaks.
Use data validation to limit entries. Select column D, open Data > Data validation, choose "Dropdown" and enter Hourly, Salary. Do the same for pay frequency and status. This prevents typos like "hourly " with a trailing space that silently break VLOOKUP and SUMIF formulas later.
Link the register to other tabs by Employee ID, not by name. Names change, duplicate, and get misspelled; IDs do not. A timesheet row can then pull the pay rate with a formula such as =IFERROR(VLOOKUP($B2, Employees!$A:$J, 5, FALSE), ""), where $B2 is the Employee ID on the timesheet. The IFERROR wrapper shows a blank instead of #N/A when an ID is missing, which makes broken links easier to spot.
Watch out: if you rename a column header after you write formulas, references can break. Lock your headers before you start calculating. You can also protect the header row with Data > Protect sheets and ranges so only you can edit it.
A worked example makes the register concrete. Suppose Dana Rivera is hourly at 22.50, paid biweekly, started 03/04/2024, and is active. Her row is EMP-001 | Rivera | Dana | Hourly | 22.50 | Biweekly | 03/04/2024 | Active | Single. Every timesheet and pay-run row that references EMP-001 inherits those values, so you update the rate in one place when it changes.
Keep an Inactive status rather than deleting rows. Deleting an employee row breaks historical references and year-to-date totals. Marking the row inactive preserves the audit trail while keeping the person out of current pay runs.
Tracking Hours and Building a Timesheet Template Google Sheets
Hourly workers need a timesheet tab that feeds the payroll register. A simple layout works well: one row per employee per day, with columns for start time, end time, and unpaid break. Then sum the daily hours for each pay period.
A clean timesheet has these columns:
| Column | Purpose |
|---|---|
| Date | Day worked |
| Employee ID | Links to the register |
| Start / End time | Clock-in and clock-out |
| Break (hours) | Unpaid break subtracted |
| Total hours | Calculated from the times |
Use a formula such as =(End - Start) - Break to calculate hours. Format the cells as time or as decimal hours, but pick one and keep it consistent across the sheet.
Payroll Spreadsheet Formulas for Gross Pay, Overtime, and Net Pay
Once hours are in, the math takes over. Gross pay for an hourly worker is regular hours times the rate, plus overtime hours times the overtime rate.
A common setup uses these formulas:
- Regular pay:
=RegularHours * PayRate - Overtime pay:
=OvertimeHours * PayRate * 1.5 - Gross pay:
=RegularPay + OvertimePay + Bonus
For salaried staff, gross pay per period is the annual salary divided by the number of pay periods in a year.
Net pay is gross pay minus deductions. Net pay takes the gross figure and subtracts withholding and other deductions. Put each calculation in its own column so you can check each step.
Overtime rules depend on your situation. Under federal law in the United States, non-exempt employees generally receive overtime at 1.5 times their regular rate for hours over 40 in a workweek. Some states add their own daily overtime or other requirements, so check your state's labor agency before you set the 1.5 multiplier in stone. The U.S. Department of Labor's wage and hour guidance at dol.gov covers the federal baseline.
Adding Tax Withholding, Deductions, and Year-to-Date Totals
Tax withholding and deductions reduce gross pay to net pay. Federal income tax, Social Security, and Medicare are typically withheld from employee wages, and employers also pay matching payroll taxes. State and local taxes vary by location.
Track each deduction in its own column so you can report it later. A tested layout on a PayRun tab puts one row per employee per pay period:
| Column | Header | Formula or entry |
|---|---|---|
| A | Pay period end | Date |
| B | Employee ID | Links to Employees |
| C | Gross pay | From the gross pay tab |
| D | Federal income tax | Entered from IRS tables |
| E | Social Security | =ROUND(C2*0.062,2) |
| F | Medicare | =ROUND(C2*0.0145,2) |
| G | State income tax | Entered from state tables |
| H | Other deductions | Entered |
| I | Total deductions | =SUM(D2:H2) |
| J | Net pay | =C2-I2 |
Withholding amounts depend on the employee's Form W-4 and current IRS tables. Rates and thresholds change, so use the official IRS guidance at irs.gov, and verify your figures against it each year. The IRS Publication 15 (Circular E) is the standard reference for employers. IRS Publication 15 (Circular E)
This is the core limitation of any spreadsheet: it can apply the rates you type in, but it cannot tell you whether those rates are current, whether an employee's W-4 changed, or whether a state added a local tax. Tax rates, withholding tables, overtime rules, and filing obligations vary by jurisdiction. Before each pay run, confirm the federal figures against Publication 15 and confirm state and local requirements with your state revenue or labor agency. If you operate in more than one state, budget time to check each one every pay period.
Year-to-date totals help you track progress toward annual limits and prepare year-end forms. Use a running sum that adds each pay period's gross pay and taxes to a cumulative column. On a YTD tab keyed by Employee ID, a pattern such as =SUMIFS(PayRun!$C:$C, PayRun!$B:$B, $A2, PayRun!$A:$A, "<="&TODAY()) sums gross pay for that employee up to today. Repeat with the tax columns to build YTD withholding figures.
Check these totals against your records each quarter. A simple reconciliation is to compare the YTD Social Security and Medicare columns to the amounts on your quarterly federal return, and to compare YTD net pay to the total of your bank transfers. If the two do not match, the difference usually traces to a missing pay run, a duplicated row, or a rate entered by hand.
Protecting Payroll Data and Catching Spreadsheet Errors
Payroll data is sensitive. It includes Social Security numbers, bank details, and pay information. Treat the file like a confidential record.
Protect it with these steps:
- Share the file only with people who need access, using viewer or editor roles.
- Avoid storing full Social Security numbers. Use the last four digits or an employee ID where possible.
- Turn on version history so you can recover from accidental changes.
- Keep a backup copy in a separate location.
Catching errors is just as important. Build simple checks into the sheet:
- Totals check: Confirm that the sum of individual net pay equals your bank transfer total.
- Hours check: Flag any day with more than 12 hours or missing clock-out times using conditional formatting.
- Reconciliation: Compare each pay period's totals to your general ledger or bank statement.
Review a sample paycheck by hand for at least one employee each cycle. If your manual math matches the sheet, the formulas are likely working.
Choosing a Free Payroll Template Google Sheets Download or Moving to Payroll Software
A free Google Sheets template is a reasonable starting point for a business with a few employees and simple pay rules. It costs nothing, you control the logic, and you can customize it as needed. The tradeoff is that you carry the compliance work yourself.
Consider moving to dedicated payroll software when:
- You have more than a handful of employees or multiple pay schedules.
- You need to file payroll taxes and produce W-2s without manual steps.
- You operate in several states, which multiplies tax and labor rules.
- You are spending hours each pay period on corrections.
- You face audit risk and need a documented, supported system.
A practical rule: if payroll takes more than a few hours per cycle or you are unsure about your tax filings, the time saved by software usually outweighs its cost. Compare the monthly price of payroll software with the hours you spend and the penalties you could face for errors.
TemplateForge offers Google Sheets templates for budgeting and expense tracking. For current product details and pricing, visit the TemplateForge website. You can also browse the Freelancer Starter Pack, which bundles integrated Google Sheets finance tools.
Frequently Asked Questions
How do I create a payroll template in Google Sheets?
Start a new sheet and create columns for employee name, pay rate, pay period, hours worked, regular pay, overtime pay, gross pay, deductions, and net pay. Add one row per employee for each pay period. Use formulas such as SUM and multiplication to calculate totals automatically, then duplicate the sheet for each new pay period. Test the formulas with a sample employee before you rely on the template for real payments, and save a master copy so you always have a clean version to start from.
Can Google Sheets calculate payroll automatically?
Google Sheets can calculate gross pay, overtime, and net pay automatically once you enter hours and rates and set up the formulas. It does not file taxes or remit withholding for you. Your sheet will still need you to confirm current federal and state withholding rules, since those change and vary by location. Many small businesses use the sheet for calculations and recordkeeping while handling tax filings separately.
What should a small business payroll spreadsheet include?
A useful small business payroll spreadsheet includes employee names, pay rates, pay frequency, hours worked, regular and overtime hours, gross pay, tax withholding, other deductions, and net pay. It should also track year-to-date totals so you can see cumulative earnings and withholding for each employee. Keeping these records in one place makes it easier to reconcile payroll and respond to questions from employees or accountants.
When should a small business move from a spreadsheet to payroll software?
Consider payroll software when you have many employees, frequent pay changes, multiple pay schedules, or a growing number of tax filings to manage. Spreadsheets work well for a few employees with simple pay, but manual errors become more likely as the workload grows. If you spend more time checking formulas than running payroll, a dedicated payroll service may save time and reduce risk.
