4-Way Reconciliation – Enrollment, Payroll, Sent File and Carrier Invoice on One Row

The admin workbench that puts what the plan expected, what payroll collected, what was sent to the carrier and what the carrier billed side by side — then records the fix as a resolution, a note, a follow-up or a clarification package.

BR Reconcile is the reconciliation workbench of Benefits Reimagined. It does not run the matching itself: Integration Center has already matched the vendor file sent to the carrier against the carrier's invoice, and BR ReVerge has already compared expected enrollment cost against the deductions payroll collected. The workbench merges both results into one seven-section row per member, plan and month, labels it Matched or Variance, and gives the benefits operations administrator the tools to close it — a resolution written on the source record, notes, a tracked follow-up with an SLA, or a PDF, Excel or CSV package for the carrier or payroll contact. Nothing on this screen creates a new match.

Enrollment · Payroll · Sent file · Invoice Seven-section row Resolve on the source record Follow-ups with SLA Clarification packages Any HRIS · any 3rd-party payroll

Reimagining Benefits Reconciliation

"Traditional reconciliation is a two-way spot check done in a spreadsheet — enrollment against the carrier bill, once a quarter, by whoever has time. It misses the deductions that never started, the terminations the carrier never applied, and the changes that were sent but never confirmed. Benefits Reimagined changes the approach: the vendor-file match and the payroll match are run by their own engines, and one workbench lays all four sides on a single row per member and month — so the administrator's job is to decide, record and follow up, never to re-key or re-match."

4 sides on every row — enrollment expected, payroll collected, the file sent to the carrier, and the carrier's invoice
7 sections in the grid — the four sides, the two match results, and the gap between what payroll collected and what the carrier billed
2 upstream engines whose results the workbench reads — Integration Center for the vendor side, BR ReVerge for the payroll side
0 new matches created here — every fix is a resolution, a note, a follow-up or a package, written back to the record it came from

Read, Decide, Record, Follow Up: One Month

Follow September's medical plan from the two engines that matched it, through the seven-section grid, to the resolutions, follow-ups and clarification package that close it — exactly as the screens are worked.

The matching happens upstream — the workbench reads the results

Two engines do the comparing before anyone opens this screen. Integration Center matches the vendor file Benefits Reimagined sent to the carrier against the carrier's invoice lines, scenario by scenario — exact match, within tolerance, timing, proration, retro, missing line, extra line, and plan, amount or date mismatch — using an amount tolerance from the reconciliation tolerance configuration that defaults to one cent. BR ReVerge compares the enrollment cost the plan master expected with the deductions payroll actually collected. Each engine writes its own result record with a match status of Matched, Mismatched or Unmatched. The workbench merges the two for a tax year, month and carrier into one grid, so the administrator sees both verdicts on the same member without opening either engine.

What the engines supply

  • Vendor side — sent-file record versus invoice line, with the scenario that fired and the tolerance it was judged against
  • Payroll side — expected line versus collected cumulative, employee and employer amounts, from the retro run BR ReVerge locked and transmitted
  • Match status per side — Matched, Mismatched or Unmatched — and the workbench label on the merged row: Matched or Variance, with the absolute variance amount
  • Tolerance as configuration — the amount tolerance is a setting the reconciliation engine reads, not a judgement the administrator makes row by row

Why it matters

A reconciliation screen that also re-matches is a screen nobody can audit — here the match and the decision are two different records.

Loading the vendor file and the invoice, and running the match, are Integration Center operator steps; the payroll comparison is a BR ReVerge operator step. Neither is done from this workbench.

WHERE THE TWO MATCHES COME FROM Integration Center · vendor side Sent to carrier: 3,896 members · 09/01Carrier invoice: 3,918 lines · 09/05Scenarios A–J: exact · tolerance · timingproration · retro · missing · extra · mismatchTolerance: $0.01 (configured)Result: 3,873 matched · 23 mism. · 22 unmatched match result · vendor BR ReVerge · payroll side Expected: plan-master cost per memberCollected: payroll cumulatives, period 17EE and ER amounts compared per linewithin the payroll tolerance settingRun 7131 · locked · transmitted · receivedResult: 3,884 matched · 12 variance match result · payroll BR Reconcile · one row per member and month year · month · carrier · plan · status · search merged for the filter, buffered about three hours, search reads live What the workbench does with them Labels each merged row Matched or Variance with the absolute amount · offers Resolve, Notes, Follow-ups and Overview · writes every decision back to the vendor-side or payroll-side record. Illustrative month · the workbench never re-runs either engine

