Accountio / Templates / Payroll tax reconciliation / Form 941 reconciliation

941 reconciliation template in Excel: Form 941 against the payroll register

Tie every line of the quarterly Form 941 to your payroll register before you file, check the tax withheld from employees, and match deposits to the liability for each month. This 941 reconciliation template is one Excel workbook with a sheet for each quarter of 2026, the IRS rates already set and a Check column that shows OK or what to fix.

US firms
$15
In the pack
Payroll tax reconciliation workbooks
Files
4, Word and Excel
Buy the pack · $15
US library · 46 packs

Get this pack and 45 more for $69

Payroll tax reconciliation · this packBookkeeping and advisory lettersAudit and AUP lettersCompilation and review lettersIndependent contractors1040 checklistsIRS noticesSales tax nexusNonprofit audit+ 37 more
$69$61589% off

You save $546 on buying them one by one

Buy the US library · $69

Want every pack, for every region? Global library, 101 packs, $129

What the workbook looks like

Form 941 reconciliation template
What the workbook checksSheet or column in the workbook
Employer details and the rounding you accept
✓
SettingsEmployer name, EIN, the difference accepted as rounding and the 2026 rates
Each 941 line, register against return
✓
Per payroll register, Per Form 941One sheet for each quarter, Q1 to Q4
Employee count
✓
941 line 1Employees paid in the pay period that includes the 12th of the quarter's last month
Wages and federal income tax withheld
✓
941 lines 2 and 3Entered from the register and the draft return
Social security and Medicare tax worked out
✓
941 lines 5a to 5eAt 12.4%, 2.9% and 0.9% on the register side
Tax on unreported tips and adjustments
✓
941 lines 5f and 7 to 9Section 3121(q) amounts, fractions of cents, sick pay, tips and group-term life
Totals, deposits and balance due
✓
941 lines 6, 12, 13 and 14 / 15Balance due or overpayment worked out for you
A check on every line
✓
Difference, CheckOK, or an instruction to correct the register or the 941 before filing
Tax withheld from employees
✓
Employee tax withheldSocial security at 6.2% and Medicare at 1.45% plus Additional Medicare Tax
Deposits against the monthly liability
✓
Deposits and tax liability by monthDeposits from bank records or EFTPS against line 16 or Schedule B, with short deposits flagged
Liability equal to line 12
✓
Deposits and tax liability by monthThe total row checks that the quarter's liability equals total taxes
The year's totals
✓
SummaryEach line for the four quarters, a year column and the count of checks not OK

When you need it

Form 941 is due by the last day of the month after the quarter ends: April 30, July 31, October 31 and January 31. If you deposited the tax for the quarter in full and on time, you can file by the 10th day of the second month after the quarter ends. Reconcile:

  • Each quarter, before the 941 is filed
  • When a payroll provider files the 941 for you, since the employer still answers to the IRS if the provider fails to file or pay
  • When a monthly deposit doesn't match the liability for that month
  • In January, before the Forms W-2 and W-3 go to the SSA, because the IRS compares the W-3 with the four 941s and contacts you about differences
  • When you find an error on a 941 already filed, before you prepare Form 941-X

How to use the 941 reconciliation template

  1. Fill in Settings. Employer name, EIN and the rounding difference you accept. The default is $1.
  2. Enter both sides for the quarter. Register totals in the Per payroll register column and your draft 941 in the Per Form 941 column. The register side works out the tax on lines 5a to 5e, 6, 12 and 14.
  3. Enter the tax withheld and the deposits. Employee social security and Medicare tax from the register, and each month's deposits from your bank records or EFTPS.
  4. Clear every check. File the 941 only when every Check cell shows OK. Correct the register or the return first.
  5. Use the Summary at year end. The year's totals for each line go into the W-2 and W-3 reconciliation in January.

Questions

What is a 941 reconciliation?

A comparison of each line of the quarterly Form 941 with the payroll register and the tax deposits for the quarter, done before the return is filed. Wages, withholding, social security and Medicare wages and tax, adjustments and deposits should all agree.

How do you reconcile Form 941 to payroll?

Take the quarter's totals from the payroll register, work out the social security and Medicare tax at the IRS rates, and compare each figure with the draft 941 line by line. Then compare the tax withheld from employees with the rates, and the deposits for each month with the liability.

When is Form 941 due?

By the last day of the month after the quarter ends: April 30, July 31, October 31 and January 31. If you made timely deposits in full payment of the quarter's taxes, you can file by the 10th day of the second month after the quarter, for example May 10 for the first quarter.

Why must the liability on line 16 equal line 12?

The IRS instructions say the total tax liability for the quarter must equal total taxes on line 12. If it doesn't, your deposits and payments may not be counted as timely. Line 16 is a summary of the liability for each month, not of the deposits you made.

What tax rates go on Form 941 for 2026?

Social security at 12.4% on lines 5a and 5b (6.2% employee and 6.2% employer) up to a wage base of $184,500, Medicare at 2.9% on line 5c (1.45% each) and Additional Medicare Tax withholding at 0.9% on wages over $200,000 in the calendar year, employee only.

How do you reconcile the 941s to the W-3?

Compare boxes 2, 3, 5 and 7 of Form W-3 with the year's totals from the four 941s: income tax withheld, social security wages, Medicare wages and tips, and social security tips. The workbook's Summary sheet gives those totals.

Also in the payroll tax reconciliation workbooks

W-2 and W-3 year-end reconciliationState unemployment reconciliation

See the whole pack →

Who it's for

US employers, bookkeepers and CPA firms that run payroll and file Form 941 each quarter.

Last checked

Checked against Form 941 (Rev. March 2026), its instructions and the 2026 Form W-2 and W-3 instructions in November 2026.