The Three-Way Match

Reconciling a benefits invoice means proving that three independent records describe the same population. The carrier's bill, your enrollment record, and your payroll deduction register.

Comparing two of them is common. Comparing all three is what actually finds problems - because a discrepancy between any two can be masked by agreement with the third.

Do it in this order

1. Invoice against enrollment. Who is the carrier billing who shouldn't be covered, and who is covered but not billed?

2. Enrollment against payroll. Who is enrolled but not being deducted, and who is being deducted but not enrolled?

3. Invoice against payroll. Does the total employee share deducted reconcile to the employee portion of the premium billed?

Running it in this order matters. Step one finds the population differences, step two finds the money differences, and step three catches anything the first two individually missed.

Step one: invoice versus enrollment

Match on a stable identifier, not on name. Then produce four lists:

Finding	Meaning	Usual cause
On invoice, not enrolled	Carrier is billing someone you don't think is covered	Termination not reported, or reported after the bill cut-off
Enrolled, not on invoice	Someone you believe is covered isn't being billed	New hire enrollment not transmitted, or transmitted after cut-off
Tier mismatch	Coverage level differs	Life event processed on one side only
Rate mismatch	Same tier, different premium	Rate change, age-band movement, or a plan change

Timing differences are not errors. Before treating any of these as a problem, check the invoice cut-off date. A termination processed after the carrier generated the bill will appear on this month's exception list and resolve itself on next month's invoice - provided it actually does. Track it rather than correcting it.

Step two: enrollment versus payroll

This is where money leaves the building incorrectly.

Finding	Consequence
Enrolled, no deduction	The employer is absorbing the employee's share
Deduction, not enrolled	You are withholding from pay for coverage that doesn't exist
Deduction amount ≠ elected tier	Under- or over-withholding
Deduction started before coverage	Withholding before the effective date
Deduction continued after coverage ended	Withholding after termination

"Deduction, not enrolled" is the one to escalate immediately. It isn't a reconciliation item. It's an incorrect payroll deduction, and the longer it runs the harder it is to unwind cleanly.

Step three: invoice versus payroll totals

Total employee-share deducted for the month should reconcile to the employee portion of the premium billed, with explainable differences.

Three structural reasons the totals won't tie exactly, none of them errors:

Deduction frequency versus premium frequency. Twenty-six biweekly deductions against twelve monthly premiums. Two months a year carry a third pay date. Whether you deduct in those months is a policy decision, and the reconciliation has to know what the policy is.

Deduction timing convention. Deducting in arrears or in advance shifts the whole comparison by a month.

Partial-month coverage. Most carriers bill full months. Payroll may or may not deduct a partial amount for a mid-month start or stop.

Document the convention, then reconcile against it. Reconciling against an assumption that doesn't match your actual policy generates permanent phantom differences.

Categorise, don't just correct

Correcting a discrepancy fixes this month. Categorising it tells you why it happened, and the categories are what let you fix the process.

Category	What it indicates
Timing - will self-resolve	Normal; monitor only
Termination not reported	Offboarding process gap
New hire not transmitted	Onboarding process gap
Life event processed on one side	Election workflow gap
Rate or tier error	Setup or renewal loading error
Identity mismatch	Data quality
Carrier error	Track separately - it drives the dispute conversation

A single category dominating your exception list is a process problem, not a reconciliation problem. If two-thirds of your findings every month are terminations not reported, no amount of reconciliation fixes it. The offboarding workflow does.

What to keep

For every discrepancy: the identifier, the month, the category, the amount, the resolution, the date resolved, and - for anything expecting a credit - whether the credit was actually received.

That last field is the one people skip, and it's the one that finds money.

Frequently asked questions

Why compare three sources instead of two?

Because a difference between two can be hidden by agreement with the third. Enrollment and payroll agreeing doesn't mean the carrier is billing correctly.

What should we match on?

A stable identifier. Names change and are inconsistently formatted across systems.

Are all discrepancies errors?

No. Timing differences from the invoice cut-off date are normal and self-resolve. Track them; don't correct them.

Should invoice and payroll totals tie exactly?

Rarely, and that's fine. Deduction frequency, timing convention and partial-month handling all create explainable differences. Document the convention first.

What's the most urgent finding?

A payroll deduction for someone who isn't enrolled. That's an incorrect withholding, not a reconciliation item.

How Praisidio fits

Praisidio connects payroll, HRIS and benefits data and runs the invoice-to-enrollment-to-deduction match on a schedule, so the exceptions arrive as a list rather than a discovery. See the reconciliation pillar or book a demo.