Excel workbook previewPayroll Reconciliation Template (Form 941 to General Ledger)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A payroll reconciliation proves that the payroll register, the quarterly Form 941 and the general ledger tell the same story. Auditors ask for it at year end, and a controller needs it before signing a Form 941, because a difference found after filing means a corrected return. This template does the quarterly tie-out and the year-end check of Forms 941 against Form W-3.
The workbook recomputes every Form 941 line from register totals using the line structure in the Form 941 instructions (Rev. 03/2026), then compares it with the return as filed. Reconciling items carry each known difference to the line or account it affects. The GL sheet rolls forward the federal tax payable account, and the W-3 sheet follows the reconciliation steps in the IRS General Instructions for Forms W-2 and W-3.
Who it is for
The controller or senior accountant who must show the auditor that Form 941, the payroll register and the general ledger agree each quarter.
What is inside
- Payroll by pay date sheet with 7 worked pay dates for Q3 2026 and 16 blank rows, deposit difference flagged in red
- Form 941 check recomputing 20 line items from the register at the 0.124, 0.029 and 0.009 multipliers
- Per register, reconciling items, adjusted, as filed and unexplained difference columns with Agreed or Investigate status
- Tax liability by month for Form 941 Part 2 or Schedule B, checked against line 12
- Reconciling items log with 11 worked items, 14 blank rows and dropdowns for the line or account affected
- GL tie-out for wages expense, payroll tax expense and the federal tax payable roll-forward
- Annual W-3 check comparing boxes 2, 3, 4, 5, 6 and 7 with the four quarterly Forms 941
- Worked example for Ashcombe Group with one unexplained difference left to investigate
How to use it
Paste your provider's register totals by pay date into the first sheet, then type the figures from the Form 941 as prepared into the As filed column.
Files
- XLSXpayroll-reconciliation-template.xlsx20 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
How do you reconcile Form 941 to the general ledger?
Start from the payroll register totals for the quarter, recompute each Form 941 line, and explain any difference with dated reconciling items such as manual checks or accruals. Then compare wages expense, payroll tax expense and the tax payable roll-forward in the ledger with the register plus those items. What remains unexplained is investigated before filing.
Why does line 7 of Form 941 show a few cents?
Line 7 is the adjustment for fractions of cents. Tax is withheld paycheck by paycheck and rounded each time, while lines 5a to 5d compute the tax on total wages for the quarter. The two rarely match to the cent, and the difference goes on line 7. The template calculates it from the register.
Which Form W-3 boxes should match Form 941?
The IRS instructions compare boxes 2, 3, 5 and 7 of Form W-3 with the yearly totals of the Forms 941, and say social security and Medicare tax on Form 941 should be about twice boxes 4 and 6, because Form 941 includes the employer share. Valid differences are confirmed and kept on file.




