Payroll Tax Spreadsheet 2026 Excel | Form 941 vs W-2 Check, FICA & FUTA, Federal Withholding Pub 15-T (Digital Download)

Payroll tax spreadsheet for 2026 in Excel: figures federal withholding by IRS Pub. 15-T 2026 and catches W-2 totals that do not match your four Forms 941, a mismatch the IRS or SSA may contact you about.

Type each paycheck. The workbook figures federal withholding (IRS Pub. 15-T 2026 percentage method), social security to the $184,500 wage base, Medicare plus 0.9% over $200,000, FUTA on the first $7,000 and state unemployment. It fills in the Form 941 lines for every quarter and W-2 boxes 1–6.

In January, type the W-2s and 941s as filed: the check page marks every line that is off and names the W-2 or quarter behind it. In the filled example, one W-2 shows $206,879.92 in box 3 (over the cap) and the Q3 941 is missing a $2,080.00 paycheck. Both turn red.

What's inside
• Filled example workbook (4 employees, biweekly)
• Blank workbook: up to 15 employees and 500 paychecks
• Paycheck check: Pub. 15-T Worksheet 1A line by line for any paycheck
• Deposit due date per paycheck (monthly or semiweekly, 2026 legal holidays)
• Word guide: 2026 filing and deposit calendar, year-end W-2/941 checklist, reconciliation record
• Fill-in guide in every file: a “Fill in with AI” chapter with ready-made sentences for an AI chat assistant, matched to the template’s fields

Who it is for
Small business owners and bookkeepers running payroll for 1–15 employees, or double-checking a payroll service.

How to edit
Excel, Google Sheets or LibreOffice; Word or Google Docs.

Format
US Letter. 2 × .xlsx, 1 × .docx. Rates: IRS Pub. 15 and Pub. 15-T (2026), re-read October 23, 2026. Federal taxes only; not tax advice.

Digital download – no physical item is shipped.

Disclosure (Etsy policy): this item was designed by the seller with the help of AI tools.