Reconciliation for Health Billing

[joecjr]

Hi.

Can anyone help with this:


I need a user friendly spreadsheet for reconciling our company health expenses to the insurance company changes each month.

These changes can be sometimes:

retroactive 1 2 or 3 months back due to timing when they get the bill and we posted the change, term, or new hire to our schedule.

I've spent a considerable amount of time trying to find the way to do it. How does your company reconcile it each month?

We have 175 Employees on average in our plan each month.

THANKS!!!!!!!!!!!!!!!