Back to blog

Adding a Defined Benefit Plan: Check the 401(k) Payroll Map

Before adding a defined benefit plan alongside a 401(k), test whether both providers can trace payroll codes, periods, and revised records to their own calculations.

Practice owner reviewing payroll and retirement plan records

Before adding a defined benefit plan alongside an existing 401(k), ask both providers to demonstrate how the same payroll records become their calculation inputs. Require a comparison by pay code, compensation period, and document provision. Two totals can legitimately differ; an unexplained difference is the reason to pause reliance on a proposal.

Our existing 401(k) coordination guide covers the broader design, testing, and payment handoff. This review serves a narrower implementation decision: can the selected providers explain and reproduce their payroll mapping before the owner approves the new arrangement?

Ask for a mapping demonstration before signing off

The IRS defined benefit plan overview confirms that an employer can maintain other retirement plans alongside a defined benefit plan. That possibility does not establish that a payroll export configured for the existing 401(k) supplies every input the new provider needs.

Request a short working session using a securely shared sample from the business's actual payroll system. Choose ordinary pay, an off-cycle bonus, and a record involving a participation-date question. Mask personal identifiers in meeting materials while preserving a secure link to the underlying records. Ask each provider to show the source field, transformation, period, and intended calculation.

TaxBowl's proposed review method is a comparison sheet with one row for each source category and separate columns for each calculation. It is an accounting control, not an alternative plan document or a substitute for actuarial work. The owner should be able to follow the numbers without deciding the legal treatment.

Compare definitions without forcing equal totals

The IRS 401(k) compensation Fix-it Guide explains that a plan may use different compensation definitions for deferrals, allocations, and testing. It recommends reviewing the plan provisions and checking operations against them. Therefore, even within the existing 401(k), one generic field labeled “eligible pay” may hide several purposes.

Comparison fieldEvidence to requestQuestion before approval
Calculation purposeReport name and document referenceIs this for deferrals, employer allocation, testing, or a benefit calculation?
Source pay codesPayroll code dictionary and sample registerAre bonuses, adjustments, and other categories explicitly mapped?
Measurement periodStart and end dates confirmed by the providerDoes the export cover the requested period?
Participation historyHire, service, and entry recordsIs any exclusion tied to a reviewed provision?
Revision statusVersion identifier and change explanationWhich report must be replaced after a correction?

Our owner compensation reconciliation guide explains the underlying income records. Here, the test is whether two providers can use those records for their respective purposes without silently borrowing each other's definitions.

Hypothetical: explain a difference, then catch a stale file

Invented implementation exercise, not a client result, approved plan design, contribution estimate, or eligibility determination: Assume a payroll sample for one employee contains $48,000 of regular gross pay and $4,000 of bonus pay. The source subtotal is $52,000. Assume solely for this exercise that professional review has confirmed $48,000 as the input for one existing-plan calculation and $52,000 for one proposed-plan calculation, for the same stated period.

The $4,000 difference is explained by the documented bonus treatment. Neither provider should change the other total merely to make the comparison sheet balance. The example establishes no general rule allowing a bonus exclusion; actual definitions and applicable requirements need professional review.

Next, payroll discovers a missing $1,500 regular-pay adjustment within that same period. The corrected source subtotal becomes $53,500: $48,000 plus $4,000 plus $1,500. Under the exercise's unchanged assumptions, the first mapped input becomes $49,500 and the second becomes $53,500. Their explained difference remains $4,000.

If the second provider still shows $52,000, the issue is now a stale record, not the earlier definition difference. The owner requests replacement of the affected analysis before relying on it. These are gross-pay input calculations only; no withholding, employee account, benefit, deduction, or funding amount is calculated.

Make period differences visible

Put each requested compensation period next to its calculation purpose. Separately identify the plan year, payroll export dates, and any partial participation period. Ask the providers to specify the records required when periods differ; do not select a convenient year-end export and assume it answers every request.

The IRS safe harbor compensation analysis describes circumstances in which compensation may cover a participation period or the entire plan year, depending on plan provisions. That illustrates why dates matter; it does not determine the proposed defined benefit plan's treatment. Obtain that answer from its professionals.

Approve a reproducible process and name the follow-up owner

Ask each provider to identify which reports a payroll correction could affect and who receives the replacement file. Preserve the old export, corrected export, reason for change, and provider acknowledgment. Acknowledging receipt is different from confirming that affected calculations have been revised.

The IRS qualified-plan requirements guide emphasizes operation under plan terms and warns that payroll-system and provider changes deserve scrutiny. Resolve unexplained mappings with the administrator and actuary before treating a proposal as implementation-ready. Confirm separately any required adoption, notice, and other action dates; this review creates no extension.

Bring the comparison sheet, source records, document references, and unresolved differences to TaxBowl's tax team. We can organize the accounting evidence and coordinate questions with the plan professionals so the owner can distinguish a documented difference from an input error.