Benefits numbers that tie to the books

Benefit cost hides inside payroll totals, carrier bills get paid as received, and enrollment status lives in a screenshot from last Tuesday. This module rebuilds benefits on an enrollment snapshot that ties to the ledger.

RuleBenefits money reconciles on two axes: to the ledger through payroll, and to the carrier through the bill. Both, every month.

Neverpay a carrier invoice unreconciled. Terminated workers still being billed is the classic leak, and only a two-sided join finds it.

◆ The pagesone model, three reports, both reconciliations.

Page	What it answers
The benefits star	The model: a daily enrollment fact and the carrier invoice fact it reconciles against.
Benefit cost	Employer cost by department, tying exactly to the ledger account the payroll module proves.
The carrier bill, reconciled	Enrollment against invoice, both directions, with the leakage named per worker.
Open enrollment	The window tracked with statuses that sum to the eligible population, and the chase list.
ACA measurement	Hours measured full-time joined to the coverage offer, with the compliance gap named before the filing.
Plan participation	Take-up with a defensible denominator: tiers, coded waives, and the affordability signal inside the rate.
Dependent audit	The file verified on a cycle; the ineligible eight priced at 1,712.00 a month until removed.
Life event lag	Events clocked occurrence to processed; the late ones tied to the retros and drift they cause.

◆ The tie that anchors the moduleone number, three pages, ledger-proved.

May 2026 employer benefit cost is 359,779.50. That number is already on this site twice: as account 6020 on the payroll-to-ledger reconciliation, split by the same departments, and inside the fully loaded cost the labor cost report trends. The benefit cost page carries the same split, so benefits, payroll, and the ledger agree by construction, and the battery checks it.

◆ The two leaks this module exists formoney out the door, quietly.

Leak	How it is caught
Paying carriers for people who left	The invoice fact joined to enrollment, both directions: a billed worker with no enrollment is a finding, named on the reconciliation.
Deductions that surprise the first payroll	New plan-year elections mapped through the same pre-commit gate as any pay component, so January reconciles instead of surprising, per the payroll mapping page.

Sample values are illustrative, never client data.

Use case

Problem

Benefit cost hides inside payroll totals, carrier bills are paid as received, and enrollment tracking is manual.

What we build

A daily enrollment snapshot and a carrier invoice fact, reconciled to the ledger on one side and the bill on the other.

What you get

Benefits money that ties to the books, leakage named per worker, and an enrollment window tracked with counts that sum.

When did you last reconcile the carrier bill line by line?

We ship both reconciliations, tied to your ledger, in 10 days.

Talk to us

Terms on this page

battery: The automated set of checks, including the crossfoot arithmetic, run on every build of this catalog.
enrollment: A worker’s active election in one plan on one date.
carrier: The insurer who bills for the plan.
premium: The monthly price of coverage, split employer and employee.
leakage: Premiums paid for people no longer enrolled. The classic exit leak.
deduction: The employee share, withheld through payroll.
eligible population: Everyone entitled to enroll in the window.
tie: A check that two independently built totals agree.