Tabulera allows brokerages to offer reconciliation services without overloading their workforce
Our brokerage clients faced a common challenge in managing benefits reconciliation for their employer groups. With an average of 4 list-bill invoices per employer against enrollment data from Employee Navigator and other benefits administration systems, reconciliation was a time-consuming task.
Moreover, the reconciliation of COBRA invoice transactions against COBRA Enrollment data required meticulous attention to detail to prevent errors and financial losses for their clients.
Most brokers lack a dedicated team of benefits reconciliation specialists and rely on account managers to provide this service. The historical manual processes in Excel lacked scalability and auditability.
128
Invoice per month
(avg)
350
benefit plans
(avg)
5750
total employees
(avg)
160
employees/client
(avg)
Tabulera's Benefits Reconciliation Module provided an efficient solution to automate the reconciliation process. By configuring the module for Enrollment Reconciliation, brokers could seamlessly match enrollment data from Employee Navigator and other HRIS with list-bill invoices.
This indicates that the system automatically identified 84% of employees from the enrollment file within the carrier invoice, cross-referenced the amounts and tier coverages, and ensured consistency between both sources. Moreover, employees with rounding variances were also automatically resolved.
The majority of the remaining 16% of variances consisted of:
Different coverage levels between the invoice and the enrollment system (e.g., “Employee only” vs. “Employee + Spouse”).
Discrepancy between the invoiced amount and expected amount in the enrollment data.
Employee terminated in the system but still present on the invoice.
Employee not on the invoice but present in the enrollment file, likely due to a new hire after invoice generation.
*Both discrepancies due to timing differences were often automatically resolved in subsequent invoices, reflecting timing differences such as new hires or terminations post-invoice generation.
Since implementing Tabulera's Benefits Reconciliation Module, brokers have experienced significant improvements in the reconciliation process. Over the last three months, the system has consistently achieved an impressive average auto-match rate of 84%.
Manual root cause analysis only needed to be performed for 16% of employees with billing variances, primarily involving timing issues and tier/rate mismatches.
With newfound efficiency, brokers can now offer benefits reconciliation services to every client without substantial workforce expansion, ensuring seamless scalability.
