6.2 Quarterly and Year-End Reconciliation

Reconciliation Is a Payroll Control, Not a Year-End Chore

Quarterly and year-end reconciliation connect the calculation side of payroll with the compliance and accounting sides. A payroll register may show what employees were paid, but Form 941 shows what the employer reported to the IRS, deposit confirmations show what cash was remitted, Forms W-2 and W-3 show what employees and the Social Security Administration receive, and the general ledger shows the financial statement impact. The FPC expects you to understand those records as a chain, not as isolated reports.

The best habit is to reconcile every quarter before year-end. Waiting until January to fix four quarters of unresolved differences creates filing pressure and increases the chance of corrected returns. A quarterly close should verify taxable wages, federal income tax withheld, Social Security and Medicare wages, Social Security and Medicare taxes, Additional Medicare Tax where applicable, deposit totals, and payroll liability accounts.

Quarterly Reconciliation Checklist

The W-2/W-3 to 941 Tie-Out

IRS Publication 15 gives a practical year-end reconciliation target: compare Form W-3 with the four quarterly Forms 941 for federal income tax withheld, Social Security and Medicare wages, and Social Security and Medicare taxes. The tax comparison requires judgment because Forms 941 report both employer and employee Social Security and Medicare taxes, while Form W-3 reports employee tax amounts. Current-year adjustments may also explain differences.

Start with totals, then drill down. If Form W-3 federal income tax withheld does not equal the total of the four Form 941 federal income tax withholding amounts, review voids, off-cycle checks, manual adjustments, third-party sick pay, reversed checks, and employees with corrected records. If Social Security wages exceed the annual wage base for an employee, that is a per-employee issue, not just a total report issue. If Medicare wages are lower than Social Security wages without a documented reason, review pretax benefit setup and taxable fringe handling.

Year-End Workflow

1. Before the final payroll, audit employee names, Social Security numbers, addresses, state work locations, and benefit deductions.
2. Before W-2 creation, load taxable fringe benefits, group-term life imputed income, relocation or award amounts, and third-party sick pay information.
3. After the final payroll, reconcile quarterly Form 941 totals to annual W-2/W-3 totals and investigate differences.
4. Compare payroll liabilities in the general ledger to tax deposits, benefit carrier invoices, garnishment remittances, and uncashed payroll items.
5. Lock final reports only after corrections are approved, documented, and reflected in all affected systems.

Retention and Evidence

Reconciliation is only as good as the evidence retained. IRS employment tax records should be kept for at least four years and should be available for review. DOL FLSA guidance separately requires employers to preserve payroll records for at least three years and wage-computation support, such as time cards and schedules, for at least two years. For exam purposes, do not collapse those rules into one generic retention period. Different laws can require different records and different timelines.

A year-end evidence file should include payroll registers, tax registers, deposit confirmations, filed returns, W-2 and W-3 totals, correction logs, taxable fringe support, benefit and garnishment remittance reports, and GL reconciliation signoffs. Electronic records are acceptable when they remain complete, readable, retrievable, secure, and backed up. A report that cannot be reproduced later is weak audit evidence even if the calculation was right at the time.

Payroll Example

Suppose the four Forms 941 show $480,000 of Social Security wages, but Form W-3 shows $478,500. Payroll should not book a $1,500 plug. The team should identify whether a voided check, corrected taxable benefit, late manual check, or employee-level wage-base issue caused the difference. If the Form 941 amount is wrong, the answer may be Form 941-X. If W-2 data is wrong after filing, the answer may be Form W-2c and Form W-3c. The reconciliation tells payroll which correction path is needed.

Common FPC Traps

• Treating reconciliation as only a year-end task instead of a quarterly control.
• Comparing net pay to taxable wages and expecting them to agree.
• Ignoring current-period adjustments, such as fractions of cents, that can explain small differences.
• Forgetting that state wage definitions may differ from federal wage definitions.
• Keeping summary totals but losing source documents that prove the totals.
• Closing a quarter before payroll, tax, bank, and GL owners agree on the same final control totals.