Premium and claims reconciliation to the general ledger, with every break explained on day one of close
Breaks found and explained on day one of close, each tied to its source records.
See one case, screen by screen ↓It is proving that the premium, claims and reserve balances in your policy admin, billing, claims, reinsurance and reserving systems agree with the general ledger at each close — and explaining every difference. Premium & Claims Reconciliation has agents tie each subledger to its ledger account, match the lines, cluster what does not match by cause and draft the fixes for the controller.
How to choose AI solutions for insurance →
Updated
At every close, written and unearned premium, premiums receivable, paid losses and LAE, case reserves, salvage and subrogation and ceded recoverables come out of the policy admin, billing, claims, reinsurance and reserving systems — and they rarely agree with the general ledger. The subledgers post line by line on effective date; the ledger takes daily summaries plus manual journals.
So a top-side reserve, a duplicated accrual reversal and a new cost code mapped to the wrong account all look the same: tens of thousands of unmatched lines. Controllers rebuild the same spreadsheets every month, sort the lines by hand and find on day four or five that a seven-figure break was three journals. What nobody had time to explain is carried forward, or written off late.
Estimated split for tying the insurance subledgers at a quarter close, by spreadsheet and with the solution.
Six specialist agents load, tie, match, cluster by cause, trace the journals and draft the entries; the financial controller approves and signs.
Larkspur Mutual Insurance Group, Q3 2026 close, business day 1 of 6. Case loss reserves are out by $2,131,418.62. Here is what happens next, screen by screen, in the working solution.
The extracts landed at 06:00. By 07:40 six agents have loaded 2,941,207 lines, proved the control totals and tied ten insurance subledger accounts to the September ledger: 4 tie to the cent, 1 is explained, 5 are out of balance — $2,625,521.69 out, gross. The biggest is 2105 Case loss reserves: subledger $412,806,540.12, ledger $414,937,958.74.
“40,318 unmatched lines of 1,288,412 · each dot ≈ 100 lines”
Teodora clusters the break by cause. 38,977 lines are timing — reserve changes entered after the 18:00 claims batch on Sep 30, in the ledger on the Oct 1 batch, paired claim by claim — and net to $0.00. 1,338 are mapping on retired cost code CA-HIRED and also net to $0.00. Three lines are manual journals, and they carry the whole −$2,131,418.62.
No cluster is explained without a source record.
JE-2609-0418 is the Q3 top-side case reserve strengthening for Commercial Auto, $1,750,000.00, approved by the reserve committee on Sep 24 — keep it as a documented reconciling item. JE-2609-0433 reverses the August settlement accrual on the Hollis Freight Lines claim a second time: JE-2609-0391 already did it on Sep 3. JE-2609-0447 booked the Dunmore Logistics subrogation recoverable, $30,581.38, against case reserves instead of 1270.
“The whole −$2,131,418.62 is three manual journals.”
The break file for 2105 shows the agents' run on this tie from the 06:00 extract check to the drafted entries, and each journal with who posted it, who approved it and its support. The reserve committee minutes of Sep 24 sit next to the top-side; the two journal lines on claim CA-26-004871 sit side by side, same claim, same amount, same accounts.
AJE-Q3-07 reverses the duplicate: debit 2105-CA, credit 5105-CA, $412,000.00. AJE-Q3-08 reclasses the Dunmore recoverable from 2105-CA to 1270-CA, $30,581.38. Each entry shows its effect on every tie and its approval chain — drafted by the agent, reviewed by Ines Calloway, approved by the controller. Five entries are waiting in all, $839,581.95.
“Nothing posts until you approve; the CFO co-approves $1M or more.”
One dialog holds the decision: keep JE-2609-0418, post AJE-Q3-07 and AJE-Q3-08 on the next ledger batch at 09:15. Each entry is under $1,000,000, so no CFO co-approval is needed, and the dialog confirms she is not the preparer. She signs with her password and the meaning of the signature: “Approved as financial controller”.
Case reserves move from −$2,131,418.62 out of balance to −$1,750,000.00 explained — the Q3 top-side, documented with the minutes. Salvage and subrogation now ties. The board reads 5 tied, 2 explained, 3 out of balance.
“Explained. One documented item, −$1,750,000.00, the Q3 top-side. Ready to sign.”
On the Breaks list every cluster says what it is and what resolves it. 214 Harrowgate Agency Partners lockbox payments arrived without policy numbers and sit in 2290 Unapplied cash (AJE-Q3-10). 61 independent adjuster invoices on new cost code IA-FEE-26 map to 5300 instead of 5210 (AJE-Q3-09). 18 marine quota share lines billed in GBP were revalued at different rates (AJE-Q3-11). Three homeowners cancellations after the 20:00 cut-off clear on the Oct 1 batch.
31 reconciling items were carried into the Q3 close. Two open items are over 60 days and flagged to escalate: the Harrowgate July sweep in unapplied cash, $18,440.00, and cash in transit on the property catastrophe treaty, $96,300.00. Premiums receivable over 90 days — $1,842,116.30 across 312 accounts — is shown as non-admitted on the statutory statement.
The carry-forward watcher never writes an item off.
The audit pack holds the summary, all ten ties, the reconciling items, the adjusting entries with who approved them, and an evidence index of 13 sources — from claims extract CLM-RSV-20260930 to the reserve committee minutes and the GBP/USD rate table. It is prepared for internal audit and the Model Audit Rule file, and exports to PDF.
The same quarter close, seen by the five people who carry it — what their day one looked like, and what it looks like now.
Six specialist agents load, tie, match, cluster by cause, trace the journals and draft the entries; the financial controller approves and signs.
Loads the policy, billing, claims, reinsurance and reserving extracts and the trial balance at 06:00 on business day 1, and proves record counts and control totals against each source.
Ties each subledger to its ledger account, then matches lines by claim, policy or treaty, amount and effective date — one-to-one, one-to-many and many-to-one.
Clusters the unmatched lines of each tie by cause — timing, mapping, manual journal, currency, missing feed — and nets each cluster.
Reads each manual journal in a break — header, preparer, approver and support such as memos, minutes and claim notes — and flags duplicates, wrong accounts and journals without support.
Drafts adjusting entries with debit and credit lines, a description and the support for each, shows the effect on every tie and routes them for approval.
Ages every reconciling item carried from earlier closes, escalates items over 60 days to the owner and controller, and reports premiums receivable over 90 days as non-admitted.
Approves entries and signs; CFO co-approves $1M or more. The agents propose; a named person decides.
The controller and preparers can ask in plain words — or tell it what to change. Every answer cites the source record.
Why is case reserves out by $2.1M?
Three manual journals — nothing in the 40,318 lines. 38,977 lines are timing, after the 18:00 claims batch, and 1,338 are mapping on retired code CA-HIRED; both net to $0.00. The $2,131,418.62 is the Q3 top-side of $1,750,000.00 approved on Sep 24, a duplicate reversal of $412,000.00, and a $30,581.38 subrogation recoverable booked against the wrong account.
What will still be open after today’s entries?
If you approve the five drafted entries, three items stay, all explained: the $1,750,000.00 Commercial Auto top-side, documented with the minutes; and 3 unearned premium cancellations, $52,300.00, and 9 returned payments, $14,221.12 — both clear on the Oct 1 batch.
Map IA-FEE-26 to 5210 from October
Done as a proposal. Claims accounting policy CAP-7 puts independent adjuster fees in 5210. IA-FEE-26 → 5210 Adjusting and other expense is added to mapping version 15, effective Oct 1, for your approval in Settings. The 61 September invoices are still corrected by AJE-Q3-09.
Show receivables over 90 days
$1,842,116.30 across 312 accounts is over 90 days past due and is non-admitted for the statutory statement — down from $2,014,880.12 at June 30.
12 screens from the working solution, on its sample data. Pick one to see it large.
What the agents may treat as tied, when the books cut off, and who approves — all settings.
| Setting | Default | Choose from |
|---|---|---|
| Tie tolerance per account | $1,000 or 0.001%, whichever is lower | Any amount and percentage |
| Line-match window | ± 2 days on effective date | Any window |
| Cluster explained only with | A source record for every line or journal | Your evidence rule |
| Cut-offs on the last day | Claims batch 18:00 · policy admin 20:00 · billing 22:00 | Per system |
| Controller approves entries under | $1,000,000 — Teodora Lind | Any limit, any named approver |
| CFO co-approves from | $1,000,000 — Grace Whitlock | Any limit, any named approver |
| Escalate carried items after | 60 days | Any number of days |
| Close calendar | 6 business days · extracts at 06:00 on day 1 · pre-close tie-out nightly at 23:30, last 5 days of the month | Per quarter |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
“demo” = seen in the working solution, on its sample close data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (Peakflo, insurance month-end close — 7–12 business days, claim reserve reconciliation 2–3 days by hand; Trintech, insurance industry page — 25–30% auto-match with one-to-one matching at one carrier). People, companies, claims and figures named on this page are fictional — characters and sample data in the working solution.
It is proving that the premium, claims and reserve balances in your policy admin, billing, claims, reinsurance and reserving systems agree with the general ledger at each close — and explaining every difference. Premium & Claims Reconciliation has agents tie each subledger to its ledger account, match the lines, cluster what does not match by cause and draft the fixes for the controller.
The cause finder groups the unmatched lines into timing, mapping, manual journal and currency clusters and nets each one. In the working solution a −$2,131,418.62 break across 40,318 lines comes down to three manual journals, because the timing and mapping clusters net to $0.00. The journal tracer then reads each journal and its support.
No. The entry drafter drafts adjusting entries with their support and their effect on each tie. Nothing posts until a person approves; approved entries go on your next ledger batch.
The controller approves entries under $1,000,000, and the CFO co-approves entries of $1,000,000 or more. Preparer and approver are never the same person, and the approval is signed with the meaning of the signature. The limits and approvers are settings.
The cause finder still finds them, but as a manual journal with the reserve committee minutes beside it. The controller can keep one as a documented reconciling item; the tie then reads explained, not out of balance, and the carry-forward watcher ages it at each close.
An audit pack with the summary, every tie, the reconciling items, the adjusting entries and who approved them, an evidence index linking each item to its source record, and the signatures. It is prepared for internal audit and your Model Audit Rule file, and exports to PDF.
Yes. Tie tolerance, line-match window, the evidence a cluster needs, the cut-off time of each system, approval limits and approvers, the carried-item escalation, the close calendar and the cost code mapping table are all settings.
The Agentic Solution Engine builds and deploys it from your requirements and documents — your account map, close calendar, approval limits and a sample of past reconciliations — and it goes live once every quality gate has passed. We will walk you through it on your own extracts first.
Adverse development seen in weeks, not at the next quarterly review.
1-min demoActuarial Assumption ManagementAn auditor's question answered in minutes, with the original support attached.
1-min demoStatutory, GAAP & IFRS 17 ReconciliationOne explained walk from statutory to GAAP or LDTI to IFRS 17 results.
1-min demoWe’ll run Premium & Claims Reconciliation on a sample of your own subledger extracts and trial balance.