Health Insurance Billing Reconciliation Template Excel

Question

I need a premium reconciliation template that will allow me to load a bill invoice and a payroll report to find discrepancies for the month? We have 5-6 different carriers and I'm looking to track billing adjustments for the month, in addition to be able to compare paid vs billed invoice amounts for the year. Any update is greatly appreciated.

Answer 1

Hi Valentin,

The bill invoices are generated from the insurance carriers with two excel reports, Detail and Adjustments. The payroll reports come from ADP (excel files) with employee deduction amounts that our payroll dept uses to verify against the carrier data. We have a third internal report (also excel) that reflects adjustments and changes made throughout the month (new hires, terminations, leave of absences, and qualifying life events). Sample attached.

Our initial internal review determines if all internal changes are reflected on the monthly invoice and then once documented, we submit to payroll for their review against the deduction report.