Start with a reviewer-approved map of employer accounts, filing arrangements and applicable jurisdictions. Compare each period's payroll records, returns and payment evidence under that map, keeping separate employers and aggregate-filer allocations traceable. Record differences and missing evidence for the authorized reviewer; do not force deposits and liability to match or assume every legal entity files its own Form 941.
The operational problem
At quarter end, an enterprise needs to identify which taxpayer and filing arrangement each record belongs to. Separate-employer and aggregate-filer arrangements require different mappings. State and local obligations follow the facts and applicable rules, not simply a count of entities or employee locations.
The workload depends on the actual return types, accounts, periods and provider arrangements. Use an inventory confirmed by the reviewer instead of estimating the filing population by multiplying entities by states.
What reconciliation means at quarter end
Quarter-end reconciliation is the process of confirming three things for each entity:
- Register to return: The payroll register's quarterly totals for wages, federal withholding, Social Security, Medicare, and employer taxes match the Form 941 that was filed (or will be filed) for that quarter.
- Return to deposit: Compare total liability with actual payments and applicable credits. Record overpayments, shortfalls, timing and posting questions separately. Historical deposits remain unchanged. Where Schedule B applies, the reviewer checks its liability totals against the applicable Form 941 instructions.
- Return to state returns: Compare reviewer-selected state wage categories with payroll detail. Federal and state tax bases can differ; an unexplained difference needs review rather than a balancing entry.
Consequences of skipping quarter-end reconciliation
When an enterprise does not perform quarter-end reconciliation, the following problems accumulate:
- Variances grow quarter over quarter. A small mismatch in Q1 that is not identified becomes harder to trace in Q2 when it compounds with new variances.
- Year-end W-2 totals do not match quarterly returns. If the quarterly returns were filed with incorrect figures and the W-2s are prepared from the register, the two will disagree, creating IRS mismatch notices.
- Deposits are missed or made for the wrong amount. Without reconciliation, the enterprise may not discover that a deposit was short until the IRS sends a failure-to-deposit penalty notice.
- State returns are missed. A new state where an employee was hired during the quarter may not have been on the filing list, leaving a state return unfiled and potentially triggering a state penalty.
Workflow: Quarter-end reconciliation process for multiple entities
| Step | What to do | Per entity or aggregate | Evidence to retain |
|---|---|---|---|
| 1 | Export the payroll register for each entity for the quarter | Per entity (each EIN) | Register export by entity |
| 2 | Confirm the required return or aggregate-filer allocation for each employer | Per entity | Filing confirmation or postmark |
| 3 | Compare register wages to Form 941 line 2 | Per entity | Reconciliation worksheet |
| 4 | Compare register federal withholding to Form 941 line 3 | Per entity | Reconciliation worksheet |
| 5 | Compare register Social Security and Medicare to Form 941 lines 5a-5d | Per entity | Reconciliation worksheet |
| 6 | Compare Form 941 total liability to EFTPS deposit total | Per entity | EFTPS report by EIN |
| 7 | If semiweekly depositor: confirm Schedule B totals match Form 941 | Per entity | Schedule B comparison |
| 8 | List all states where each entity had employees during the quarter | Per entity | State wage summary by entity |
| 9 | Confirm evidence for each reviewer-approved state withholding obligation | Per entity, per state | State filing confirmations |
| 10 | Confirm evidence for each reviewer-approved unemployment obligation | Per entity, per state | State SUI filing confirmations |
| 11 | Compare state wage totals to register state breakdown | Per entity, per state | State reconciliation worksheet |
| 12 | Compare state payments and liabilities; explain differences | Per entity, per state | State deposit confirmations |
| 13 | Document all variances with a resolution plan | Per entity | Variance log |
| 14 | Confirm Form 940 (FUTA) status (annual, but accrued quarterly) | Per entity | FUTA accrual worksheet |
| 15 | Controller or CFO review and sign-off | Aggregate review | Signed reconciliation summary |
What may be delegated and what remains with an authorized owner
A staff accountant or bookkeeper can perform steps 1 through 12 above. The controller or CFO should review the completed reconciliation (step 15) and approve any corrections that need to be filed.
If the reconciliation reveals that a Form 941 was filed incorrectly, a Form 941-X should be prepared by someone who understands the correction vs. adjustment distinction. If a state return was missed, the state return should be filed as soon as possible, and the state agency should be contacted to request penalty abatement if applicable.
Synthetic workflow example
SYNTHETIC EXAMPLE: These are fabricated source-to-return comparisons, not tax calculations or a completed client engagement.
Four confirmed employer records contain Q2 wages of $680,000, $440,000, $310,000 and $195,000. The corresponding supplied Form 941 line 2 values are $680,000, $440,000, $310,000 and $192,000. The reviewer's filing map treats them as separate employers for this exercise only.
| Employer | Source wages | Reported wages | Source less reported |
|---|---|---|---|
| A | $680,000 | $680,000 | $0 |
| B | $440,000 | $440,000 | $0 |
| C | $310,000 | $310,000 | $0 |
| D | $195,000 | $192,000 | $3,000 |
| Management summary | $1,625,000 | $1,622,000 | $3,000 |
The team links the $3,000 difference to an omitted source-export entry and asks the tax reviewer to assess the affected fields. This table does not calculate full payroll tax from gross wages or assume every employee remains below the Social Security wage limit. Actual withholding, taxable wage categories, employer and employee portions, credits and adjustments need separate records.
Deposits remain tied to their own confirmations, account and period. The reviewer determines whether a return, wage statement or payment requires action. The administrative workbook records the decision and keeps unresolved state allocations separate. No $229.50 payment, amendment or clean-close result is inferred from the wage difference.
Education, experience, and systems considerations
The person performing the reconciliation should be able to:
- Export payroll register data at the entity level and aggregate it to quarterly totals
- Work through EFTPS and filter deposit history by EIN
- Read a Form 941 and map each line to the corresponding register field
- Understand that Schedule B daily liability must total to the Form 941 for semiweekly depositors
- Identify which state returns are required based on employee work states
- Recognize that some states have local tax returns (such as Ohio school district tax, Pennsylvania local earned income tax) that must be reconciled in addition to state-level returns
- Distinguish between federal wages (Form 941 line 2) and state wages (which may differ due to state-specific exemptions)
Engagement and jurisdiction considerations
Use the approved jurisdiction list to check the applicable state and local records. An absence of state wage income tax does not settle unemployment or other reporting obligations. The reviewer confirms coverage, exemptions, account status and required filings for the actual employer.
Local tax jurisdictions add another layer. Ohio has school district income tax in addition to state withholding. Pennsylvania has local earned income tax collected by local tax bureaus. New York has NYC and Yonkers withholding. Maryland has county piggyback tax. Each local jurisdiction may have its own return and filing frequency.
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.
- Reconciliation completed for 100% of entities within 15 business days of quarter end
- All variances documented with a root cause and resolution plan
- Zero unexplained variances between register, return, and deposit evidence
- Evidence checked for each state return included in the reviewer-approved filing population
- Controller or CFO sign-off on the reconciliation summary before the next quarter begins
- Variances from prior quarter reviewed to confirm they were resolved
FAQs
How soon after quarter end should the reconciliation be completed?
Within 15 business days of the quarter end, before the Form 941 filing deadline (the last day of the month following the quarter end). Completing the reconciliation before the filing deadline allows corrections to be made on the current return rather than requiring an amendment.
What if I find a variance after the Form 941 has already been filed?
File a Form 941-X to correct the filed return. If the variance also affects state returns, file state correction returns. Make any supplemental deposits needed to cover the shortfall.
Do I need to reconcile states where I have no income tax?
Yes. States without income tax (such as Texas and Florida) still require SUI returns. The reconciliation should confirm that SUI returns were filed and that the deposit matches the return liability.
What if my payroll provider files returns for me? Do I still need to reconcile?
Yes. The payroll provider files returns based on the data in its system, but the employer remains responsible for the accuracy of the filings. The reconciliation confirms that the provider's filings match the actual payroll activity.
How do I handle an entity that had no payroll in one quarter?
File the returns with zero amounts if required by the agency (some agencies require zero returns even when no wages were paid). Confirm that the entity's registrations are still active or that they have been formally closed if the entity is no longer operating in that state.
What is the difference between federal wages and state wages?
Federal wages (Form 941 line 2) are total taxable wages for federal purposes. State wages may differ because states may exempt certain types of compensation (such as retirement contributions, certain fringe benefits, or military pay) from state taxation. The reconciliation should identify any differences between federal and state wage totals and confirm that the state returns reflect the correct state taxable wages.
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.
