Benefits Reconciliation UI Overview

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.

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.

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.
• Configure Button: Access Plan Configuration and Member Mapping. Each has a dedicated article.

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:

1. Plan Balance – Detailed transaction register for each plan.
2. Detailed View – Shows plan-level info and paycheck data. Download via Payroll Paychecks button.
3. Member Mapping – Manage mappings at the member level. See the dedicated article for full instructions.
4. Plan Mapping – Edit plan-to-plan mappings. A full guide is available.
5. 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.

‍

‍