Form 941 reconciliation

Drop two files — your payroll data and your tax payments for the quarter — and see whether what payroll owed matches what you deposited. Add the filed 941 for the full three-way tie-out. Every variance is traced to the rows that produced it. How it works, with example files →

STEP 1

Quarter & deposit schedule

TAX YEARQUARTERDEPOSIT SCHEDULE

STEP 2

Payroll data for the quarter

Choose fileCSV or XLSX — one row per employee per check date

STEP 3

Tax payments for the quarter

Choose fileEFTPS export, bank CSV, or GL extract

STEP 4 · OPTIONAL

Form 941 as filed

Skip this for a two-file balance (payroll vs deposits). Add the filed 941 to also check the reported leg — the full three-way tie-out. Payroll Social Security wages include tips, so lines 5a and 5b are checked together.

L2 Wages/tips/compL3 FIT withheldL5a SS wagesL5a SS tax (×12.4%)L5b SS tipsL5b SS tips tax (×12.4%)L5c Medicare wagesL5c Medicare tax (×2.9%)L5d Add'l Medicare wagesL5d Add'l Medicare tax (×0.9%)L7 Fractions of centsL12 Total taxL13 Total deposits

L16 MONTHLY LIABILITY (OPTIONAL)

Month 1Month 2Month 3