Payroll register template
A payroll register records every paycheck in a pay run: hours, gross pay, each tax withheld, other deductions and net pay. This free template adds up the run, so you can check it against your payroll provider, pay the taxes you withheld, and tie your quarterly Form 941 and year-end W-2s to the totals.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Employee | Hours | Rate | Gross pay | Federal income tax | Social Security 6.2% | Medicare 1.45% | State tax | Other deductions | Net pay |
|---|---|---|---|---|---|---|---|---|---|
| A. Lopez | 80 | $22.00 | $1,760.00 | $142.00 | $109.12 | $25.52 | $0.00 | $60.00 | $1,423.36 |
| B. Chen | 80 | $26.50 | $2,120.00 | $198.00 | $131.44 | $30.74 | $0.00 | $85.00 | $1,674.82 |
| C. Patel | 64 | $19.00 | $1,216.00 | $81.00 | $75.39 | $17.63 | $0.00 | $0.00 | $1,041.98 |
| Total | 224 | $5,096.00 | $421.00 | $315.95 | $73.89 | $0.00 | $145.00 | $4,140.16 |
What does a payroll register show?
Each employee's hours or salary, gross pay, every tax withheld, other deductions such as health insurance or 401(k), and net pay, for one pay run. Add the runs for a quarter and you have what goes on Form 941. Add the year and you have each employee's W-2.
Which taxes come out of a paycheck?
Federal income tax, based on the employee's W-4. Social Security at 6.2% on wages up to $184,500 for 2026. Medicare at 1.45% on all wages, plus 0.9% additional Medicare once wages pass $200,000. State and sometimes local income tax. You match Social Security and Medicare and pay federal and state unemployment yourself. Our payroll cost calculator shows the full cost of a hire.
Should I run payroll from a spreadsheet?
We don't recommend it beyond one or two employees. Withholding tables, deposit schedules, state rules and year-end forms are where small mistakes turn into penalties. Gusto or ADP handle the math and filings, and this register is a good way to check them. Or let us run payroll for you.
Sources
- IRS: Publication 15 (Circular E), employer's tax guide
- IRS: Publication 15-T, federal income tax withholding
General information, not tax advice for your situation.
How long must I keep payroll records?
At least four years after the tax is due or paid, whichever is later, for employment tax records.
Is health insurance taken before tax?
Usually, if it's under a cafeteria plan. That lowers federal income tax and, in most cases, Social Security and Medicare too.
What is the 2026 Social Security wage base?
$184,500. Social Security tax stops for the rest of the year once an employee's wages reach it.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.