In this article:

Free Payroll Template for Google Sheets (2024 Update)

May 8, 2024

Google Sheets Payroll Template

Using a payroll template in Google Sheets is useful for streamlining payroll processing and ensuring accuracy. Get a copy of our free Google Sheets payroll template here.

google sheets payroll template

Select File > Make a copy.

payroll template google sheets

How to Use the Payroll Template in Google Sheets

Follow the steps below to use our payroll template in Google Sheets. 

1. Specify Pay Period Date Range

Start by specifying the pay period at the top of the template where it says [Indicate here the date range]. Replace this text with the specific dates for which you are calculating payroll, e.g., "March 1-15, 2024".

free payroll template google sheets

2. Enter Hours Worked for Each Day

For each employee, fill in the number of hours worked on each day from Monday to Sunday. If an employee didn't work on a particular day, you can leave that cell as 0 or enter a dash (-).

google sheets payroll template free

3. Input Hourly Wage for Each Employee

In the column marked "HOURLY RATE $", input the agreed-upon hourly wage for each employee.

4. Fill in Applicable Tax Deduction Percentages

Fill in the respective percentages for "STATE TAX %", "FEDERAL TAX %", "SOCIAL SECURITY TAX %", and any "OTHER %" deductions that apply to each employee. These should be in percentage form (e.g., 5 for 5%).

5. Review Automatically Calculated Payroll Totals

The template will automatically calculate the "TOTAL HOURS", "GROSS AMOUNT $", "TOTAL TAXES %", "TOTAL TAXES $", and the "NET AMOUNT $" based on the inputs you provide. Ensure that the hours worked and hourly rates are correct as these directly influence the calculations.

6. Ensure Accuracy for All Employee Entries

Repeat the process for all employees listed in the template, ensuring that their hours, rates, and deductions are accurately recorded.

7. Conduct a Final Accuracy Check Across the Template

Once all information has been entered, review the entire sheet to ensure that all data is accurate and complete. Pay special attention to the hours worked and tax percentages to ensure there are no mistakes.

We hope that you now have a better understanding of how to use our Google Sheets payroll template. If you enjoyed this article, you might also like our article on our free shot list Google Sheets template or our article on Google Sheets sign up sheet template.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->