How to Reconcile Payroll to 401(k) Contributions

Reconciling payroll to 401(k) contributions means proving, by participant and contribution source, that payroll deferrals, employer contributions, eligible compensation, recordkeeper postings, and trust deposits all agree. It is a payroll-to-plan tie-out, separate from payroll-to-general-ledger reconciliation and from the participant census that has to tie alongside it.

Use this control to investigate a mismatch already found, or to run the recurring per-cycle review that keeps payroll corrections, match calculations, and deposit timing from becoming year-end fixes. Breaks usually trace to excluded pay codes, compensation-definition drift, match formulas using the wrong base, or post-payroll corrections reflected on only one side.

The amounts that have to tie between payroll and the plan

The reconciliation is not one number against one number. It is a set of contribution and compensation amounts that can fail independently and appear under different labels in payroll, the plan document, and the recordkeeper report.

Per-period employee deferrals. Pre-tax, Roth, and catch-up deferrals reconcile separately. Netting them together can hide a source misallocation, because the W-2, recordkeeper report, and plan limits treat them as different buckets.

Employer match. Match ties to the formula, funding cadence, and plan-document definition of compensation. A per-period match and an annual true-up can produce the same full-year result but different mid-year numbers, so the reconciliation has to distinguish a real mismatch from the plan's funding design.

Nonelective and safe-harbor contributions. Safe-harbor nonelective (typically 3% of eligible compensation), safe-harbor match (basic and enhanced formulas), and discretionary nonelective or profit-sharing contributions all post on their own cadence, frequently funded annually or quarterly rather than per pay period. Reconciling them mid-cycle, before the funding has happened, produces a phantom break that resolves itself when the contribution is made. The reconciliation either runs at a moment after the funding cycle, or it explicitly carries the unfunded amount forward as an in-process item.

Eligible compensation. This is the common drift point. The plan document controls whether the base is Section 415 compensation, W-2 compensation, or a modified definition that excludes specific pay types. The payroll system's "gross pay" or default 401(k) eligible earnings code may not match, so the tie-out has to prove deferrals and match were calculated on the plan's compensation definition.

Secondary sources. Loan repayments, after-tax contributions, and voluntary contributions reconcile to their own sources when the plan supports them, but most payroll-to-plan reconciliation effort sits with the four amounts above.

The source documents, in the order you reconcile them

The reconciliation is a four-document walk, and each handoff between documents is its own potential break point. A clean tie-out proves that the dollars survived all four.

1. The payroll register. Per-period employee deferrals (broken out by source — pre-tax, Roth, catch-up), employer contribution amounts as calculated by the payroll system, and the eligible compensation base for each participant. This is the originating record. Everything downstream is supposed to agree with it.

2. The contribution remittance file. The file actually transmitted to the recordkeeper for the cycle, in the recordkeeper's mandated layout. In a system that is working correctly, the remittance file is a one-to-one expression of the payroll register's contribution detail. In practice, file-build logic on the payroll provider's side or a custom transmittal step on the sponsor's side can drop participants, round amounts differently, or split a single deferral across multiple sources. Reconciling the remittance file against the payroll register before transmission catches problems while they are still cheap.

3. The recordkeeper or TPA contribution report. What the plan side received and posted, broken out by source: pre-tax, Roth, employer match, nonelective, safe harbor, loan repayments, after-tax. You tie the payroll register to the 401(k) recordkeeper report side by side, by source and by participant. A mismatch here means the remittance file did not load cleanly — sometimes a participant did not exist on the recordkeeper census, sometimes a source mapping was wrong, sometimes a contribution was rejected and rerouted to a holding account.

4. The plan trust or custodian statement. What actually settled into the trust. Trust-side amounts should agree with the recordkeeper contribution report once timing is normalized. Movements on the trust statement that do not correspond to contribution activity (mid-year fund transfers, corrective distributions, fee withdrawals) are not reconciliation breaks — they are non-contribution activity that has to be separated out before the comparison.

The most common operator mistake at this step is treating the timing offset between payroll posting and plan posting as a break. Funds withheld from a Friday paycheck do not appear on the trust statement that same day; they post over the next several business days as the contribution is transmitted, allocated by the recordkeeper, and settled in the trust. A reconciliation run mid-cycle will show the payroll side ahead of the plan side. That is in-process variance, not an exception. The reconciliation either waits for both sides to settle, or it explicitly carries the in-process amount forward as a reconciling item until it clears.

The regulatory line distinguishes in-process variance from a true exception. Under the 7-business-day safe harbor at 29 CFR 2510.3-102, retirement plans with fewer than 100 participants at the start of the plan year qualify for a safe harbor that treats employee contributions as deposited on time when they reach the plan no later than the 7th business day following the day the employer received or withheld the amount. Larger plans do not get that safe harbor; they operate under the general rule that contributions become plan assets as soon as they can reasonably be segregated from employer assets. A timing variance still inside the applicable window is in-process and not a reconciliation discrepancy; an amount sitting outside it is a late deposit, which is a separate fiduciary issue that surfaces on Form 5500 Schedule H and triggers its own correction process. The mechanics of setting an earliest-segregable date for the plan, comparing payroll dates to deposit dates, and unwinding a late deposit through VFCP are covered separately in the 401(k) deposit timing rules and late-deposit correction guide.