Core Capabilities of 4-Way Reconciliation

Three screens in one sidebar — Dashboard, Reconciliation View and Follow-ups — plus an Overview reached from the toolbar, each mapped to the records it reads and writes, on the match results the platform's own engines produce.

1

Two Engines, One Grid

Reads the vendor-side result from Integration Center (sent file versus invoice, scenarios from exact match to plan, amount and date mismatch, tolerance from configuration) and the payroll-side result from BR ReVerge (expected versus collected), merged per tax year, month and carrier.

2

The Seven-Section Row

Enrollment, Payroll, their reconciliation, the expected result, the vendor invoice, its reconciliation, and the invoice-versus-payroll difference — filtered by year, month, carrier, plan, status and search, labelled Matched or Variance with the absolute amount.

3

Resolutions by Source

The row's origin is detected, not chosen; vendor-side rows offer vendor correction, our correction, credit memo and accepted as is; payroll-side rows add direct billing, pay distribution and payroll correction; imputed income is resolved separately; the decision is written on the source record.

4

Follow-ups with an SLA

Tracked cases linked to reconciliation rows, with system impacts, a note thread, a status history and an SLA set by priority — three, five or seven days — shown in module, active and resolved-mismatch lanes.

5

Clarification Packages

Selected mismatches — from follow-ups first, then from resolved rows — generated as a PDF, Excel or CSV for the carrier or payroll contact, with the request metadata stored beside the document.

6

Dashboard & Overview

A year picker with summary KPIs computed from the year's rows, carrier distribution, invoice periods, the follow-ups list, a self-insured table and a summary; the Overview route or modal gives carrier and period totals for the current filter.

Three Days in 4-Way Reconciliation

The workbench is worked in three recognisable sequences — the month-end read, the variance decided on its source, and the carrier query packaged and tracked. Each starts where the engines left off and ends with a record someone can reopen.

Before day 1 · Upstream The engines run Integration Center: the vendor file is sent, the invoice is loaded, the matching engine runs scenarios A–J against the configured tolerance. BR ReVerge: the retro run is locked, transmitted, and the collected cumulatives are received and compared with the expected lines. Both write their results. Nothing here is done in the workbench.
Day 1 · Month-end read Year, month, carrier Open the Reconciliation View on the tax year → narrow to the month and carrier → the grid is built and buffered → read the Matched rows for confidence and the Variance rows by absolute amount → double-click the totals row to expand all seven sections → open the Overview for carrier and period totals → add notes on rows that need context.
Day 2 · Decide on the source Resolve, by side Select a Variance row → Resolve → the modal shows the methods for the side the row came from → a wrong carrier tier becomes a vendor correction; an uncollected deduction becomes a payroll correction or a direct-billing case; a rounding difference is accepted as is with a reason → method, outcome and notes are written on the source record → the row appears in the resolved-mismatches lane.
Day 3 · Package and track Follow up externally Select the rows the carrier must answer → create a follow-up with priority, impacts and notes; the SLA clock starts (3, 5 or 7 days) → generate a clarification package as PDF, Excel or CSV; the request is recorded → status moves New → In progress → Waiting external → once the carrier credits or corrects, record the resolution and close the case.

Sequences from the workbench's working flow · the dashboard's year KPIs, carrier distribution, invoice periods, follow-ups and self-insured table are live; trend charts on the dashboard are not marketed here.

Two-Way Spreadsheet Checks vs. 4-Way Reconciliation

Most reconciliation compares one pair of sources in a workbook and leaves the decision in an email. Here is what changes when all four sides sit on one row and every decision is a record.

Moment Two-way spreadsheet check BR 4-Way Reconciliation
What is compared Enrollment against the carrier bill, or payroll against the bill — one pair at a time. Four sides on one row — expected, collected, sent and billed — with both engine verdicts and the invoice-versus-payroll gap.
Who does the matching The analyst, with lookups, at month end. Integration Center and BR ReVerge, scenario by scenario, against configured tolerances — before the workbench opens.
A variance is found A cell is highlighted; what happened next lives in an email. Resolve on the source record with a method that fits the side — vendor correction, payroll correction, direct billing, credit memo, accepted as is.
The carrier has to answer A forwarded spreadsheet and a reminder in two weeks. A follow-up with an SLA and a clarification package in PDF, Excel or CSV, with the request recorded.
Payroll took the wrong amount Noticed when the employee asks. Section 7 shows it — collected against billed — and the payroll-side methods route it to a correction, a spread or a bill.
Reopening last quarter Find the workbook, find the version, find the person. Pick the year and month — the rows, the resolutions, the notes and the packages are still there.
A second carrier, payroll or HRIS A second workbook with its own logic. The same grid — the engines write one result shape whatever they read.
Athena on the reconciliation desk

