How to Make a Pay Stub in Excel or Google Sheets (Free Template)
Thousands of freelancers, gig workers, and small business owners need to document income every year, and unlike traditional W-2 employees, they don't receive an employer-issued pay stub automatically. This guide walks through the free pay stub template, the formulas that power it, and when a spreadsheet makes sense versus a dedicated pay stub generator.
What Is a Pay Stub Template, and Why Use a Spreadsheet?
A pay stub template is a pre-built layout in Excel or Google Sheets that already has the fields and formulas a pay stub needs, so you only have to enter the numbers.
People reach for a spreadsheet because it's free and familiar, and it doesn't require signing up for anything just to document one payment. If you'd rather skip the setup entirely, PayStubVault's pay stub generator builds the same document automatically, with the calculations already handled for you.
Example: A small business owner paying one part-time employee twice a month can reuse the same spreadsheet template every pay period instead of rebuilding the layout from scratch.
Unlike payroll software, a spreadsheet won't notify you when withholding rates change each tax year. The formulas do the math correctly, but only if the numbers you feed them are current, so it's worth checking the IRS's published rates before each new tax year rather than assuming last year's percentages still apply.
Manual Payroll vs. a Pay Stub Generator
Manual payroll means calculating gross pay, deductions, and net pay yourself in a spreadsheet, with no automatic tax-table lookups. A generator does that calculation for you.
If you're processing pay for contractors regularly rather than a single spreadsheet entry, it's a different workload than a one-off stub, and PayStubVault's pay stub tool for self-employed workersis built for exactly that case, so you're not rebuilding a template every time someone new needs a stub.
Q: Is it hard to make a pay stub manually in Excel?
A: Not for a single employee with a fixed salary. It gets harder once you're handling overtime, multiple pay rates, or several employees at once.
Download the Free Pay Stub Template
Rather than building the layout and formulas from scratch, you can start from a ready-made template and just fill in your details. Pick the one that matches the worker type you're paying — the rest of this guide explains how the formulas in each one work.
Employee Pay Stub Template
Standard layout for full- and part-time W-2 employees with itemized federal, state, and FICA deductions.
Open in Google SheetsHourly Pay Stub Template
Built for hourly workers — rate × hours, overtime, and tip credit in a single gross-to-net formula.
Open in Google SheetsSalary Pay Stub with PTO & Overtime
Salaried workers with paid time-off accruals and overtime exceptions calculated automatically.
Open in Google SheetsContractor Pay Stub
1099 contractor stub with no withholding line items — just gross pay, optional estimated set-asides, and YTD totals.
Open in Google SheetsCommission-Based Pay Stub
For sales and commission roles — base salary plus commission earnings tracked separately, with per-period and YTD totals.
Open in Google SheetsBoth versions use the same layout and formulas covered later in this guide, so you can switch between them without rebuilding anything.
What to Include in a Pay Stub Template Excel or Sheets File
A pay stub template needs employer and employee details, the pay period, gross pay, itemized deductions, and net pay, all laid out so each pay period is consistent.
Required Fields for Any Pay Period
Every version of the template should include:
- Employer name and address
- Employee name and ID
- Pay period start and end date
- Pay date
- Gross pay
- Itemized deductions (federal income tax, FICA, Social Security, Medicare, state tax where applicable)
- Net pay
- Year-to-date totals
Example:Missing the pay period dates is one of the most common reasons a self-made stub gets rejected as proof of income, since reviewers can't confirm what timeframe the numbers cover.
Gross Pay, Deductions, and Net Pay
Gross pay is total earnings before anything is subtracted. Deductions are taxes and withholdings. Net pay is what's left after deductions come out.
For a W-2 employee, those deductions typically include federal income tax, Social Security, and Medicare, together known as FICA, plus any state withholding. For a 1099 contractor, there's no automatic withholding at all, since payroll taxes are the worker's own responsibility rather than something an employer deducts.
Before estimating deductions in the spreadsheet, it's worth understanding how self-employment taxes are actually calculated, since those numbers directly affect net pay and most people underestimate them. PayStubVault's self-employment tax guidebreaks down exactly how that calculation works if you're building this for 1099 income.
Spending twenty minutes rebuilding formulas every payday gets old fast.
PayStubVault's pay stub generator produces the same itemized, professional stub automatically in a couple of minutes, with the gross-to-net math handled for you every time.
How to Make a Pay Stub in Excel or Google Sheets, Step by Step
Building a pay stub template comes down to five steps: set up the layout, enter employer and employee details, add pay and deductions, build the gross-to-net formula, then save it as a reusable file.
Step 1: Set Up Your Spreadsheet Layout
Create labeled rows or columns for each required field so the template stays consistent every time you reuse it.
Step 2: Enter Employer and Employee Details
Fill in the business name, employee name, ID, and the specific pay period you're documenting.
Step 3: Add Gross Pay and Deductions
List gross pay first, then itemize each deduction on its own line (federal tax, FICA, state tax, and so on) rather than combining them into one number.
Step 4: Build the Gross-to-Net Calculation
Set up a formula that subtracts total deductions from gross pay automatically, so net pay updates whenever you change an input.
Step 5: Save as a Reusable Template
Save a blank copy separately from any completed stub, so you can duplicate it for the next pay period without re-typing the layout.
Excel Pay Stub Formulas Explained: SUM, IF, and Gross-to-Net
The two formulas that do most of the work in a pay stub template are SUM, for adding up earnings or deductions, and IF, for handling different pay types like hourly versus salaried.
Writing a Basic SUM Formula for Gross Pay
A simple SUM formula adds every earnings line into one gross pay total, for example =SUM(B2:B5) if your earnings entries sit in cells B2 through B5.
Most templates online hardcode this total instead of using SUM, which means one manual entry error throws off the whole stub. Using an actual formula catches that automatically.
Using IF Formulas for Hourly vs. Salaried Pay
An IF formula lets one template handle both pay types, for example =IF(C2="Hourly", D2*E2, F2), which multiplies rate by hours for hourly workers or pulls a flat salary otherwise.
Example: A contractor who splits time between hourly project work and a flat monthly retainer can use one IF formula instead of building two separate templates.
Q: What's the easiest formula for calculating net pay in Excel?
A: Gross pay minus total deductions, written as a simple subtraction formula like =B2-C2, is enough for most single-employee templates.
Excel vs. Google Sheets for Pay Stubs: Which Fits Your Situation
Excel and Google Sheets can both build the same pay stub template, so the better choice usually comes down to collaboration needs and where you already work.
When Excel Makes More Sense
Excel works better if you're working offline often, need more advanced formula and formatting options, or already use it for other business records.
When Google Sheets Makes More Sense
Google Sheets works better if you need to share or edit the template with someone else, want automatic cloud backup without manually saving versions, or need to check a stub from your phone.
One thing competitors don't mention: formulas built in Excel generally transfer cleanly into Google Sheets, so you're not locked into one platform once you've built a template.
Common Mistakes That Make a Spreadsheet Pay Stub Look Wrong
The most common mistakes are broken formula references after copying the template, inconsistent formatting between pay periods, and outdated tax withholding estimates.
- Copying the template without checking that formulas still point to the right cells
- Reusing last year's tax percentages without updating them against current IRS withholding tables
- Leaving deduction lines blank instead of showing $0
- Changing the layout between pay periods, which makes a pattern of stubs look inconsistent to a reviewer
- Forgetting to keep copies for your own payroll records once a stub has been issued
Many lenders and landlords only accept a spreadsheet-generated pay stub when the numbers are consistent with your bank statements and tax records. A stub that looks clean but doesn't match your deposits can raise more questions than one with no stub at all.
FAQs
Is there a free pay stub template for Excel or Google Sheets?
Yes. You can build one from scratch using the steps above, or start from PayStubVault's pay stub builderif you'd rather skip the manual formula setup.
Can I make a pay stub without knowing spreadsheet formulas?
Yes, though you'll need to calculate gross pay, deductions, and net pay by hand instead of having the spreadsheet update automatically.
Does a pay stub made in Excel count as proof of income?
Often yes, as long as it's accurate and consistent across pay periods. Some lenders may still ask for supporting documents like bank statements alongside it.
How do I make a pay stub for an hourly employee in Excel?
Multiply the hourly rate by hours worked to get gross pay, then subtract deductions the same way you would for a salaried employee.
Are spreadsheet pay stubs legal?
Yes. Making your own pay stub in Excel or Google Sheets is legal as long as every figure reflects income that was actually earned and paid.
Do landlords accept spreadsheet pay stubs?
Many do, especially when the stub is consistent across pay periods and lines up with bank statements. Some landlords may still ask for a tax return or 1099-NEC as backup.
Can I print an Excel pay stub?
Yes. Once the template is filled in, you can print it directly from Excel or export it as a PDF first for a cleaner printed copy.
Can I use Google Sheets on mobile to check or edit a pay stub?
Yes. Google Sheets' mobile app supports the same formulas and formatting as the desktop version, so you can review or update a stub from your phone.
What to Do Next: Download the Template or Automate It
Start with a single pay period, build or download the template, and confirm the formulas are pulling the right numbers before you rely on it going forward.
Related Reading on the Full Pay Stub Process
For the full breakdown of what goes into a pay stub and how the process works beyond spreadsheets, PayStubVault's complete guide to making a pay stubcovers everything this walkthrough doesn't, including legal requirements, common rejection reasons, and 2026 pay stub law updates.
Conclusion
A pay stub template in Excel or Google Sheets is a straightforward way to document pay without payroll software, as long as the formulas are set up correctly, the deductions reflect current IRS withholding rules, and the format stays consistent every period.
Tired of rebuilding formulas and double-checking tax tables by hand? Generate a pay stub with PayStubVault instead, with gross-to-net calculations handled automatically and a consistent, professional format every time, no spreadsheet maintenance required.
