Skip to content
Small Business Payroll Calculator cover: a sample sheet, beside the Pay run and Pay log tabs

Small Business Payroll Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Owners of very small businesses and their bookkeepers use the Small Business Payroll Calculator to run a pay period from one sheet. The Pay run tab works as a form: business name and pay date first, then period dates, then one line per employee with regular hours, overtime hours and hourly rate. Gross pay and totals are calculated for you, and the withholding rate you type yields estimated withholding and net pay. The Pay log tab keeps the totals from earlier runs.

Replace the sample withholding rate with a figure from your own estimate or your payroll provider's tables before you rely on any net pay number. Check overtime against the rules that apply in your state, and keep a record for each pay date. The sheet does not calculate employer taxes, benefits or the full withholding schedule, so use it to plan and check, not to file returns.

Useful for

  • Estimate pay for a small team every two weeks
  • Check overtime hours before each pay date
  • Keep a log of gross and net totals by period

What's included

  • 3 tabs: Pay run, Pay log, How to use
  • Pay run: a ready-to-fill form
  • Pay log: a table
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Pay run tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Does this replace a payroll service?

No. It helps you work out pay and see the totals in one place. A payroll service or your accountant still handles tax filings, deposits and year-end forms. Use the figures here to check their work rather than as a substitute.

Why does net pay differ from what the bank shows?

Net pay here subtracts only the withholding rate you enter. Real paychecks also reflect exact withholding tables, employer and employee taxes and benefit deductions. Treat your payroll statement as the final figure.

How is overtime paid?

The Gross pay formula pays overtime hours at time and a half, a multiplier of 1.5 on the hourly rate. Federal rules set that multiple for most hourly staff on hours over 40 in a workweek, and some states add their own requirements. Confirm which rules apply before you pay anyone.

  • #timesheet
  • #payroll-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More timesheet templates

See all 10

Also in Human resources

All human resources templates
Get this template

Preparing your template…