Benefits Reconciliation™ FAQs

Everything you need to know about OUR SOLUTION

What is Benefits Reconciliation?

Benefit reconciliation (also referred to as premium reconciliation or health insurance reconciliation) is a monthly review of premium invoices against your company's payroll deductions to check for any discrepancies. Your company's benefits enrollment information and payroll deductions spreadsheet may contain employee's name, effective date, coverage, and premium cost. The goal is to ensure there are no under-or-over payments, that employees are enrolled in correct insurance plans, and that you're not paying premiums for terminated employees. The point person for this process will then determine what action needs to be taken to rectify any errors. This process is is typically done by HR Benefits Specialist or someone in Accounting.

Why should I automate the Benefits Reconciliationprocess?

Anytime there’s a manual process, inadvertent errors can be introduced. And anyone who’s ever done reconciliation of benefits, knows that this process is extremely time-intensive and prone to errors, especially for companies with a large number of employees (and many monthly changes!). It’s very easy to miss over-or-under payments or if an employee is in the wrong plan or not enrolled at all. If errors are not caught in time, employers can face unexpected expenses and potential lawsuits.

How do companies typically reconcile their benefits?

A lot of companies perform this process using spreadsheets or print-outs and rulers highlighting areas of concern or discrepancy. Either process lends itself to mistakes, and even more so if there’s a change in HR personnel where historical insights are lost. We also hear that some companies are not auditing their benefits bills at all, which really not advisable.

What does EverythingBenefits’ automated Benefits Reconciliation™ solution offer?

Our Benefits Reconciliation solution automates the entire process - from hours down to minutes. Using your uploaded invoices, it compares your monthly billing invoice against your carrier (for the same time period) to flag for discrepancies. Our solutions drastically shorten the reconciliation process through the use of advanced matching logic and a user-friendly customizable interface. You'll be an expert in no time!

What does the dashboard look like?

Here are a couple of screenshots:

Drag-and-drop employee’s invoices from one side to the other to correctly match and correct for instances of under-deductions, under-coverages, and other discrepancies.

benefits reconciliation spreadsheet

High-Level view of your total calculated invoices vs what the Vendor is billing you, per billing period.premium reconciliation spreadsheet

What information is needed in order to audit the payments?

There are two items that are needed to implement Benefits Reconciliation™ and to continue to utilize it in production:

  • Vendor Invoices - For implementation we prefer to have the last 6 months of invoices in order to account for any anomalies in the formatting and data structure of the actual document, because we are processing them automatically through a custom data import

  • Payroll data feed -  If your HR / Time & Attendance platform already provides Everything Benefits with full line item details from your payroll data,  then we will have everything we need. We can either setup a new data feed to implement Premium Recon, or we can use your existing data feed which was configured for a payroll or other contribution export. If your platform does not provide us with full line item detail then you will need to provide us with a manual export of 6 months of line item detail from your payroll and you will need to manually import a file for each month of reconciliation once in production.

We receive multiple carrier invoices a month, all in different formats.  Will I need to convert this data to a default format for EverythingBenefits to work with?

No.  EverythingBenefits is capable of working with all different file formats.  During implementation, we will identify how your carriers are structuring their bills, and which file format they typically send. We will configure our system to support these files so that your only responsibility is to import them each month.

We are a PEO with a Master Plan that needs to be reconciled each month. Can EverythingBenefits support multiple clients on a single bill for reconciliation?

Definitely.  We work with many PEOs, most of which offer a Master Plan.  We will display the bill broken out for each employee, and match the invoice to the appropriate payroll deductions for each client.

We reconcile our carrier’s bill to our payroll deductions, but we collect a month in advance. Can this be supported?

Yes! Depending on your payroll solution’s capabilities, EverythingBenefits can display each payroll batch from our system.  Users can choose which payrolls will be utilized for the monthly reconciliation.  If payroll data is not sent directly to EverythingBenefits, simply import the payroll deduction data that you would use to reconcile for the month using our import tools.

Our carriers use their own unique employee identifications. How would these match up to employee data within our payroll system?

During implementation, we will match a carrier’s unique identifier to your payroll solution’s unique identifier.  These configurations then allow our system to automatically see if an employee is shown on your monthly carrier bill, as well as your payroll deductions.

Some of our bills include multiple products for a single carrier.  Can these be reconciled within EverythingBenefits?

Yes, this is completely possible.For these types of bills, we can consolidate an employee’s plans onto one line, and match it up to each of their deductions.

Where can I learn more about EverythingBenefits' Benefits Reconciliation™ Solution?

The best way to get to know our Benefits Reconciliation™ solution is to Schedule a DEMO for a one-on-one with our product specialist. We look forward to solving all your Benefits Reconciliation™ headaches!


Let us show you how our automated Benefits Reconciliation™ solution works. Send us a note to schedule a DEMO.




Sign-up for Company News and Updates

Be the first to know about our new solutions, upcoming events, and the latest industry research. You'll be looking forward to the next newsletter all week!