The practical hurdle is getting the four documents into one comparable view. The payroll register, remittance file, recordkeeper report, and trust statement often arrive in different formats and on different schedules. Structured payroll and recordkeeper data extraction is one way to turn them into comparable participant-and-source rows; the broader pattern is the same whether the conversion is done by hand, by a custom script, or by tooling that can extract payroll register data from PDF and the recordkeeper report alongside it.

Triage tree: why a payroll-to-plan tie-out fails

When a reconciliation breaks, classify the report pattern before recalculating everything.

Excluded pay codes. Symptom: a participant's deferral percentage looks right against gross pay but wrong against plan compensation, often on a cycle with a bonus, severance, commission, fringe benefit, equity income, or other irregular pay. Confirm by recalculating deferral and match against the plan-document compensation definition.

Compensation-definition drift. Symptom: prior years reconciled cleanly, then the current year breaks without an obvious process change. Confirm by comparing the current plan definition with the active payroll earnings-code map; new earnings codes are the usual missing decision.

Missing or duplicated payroll cycles. Symptom: each cycle reconciles, but the period total does not. Confirm by counting payroll runs against recordkeeper remittances and resolving cycles that exist on only one side.

Post-payroll corrections reflected on only one side. Symptom: year-to-date payroll no longer ties even though the original cycles did. Confirm by listing voids, reissues, and wage adjustments since the last clean reconciliation and tracing each to the plan side.

Employer-formula errors against the wrong base. Symptom: the employer amount ties inside payroll but exceeds the recordkeeper recalculation by a stable percentage. Confirm by recalculating a participant sample using the plan formula and plan compensation definition.

Mid-year plan amendments. Symptom: the tie-out is clean through one date and breaks consistently after it. Confirm by checking the amendment effective date against the cycle where the failure starts.

Terminations and final-pay catch-up. Symptom: the break is confined to terminated participants. Confirm by reconciling the termination roster against final-pay contribution detail.

Plan-side timing differences that look like breaks but are not. Symptom: the trust statement does not tie to the contribution report even though contribution activity reconciled. Confirm by separating contribution activity from fund transfers, corrective distributions, fee withdrawals, and excess-deferral refunds.

These eight cover the bulk of payroll-to-plan reconciliation failures. They are deliberately narrow to the contribution tie-out itself. If the underlying issue is broader payroll-to-general-ledger reconciliation — payroll-side wages, taxes, and accruals against the GL accounts — that is a separate control with its own scope and its own failure modes; the payroll-to-general-ledger reconciliation process covers it on its own terms.

The calendar that drives when each tie-out matters

The cadence matters because a break caught after W-2 issuance or after the correction deadline is harder and more visible to fix.

Per-pay-period operational reconcile. The first-line control. Each cycle's payroll register is reconciled to its contribution remittance file before the remittance is transmitted, and then to the recordkeeper contribution report once the contribution has posted. Catching breaks at this cadence is the cheapest place to fix them — the correction runs through the next cycle's remittance, the participant impact is small, and the dollars stay inside the same plan year and usually the same quarter. Per-cycle reconciliation is also where the recurring control shape gets built; the year-end tie-out and the audit are easier when there is a documented sign-off for each cycle behind them.

Quarterly with Form 941. At quarter end, payroll-side wages and FICA reconcile to the 941 filing. The same payroll-side compensation total feeds the contributions transmitted to the plan over the quarter, so a quarterly tie-out aligns the payroll-tax view and the plan-contribution view at a cadence short enough to remediate without filing a corrective 941 or a corrective contribution. A break that surfaces at quarter end and gets resolved before the next quarter is a contained problem; the same break at year-end is a corrective-filing problem.

Year-end against W-2 Box 12 and W-3. Annual deferrals reconcile to W-2 Box 12 code D (traditional pre-tax 401(k) deferrals) and code AA (Roth 401(k) deferrals), participant by participant. Aggregated W-3 totals should agree with annual contribution totals on the recordkeeper side. This is the canonical year-end tie-out — the one most commonly examined when the plan is audited, the one that supports the contribution figures reported on Form 5500, and the one that has to be clean before W-2s go out to participants. A break discovered after W-2 issuance forces a W-2c, which is visible to the participant and to the IRS.

March 15 corrective distribution deadline for excess deferrals. Where the year-end reconciliation surfaces a participant who exceeded the elective-deferral limit (across all plans the participant contributed to that year, which the plan sponsor often will not see without participant notification), the corrective distribution must be processed by March 15 of the following year to avoid double taxation on the excess — taxed in the year deferred and again in the year distributed. A reconciliation that does not surface excess deferrals before March 15 forces the participant into the worse tax outcome. This is one of the harder cases for the per-cycle control to catch, because the excess often arises from contributions to another employer's plan the sponsor has no visibility into, but the year-end reconciliation surfaces it in time only if it runs early enough to act on.

Form 5500 and the audit window for large plans. Plans with 100 or more eligible participants at the start of the plan year are large plans for Form 5500 purposes and require an independent audit. Auditors test the same payroll-to-plan control, but they expect the sponsor's worksheets, payroll register, recordkeeper report, and participant samples to reconcile without unexplained differences. The audit-package contents sit in the 401(k) audit package checklist for employers, while the participant-data census tie-out is covered in the employee benefit plan census reconciliation guide.