Benefits invoice reconciliation

What benefits invoice reconciliation actually is

Benefits invoice reconciliation is a three-way match. The carrier's bill, the enrollment record in your HRIS or benefits administration system, and the deduction register in payroll all describe the same population of covered employees and dependents. Reconciliation is the monthly process of proving they describe it identically, and resolving the differences when they do not.

It is not an accounting task in any meaningful sense. It is a data reconciliation problem: three exports, three different key structures, three different effective-date conventions, and one number at the bottom that has to be defensible.

The three-way match

Source	What it asserts	Typical key
Carrier invoice	Who the carrier believes is covered this month, at what tier and rate	Carrier member ID, subscriber ID, sometimes SSN
HRIS / ben-admin enrollment	Who your records say is enrolled, in which plan and tier, with what effective dates	Employee ID
Payroll deduction register	What was actually withheld, per pay period, per deduction code	Employee ID plus deduction code

The match fails at the joins. Carrier files rarely carry your employee ID. Payroll runs biweekly or semi-monthly while carriers bill monthly, so a clean month is 2.0 or 2.17 deductions per employee depending on the calendar. And enrollment is effective-dated while the invoice is a snapshot, so a mid-month termination looks like a discrepancy on both sides.

Why the bill never matches the deductions

• Terminated employees still on the bill. The most common and most expensive item. The termination reached payroll but not the carrier, and the premium keeps billing until someone catches it.
• New hires missing. Enrollment completed after the carrier's cutoff, so the employee is covered, deducted, and not on the invoice - then appears next month with a retroactive charge.
• Tier changes lagging. A birth, marriage or divorce changes the tier in your system before the carrier processes it. You deduct family, the carrier bills employee-plus-one.
• Retroactive credits nobody ties out. A credit appears two or three months later, netted into a total, with no line-level detail matching it back to the employee who generated it.
• Missed deductions. Unpaid leave, insufficient net pay, or a late enrollment means the premium was billed and paid but never withheld - an arrears balance that grows quietly.
• Age-banded and salary-based rates. Life and disability premiums move at birthdays and at salary changes, on the carrier's schedule rather than yours.

Self-bill vs list-bill

How you reconcile depends entirely on which billing method the carrier uses.

	List-bill	Self-bill
Who produces the detail	The carrier, line by line	The employer
What you pay	The amount billed	The amount you calculate
Where errors surface	On the invoice, visible	In your own file, invisible until audit
Reconciliation job	Dispute what is wrong on their bill	Prove your own numbers before you remit

List-billed plans put the burden of accuracy on the carrier and the burden of review on you. Self-billed plans move both to you: you submit the covered population and remit accordingly, which is faster every month and far more exposed at renewal or audit. Some carriers let the employer choose. Many do not.

A monthly process that holds up

1. Pull the invoice detail file - not the PDF summary - in whatever format the carrier's portal supports.
2. Pull enrollment as of the invoice period, effective-dated, not as of today.
3. Pull the payroll deduction register for the pay dates that fund that coverage month.
4. Match on a stable key and quarantine what does not join, because unmatched rows are where the money is.
5. Classify every variance: timing, tier, rate, eligibility, or error.
6. Resolve the ones you own, dispute the ones the carrier owns, and carry the rest forward with an audit trail.

Done in spreadsheets this is a multi-day job per carrier per month. Done as a scheduled report against connected systems, it is a variance list waiting for you on the first business day.

How Praisidio fits

Praisidio connects to your HRIS, payroll and benefits systems and runs the match on a schedule: invoice against enrollment against deduction, with the exceptions surfaced and delivered rather than discovered. The same connected data drives the compliance filings that use the same fields.