Enterprise payroll reconciliation matches three independent data streams: the payroll register (what the system calculated), the filed returns (what was reported to agencies), and the payment evidence (what was actually deposited). When all three align for each entity, quarter, and jurisdiction, the reconciliation is complete. When any two disagree, the gap identifies a correction that needs to be filed or a deposit that needs to be traced.
The operational problem
Payroll reconciliation at the enterprise level is not the same as balancing a single payroll run. Each pay period generates a payroll register with gross wages, tax withholdings, employer liabilities, and net pay. Those figures accumulate into quarterly returns (Form 941 for federal, plus state withholding and unemployment returns). The deposits that fund those liabilities flow through EFTPS for federal taxes and state electronic payment systems for state taxes.
Three-way reconciliation means matching the payroll register totals to the filed return totals to the deposit evidence totals. A discrepancy between the register and the filed return means the return was prepared incorrectly. A discrepancy between the filed return and the deposit evidence means either the deposit was for the wrong amount, the wrong date, or was not made at all. A discrepancy between the register and the deposit evidence without a discrepancy on the return means the return was filed with figures that do not match the actual deposits.
Consequences of unreconciled discrepancies
When the three data streams are not reconciled, the following issues tend to surface:
- Notices from agencies identifying mismatches between filed returns and deposits. The IRS may issue a CP notice if the Form 941 tax liability does not match the EFTPS deposit history.
- Year-end W-2 figures that do not match quarterly return totals. If the quarterly returns were filed with incorrect wage figures and the annual W-2 is prepared from the payroll register, the two will disagree.
- Failure-to-deposit penalties when deposits were made for the wrong amount or on the wrong schedule (monthly vs. semiweekly).
- State unemployment insurance rate errors that result in overpayment or underpayment of SUI tax, which can affect the employer's experience rating in subsequent years.
Workflow: Three-way reconciliation process
| Step | Data source | What to compare | Expected result | Action if mismatch |
|---|---|---|---|---|
| 1 | Payroll register (per pay period) | Gross wages, employee withholding, employer taxes | Totals accumulate to quarterly figures | Recheck payroll system setup and employee tax profiles |
| 2 | Form 941 (as filed) | Register quarterly totals vs. return line items | Register total = return line 2 (wages), line 3 (income tax), lines 5a-5d (SS/Medicare) | Prepare Form 941-X to correct the return |
| 3 | EFTPS deposit history | Return tax liability (Form 941 Part 2 or Schedule B) vs. deposits made | Total deposits = total tax liability for the quarter | If deposits short, make supplemental deposit; if over, claim refund or apply to next quarter |
| 4 | State withholding returns | Register state-level wages vs. state return | State wages on return = register wages by state | File state correction return |
| 5 | State SUI returns | Register SUI wages vs. state SUI return | SUI wages by state = register SUI wages | File state SUI correction |
| 6 | State deposit confirmations | State return liability vs. state payment history | State deposits = state return liability | Contact state agency to trace missing payment |
| 7 | Annual W-2 / W-3 | Annual register totals vs. W-2 totals | W-2 wages = full-year register wages | File W-2c if W-2 is wrong; file Form 941-X if quarterly returns are wrong |
What may be delegated and what remains with an authorized owner
A bookkeeper or staff accountant can compile the payroll register exports, download EFTPS history, and prepare the initial reconciliation worksheet. A controller or accounting manager should review the reconciliation and approve any corrections before they are filed.
The preparer determines the correction method, affected returns and payment timing from the facts and current instructions. A source workbook alone does not authorize an amendment or a deposit.
IRS contact and representation require confirmation of the named person's rights and the applicable authorization. The administrative staffing role described here does not include agency representation.
Synthetic workflow example
SYNTHETIC EXAMPLE: These are fabricated worksheet values. They are not tax computations or a completed engagement.
Three employer files contain source wages of $1,240,000, $890,000 and $675,000. Their supplied Form 941 line 2 amounts are $1,240,000, $890,000 and $672,000. The source-to-return differences are $0, $0 and $3,000, respectively. The combined source wages are $2,805,000; the combined reported wages are $2,802,000. These portfolio totals are a management view, not an instruction to combine returns.
The third file contains a $3,000 bonus entry missing from the return-preparation export. The reviewer must determine which tax fields and filings are affected. The worksheet does not derive total payroll tax from wages alone or apply the employee-only 7.65% rate as full payroll tax. Actual income-tax withholding, wage-limit status, both employer and employee tax portions, credits and adjustments need separate evidence.
Support delivers the source references and discrepancy to the tax reviewer. No amendment, payment or penalty estimate is treated as approved. State wage categories and unemployment taxable wages are compared under their own definitions rather than assumed equal to federal gross wages.
Education, experience, and systems considerations
The person performing the reconciliation should be able to:
- Export payroll register data at the pay-period level and aggregate it to quarterly totals
- Work through EFTPS and download deposit history with date and amount detail
- Read a Form 941 and map each line to the corresponding payroll register field
- Understand that Schedule B (semiweekly depositors) requires daily liability accumulation that must match the deposit timing
- Distinguish between employer taxes (FUTA, SUI, employer share of Social Security and Medicare) and employee withholding (income tax, employee share of Social Security and Medicare)
- Identify which state returns are required for each entity based on where employees work, not where the entity is headquartered
Engagement and jurisdiction considerations
Use the reviewer-approved federal, state and local filing inventory. Compare each tax base and period separately. Employee presence in a state does not by itself establish every withholding or unemployment obligation.
For employers operating in states with local taxes (such as Ohio school district tax, Pennsylvania local earned income tax, or New York City and Yonkers withholding), local returns must also be included in the reconciliation. Local tax jurisdictions may have different filing frequencies than the state-level returns.
Privacy considerations
Access should be limited to approved people and systems. Before sharing records, the engagement owner and counsel determine which privacy, confidentiality, consent and security rules apply to the information and the proposed activity. IRC Section 7216 and the FTC Safeguards Rule have defined scopes and exceptions; neither should be applied to every payroll record solely because an outside provider is involved. This is general information, not legal advice. Official consent rule.
Proposed measurement guidance
These are proposed internal review measures to agree for an engagement, not agency deadlines, guaranteed results or verified performance. Applicable deadlines must be confirmed separately.
- Three-way reconciliation completed for each entity for each quarter
- Zero unexplained variances between register, return, and deposit evidence
- All variances documented with a resolution plan and target date
- State-level reconciliation completed for every jurisdiction where wages were paid
- Annual W-2 totals reconciled to full-year payroll register before year-end filing
- Reconciliation reviewed and approved by the controller or CFO within 15 business days of quarter end
FAQs
How often should the three-way reconciliation be performed?
At minimum, quarterly, aligned with the Form 941 filing cycle. Enterprises with high payroll volume or multiple entities should consider monthly or per-pay-period reconciliation to catch discrepancies before they accumulate.
What if the payroll register and the Form 941 agree but EFTPS shows a different deposit amount?
The deposit was made for the wrong amount or was not posted. Check EFTPS for the specific deposit date and amount. If the deposit is missing, make it immediately. If the deposit amount is wrong, the difference will need to be resolved either through a supplemental deposit (if short) or a refund claim (if over).
Do I need to reconcile state returns the same way?
Yes. Each state return should be reconciled to the payroll register's state-level wage totals and to the state deposit history. State deposit systems are separate from EFTPS and must be checked independently.
What is Schedule B and when is it needed?
Schedule B is attached to Form 941 by employers who are semiweekly depositors. It reports the daily tax liability for each day of the quarter. The total on Schedule B must equal the total tax liability on Form 941. If the reconciliation shows a mismatch between Schedule B and the register, the daily liability accumulation in the payroll system needs to be reviewed.
Can I delegate the reconciliation to a bookkeeper?
A bookkeeper can compile the data and prepare the initial reconciliation. A controller or accounting manager should review and approve the results. If the reconciliation reveals errors requiring amended returns, a credentialed preparer should handle the correction filings.
What records should I retain from the reconciliation?
Retain the payroll register exports, the filed returns, the EFTPS and state deposit confirmations, the reconciliation worksheet, and any resolution documentation for at least four years (the federal employment tax record retention period). Some states may require longer retention.
This guide provides general educational information. Your qualified adviser must assess the facts, current instructions and applicable jurisdiction before a tax or legal decision.
Explore related support
Explore quarter end reconciliation or discuss your support scope.
Sources
- IRS, Outsourcing Payroll Duties
- IRS, About Form 941-X
- IRS, About Form 941
- IRS, About Form 940 (FUTA)
- IRS, Publication 15 (Circular E)
- IRS, IRM 5.1.24, Third-Party Payer Arrangements
- Official records guidance
- Official source for the current correction
- Official source for the current correction
- Official source for the current correction
