Carrier Invoice Reconciliation for a 1,500-Employee Healthcare Company

The Challenge

At a non-union, white-collar healthcare company with 1,500 employees, carrier invoices were not routinely audited against the benefit system. To reduce costs wherever possible, the company hired a new CFO. Based on our past professional relationship with the CFO, we were asked to make recommendations. At the time, HR was very protective of incumbent brokers, and the head of benefits confirmed that their broker audits invoices monthly.

The account spanned four lines of coverage — medical, RX, dental, and vision — and the plan names never lined up: 31 plan names across the carrier files against 20 in the benefit system.

The Solution

We deployed our Benefit Automated Reconciliation Tool (BART) to audit the carrier files against the benefit system. Four steps came first.

  • Step 1: We gathered all eligibility files from the carriers and vendors.
  • Step 2: We placed the data into our templates.
  • Step 3: We mapped all plan names between the carrier files and the benefit system file.
  • Step 4: We exported a granular benefit detail report from the benefits system — a single line-by-line listing of every benefit offered to all employees. Benefit system: 7,283 lines. Medical: 1,875. Dental: 1,866. Vision: 1,682.
  • Step 5: With steps one through four complete, we uploaded all files to BART — four files containing 12,706 rows of data. BART produced the reconciliation report in under 10 seconds.

 

The Results

Rather than running a manual audit line of coverage by line of coverage, BART consumed all four files and produced one reconciliation report covering every line. That makes it far easier to work the rec and resolve every discrepancy on a single audit report.

BART runs a quintuple wash — employee name, plan name, coverage tier, total monthly cost, and employee SSN — flagging cost mismatches, coverage mismatches, name mismatches, records found in the benefit system but not the carrier, and records found in the carrier but not the benefit system.

Key Takeaway

The audit revealed numerous discrepancies with both real and potential cost impact on the company. Monthly audits are essential to address discrepancies quickly and plug the holes in a leaking benefit program.

Run them monthly and the number of discrepancies drops drastically — and the ability to correct them before they result in significant claims or premium costs to the company improves consistently.

Client Profile

Industry
Healthcare
Employees
1,500
Plan Type
Medical, RX, Dental, Vision

Key Results

104 true discrepancies uncovered
12,706 rows reconciled in under 10 seconds
One report across all four lines of coverage
Quintuple wash — name, plan, tier, cost, SSN

Related Case Studies