Ask Why a Row Says Variance

The Athena administrator assistant answers questions from the same records the grid shows — which side a variance came from, which scenario the vendor match fired, what the payroll side collected, which follow-ups are past their SLA. Athena explains and points to the row or the case; it does not resolve, create follow-ups or generate packages. Those remain administrator actions on their own screens.

  • Explain a row — the seven sections in plain language, and which engine produced each verdict
  • Read the month — matched and variance counts, absolute variance by carrier, the largest open rows
  • Watch the SLA — follow-ups due today, waiting on a carrier, past due
  • Suggest the side — whether a variance reads as a vendor-side or payroll-side problem, from the two verdicts on the row
  • Never resolves — Resolve, Follow-up and Package stay with people
Meet Athena
Athena BR Reconcile · September 2026 · BCBS
Why is employee 40217 a variance? Payroll looks right.
AthenaPayroll is right. Sections 1 to 3 agree: enrollment expected $345.38 for EE+Spouse and payroll collected $345.38, so BR ReVerge marked the payroll side Matched. The variance is on the vendor side: Integration Center matched the sent file against the invoice and found an amount mismatch — the carrier billed $402.10, the EE+Family tier. Section 7 shows the $56.72 gap between what payroll took and what the carrier charged.
ReferenceVendor-side result · scenario: plan/amount mismatch · tolerance $0.01 · sent tier EE+Spouse 09/01 · invoiced tier EE+Family
Open the row Show the sent file line Why am I seeing this?
Which follow-ups are past their SLA?
AthenaTwo. FU-0897, a high-priority payroll follow-up created 09/17, was due 09/20 and is still Partial; FU-0901, low priority, created 09/12, was due 09/19 and is in Review. FU-0912 for the 22 terminated members is Waiting external and due 09/25, so it is inside its three-day window. Closing or updating a case is done on the Follow-ups page — I can take you there.
Ask Athena about this month…

What 4-Way Reconciliation Changes

All four sides on one line

Expected, collected, sent and billed for one member and month — the timing difference between payroll and carrier stops looking like an error.

Matching and deciding kept apart

The engines match; the workbench decides. An auditor can read the verdict and the decision as two records with two authors.

A method for every side

Vendor-side and payroll-side variances get the methods that fit them, and a direct-billing or pay-distribution outcome hands off to the module that executes it.

A clock on every carrier question

A follow-up has a priority, an SLA, an owner and a status history — the carrier query cannot quietly age in an inbox.

Evidence in the carrier's format

A clarification package is the selected mismatches as PDF, Excel or CSV, with the request on file — the same rows the administrator resolved.

Last quarter is a filter, not a search

Every month's rows, resolutions, notes, follow-ups and packages stay under the tax year they belong to.

Enterprise Governance for Reconciliation

4-Way Reconciliation is built for organizations with many carriers, several payrolls and more than one HRIS. The engines run under their own operators, the workbench is read-and-decide, and every decision, note, case and package is a record under the tax year it belongs to — so the same controls hold at any scale.

  • Separation of duties — Integration Center and BR ReVerge operators produce the matches; benefits operations decides and follows up; the carrier contact receives a package, never a login
  • Decisions on the source — a resolution is written to the vendor-side or payroll-side record with method, outcome and notes; the match itself is never edited
  • Module-level permissions — Dashboard, Reconciliation View, Follow-ups and Overview are each gated by the platform's role model
  • Evidence kept in place — row notes, follow-up threads and status histories, generated packages and their request records stay with the month
Where the payroll side comes from: BR ReVerge

Ready to reconcile all four sides at once?

Bring one month of one carrier — the file you sent, the invoice that came back, and the payroll register — to a demo. We will show the two engines' verdicts on the same row, resolve a vendor-side and a payroll-side variance, open a follow-up and generate the clarification package — on the screens your team would use.

Four sides per row Resolutions on the source record Follow-ups with SLA PDF · Excel · CSV packages Any HRIS · any 3rd-party payroll

4-Way Reconciliation FAQs

4-Way Reconciliation – Four Sides, One Row, One Decision

Turn month-end reconciliation from a two-way spreadsheet into a workbench that reads both engines, records every decision on its source, and tracks every carrier question to an SLA.