Learn how to work with Source Data in Tabulera. Upload and Map Enrollment, Payroll, COBRA and Carrier Invoice Files.
The first step in using Tabulera’s Benefits Reconciliation Platform is uploading your source documents. Depending on the type of reconciliation selected, you may need to upload up to four types of documents.
Uploading Enrollment, Payroll and COBRA Remittance Data
The process for uploading Enrollment and Payroll data is identical. These files are typically generated from your Enrollment, HRIS, Payroll and COBRA vendors.
Before uploading, please download and use our file template to ensure the required fields are included.
Select the Source type (Payroll, Enrollment or COBRA).
Choose the period you are uploading the file for.
Click Upload File and locate the file on your device.
[[Note]]If this is your first upload, a modal window will appear prompting you to complete the file mapping. For subsequent uploads, click the Mapping button to open the mapping wizard.[[/Note]]
Mapping Your Data
Data mapping means telling the system which columns in your file match the fields Tabulera needs—like saying “this column is the employee name” or “this one is the plan type.”
The mapping process is identical for Payroll and Enrollment. Mapping is typically done once, unless the file format changes. Tabulera’s built-in AI assists in mapping most fields automatically.
Let’s quickly review the mapping wizards interface.
The left panel displays both required and optional fields.
Mandatory fields are marked with a red asterisk (*).
[[Error]]Red highlights indicate a required field that hasn’t been mapped yet.[[/Error]]
[[Warning]]Orange highlights indicate optional but recommended fields that are still unmapped.[[/Warning]]
Click any unmapped field and select the corresponding column from your file.
The right panel displays a preview of the values in that column. In some cases, you may need to help match these values to the format Tabulera expects.
Once all required columns and values are mapped, click **Submit Mapping**. You’ll be returned to the Sources menu and the file status will update to **Completed**.
Next Let’s switch to the Carrier Invoice Section.
Uploading Carrier Invoices
To upload a carrier invoice:
Go to the Carrier Invoices section.
Click Upload Files and select the invoice file.
[[Note]]The Starter Plan supports CSV and XLSX formats.[[/Note]]
If it’s your first time uploading a specific invoice format, you’ll need to complete the mapping process. Future uploads will not require remapping unless the format changes.
Click the Mapping button to launch the wizard.
Locating Member Tables
Tabulera’s built-in AI will attempt to auto-detect the tables containing member data. If the selection isn’t accurate, you can click Remove and manually select the correct table.
To Add and Remove a Table:
Click once on the header row.
Click again on the last row of the table.
If the invoice includes multiple tabs, navigate them just like in Excel.
You may select more than one table.
Mapping Invoice Columns
After selecting a table, you’ll see an orange section indicating that the columns aren’t yet mapped. Click Review Columns to launch the mapping wizard.
[[Warning]]Orange highlights = optional but useful. [[/Warning]]
Click the dropdown next to each field and select the corresponding column in your invoice.
Mapping Invoice Values
Next, check any lines marked with a red asterisk (*). These values must be reviewed and confirmed using the right-side panel. Assign any unmapped values as needed.
Next, check any lines marked with a red asterisk (*). These values must be reviewed and confirmed using the right-side panel. Assign any unmapped values as needed.
Once mapping is complete:
The Column Mapping Status will turn green.
Repeat the process for each table in the file.
Click Submit Mapping when done.
You’ll return to the Sources menu and the invoice status will update to Completed. Repeat for any additional invoices you plan to reconcile.
That’s it! You’re now ready to move on to the Benefits Reconciliation application.
Understand how to navigate Tabulera’s Reconciliation UI to resolve variances faster and work more efficiently across invoices and employee records.
Invoice List View
When you launch Reconciliation for the first time, you’ll land on the Invoice List View. From there, everything you need is available through a clean and intuitive layout. Let's walk through each part of the screen from top to bottom.
Top Navigation
Hamburger Menu (top-left): lets you switch between Payroll and Enrollment reconciliation views.
Reconciliation Period Selector: just below the menu, you’ll find the month selector. Click on it to pick the reconciliation period. Tabulera supports one month at a time, keeping things focused.
Statistical Panel
This panel gives you a quick summary of your current reconciliation progress. It shows:
Beginning Variance – the total amount off at the start.
Resolved Amount – how much you've already explained or written off.
Over Collected – extra payroll deductions compared to what was invoiced.
Under Collected – missing payroll deductions compared to the invoice.
Discrepancy Count – the number of employees with variances, including how many are currently marked as In Progress.
Plan Balance – how much has been collected and adjusted for the plan since inception. You can view the plan balance across all time, or narrow it down by selecting specific effective dates. Tabulera creates employee plan-level transaction registers, so you have a clear balance history down to the penny.
Invoice List
Here you’ll see all the uploaded invoices for the selected month, along with key statistics.
The table is fully configurable: enable or disable columns by clicking the Columns button in the bottom-left corner.
You can search within the Invoice Name and Plan Type columns by clicking the column header.
To apply changes to invoice mapping or settings, use the Regenerate button next to the invoice name.
You might also see different invoice statuses—these indicate if action is needed.
Columns can be resized or sorted. Drag the dotted edge to resize or click the sort icon.
Employee List View
Click on any invoice to open the Employee List View. The layout is similar to what you’ve already seen, so it should feel familiar.
Statistical Panel
The panel at the top of this view changes depending on the reconciliation type you're working with.
Payroll Reconciliation
It’s almost the same as in the Invoice List View, but with one extra tile:
Total Amounts – shows the total from the carrier invoice and payroll data side-by-side.
Enrollment Reconciliation
Switching to Enrollment Reconciliation updates the panel:
Total Amounts – totals from both the carrier and the enrollment system.
Plan/Tier Mismatch – employees with mismatched tier coverage.
Rate Mismatch – employees with different rates.
Carrier Bill Only – employees who are on the invoice but not in enrollment.
Enrollment Only – employees in enrollment but not on the invoice.
Discrepancy Count – number of employees with a variance.
Plan Balance – running balance over time, filterable by effective date.
Employee Table
This table shows all employees listed on the invoice.
Person, Carrier Plan, and Notes columns are searchable.
A small person icon shows active/terminated status—click to filter.
Use the Columns button to select which columns are visible.
Available Columns:
Person
Color Tag
Client ID
Plan Type
Notes
Enrollment Plan
Payroll Plan
Carrier Plan
Carrier Premium
Carrier Amount
Payroll Amount
Resolution Adjustment
Resolution Reason
Variance
Plan Balance
Reconciled Balance
Reason
Status
Utility Panel
The bottom panel contains tools designed to speed up your work.
Columns: Show or hide fields in the Employee Table.
Mass Update: Apply bulk updates to selected employees:
Add notes
Change statuses
Update color tags
Mass Refresh: Re-run reconciliation after updates.
Mass Adjustment Upload: Upload templates for Beginning Balance, Write-offs, or Adjustments.
Reports: Generate and download reconciliation reports. More on this in the [Reports article].
Three-Dot Button: Clear the app cache after backend updates.
When you select any employee in the Employee List View, the Employee Detail View panel slides in from the right.
Top Section
Employee & Employer Name – shown on the left.
Color Picker – tag employees for easier identification.
Resolution Button:
Shows Auto Resolved and is locked if no discrepancies are found.
If discrepancies exist, use Mark Resolved to update and sync stats.
Dropdown options:
Mark In Progress
Mark Resolved for Prior Periods
Notes Section
Add internal notes related to this employee. Use Mass Update in the Utility Panel to apply notes to multiple employees.
Middle Section
Left: Demographics, hire and termination dates.
Right: Resolution reason, who resolved it, and when.
Bottom Section
Five tabs give you deeper visibility:
Plan Balance – Detailed transaction register for each plan.
Detailed View – Shows plan-level info and paycheck data. Download via Payroll Paychecks button.
Member Mapping – Manage mappings at the member level. See the dedicated article for full instructions.
Plan Mapping – Edit plan-to-plan mappings. A full guide is available.
Activity Log – Tracks all user actions within the Benefits Reconciliation Module. See the Activity Reports article for more.
The Plan Balance tab acts as a running ledger of all financial transactions tied to the employee’s benefit plans. It gives you a detailed view of how premiums have been collected, adjusted, or written off over time. Two key tools in this view help you maintain accuracy: the Manual Adjustments button allows you to post Beginning Balances or apply Write-offs when needed. The Reconciled Balance toggle lets you switch between the actual balance and an adjusted view that accounts for payroll frequency differences, helping you align more accurately with carrier billing cycles.
When you open the Benefits Reconciliation Platform for the first time or add a new invoice, a gear icon will appear next to unconfigured invoices. Click it to start the Plan Configuration wizard, which will guide you through setup.
1. Invoice Plans
Enable or disable any plans that don’t need reconciliation, like administrative fees and change plan type if needed.
2. Enrollment Plans
These come from HRIS and correspond to the selected invoice. If the system labels a plan as “Undefined” or is wrong, use the Edit button to update it. A filter option helps navigate large master plans.
3. Deduction Codes
These codes are pulled from payroll data and link payroll deductions to benefit plans. Enable or disable the deduction codes you wish to include in the reconciliation with a checkbox in the first column, change or assign plan types by clicking the edit button in the Plan Type column.
4. Add Margin Fee (optional)
In some cases, payroll or enrollment data may include margin fees or admin fees that need to be adjusted for accurate reconciliation. The system allows you to subtract these fees either as a percentage or as a flat dollar amount.
You can now apply margin fees to individual plan codes or in bulk, across multiple plan codes at once.
To add a margin fee to a single plan code:
Click + Add Margin Fee
Select Source: Enrollment or Payroll
Choose the Plan Code and select the Target*
Enter the margin amount (percentage or dollar value)
To add a margin fee to multiple plan codes:
Click the Bulk Add Margin Fee icon next to the + Add Margin Fee button
Select Source: Enrollment or Payroll
Choose multiple Plan Codes that share the same margin fee and Target*
Enter the margin amount (percentage or dollar value)
[[Note]]What is Target? The Target defines where the adjustment will be made—usually from the payroll data but in some cases, from the carrier invoice.[[/Note]]
Once configured, the system will automatically subtract the margin/admin fee from the payroll or enrollment amounts tied to the selected plan(s).
[[Note]] The Margin Fee step is optional and can be skipped if no adjustments are needed. [[/Note]]
5. Map plans
Plan Mapping links plans across invoices, enrollment data, and payroll deductions.
The interface consists of three columns:
Invoice Plans (from the carrier invoice)
Enrollment Plans (from HRIS)
Deduction Codes (from payroll)
[[Note]] The system automaps plans where possible, and any unmatched plans require manual selection. Unlike previous versions, tiers are no longer displayed—only plan names, which makes the selection much easier and cleaner.[[/Note]]
How to Map Plans:
Select any row. A panel will slide out from the right, displaying three tabs for different data sources.
In the Enrollment or Deduction Codes tab, select all related plans (you can choose multiple options).
In the Invoice Plans tab, you can merge multiple plans into a single row if necessary. Some plans, like Life Plans or Life AD&D, may be merged into a single row. If needed, you can unmerge them by clicking the Split button.
Activity Log
All plan mapping actions are automatically recorded in the Activity Log, ensuring full visibility and traceability.
Editing an Existing Plan Configuration
If there is a change in the plan configuration, users should update the settings to ensure the platform continues to function properly.
Follow these steps:
Select the invoice that needs updating.
Click the Configure button at the bottom of the screen.
Choose Plan Configuration.
1.Invoice Plans
Enable or disable any plans that don’t need reconciliation, like administrative fees and change plan type if needed.
2. Enrollment Plans
These come from HRIS and correspond to the selected invoice. If the system labels a plan as “Undefined” or is wrong, use the Edit button to update it. A filter option helps navigate large master plans.
3. Deduction Codes
These codes are pulled from payroll data and link payroll deductions to benefit plans. Enable or disable the deduction codes you wish to include in the reconciliation with a checkbox in the first column, change or assign plan types by clicking the edit button in the Plan Type column.
4. Add Margin Fee (optional)
In some cases, payroll or enrollment data may include margin fees or admin fees that need to be adjusted for accurate reconciliation. The system allows you to subtract these fees either as a percentage or as a flat dollar amount.
You can now apply margin fees to individual plan codes or in bulk, across multiple plan codes at once.
To add a margin fee to a single plan code:
Click + Add Margin Fee
Select Source: Enrollment or Payroll
Choose the Plan Code and select the Target*
Enter the margin amount (percentage or dollar value)
To add a margin fee to multiple plan codes:
Click the Bulk Add Margin Fee icon next to the + Add Margin Fee button
Select Source: Enrollment or Payroll
Choose multiple Plan Codes that share the same margin fee and Target*
Enter the margin amount (percentage or dollar value)
* What is Target The Target defines where the adjustment will be made—usually from the payroll data but in some cases, from the carrier invoice.
Once configured, the system will automatically subtract the margin/admin fee from the payroll or enrollment amounts tied to the selected plan(s).
[[Note]] The Margin Fee step is optional and can be skipped if no adjustments are needed.[[/Note]]
5. Plan Mapping
Plan Mapping links plans across invoices, enrollment data, and payroll deductions. The interface consists of three columns:
Invoice Plans (from the carrier invoice)
Enrollment Plans (from HRIS)
Deduction Codes (from payroll)
[[Note]] The system automaps plans where possible, and any unmatched plans require manual selection. Unlike previous versions, tiers are no longer displayed—only plan names, which makes the selection much easier and cleaner.[[/Note]]
How to Map Plans:
Select any row. A panel will slide out from the right, displaying three tabs for different data sources.
In the Enrollment or Deduction Codes tab, select all related plans (you can choose multiple options).
In the Invoice Plans tab, you can merge multiple plans into a single row if necessary. Some plans, like Life Plans or Life AD&D, may be merged into a single row. If needed, you can unmerge them by clicking the Split button.
[[Note]] Once changes are made, go back to the invoice list and click Regenerate next to the updated invoice to ensure all updates are applied properly.[[/Note]]
Inline Mapping
If employees still have missing amounts after completing the plan configuration, you can map them directly in the reconciliation view.
Locate a plan type with a Carrier Plan name and click it
A panel will slide out from the right. Navigate to More -> Plan Mapping -> Edit Mapping.
Enable the missing plans. Ensure the amounts in the three column headers are equal.
Click Save Changes.
Employees with updated mappings will be highlighted in yellow, indicating that the Reconciliation View needs to be regenerated.
To finalize, go to the Invoice List and click Regenerate next to the updated invoice.
New Plan Added
When working in the Benefits Reconciliation Platform, you may notice a yellow triangle next to an invoice name. This indicates that new plans have been added to the invoice and require configuration.
Simply select the invoice, and a notification will appear informing you that new plans were found. Click the Plan Configuration link to proceed. If you accidentally close the notification, don’t worry—you can always click the Configure button at the bottom of the screen and select Plan Configuration from there.
Inside the Plan Configuration wizard, you will see a list of new plans along with their plan types. You also have the option to turn off a plan if you do not wish to reconcile it. Once reviewed, continue with your standard plan configuration process.
The Mass Updates of Employee Records feature in the Benefits Reconciliation Module simplifies bulk editing of employee records.
Editing large volumes of employee records just got easier. With the new Mass Update feature in the Benefits Reconciliation Module, you can now efficiently update multiple records in just a few clicks.
How to Access the Mass Update Feature
Navigate to the Benefits Reconciliation application.
Select any invoice.
In the Employee View, at the bottom and click the Mass Update button.
What Employees Can You Mass Update?
Once inside the Mass Update tool, you can select and modify employees with the following statuses:
Unresolved
Manually Resolved
In Progress
Select employees individually or use the checkbox in the column header to select all employees on the current page. If there are multiple pages, repeat the selection process for each page. The green “Update” button will display the total number of selected employees. Once your selection is complete, click Update to proceed.
Available Mass Updates
Notes
Resolution Status
Color Change
Mass Updating Notes
Check the box next to Update Notes.
If the text field is left blank, existing notes will remain unchanged, preventing accidental overrides.
Enter the desired text and click Update—the new notes will be applied to all selected employees.
Mass Updating Resolution Status
Select the necessary employees.
Choose the new Resolution Status from the dropdown.
Click Update to apply changes.
Mass Changing Colors
Check the box next to Color Change.
By default, the selected color is white. If applied, this will remove any existing color from the selected employees.
Choose a different color to apply a new highlight.
Try it today in the Benefits Reconciliation Module!
New! Carrier Access Manager – Securely store carrier logins and access invoices much faster with Tabulera's auto-fill extension or copy-paste options.
We’re happy to introduce a highly requested feature that makes accessing your carrier invoices faster and more secure. This update allows you to store and access all your carrier portal login details from one secure location.
Setup your carrier credentials
Access the Admin Section
Select Carrier Credentials in the left navigation menu.
Click the + Add Credential button.
Give it a Unique Name: Create a name that helps you easily identify the carrier.
Set Visibility: If multiple users need access to these credentials, select Company-Wide visibility.
Select Invoices: Use the drop-down to select the invoices that these credentials apply to.
Enter URL and Login Info: Type in the URL of the carrier’s login page along with your username and password.
Create the Secret: Click Create to finalize.
Once completed, your credentials are securely stored using Delinea’s encrypted vault, ready for seamless access.
How to Use the New Feature
Navigate to the Sources panel and select Carrier Invoices.
Look for the globe icon next to the invoices linked to your credentials.
Choose Your Access Method
Option 1: Use the Chrome Extension
Click the globe icon next to the invoice.
You’ll be redirected to the Chrome Web Store.
Click Add to Chrome to install the extension.
Refresh the Tabulera Portal to activate the extension.
From now on, clicking the globe icon will automatically open the carrier’s login page with credentials pre-filled.
Option 2: Manual Copy/Paste
Click the globe icon next to the invoice.
A pop-up will display the link to the carrier’s login page and your stored login credentials.
Copy and paste the credentials manually to log in.
With this new feature, you’ll save time, reduce login friction, and ensure your credentials are always secure. Whether you prefer the speed of an automatic Chrome extension or the simplicity of copy-paste, this update gives you the flexibility to access carrier invoices faster and more efficiently than ever before.
We’ve introduced a count of "In Progress" items, Notes column search functionality, multi-month invoice refresh, and color-coded employee line items.
This month, Tabulera is introducing several small updates to enhance your experience with the Benefits Reconciliation Module.
Count of "In Progress" Items
We’ve introduced a count of items marked as "In Progress" to the chart. Now, whenever you mark an issue as "In Progress," the total number of these items will display alongside the count of resolved records at the top of the page, giving you a quick overview of your progress.
Note Column Search Functionality
You can now filter the Notes column by typing keywords directly into the search box. Currently, this functionality works only for notes you’ve added manually, not system-generated ones. Enhancements are already underway, and this feature will be upgraded in Q1 2025.
How to Use It:
Open the invoice you need.
Scroll down and click Columns.
Add the Notes column.
Once the column appears, type your keywords into the Search box.
Multi-Month Invoice Refresh
We’ve added the ability to refresh invoices across multiple months, streamlining your process.
How to Use It:
Go to the main screen where all invoices are listed.
Click on the Mass Actions button at the bottom of the screen.
Select Mass Refresh, choose the invoices you need, and locate the small calendar icon next to the Generate button at the bottom right.
Click the calendar icon to select your desired period, click Apply, and then hit Generate.
Color-Coding Employee Line Items
You can now color-code employee line items for easier visual identification.
How to Use It:
Select an employee.
In the slide-out Employee Details view, locate the Header section.
Click the circle icon and choose a color to assign.
This article is a must-read for brokers and agencies looking to grow their service offerings without overburdening their teams. We dive into how to su
This article should be valuable to brokers and agencies that want to expand their services without overwhelming their teams. We explore how to effectively offer premium administration services, specifically benefit invoice audits, streamline auditing operations, and meet your clients' growing needs.
Introduction
In today's dynamic benefits landscape, brokers are continually seeking ways to enhance their service offerings and generate new revenue streams. One area gaining significant traction is premium administration services. As employers grapple with the complexities of benefits billing, invoice audits, and carrier payments, brokers have a unique opportunity to step in and provide valuable solutions. However, offering these services comes with its own set of challenges, especially when service teams are stretched thin.
The Competitive Landscape and Evolving Role of Benefit Brokers
Benefit brokers have traditionally served as intermediaries between employers and insurance carriers, helping businesses select the best benefits packages for their employees. However, the role is expanding. For instance, Professional Employer Organizations (PEOs), Association Health Plans and other group benefit arrangements offer a myriad of overlapping services including purchasing, reconciliation and payment of plan premiums.
Small to mid-sized employers now look to service providers not just for plan selection but also for assistance with administrative tasks that accompany those plans. This shift presents both an opportunity and a challenge: brokers can increase their revenue by offering additional services, but they must also manage the operational demands these services entail.
Understanding Premium Administration Services
What Is Premium Administration?
Premium administration involves managing the processes related to benefits billing, including auditing invoices and ensuring accurate carrier payments. By handling these complex tasks, it relieves the employer's HR and benefits teams of administrative burdens that sometimes have more to do with accounting rather than benefits.
For employers, streamlined premium administration means fewer errors, reduced overpayments, and compliance assurance. For brokers, it opens up a new revenue stream and strengthens client relationships by providing a comprehensive service package.
Two Ways Brokers Can Assist with Premium Administration
There are two ways brokers can help clients with their premium administration needs and generate revenue.
Option 1: Providing invoice audit as a service
Brokers already have access to their clients' enrollment data through systems like Employee Navigator or other HR software. This means they can offer benefits reconciliation services by using this data to audit invoices effectively. By comparing the enrollment information with carrier invoices, brokers can spot discrepancies including incorrect charges or coverage errors, which can happen as a result of human error or system misconfiguration on both, employer and insurance carrier sides.
Challenges of Manual Invoice Auditing
Manual invoice auditing, though seemingly straightforward, is labor-intensive and requires meticulous attention to detail. Brokers often lack staff with both accounting and benefits expertise, making the process inefficient and prone to errors.
These challenges become even more significant when working with clients who have complex company structures, multiple HR systems, and multiple locations. Sometimes, clients grow through mergers and acquisitions, bringing in subsidiaries that use different HR systems than the parent company. This adds layers of complexity to the auditing process. Brokers can assist these clients by figuring out exactly how much each location or business unit owes for their benefit plans. By bringing together and matching data from different systems, brokers help organizations handle this added complexity, ensuring billing is accurate and costs are correctly allocated throughout the entire company. However, doing this manually increases the risk of mistakes and can overwhelm service teams.
Case Study: Uncovering Invoice Discrepancies
A broker auditing invoices for multiple clients with 5,000 employees (avg.) on benefits and 128 invoices revealed significant discrepancies:
84% of plan participants automatically matched between the carrier invoices and the enrollment data.
Of the remaining 16% the following was observed:
2% had a Tier Mismatch, where coverage levels differed (e.g., "Employee Only" vs. "Employee + Spouse").
17.5% showed a Rate Mismatch, indicating discrepancies between invoiced amounts and expected amounts.
33.5% involved Timing Differences due to Suspected Termination, where terminated employees were still on invoices.
35.5% had Timing Differences due to Suspected New Hires, with new employees not yet appearing on invoices.
While some discrepancies would resolve in subsequent billing cycles, issues like tier and rate mismatches could lead to financial losses or legal complications if left unaddressed. Auditing all employees and invoices manually each month is not sustainable, highlighting the need for streamlined processes.
Option 2: Winning Large Deals with Limited Resources
Securing large contracts often involves responding to Requests for Proposals (RFPs), where employers outline their specific needs and expectations. These proposals require brokers to meet complex requirements and offer supporting service packages, which often include premium administration services.
For brokers, especially smaller ones or those without extensive administrative teams, meeting these demands can be challenging. Without the necessary infrastructure, competing for large deals can strain existing resources and make it tough to match larger firms with more substantial teams and systems.
An effective strategy is for brokers to partner with technology providers to bundle insurance offerings with software solutions. This approach allows brokers to provide tools that enable their service teams to handle benefit plan billing more efficiently. As a result, the agency can assist employer's HR and benefits teams to manage complex billing tasks across multiple locations or different HR systems, especially after mergers and acquisitions. Bundling these services gives employers a single solution to simplify benefit plan billing operations and improve efficiency, while brokers add value without overextending their resources.
The Importance of Invoice Auditing
Common Discrepancies and Their Impacts
Invoice discrepancies are not just administrative nuisances; they have real financial and legal implications. Overpaying premiums affects an employer's bottom line, while underpayments or coverage gaps can lead to compliance issues and employee dissatisfaction.
Financial and Legal Risks
Failing to identify and correct invoice errors can result in:
Financial Losses: Paying for coverage not received or for terminated employees.
Compliance Issues: Non-adherence to regulations like COBRA can lead to penalties.
Employee Relations Problems: Employees may face coverage gaps, leading to mistrust and potential legal action.
Conclusion
Premium administration services represent a significant opportunity for benefit plan brokers and agencies to expand their offerings and strengthen client relationships. Whether by providing these services directly or by enabling clients through technology solutions, enable brokers to compete in the market and navigate the challenges of efficiency and resource management. Embracing technological tools and partnerships can help brokers deliver these services in a repeatable and high-quality offering without overburdening their teams.
How Tabulera Fits In
Tabulera offers a platform that seamlessly integrates with enrollment systems like Employee Navigator, isolved and other HRIS platforms enabling brokers to efficiently audit client invoices. With smart algorithms and configurable settings, Tabulera's benefits reconciliation module automates much of the auditing process. It filters out employees without discrepancies, highlights timing, rate, or tier differences, and aggregates benefits-related data in one place for easier research of the underlying issue. This allows brokers to focus on resolving genuine issues, significantly reducing the administrative burden. By partnering with Tabulera, brokers can enhance their service offerings, win larger deals, and provide clients with the tools they need for effective premium administration.
The Member Search feature allows users to quickly find employee, dependent, or company data with just a few keystrokes, streamlining the process.
We’ve introduced a feature to our platform called Member Search, making it easier to quickly find data related to any employee, dependent, or company on the platform. This feature is available to everyone, regardless of the modules purchased, but you must have parent company user privileges to access it.
How does it work?
Simply start typing the company name, employee, or dependent in the search box at the top right corner of the screen, then select the correct option from the suggestion dropdown.
Company Search
Type the company name in the search box and select it from the dropdown. You’ll be taken to a Company Summary Dashboard that shows:
A list of carriers the company is enrolled with.
Payroll deduction amounts with check dates.
A list of employees working for that company.
And if you’re using the EDI Carrier Connectivity Module, you’ll also see any sent EDI 834 and other EDI format files.
Enrollment History
The Enrollment Tab shows the history of enrollment files. You can see the upload dates, whether from direct system integrations or manual file uploads. By clicking on an enrollment file, you can view the members listed in that specific file.
Payroll History
The Payroll Tab displays the history of paychecks. Click on any payroll record to see the members associated with that paycheck, including deductions and contributions.
Employee Search
If you need to find information on a specific member (employee or dependent), simply type their name in the search box. The system will show the member’s details, including:
Learn how to use Tabulera’s new Member Mapping feature to easily link unmatched employee records in your system.
We have a new update to Tabulera’s Benefits Reconciliation Module—Member Mapping. Previously, this process required switching to the Old UI, but now, it’s fully integrated into the New UI for a seamless reconciliation experience.
What is Member Mapping?
When you’re performing a reconciliation and viewing the member list, you might notice some members with a red icon next to their names. This icon indicates that the member appears on an invoice but isn’t matched in Tabulera's database. This usually happens because the members name is different on the invoice compared to the Enrollment or Payroll systems, making it impossible for the platform to automatically connect them. The Member Mapping feature allows you to manually link these records.
How to Use Member Mapping
Filter Unmapped Members: Start by filtering the Member View to display only the unmapped members. Click on the icon in the Person Column and select “Not Enrolled Members.”
Select and Map: Choose a member from the list. In the panel that slides out from the right, navigate to the Member Mapping Tab. If you know the name as it appears in the HRIS, begin typing it, and select the correct entry from the suggestions. In our demonstration case, the invoice shows “Cat Grant,” and the HRIS lists “Catty Grant-Olsen,” you can map these records together. If you’re unsure of the exact name, start typing, and the platform will narrow down the options. Alternatively, you can manually enter the details if you know the members SSN. There’s also an option to ignore the mapping, which is useful for COBRA employees.
Advanced Options
In more complex scenarios, you can use the Advanced Options:
“Activate this mapping only for the specified date range”: Use this when a member has changed companies, and you need the platform to recognize that the employee works for a different company after a certain date.
“Apply Mapping to this Member Plan Only”: This option is for when you want to map a member for a specific invoice (e.g., for this month or year only).
Once you’ve mapped the member, click “Create Mapping.” The icon next to the employee’s name will change to a clock, indicating the mapping is complete. Remember, after mapping, you need to regenerate the reconciliation report. To save time, map as many employees as possible before regenerating.
Regenerate Reconciliation Reports
To regenerate the reconciliation reports, click on the Payroll/Enrollment Reconciliation Button in the Top Navigation menu. Then, click the Regenerate Button next to the invoice you’ve been working on.
Review and Adjust Member Mappings
To view all Member Mapping configurations for a specific invoice, go inside the invoice. At the bottom of the screen, click the “Configure” button and select “Member Mapping.” Here, you’ll see all your mapped members. If you need to correct any mappings, simply click the “Remove” button and remap the employee. Remember to regenerate the reconciliation report after making any changes.
In August, we launched updates to the Benefits Reconciliation Module, introducing Activity Logs, Paycheck dates, and a new Source Report.
Activity Log: A Complete Record of Every Action
We’ve introduced the Activity Log—a feature designed to track every action performed within the Benefits Reconciliation Module. This running register provides an activity log at every level.
1. General Activity Report:
Accessed through the Invoice List View under the Reports Menu, this report offers an overview of activities across the entire Benefits Reconciliation application.
2.Invoice-Level Activity Report:
This report is found in the bottom Reports section after selecting an invoice. It lists all activities associated with the selected invoice, giving you a clear view of each step taken.
3.Employee-Level Activity Report:
Track activity associated to a specific employee. Access it by selecting an employee in the Employee List view, then clicking on the Audit Log tab in the Employee Details Panel.
Enhanced Employee Detailed View: Now with Paycheck Data
We’ve updated the Employee Detailed View Panel to provide more insight. In addition to information from Carrier Invoices and Enrollment data, the panel now displays individual paycheck dates and associated deduction amounts.
Introducing the Source Report
The new Source Report feature, accessible at the bottom of the Invoice View through the Reports Menu, allows you to download source data as seen by our Benefits Reconciliation Platform. Choose from:
In July, we launched two important updates to the Benefits Reconciliation Module, enhancing our platform's versatility and efficiency.
In July, we launched two important updates to the Benefits Reconciliation Module, enhancing our platform's versatility and efficiency.
Payroll Frequency Adjustment
Companies using bi-weekly or weekly payroll deductions for benefit plan premiums require a different methodology to reconcile insurance carrier invoices. This methodology adjusts for the discrepancies that arise due to differing deduction cycles compared to the carrier invoicing cycle.
For example:
Bi-weekly payrolls have 26 deductions per year, resulting in some months having 2 and others having 3 payroll deductions. Consequently, all months will show a variance to the monthly carrier invoice. We adjust for this variance by creating a pay frequency adjustment, allowing users to see this adjustment as expected and marking it as 🟢Auto Resolved.
We have created a Reconciled Balance View that appears on the Employee Detail Panel, with all adjustments, including:
Rounding
Payroll Frequency
Write-offs
Beginning Balance
This Reconciled Balance View documents in a running ledger format how the invoice was reconciled each month.
The Reconciled Balance toggle disables the Payroll Frequency Adjustments to show the employee’s actual Plan Balance. For instance, an employee who starts deductions in a 3 payroll frequency month and terminates in the same month will show a refund owed to the employee under the Plan Balance View, but under the Reconciled Balance View, they will show a 0 balance due to a Payroll Frequency Adjustment being added to account for the expected variance.
Monthly Reconciliation Report Update
The additional Summary Reconciliation tab was added to the Monthly Reconciliation Report at the request of many of our client accounting teams. We’ve created an Excel Pivot Table to show a summary of all Adjustments and Plan Balances between the Payroll/Enrollment systems and the carrier invoices to tie these amounts to each other.
“Column C” starts with the payroll system and “Columns D - H” show Adjustment Amounts. “Column I” shows the balances created in the Employee Plan Balance View.
If you add the Payroll/Enrollment system totals in “Column C” and add the totals from “Columns D - H” and subtract the plan balances in “Column I”, this will equal the carrier invoice amount in “Column J”.
As you make adjustments, such as writing-off amounts, this report will change to reflect these adjustments.
Discover how benefits invoice audit, also known as benefits reconciliation, helps brokers catch and correct billing errors.
Why Are Benefit Invoice Audits Important for Brokers and Their Clients?
Employers audit their employee benefit invoices to catch errors and correct discrepancies, ensuring proper financial controls and making sure employees receive the health coverage they selected. In benefits administration, errors and discrepancies often arise from human mistakes on both the carrier and employer sides. Common issues include:
System Misconfiguration: Incorrect rates being applied, wrong eligibility dates etc.
Terminated Employees on Invoices: Employees who have left the company but are still being billed cause unnecessary expenses.
New Hires Not Appearing on Invoices: New hires missing from invoices can lead to compliance issues.
Implementing benefit invoice audit processes helps identify and correct issues promptly, maintaining financial accuracy and efficiency. Brokers can assist their clients by leveraging tools and expertise to streamline this audit process, ensuring accurate billing.
Two Ways Brokers Can Help Their Clients with Benefit Audits Using Tabulera:
1. Benefit Invoice Audits As A Service.
Brokers can leverage Tabulera’s Benefits Reconciliation Module by integrating it directly with any HR and Benefit Enrollment platforms. This integration allows brokers to upload clients’ carrier invoices into Tabulera, which then automates the discrepancy identification process.
According to our research, the efficiency of automated matching is around 84% with Version 3.0 of the Benefits Reconciliation Module; meaning brokers need to manually review only 16% of the total benefits-eligible employee population. Of these, statistically 10% are new hires and terminations in transit, which should auto-resolve next month, while 6% will have actual rate discrepancies, system misconfigurations, or plan mismatches that can cause financial leakage for the employer.
Automation: The system automatically matches invoices with enrollment data, significantly reducing manual effort. It efficiently identifies enrollments in transit (such as employees hired after the invoice generation date) and terminations in transit (employees terminated after the invoice generation date), as well as plan mismatches. The system highlights all discrepancies in order to address system misconfigurations or data errors.
Efficiency: Brokers can reconcile all of their clients' invoices or select specific clients that need this service within a single platform, streamlining their operations and enhancing service delivery.
2. Referrals for Enterprise Accounts.
Some brokers, particularly smaller ones, manage large, complex accounts that require detailed payroll reconciliations. For these accounts, brokers can become a referral source, directing clients to Tabulera’s solutions. This approach is especially beneficial for brokers who lack the capacity to provide detailed reconciliations effectively. By offering Tabulera’s software, brokers can equip their clients' HR teams with the necessary tools to perform benefits reconciliation accurately on their own, retaining their large clients and demonstrating creativity in finding solutions to their problems.
Cost Savings: The reduction in billing errors and write-offs leads to significant cost savings for employers.
Financial Control: Controllers and CFOs will appreciate the improved financial oversight, knowing that their benefit plans are frequently reconciled.
Benefits of Using Tabulera’s Software
Tabulera’s Benefits Reconciliation Module is highly effective for accurately and efficiently auditing list-bill or self-bill invoices against enrollment or payroll data. The platform focuses on verifying that charges from insurance carriers or self-bill calculations align with actual enrollments and payroll deductions.
Key benefits include:
Monthly Premium Reconciliation: Ensures that the premiums billed by carriers accurately reflect the enrolled employees and their selected plans, reducing overpayments and billing errors.
Reporting: Provides detailed reports that highlight discrepancies, allowing brokers to address issues with carriers promptly and ensure accurate billing.
Enhanced Efficiency: Tabulera’s software automates the tedious task of matching carrier premium invoices with payroll and enrollment data. This automation not only reduces the chances of manual errors but also ensures that discrepancies are identified and addressed promptly.
ROI: Our clients have experienced significant financial benefits from using Tabulera’s software. For example, one case study revealed that a client eliminated 97% of benefit write-offs, showcasing the substantial ROI and improved financial accuracy achieved through our platform.
Seamless Integration: Tabulera’s Benefits Reconciliation Module accepts enrollment and payroll data via API, reports, and SFTP connections from the most popular HR and Benefits platforms such as Employee Navigator, Workday, UKG Kronos, and ADP. It can also accept any enrollment or payroll report in Excel or CSV format. This compatibility ensures that brokers can easily incorporate our solution into their clients' existing systems without disruption.
Conclusion
By utilizing Tabulera’s Benefits Reconciliation Module, brokers can offer enhanced services to their clients, ensuring accurate and efficient benefit invoice audits. Whether integrating our module into their own systems or referring larger clients to us, brokers can trust Tabulera to deliver reliable, automated solutions that drive productivity and financial accuracy. Our proven technology not only simplifies the reconciliation process but also provides significant ROI, making it an essential tool for modern benefits administration.
Accurate benefits reconciliation is paramount for Professional Employer Organizations (PEOs) acting as plan sponsors for their clients' employees, as it ensures financial accuracy, compliance, and exceptional service delivery. The reconciliation process involves frequently examining and reconciling benefit invoices to uncover differences, guarantee accurate benefits coverage, and prevent overpayments to insurance carriers. Let’s compare Tabulera’s Benefits Reconciliation Module with EverythingBenefits to highlight why now is the time to make the switch to Tabulera.
Tabulera’s Benefits Reconciliation Module
Tabulera’s Benefits Reconciliation Module provides an automated, streamlined process to ensure accuracy in billing and reduce administrative burden. It matches carrier invoices against employee payroll, enrollment, and COBRA data automatically, identifying discrepancies in seconds. Key benefits include:
The system automatically matches 84% of items, reducing the client's reconciliation workload to just 16%.
Proven ROI in Q1
The ability to eliminate 97% of write-offs within six quarters
Track Plan Balances: Creates employee plan-level transaction registers for clear balance history, allowing for proper collection or adjustments of premium variances.
User-Friendly Interface: Simplifies the reconciliation process with easy-to-use matching algorithms and a short learning curve. Sorts discrepancies by discrepancy reason and allows users to quickly focus on discrepancies that can cause serious potential financial losses.
Direct Integrations
Tabulera offers dedicated integrations with popular software platforms to enhance the benefits reconciliation process:
iSolved and PrismHR: Enables automatic enrollment and payroll data stream, eliminating manual monthly enrollment and payroll generations.
Employee Navigator: Facilitates seamless data exchange, ensuring accurate reconciliation of employee benefits enrollment data with carrier invoices. This integration is particularly useful for brokers expanding their offerings to clients.
In addition to these direct integrations, Tabulera is platform-agnostic and accepts files from any enrollment or payroll system, including UKG Kronosenrollment and payroll reports.
Why Make the Switch to Tabulera?
Try before you buy: Take advantage of Tabulera's free 90-day trial for clients switching from EverythingBenefits. This trial provides ample time to experience the platform's benefits firsthand and ensures a smooth transition.
Short implementation time: Tabulera offers a streamlined implementation process, minimizing downtime and ensuring rapid deployment.
Flexible configuration: Tabulera accommodates various payroll frequencies and supports both list and self-bill invoices. Additionally, it is capable of accounting for plan margins, providing flexibility to meet diverse client needs.
Track Plan Balances: Tabulera maintains clear balance history for accurate premium collection or adjustments, ensuring financial integrity and compliance.
Various Plan Structures: Tabulera works seamlessly with both self-funded and fully insured plans, offering flexibility to accommodate various plan structures
Organizational Structures: Tabulera seamlessly adapts to any organizational structure, including subsidiary companies, and facilitates the rebilling process accordingly.
Discrepancy Reason Classification: Tabulera automatically classifies discrepancy reasons, streamlining the resolution process and saving valuable time.
User-friendly interface: Tabulera's intuitive platform features a short learning curve, meaning you don't need to be an accountant to successfully reconcile benefits.
Continuous improvement: Unlike competitors, Tabulera is committed to constant improvement and development. With monthly new feature releases, you can trust that Tabulera remains at the forefront of innovation in benefits reconciliation.
Switching to Tabulera’s Benefits Reconciliation Module ensures PEOs can continue to manage their benefits billing accurately and efficiently, maintaining the high service standards their clients expect.
Discover powerful new features in our Benefits Reconciliation Module! Generate multiple reconciliation reports effortlessly, mass-enter beginning bala
Dear Tabulera Users, We are excited to announce the implementation of two new features aimed at enhancing the usability of our Benefits Reconciliation Module:
Mass Actions - Generate Reconciliation Reports:
This feature empowers you to regenerate multiple or all reconciliation reports for a selected period of time with ease. No longer will you need to manually refresh each invoice after adjusting mapping configurations or uploading new invoices. To utilize this feature, simply navigate to the “Mass Actions” button located in the bottom left corner of the invoice list. From there, choose “Generate Report” and select individual invoices or use the checkbox in the table header to select all invoices. Click the “Generate” button and allow the reports to regenerate seamlessly.
Mass Actions: Beginning Balance
This feature allows for the mass entry of adjustments into the Plan Balance ledger, specifically supporting retroactive adjustments (Beginning Balance) for balances prior to the conversion to Tabulera.
To utilize this feature, simply navigate to the “Mass Actions” button located in the bottom left corner of the invoice list. Hover over "Beginning Balance" and select a "Generate Report" template. Then, either select individual invoices or use the checkbox in the table header to generate a template for all invoices. The template file will be downloaded as soon as it's generated.
Next, open the table with Excel and enter the beginning balances from the system you're migrating from in the last column. Ensure not to change any other values except for the last column. Once you've finished entering the amounts, return to the system, click on the "Mass Actions" button in the bottom left corner, select "Beginning Balance," and upload the report. The invoice will automatically regenerate.
If you've made a mistake and would like to remove all the beginning balance amounts, download the template and enter "0" in the last column, then reupload it. This action will revert your previous edits. If the invoice regenerates longer than expected, please refresh the page.
Employee Status Filter:
This feature provides you with the ability to quickly display employees falling into specific categories, including:
Active Employees
Terminated Employees
COBRA Employees
Employees not registered on the platform (commonly due to missing or incomplete SSNs). To address issues with these employees, please contact our support team at client.support@tabulera.com.
To access this feature, simply click the person icon in the header of the first column in the Employee List View. Then, select the desired employee status you wish to view.
We believe these enhancements will greatly improve your experience with our Benefits Reconciliation Module. If you have any questions or require assistance, please don't hesitate to reach out to our support team.
Enhanced platform security with our new Two-Factor Authentication (2FA) feature, ensuring secure access with every login.
Effective March 4th, 2024, Two-Factor Authentication (2FA) has been implemented as a mandatory security measure for all users accessing the Tabulera platform. Please note that the platform will require 2FA verification every 3 hours to ensure ongoing security. This guide will walk you through the steps to login using 2FA.
Visit Your Organization's Login Page
Begin by navigating to your organization's designated Tabulera login page.
Enter Username and Password
Once on the login page, input your username and password into the respective text fields provided and click on the "Sign In" button to proceed with the login process.
OTP Verification Popup
Upon hitting the "Sign In" button, a popup titled "OTP Verification" will appear on your screen. This popup will prompt you to enter a one-time password (OTP) for authentication.
Check Your Email
To obtain the OTP, check the email associated with your organization's Tabulera account. You will receive an email from client.support@tabulera.com containing the OTP. The code is valid for 5 minutes.
Login Option 1
Within the email, you will find a "Click here to login" button. Clicking this button will automatically log you into the Tabulera platform without needing to manually enter the OTP.
Login Option 2
Alternatively, you can manually copy the OTP provided in the email and paste it into the text field within the "OTP Verification" popup on the Tabulera Login Page.
Complete Login
After entering the OTP, click on the "Verify" or "Login" button within the OTP Verification popup to complete the login process.
By following these steps, you will successfully log in to the Tabulera platform using Two-Factor Authentication (2FA), ensuring an added layer of security for your account. If you encounter any issues or require further assistance, please reach out to our support team at client.support@tabulera.com.
Explore the latest enhancements in Tabulera's Benefits Reconciliation 3.2, including Manual Adjustments, Previous Period Resolved, Platform Guide.
We are thrilled to announce the release of Tabulera 3.2, the latest upgrade aimed at enhancing your experience with our Benefits Reconciliation Module. This upgrade introduces several new features designed to streamline your processes and provide greater control over your reconciliation tasks.
Manual Adjustments
The "Manual Adjustments" feature provides a method for entering adjustments into the Plan Balance ledger. This feature supports retroactive adjustments (Beginning Balance) for balances prior to the conversion to Tabulera or allows for the write-off of benefit premiums.
Click "Add Manual Adjustments" Button to add corrections to the Plan Ledger
Enter the amount and select an adjustment type
The added adjustment will be visible in the plan ledger view
Previous Period Resolution
This new feature allows you to resolve the current and previous month's discrepancies with just two clicks. This means users no longer have to go through each month individually to mark the plan as resolved and add a note for each month.
Click on the dropdown button to resolve multiple months
Select the months you wish to be resolved and add notes
Platform Guide
The most recent update now includes a Platform Guide, which explains step-by-step how to upload the source data files and how to navigate and use the Benefits Reconciliation Module. It can be accessed from the User Menu in the top right corner.
Launch a Platform Guide
Carrier Portal Links
Invoice retrieval from the carrier portal can be a time-consuming process. This new feature allows you to automatically log in to the carrier portals and avoid the copy-pasting of login credentials. The first time you access this feature, you will be redirected to the Chrome Webstore to download a Tabulera Web Password Filler Extension. Once the extension is installed, every time you hit the button next to the carrier invoice name, you will be automatically redirected to the login page, and the login credentials will be auto-completed.
2FA, or two-factor authentication, is a security measure implemented to safeguard access to the Tabulera platform. Beginning March 4th, this enhanced security feature will require every Tabulera user to provide an additional layer of authentication when logging in. In addition to entering their username and password, users will also be prompted to input a unique code sent to their registered email address.
Master Tabulera's benefits reconciliation platform with our comprehensive guide. Seamlessly navigate plan mapping, person mapping, and plan merging fo
In this guide, you will learn how to efficiently conduct Plan Mapping, Member Mapping, and Plan Merge inside Tabulera's Benefits Reconciliation Module, ensuring seamless alignment between enrollment, payroll, and carrier invoice data.
Plan Mapping
Tabulera implementation team takes care of the initial plan mapping process, but maintaining accuracy requires periodic checks. To ensure ongoing precision and automatic matching, we recommend conducting monthly reviews, especially if new Plans are added or discrepancies in the data between systems occur. Here's how to perform this operation:
Go to the Benefits Reconciliation Application
Toggle to the Old UI (Legacy UI).
Select your company type - choose either "PEO" or "ASO" from the dropdown menu. Single employer clients can skip this step.
Choose the date and the Carrier Invoice you want to map.
Click the "Generate" button. For large Master plans, generation might take a minute.
The view will display all employees alongside Enrollment, Payroll, and Invoice data sorted by plan types.
Navigate to the Plans tab.
In the Statistical Panel, verify if the "Total Plans Number" matches the "Confirmed Plans" number. If they don’t match, manually check which Plan Codes don’t match the corresponding source data.
Review each of the source data tabs and verify if any "Confirm" button is grayed out (as displayed on the image below). If a Plan Code is crossed out, it will not be reflected on the reconciliation report and can be disregarded for now. Reasons for this exclusion may include duplicate plan types, legacy plan names, or the decision not to reconcile this plan at the moment.
When encountering an unmapped plan code, select its type from the dropdown menu. If the plan lacks a typical name, opt for "Custom Plan Type" and assign it a custom name. Then, choose the corresponding "Invoice name" from the dropdown menu, unless assigned automatically. Ensure that the names align consistently across all three source data tabs. This alignment facilitates mapping; when Recon detects identical names within one Plan Type, it automatically merges those entries, eliminating the need for manual merging under the "Details" tab. Finally, click "Confirm". The "Confirmed" button will then turn green, signifying successful mapping.
Ensure that all three data sources have all Plan Codes confirmed and that the "Total Plans" number equals the "Confirmed Plans" number in the Statistical Panel.
After any edits of the mapping, if you want the data to be displayed correctly in the Reconciliation Module, refresh the page with the button located in the bottom left corner of the “Details” tab.
Member Mapping
With our latest update, Person Mapping has become more intuitive and integrated directly into the current UI, eliminating the need to switch between interfaces.
When performing reconciliation, you might encounter employees with a red icon in the Employee List View. This indicates that an employee appears on an invoice but doesn't have a corresponding match in the HRIS database within the Tabulera system. This situation often arises when an employee is listed under different names across your invoice, payroll, and enrollment systems, preventing automatic matching by the Platform.
To resolve this, you need to manually map the employee records:
Filter the Employee View: Start by filtering the Employee View to display only the Unmapped Members. You can do this by clicking on the icon in the Person column and selecting "Not Enrolled Members."
Mapping the Employee: Select any employee from the filtered list. In the panel that slides out from the right, go to the Member Mapping tab. If you know the employee's name as it appears in the HRIS system, start typing it, and select the correct match from the list provided by the Platform. For example, if the invoice lists "Cat Grant" and the HRIS lists "Catty Grant-Olsen," you can map these records together. If you're unsure of the exact name, you can make several attempts, and the Platform will narrow down your search. Additionally, if you have the employee's SSN, you can enter the details manually.
Ignore Mapping: If necessary, you can choose to ignore mapping for certain employees, such as those under COBRA, by selecting the “Ignore the Mapping for this Member” option.
Advanced Options: For more complex scenarios, use the Advanced Options:some text
Activate this mapping only for the specified date range: Useful when an employee changes companies and you need the system to recognize that the employee works in a different company after a certain date.
Apply Mapping to this Member Plan Only: This option is ideal if you want to map an employee only for a specific invoice (e.g., this month/year).
Finalizing the Mapping: Once the correct employee is selected, click the Create Mapping button. The red icon next to the employee will change to a clock icon, indicating that the mapping was successful.
Regenerate Reports: After mapping, it’s important to regenerate the reconciliation report. To do this, click on the Payroll/Enrollment Reconciliation Button in the Top Navigation menu, then select the Regenerate Button next to the invoice you've been working on. It’s recommended to map as many employees as possible before regenerating the reports to avoid repeating this step multiple times.
View All Mappings: To review all Member Mapping configurations for a specific invoice, go inside the invoice and click the "Configure" Button at the bottom of the screen, then select "Member Mapping." Here, you can see all your mapped employees. If you made any accidental mappings, simply click the "Remove" button next to the employee, and you can remap the employee as needed. Remember, after any mapping changes, you should regenerate the reconciliation report to ensure all data is up to date.
Plan Merge
Occasionally, you may encounter an employee with two or more similarly named plans under their name (for example A D & D and Life A D & D). In such cases, one plan may have a carrier invoice amount but no payroll amount, while the other plan may have the payroll amount but no invoice amounts. This discrepancy indicates unmerged plans. Follow this procedure to merge the plans:
Access the Benefits Reconciliation Application.
Toggle to the Old UI
Depending on your company type, select "PEO" or "ASO" from the dropdown menu. Single employer clients can skip this step.
Choose the date and the Carrier Invoice you want to work on, then click "Generate".
Utilize the “Find Person” feature to locate the employee with unmerged plans. Simply type in the employee's name and click the “Find” button, or search for them manually.
Hover your mouse over the Plan name in the enrollment section. When the mouse cursor changes, click on the plan name. A “Merge” button will appear in the Carrier Invoice section. Click it to merge the two plans. Repeat for the remaining plans you wish to merge.
If this action is performed for one employee, it will automatically be applied to other employees with the same unmerged case.
After any edits of the mapping, if you want the data to be displayed correctly in the Reconciliation Module, refresh the page with the button located in the bottom left corner.
Let’s make sure the plans have been merged correctly
To unmerge the plans, navigate to the Mapping Tab in the Old . Find the plan name that you wish to unmerge and click the "Remove" button.
Discover Tabulera Benefits Reconciliation 3.1: Enhanced features for streamlined reconciliation and user control.
Tabulera’s Benefits Reconciliation version 3.1 includes a number of new features based on user feedback to enhance your user experience including more user control over update processes, notifications, and new user interface enhancements.
Invoice Refresh
Yellow indicates that an invoice has not been uploaded
The invoice summary page of Benefits Reconciliation version 3.1 now enables the user to regenerate the reconciliation on-demand once invoice data is entered or updated from the Sources menu.
To regenerate a reconciliation simply click the refresh icon next to the invoice name in the invoice summary page.
Enrollment Reconciliation
Version 3.1 introduces Enrollment Reconciliation alongside our Payroll Reconciliation capabilities. Enrollment reconciliations may be useful for companies looking for a reconciliation process, even if employers are covering all benefits or before payroll data becomes available.
To access this feature, click on the hamburger menu at the top left of the invoice summary page and select either Payroll Reconciliation or Enrollment Reconciliation.
Carrier Invoice Alerts
The Sources menu Carrier Invoice panel now includes new warning labels added to the invoice name column:
Red indicates that an uploaded invoice lacks plan configuration information
Yellow indicates tha an invoice has not been uploaded
Manually Resolved Status
The Resolution Status in the “Status” column of the Benefits Reconciliation detailed invoice panel now features several new status categories. When transactions find a match with no variances or rounding discrepancies, the system now designates these as "Auto Resolved." You may also change the status, or if you resolve an item by clicking on the “Resolve” button in the Employee View detailed panel and the item is marked as "Manually Resolved". This allows for improved tracking and auditing of how each invoice item was resolved.
Customizable Field
The Employee View detail panel now has the ability to display additional enrollment information in the form of an extra text field. It can contain any information requested by the user, such as:
Job title
Division/Subsidiary
COBRA status
Enrollment platform, etc,.
Increased Line Items Per Page
The platform has now the ability to display up to 100 line items on a single page (Invoice or Employee view in both payroll and enrollment reconciliation).
Beginning Plan Balance Date
Our Beginning Plan Balance feature allows you to ignore data from previous periods, simplifying your reconciliation process and ensuring you start fresh when you need to. All panels and dashboard will display the plan balance information starting from the predefined date.
Explore the essential processes of enrollment and payroll reconciliations in employee benefit premium administration.
In the world of employee benefit administration, nothing is more dreaded than the monthly task of attempting to reconcile insurance carrier invoices. When we asked benefit managers, directors and VPs what they compare during the reconciliation process, we received puzzled looks. Let’s look at two common approaches to carrier invoice reconciliations. While Insurance carriers provide a 30-day payment grace period, most request payment and mark invoices “Due” on the first day of the insurance coverage period. In other words, insurance invoices are generated up to a few weeks in advance of the month of coverage but payable on the first day of coverage.
Enrollment Reconciliations
In the reconciliation process, the first step should involve aligning people and premiums with your benefits enrollment platform. This essentially requires a comparison of the plans employees have elected in your enrollment platform against what carriers reflect on their invoices. An enrollment reconciliation is an excellent first step to identify timing differences, such as new hires or terminations, for events that occur after the statement generation date. This step can be accomplished even prior to the payment of premiums.
Payroll Reconciliations
If your company pays 100% of all insurance coverage and makes no cost sharing arrangements via payroll deductions for employees, which is rare these days, then you can skip the payroll reconciliation process. More likely your second step is to reconcile the amount of premiums employees should be reimbursing your company as the plan sponsor for any cost-sharing premium arrangements. For instance, if your company as the plan sponsor pays for 75% of the employee only premium and the employee is responsible to reimburse the plan for the other 25%, then these amounts should be reflected with the appropriate payroll deductions.
Performing both an enrollment and payroll reconciliation assures that at the end of the day, you as the plan sponsor are not overpaying for premiums by leaving terminated employees on the invoice. Perhaps worse yet, also double checking that employees haven’t been accidentally dropped from coverage or were missed from being enrolled. Both of these reconciliation processes need to take into account COBRA plan enrollments and COBRA reimbursements as this can be a big benefit leakage area as well since these ex-employees may still be on the carrier invoices.
Insurance Carrier Correction Period
Unlike other vendor relationships, where you might find a mistake and a vendor will retroactively correct, insurance carriers usually allow only a 60 to 90 day look back period for corrections that could be attributed to the plan sponsor. This rule is not unreasonable given that carriers may be paying out claims due to the error of a plan sponsor.
Which One Works Best
Reconciling enrollment transactions to the carrier invoice is an important step before you pay your invoice but of course doesn’t ensure that your payroll platform is taking the appropriate deductions. Payroll reconciliations maybe a better way to look at the outcome for a month but can only be completed after the coverage period month ends since payroll deductions are actively processing until the last day of the coverage month. This puts you as the plan sponsor in a tough spot to quickly identifying and resolve discrepancies before the correction period expires. This may be difficult if you’re a large employer with high turnover.
The right answer maybe is to look at both processes as independent of each other that validate different steps in the Benefit Premium Administration process, the results of each reconciliation can, however, be mutually leveraged. Using both your benefit team and your accounting teams and these two processes you should be able to provide a high level of reliability that you as the plan sponsor are covering the right people, paying the appropriate premium and receiving the right employee reimbursements.
Explore the relevance of Management by Walking Around (MBWA) in the digital age of remote work. Discover the benefits and the challenges of MBWA.
In the age of remote work, effective management can be challenging, but it is essential for achieving success. One popular management style that has stood the test of time is Management by Walking Around (MBWA). Initially introduced in the 1980s by Tom Peters and Robert Waterman's book In Search of Excellence, MBWA encourages managers to interact with their employees in a casual and informal manner by walking around the office and engaging in conversations. However, in the digital age, with remote employees, MBWA requires adaptation to remain effective. This article explores the benefits and challenges of MBWA in the digital age and offers tips for adapting the approach for remote teams.
Management by Walking Around (MBWA) is a popular management style that has been used since the 1980s to build relationships and trust between managers and employees. However, in the digital age, with remote employees, MBWA has become challenging to implement. The question is whether this style of management is still effective or not.
The Benefits of MBWA
MBWA has many benefits for both managers and employees. It allows managers to gain a better understanding of their employees' work and build relationships based on trust and open communication. It also encourages employees to be more honest and open with their managers, as they feel valued and listened to.
The Challenges of MBWA
In the digital age, implementing MBWA can be challenging. Managers cannot physically be present in the office, making it difficult to connect with employees. It also requires managers to be available at all times, which can be difficult to manage with a busy schedule.
Adapting MBWA for the Digital Age
Despite the challenges, MBWA can still be effective in the digital age if it is adapted to fit the new environment. Managers can use virtual meetings and video conferencing to stay connected with their employees. They can also use digital tools to track progress and performance. This may require some training and investment, but it can lead to streamlining manual and repetitive processes, and improve overall efficiency.
Conclusion
To ensure a successful transition, both managers and employees need to approach the change with an openness to new ways of doing things. The adaptation of MBWA to the digital age may lead to even more effectiveness and success.
Learn about the EDI 834 implementation process and the significant benefits of using EDI's for streamlined benefits enrollment.
With proper planning and implementation, EDI 834 can be a game-changer for benefits enrollment, bringing speed, accuracy, and simplicity to a complex process.
What is EDI 834?
Electronic Data Interchange (EDI) is a standardized file structure to move information between two systems. One standard setting body the American National Standards Institute (ANSI) has hundreds of file formats represented by three-digit numbers for accounting, healthcare and various industries. In 1993 ANSI and the Accredited Standards Committee (ASC) for healthcare developed the 834 file format for plan enrollment transactions. This meant that systems could transmit electronically participant enrollment and demographic information from employers to insurance carrier’s eligibility, claims and accounting systems.
From Manual to Automated
Most insurance carriers now also provide a website to allow for the manual entry of new, terminated or changes to participant information transaction sets. Of course, tracking which employee information has been updated takes time and meticulous data entry skills and becomes burdensome. The beauty of the 834 file format is that it avoids these repetitive and error prone tasks while giving your team the efficiency required as you scale.
A Team Approach
Implementation of an 834 EDI file depends upon several factors such insurance carrier, EDI vendor and your own team’s availability. Your internal cross functional team should be comprised of benefit, accounting, and information technology staff. Each insurance carrier will have an EDI guide commonly referred to as a “structure” document. Your cross functional team will be helpful to coordinate answers regarding the administration and plan rules to facilitate carrier discussions. The analysis of the EDI structure document and the technical implementation and testing commonly can take between three and twelve weeks.
Getting Started with EDI 834
While some larger companies have EDI experienced analysts or developers on staff, your enrollment, HRIS or third-party EDI software platform vendor many times create your 834 file feeds. Transmission of these feeds is automated through secure file transmissions. Testing with insurance carriers is required prior to beginning of production transmissions. Files can be transmitted on a weekly basis with carriers providing a discrepancy report for incomplete enrollment information for your team’s review.
Candence & Controls:
Correcting weekly discrepancy reports usually resides with the entity that understands how to read the report, is closest to the data, and has the system permissions to fix errors like missing dependent or date of birth information. Maintaining the process is imperative to keep things accurate in the carrier system and requires staff that can devote the time and effort to the process.
Benefits of 834 Files
The benefits of using EDI 834 files, are significant, from the efficiency and timeliness of the process, quality of the data transmitted to the ability to include fields like department or business unit that can later appear on your premium invoice and can significantly reduce your accounting work. Job satisfaction is also improved materially as employees receive fewer employee complaints, move from a tedious data entry role into a research and system correction role with a process that can scale with your company.
Discover the differences between list-billing and self-billing for employee benefit plans, including their unique reconciliation processes.
When it comes to managing an employee benefit plan, choosing the right billing method can make all the difference. This is where list-billing and self-billing come into play. List-billing involves the insurance carrier generating an invoice for premiums and sending it to the employer, while self-billing is when the employer creates and sends the invoice to the insurance carrier. Each method has its unique processes and reconciliation methods, and choosing the right one for your company can impact how you manage premiums and reconcile discrepancies. By understanding the differences and advantages of each method, you can make an informed decision on which billing method is best for your organization.
Employee benefit plans are an essential part of any organization. As an employer, you need to ensure that your employees receive the benefits they deserve, and one of the critical factors is paying the premiums on time. This is where list-billing and self-billing come into play.
What is List-Billing for an Employee Benefit Plan?
List-billing is a process where the insurance carrier generates an invoice for premiums and sends it to the employer. The data for the invoice is taken from the enrollment system, which may be manually entered into a carrier website, or larger employers may transmit the data directly to the carrier. The employer is responsible for paying the amount stated on the invoice to settle the transaction. Insurance companies usually publish the list-bill on their website.
What is Self-Billing for an Employee Benefit Plan?
Self-billing is a financial arrangement between the employer and the insurance carrier, where the employer creates an insurance premium invoice and sends it to the carrier along with the backup detail information. The data to create the invoice is usually derived from the employer's benefit enrollment or payroll system. The employer is then responsible for paying the amount stated on the invoice they created to settle the transaction.
What's the difference between Self and List Bills?
The main difference between self-billing and list-billing is who creates and sends the invoice. In self-billing, the employer creates and sends the invoice, while in list-billing, the insurance carrier creates and sends the invoice.
Comparing the Reconciliation Processes of List-Bills and Self-Bills for Employee Benefit Plans
The reconciliation process also differs between list-billing and self-billing. With a list-bill, the employer needs to note any variances in timing that occur for new hires or terminations after the statement generation date and the enrollment and/or payroll system to ensure these are resolved on the following month's invoice. Differences in premiums between the enrollment and payroll systems may also occur due to carrier invoicing calculation errors or configuration of payroll deduction and/or plan enrollment premium tables.
While self-bills may eliminate enrollment and termination timing differences, they do not eliminate system configuration errors, such as lack of payroll deductions, leaves of absence, missed first or last deductions from partial months of employment. Moreover, self-bill programming or spreadsheets may introduce calculation errors given the complexity of eligibility and possible wash rule algorithms. The benefit or accounting team may be unaware that these errors even exist if premiums are not reconciled against a third-party invoice.
Conclusion
In conclusion, both list-billing and self-billing have their pros and cons. With list-billing, the carrier creates an invoice documenting what they believe the employer owes, and the employer can validate it against their own systems. With self-billing, the employer can eliminate timing differences, but it leaves them guessing what rates the carriers attach or when rate increases may take effect for their plans. Regardless of which billing method an employer chooses, monthly invoice auditing against their enrollment, payroll, and their invoices is a sure way to avoid surprises.
Discover how our clients saved over $531,742 in just one year by implementing consolidated invoicing and benefits reconciliation.
Employee benefits are an essential component of attracting and retaining top talent in today's competitive job market. However, many employers may not be aware that they are losing significant amounts of money due to errors and inefficiencies in benefits billing. We took an in-depth look at the data from our own clients, analyzing write-offs over a two-year period, and discovered surprising revelations about where employers are losing benefits dollars. This blog post will explore the causes, the numbers, and how implementing consolidated invoicing and benefits reconciliation can help your organization save valuable resources.
Key Point #1: The Perils of Multiple Systems with Manual Configuration
Many employers utilize separate enrollment and payroll systems, alongside manual data entry processes for COBRA and emergency enrollments. These disparate systems can create a perfect storm of confusion and inefficiency, leading to costly errors.One of the main issues is that these systems are often maintained by different teams. Each team might have varying levels of expertise, experience, and commitment to maintaining the quality of the system. This inconsistency can lead to data discrepancies, making it difficult to reconcile even one set of systems, let alone multiple sets.Furthermore, these systems don't only differ in how they handle employee names and identifying information. They can also have different names and descriptions for the same plans and benefits, causing even more confusion when trying to match records across systems.
In this illustration, we demonstrate the discrepancies that can arise when the same employee and plan are represented in three different systems:
Enrollment system
First name: Ken Middle name: P. Last name: Lee SSN: 1234******** Plan Name: OAMC 500 Plan Description: ER Funded Short-Term Disability-Employee Only
Payroll system
Employee Name: Kenneth Peter Lee SSN: (NOT AVAILABLE) Plan Name: AETNA-OAMC-500/80-NB Plan Description: STD Deduction amount: $80.74 Pay Frequency: Bi-Weekly
Carrier Invoice
Employee name: Lee, Ken P. Plan Description: STD Cigna Tier: EMP+Family Rate: $161.48
This example highlights the inconsistencies between different systems in terms of naming conventions, plan descriptions, employee names, and the availability of key data like Social Security Numbers. These discrepancies can make benefit plan reconciliation challenging, emphasizing the need for effective tools and processes to improve accuracy and efficiency.
Key Point #2: The Responsibility Conundrum
Determining who should be responsible for preventing benefits billing errors is a challenge. In many instances, reconciliation is ignored by both the benefits and accounting teams. This lack of accountability can lead to costly mistakes and lost benefits dollars.
Benefits teams often find themselves understaffed and overworked, trying to manage complex benefits processes with limited resources. They usually rely on Excel spreadsheets, which, while useful, have their limitations when it comes to handling complex benefits processes. As a result, it's difficult for benefits teams to come up with a formula that can match records across disparate systems, leading to errors and inefficiencies.
Accounting teams, on the other hand, may not have the specialized knowledge required to handle complex benefits processes. They may also lack access to HR systems, which can result in errors and inefficiencies when it comes to benefits billing and reconciliation.
The Numbers: A Closer Look at Lost Benefits Dollars
Our analysis revealed an average of $6.47 per employee per month in premium write-offs during the first quarter. This may not seem significant initially, but multiplying it by the number of employees demonstrates the true impact:
One quarter: $6.47 x 21,182 = $136,944
Pre-Tabulera numbers: Total Benefit Write-Offs: $136,944 Benefit Premium Write-off: 0.79% Benefit Premium Processed: $17.4 million Employees per Quarter: 21,182
These numbers reveal the hidden costs of inefficient benefits billing process. Over time, these costs can add up and significantly impact an organization's bottom line.
Addressing the Problem: Implementing Consolidated Invoicing and Benefits Reconciliation
To combat these issues, we introduced two modules for our clients: Consolidated Invoicing and Benefits Reconciliation. These modules were designed to streamline the benefits billing process and reduce the likelihood of errors and inefficiencies.
The Consolidated Invoicing module combines carrier list bills and generated self-bills into a single monthly invoice. This simplifies the invoicing process and frees up Accounts Payable staff from having to manage and pay multiple invoices each month. By consolidating invoices, the module also makes it easier for accounting teams to track benefits spending and ensure that payments are made on time.
The Benefits Reconciliation module filters out timing differences and identifies potential system misconfigurations. This allows the Benefits team to focus on employees who require attention and helps prevent billing errors. The module automates much of the reconciliation process, flagging issues such as:
Employee terminations that are still being invoiced
Deductions from employees who aren't present on an invoice
Rate differences between payroll, enrollment, COBRA, and carrier invoices
By automatically categorizing these variances and calculating self-bills, the Benefits Reconciliation module enables HR teams to address discrepancies more efficiently.
The Impact: Substantial Time and Cost Savings
By the third quarter, most clients had reduced their premium write-offs to about $0.22 per employee per month, a 97% reduction. This demonstrates the powerful impact of implementing consolidated invoicing and benefits reconciliation on an organization's bottom line.
Despite some residual write-offs due to varying implementation timelines and delayed reporting of terminations, the overall impact was significant. The case study covered multiple employers that were not implemented at the same time, which may have contributed to some of the remaining write-offs.
Benefits reconciliation can introduce substantial time and cost savings by allowing HR teams to focus on analyzing variances instead of manually checking every employee's information. This can reduce the labor-intensive aspect of the process by up to 90%, freeing up HR professionals to focus on other important tasks.
Let's take a closer look at the complete timeline. By analyzing the data over two years, we were able to track the progress of our clients' benefits billing processes. In the beginning, premium write-offs were a significant issue, causing unnecessary financial strain on the organizations. However, as the clients implemented the Consolidated Invoicing and Benefits Reconciliation modules, the write-offs began to decrease dramatically.
By Q3, most clients had normalized their Write-Offs of premiums to about $0.22 PEPM, effectively eliminating the issue for many employers. This demonstrates the power of implementing efficient benefits billing processes and tools, which can help organizations save valuable resources and improve their bottom lines.
Conclusion
Inefficiencies in benefits reconciliation can lead to lost dollars for employers, negatively impacting their financial health. By addressing the challenges posed by disparate systems, manual processes, and lack of accountability, organizations can save valuable resources and ensure accurate benefits billing.
Implementing Consolidated Invoicing and Benefits Reconciliation can have a significant impact on an organization's bottom line, reducing premium write-offs by up to 97%. With the potential for substantial time and cost savings, these tools should be considered by any organization looking to streamline their benefits reconciliation process and eliminate unnecessary expenses.
If you know someone who is tired of wrestling with spreadsheets and dealing with the headaches of inefficient benefits reconciliation, please share and repost this analysis to spread awareness about the potential benefits of implementing consolidated invoicing and benefits reconciliation. By shedding light on the hidden costs of employee benefits reconciliation and sharing solutions to address these challenges, we can help organizations save money and better support their employees.
Learn how Tabulera's Benefits Reconciliation Module simplifies the identification of variances, streamlining the process for Benefits professionals.
For HR and Benefits professionals, reconciling employee benefit plan invoices is a critical task that cannot be ignored. However, in understaffed departments, accounting work can often take a backseat due to time constraints and limited resources. Ignoring this work can result in serious consequences such as non-compliance, financial penalties, and dissatisfied employees. The good news is that the Tabulera, now in its latest version 3.2, provides a user-friendly solution that streamlines the reconciliation process, ensuring accuracy and saving time. This comprehensive guide will take you through the step-by-step process of reconciling employee benefit plan invoices using Tabulera 3.2, giving HR and Benefits professionals the tools they need to effectively manage accounting work and mitigate potential risks.
Home Dashboard review
Log in to the Tabulera Portal and access the Home Page, offering an overview of key metrics related to your employee benefit plans. The user-friendly and intuitive design of the Home Page facilitates easy navigation through various features of the Tabulera platform.
The Home Page dashboard presents statistical information on the left and financial details on the right, complemented by a navigation bar along the top.
Our primary focus will be on the Sources and Benefits Reconciliation links in the main menu.
Let’s walk through a step-by-step process that starts with uploading the source data files, then reconcile an insurance carrier invoice and look at our reconciliation reports.
Upload Source Data Files
Sources menu
Uploading the relevant source data is the first step in reconciling employee benefit plan invoices using the Tabulera platform. This is a crucial step in ensuring that accurate data is used to reconcile the invoices. The type of source data that needs to be uploaded includes enrollment data, payroll data, COBRA data, and carrier invoices.
At the top of the page, you’ll notice a Date Ribbon for your coverage periods and along the left navigation menu we have the four data sources we need to load to complete a reconciliation. These data sources include your enrollment, payroll, COBRA and your carrier invoice data.
Enrollment Data Upload
Let's kick off the data upload process by focusing on the enrollment file. Click on the "Re-upload" button and select the enrollment report file from your local computer. It's crucial to ensure the file is accurate and reflects the most up-to-date information for the respective period.
Payroll Data Upload
After managing the enrollment data, navigate to the payroll menu. Click on "Add File" to upload the payroll report specifically for January 2024 from your local computer. Once this upload is complete, proceed to the subsequent month, February 2024, and repeat the same procedure. Verify that each payroll report aligns seamlessly with its corresponding month.
Invoice Upload
Next, for the purpose of demonstrating how to resolve timing discrepancies we will upload two invoices, one for January and another for February 2024. Locate the Daily Planet – UHC invoice and click on the "Upload" button next to it. Then, locate the respective invoice in your local file system, downloaded previously from the insurance carrier website, and click "OPEN." Observe the status of the invoice changing to "Processing," soon transitioning to "Completed," indicating the successful upload. Repeat this process for the February 2024 invoice.
Congrats, we have successfully uploaded the source data and that we can move to the Benefits Recon Menu.
Start the Reconciliation Process
In this demo example, we will reconcile payroll deductions and employer contributions to the carrier invoice to look at any variances between these data sources and ensure we understand why the variances exist, add any adjustments, or notes to complete the reconciliation.
A dashboard at the top of the page summarizes progress on your current month's reconciliations.
The panel below displays a list of invoices, with columns indicating the invoiced amount for carrier premiums and another column reflecting the payroll amount, including employer contributions for the month. Additional columns indicate instances where you may have over-collected from certain employees compared to the invoice, as well as a column designating under-collected amounts from employees compared to the invoice. These columns usually represent timing differences for new hires and terminations. We also show the cumulative amount for each invoice variance over time in the Plan Balance column.
Since the invoices for Daily Planet have recently been uploaded - we have to click the 'Regenerate Reconciliation' button next to the invoice name.
Let’s click on the Daily Planet UHC invoice line to look at the invoice line-item details.
On the Details Page, you’ll see columns for Employee Name, Plan Type, Carrier Plan Name, the Invoice Amount, Payroll Amount, and columns for Resolution Adjustments, Resolution Reason, and a variance column for the month and a variance column for the Plan to Date. You’ll notice that one Resolution Adjustment for Rounding has already been made for our Employee “Clark Kent”.
Rounding discrepancy
If you click on his line item, you will see a panel for Clark Kent with detailed demographic data that pops out from the right, along with a history of transactions including Payroll Deductions, Employer Contributions, and Carrier Invoices, as well as a running Plan Balance for each month. The Plan Balance is expected to be zero every month, calculated as the sum of Payroll Deductions and Employer Contributions minus Carrier Invoices.
When invoices and payroll are uploaded each month, the system automatically assigns a variance reason. These reasons are helpful in categorizing possible variance causes such as rounding, timing, or configuration issues.
If no variance exists for an employee between the premium amount on the carrier invoice and monthly payroll deduction and employer contribution, the system will automatically mark the employee line items as “Auto Resolved” for the month. As you can see in the Plan Balance view, the Rounding Adjustment has been generated by the system for Clark Kent based on the company rounding rules configured during implementation.
Most transactions can be Auto Resolved by the system, but Manual Adjustments may be necessary in certain cases. Let’s examine a few of these cases.
Click on the “Filter Funnel” at the top of the Status column to filter for only those transactions that are “Unresolved”. You'll notice four transactions marked with a red dot and a status of 'Unresolved'.
Rate Differential: Beginning Plan Balance
Let's click on the first employee in the list, Jimmy Olsen.
You'll notice that he appears to be a new hire, having been onboarded on November First, 2023. If we take a closer look at his coverage start date in the detailed view, it began on December First, 2023. The carrier is billing Daily Planet for coverage retroactively for a month, as indicated by the doubled premiums billed in January.
Since January 2024 is the first time Daily Planet has been reconciled on the system, we’ll Click on Add Manual Adjustment and create a beginning balance to Jimmy’s Plan Balance in the amount of $374.82, since we don’t have any payroll deduction transaction history prior to January 2024 for the Daily Planet. This lets the system know that this is a reconciling entry for January, and the balance is recorded in both the Carrier and your systems.
You’ll now notice that as the entry is made the employee’s Plan Balance becomes zero to correctly show the running balance for Jimmy’s medical plan and that the item has been marked as “Resolved”. The Resolution Adjustment and Resolution Reason columns are also updated, along with the Over and Under Collected Amounts and Item Resolved counts at the top of the page.
Rate Differential: Write-Off
We'll click on the next employee with a red dot and a status of 'Unresolved' - Lois Lane.
By examining Lois's details page, it appears she was hired in the last half of January 2024 and only had one payroll deduction for medical insurance premiums.
We'll click on 'Add Manual Adjustments' under the Plan Balance view, Use the January Coverage Period, select the 'Write-off' reason, and enter $35.32 to record the write-off per the company policy. This once again shows the employee with a balance of zero and the item with a 'Manual Resolved' status.
The Resolution Amount, Resolution Reason column information, and top-of-page metrics have also been updated to reflect your progress.
Enrollment in transit
Next, we'll click on Perry White as he has an 'Unresolved' status as well. Perry is also a new hire with a Payroll Deduction Amount but hasn't yet shown up on the carrier invoice (You can notice a missing premium in the section highlighted in red). The system has automatically marked him in this status as 'Enroll In Transit.'
You can validate his hire date and details, but also notice, since the February invoices have already been uploaded, that the Carrier has retroactively billed for January. We'll click on 'Manually Resolved' for January with no manual adjustments necessary, as we see his plan balance is zero by February 2024.
Termination in transit
Finally, we’ll Click on Steve Lombard as his Status is also “Unresolved” with a Variance Reason as “Term In Transit”. Steve looks to be a late December termination and we, in fact, see that in February the carrier has provided the credit to refund the January Premium showing Steve has a zero Plan Balance. We can mark Steve as “Manually Resolved”.
At the top of the page, the Over Collected, Under Collected Beginning and Resolved Amounts, and Beginning and Resolved Item Counts equal each other, indicating we have completed the reconciliation of the Daily Planet’s UHC January Invoice.
Reconciliation Report
Click on the Report button at the top of the page and Click on Monthly report item to download a report listing the reconciliation details.
The report shows the total amount of the carrier invoices and any Manual Adjustments made to balance to the invoice. This reconciliation report should be provided to your Accounting Department in case these Manual Adjustment entries, as well as provide details of In-Transit items that may be required by your Accounting Department for entry into your company’s general ledger.
Conclusion
In conclusion, by following these simple steps, you can easily reconcile employee benefits plan invoices using the Tabulera Portal. The platform's user-friendly interface and straightforward upload process make it easy to quickly and accurately reconcile employee benefits against both your enrollment and payroll information.