A friend texted me last spring with a screenshot. She'd been logging her paystubs in a spreadsheet all year and wanted me to look at it before she handed the file to her CPA.
The columns were Date, Net Pay, and a single "Taxes" column. That was it. No gross, no pre-tax breakout, no FICA line, no way to reconcile against her W-2. She'd been faithfully entering one number a paycheck — the amount that hit her checking — and calling it income tracking.
When her CPA opened the file, the first question was "what was your gross pay?" She had to log back into ADP and pull every single stub again. Two hours that should have been zero, all because the format she'd picked didn't carry the data she needed.
This is the part nobody tells you about tracking paystubs in a spreadsheet: the layout matters more than the spreadsheet skills. If your columns don't match the structure of the underlying paystub, you'll find out at the worst possible time — usually April.
Here's the pay stub format in Excel that actually works.
What every US paystub contains
Whether your stub comes from ADP, Workday, UKG, Paychex, Gusto, or any other US provider, it has the same logical sections. The visual styling differs; the data doesn't.
- Employer info — company name, address, EIN
- Employee info — your name, employee ID, address
- Pay period — start date, end date, check date
- Earnings — gross pay broken down by line item (regular, overtime, bonus, holiday, PTO)
- Pre-tax deductions — 401(k), HSA, FSA, pre-tax health/dental/vision
- Taxes — federal income, state income, Social Security, Medicare, sometimes local
- Post-tax deductions — Roth 401(k), garnishments, post-tax insurance, union dues
- Net pay — what actually hits your bank account
A working Excel format mirrors that order from left to right. Gross at the start; net at the end. Everything in between subtracts in the right sequence.
The recommended Excel column layout
Here are the columns I use, left to right. Each row is one paystub.
- Date (check date, not pay period start — you'll thank yourself when sorting by year)
- Pay period start
- Pay period end
- Hours regular
- Hours OT
- Rate
- Earnings: regular
- Earnings: OT / bonus / other
- Gross pay (= sum of Earnings columns)
- Pre-tax: 401(k)
- Pre-tax: health / HSA / FSA
- Taxable wages (= Gross − Pre-tax deductions)
- Federal tax
- State tax
- Social Security (6.2%)
- Medicare (1.45%)
- Post-tax: Roth 401(k) / other
- Net pay
- YTD gross
- YTD net
That's twenty columns. It looks like a lot until you realize every paystub already has these numbers printed on it — the work is reading them off, not calculating anything new.
The first three columns identify the row. The next five capture earnings detail. The middle eight are the breakdown that makes the math reproducible. The last two are YTD running totals, which Workday, ADP, and UKG all print but most people forget to log.
If twenty columns feels like too much, collapse Earnings: regular and Earnings: OT into a single Earnings column and skip Hours/Rate. You'll lose detail but keep the math.
Why the column order matters
The order isn't arbitrary. It mirrors how a paystub computes net pay, top to bottom:
Gross pay
− Pre-tax deductions
= Taxable wages
− Taxes (federal, state, FICA, Medicare)
− Post-tax deductions
= Net pay
When your Excel columns flow in that same direction, you can drop a formula in at any point and it just works. Put one in the Taxable wages column: = Gross − (Pre-tax 401k + Pre-tax health). Put one in Net pay: = Taxable wages − (Federal + State + SS + Medicare + Post-tax). The arithmetic ought to land on the printed Net Pay number to the cent.
When it doesn't, you've found a mistake — yours or the payroll system's.
That last sentence is the actual reason to use this format. Tracking paystubs isn't really about logging history. It's about catching errors. If you can't reconstruct net pay from the breakdown, your format is too coarse to be useful.
Mapping from ADP, Workday, and UKG
Every major US provider uses the same logical sections. The labels differ.
- ADP (RUN, Workforce Now, Vantage): "Earnings" → Earnings columns. "Taxes" → Taxes. "Deductions" splits into pre-tax and post-tax sub-blocks; copy each into the matching column.
- Workday: "Earnings" or "Pay Inputs" → Earnings. "Employee Taxes" → Taxes. "Pre-Tax Deductions" and "Post-Tax Deductions" come pre-split — direct copy. "Take Home Pay" → Net pay.
- UKG Pro / UltiPro / UKG Ready: standard "Earnings / Taxes / Deductions / Net Pay" labels. UKG also prints a YTD column right next to current — your YTD columns map directly.
- Paychex, Gusto, QuickBooks Payroll, Paylocity, Dayforce, Paycom, Rippling: same shape, different visuals.
If you want a head start with the columns and formulas already wired up, the free pay stub Excel template on StubSheet has them built in. No signup, instant .xlsx. Disclosure: I built StubSheet, so I'm not neutral about which template I'm pointing you at — but it really is free, and the paycheck calculator on that page is useful for sketching out gross-to-net before you've got a real stub to work from.
Common format mistakes
Things I've watched people do, in roughly the order I see them:
One column for "Taxes." This is what my friend did. You lose the ability to verify your W-2 (which breaks taxes into Box 2 federal, Box 17 state, plus the FICA boxes) and you can't compute taxable wages.
No pre-tax deductions column. The number that gets taxed isn't your gross — it's your gross minus 401(k), health, HSA, FSA. If you skip pre-tax in the spreadsheet, your math will diverge from the stub by exactly the pre-tax amount, and you'll spend an evening confused before figuring out why.
Logging gross only, or net only. Either alone is incomplete. Gross without net makes you think you make more than you do. Net without gross makes tax-time reconciliation impossible.
No YTD columns. Every stub prints YTD numbers because they're load-bearing — your year-end W-2 is built from them. If you don't log YTD, you can't catch the case where the stub's YTD doesn't match the sum of your individual rows. (Yes, this happens. It's how you spot a missed paystub, a mid-year payroll system migration, or a retro adjustment that landed in a different period than you expected.)
Pay period start/end as a single field like "10/15–10/29". Now you can't sort or filter on date. Always two date columns.
Skipping check date. Pay period dates and check date can differ by a week or more. The IRS cares about check date for the year a payment falls in. So does Excel, when you're trying to graph anything.
The honest pitch
If you've read this far, you fall into one of two camps.
Camp A: you have a stack of paystub PDFs and you want them in Excel without retyping. The fastest path is dropping them into StubSheet one at a time — the output uses this same column structure. Single file at a time right now; true batch is on the roadmap but not live yet. If you've got more than ten stubs and need them all at once, the competitor StubToCSV has batch upload today and is the better fit for that volume. I'd rather be honest about that than oversell.
Camp B: you don't have a backlog of PDFs — you want a clean template to fill in going forward, or you're modeling a paycheck for a budget. The free Excel template is what you want. Download it, type your paystub numbers into the rows, done.
Either way, the column structure is the same. Get the format right once and the work after that is just data entry.
If you want a deeper read on what each section of a paystub means before you start filling things in, How to Read a Pay Stub walks through the anatomy. And if you're already running multiple stubs through Excel, Track Multiple Pay Stubs in Excel covers the multi-row patterns — pivots, monthly totals, YTD reconciliation against the W-2.
The short version
Pay stub format in Excel is one row per stub, columns flowing left to right in the same order the paystub computes net pay: identifier columns, then gross, then pre-tax deductions, then taxable wages, then taxes, then post-tax deductions, then net, then YTD totals.
The order matters because it makes the arithmetic verifiable. If your formula for net pay doesn't match the printed number on the stub, the format caught a mistake — yours or the payroll system's. That's the entire point.
Skip the bare-minimum "Date, Net Pay" layout. Get the full column set in once and you won't redo it. The free template has the columns and formulas already in place if you'd rather not build it from scratch.