- Before
- “I didn't make that pick. The man who did left last June.” Each PBC request means days on the shared drive rebuilding someone else's reasoning.
- Now
- Opens the cell and the memo paragraph together on one click, sees whether the pick has gone stale, and starts from a cited draft.
One PBC request, from open to signed
Thornmere Mutual's year-end 2025 selections are in force. Morrow Abbott LLP asks about the 1.12 general liability tail, held since year-end 2023, whose author left in June 2025. Here is what happens next, screen by screen, in the working solution.
- 01Monday morning
The key picks on one tree, and the request on top
Inés Albarrán · Director, Commercial Lines ReservingInés opens the assumption lineage: 18 key picks of 1,284 across general liability, commercial auto, workers' comp and multi-peril — 13 supported, 3 stale, 2 without support. PBC-17 from Morrow Abbott is open, due Friday 16 October, four days away.
“Provide support for the 1.12 tail factor (120 months to ultimate) on commercial general liability, occurrence, held since year-end 2023 — including why the company's own indication was not used, and whether it remains appropriate given 2026 data.”
- 02One click
The cell and the paragraph, side by side
Inés Albarrán · Director, Commercial Lines ReservingShe clicks the Tail 120–ult leaf. Cell F42 of the Tail tab opens beside §4.3 of the year-end 2023 memo, page 23 of 41: an inverse power fit of 1.094 weighted one-third, the industry tail of 1.138 weighted two-thirds, 1.123 rounded to 1.12. The lineage runs on to the data cut RX-23Q3-CGL, the Reserve Committee of 21 February 2024 and peer review MV-24-07. The pick was made by Teodor Maksimović, ACAS, who left in June 2025.
Memo §4.3: “the last three diagonals show case reserve strengthening on 2014–2016 construction defect claims that the fit does not yet reflect.”
- 03Re-run
The pick's own method, on the June triangles
Freshness watcherThe leaf is marked stale. The freshness watcher re-ran the workbook's own formula and weights on RX-26Q2-CGL, loaded 14 July: the company fit is now 1.131 and the 2025 industry tail 1.152, so the same method indicates 1.145 — 2.0% above the 1.123 the pick was made on. Its own cells sit beside the original ones.
“Re-run on RX-26Q2-CGL: 1.145 indicated · +$4.7M IBNR at 1.145 · the pick is unchanged”
- 04Seven year-ends
How the tail got here
Inés Albarrán · Director, Commercial Lines ReservingThe history shows the pick against the same method on each year's data. 1.09 at year-end 2019 on the company fit only; 1.10 in 2021, when the industry tail first got one-third weight; 1.12 in 2023, with two-thirds. Then held at year-end 2024 and 2025 — “no change; see YE2023 memo §4.3” and “consistent with the prior year” — while the indication rose to 1.134 and 1.139.
- 053 min 52 s
A drafted answer, every sentence cited
Support researcher and citation checkerShe presses “Draft the answer”. The support researcher searches 2,316 documents across seven year-ends, reads 31 passages from 11 of them, follows the lineage, reads how the pick was held and checks freshness. It writes 9 sentences, one claim each, under the auditor's three questions. The citation checker reads every sentence back: 9 of 9 supported, none removed, figures quoted rather than recalculated.
“Disclosed in the answer. The tail was held at year-end 2024 and 2025 without a re-run, and the June 2026 data moves the indication by +2.0%. The answer says so rather than leave the auditor to find it.”
- 06Saved
A support note, with the original pages attached
Inés Albarrán · Director, Commercial Lines ReservingSaved as the support note for PBC-17: the selection, why the company's indication was not used alone, review and governance, and whether it remains appropriate. Seven attachments carry the original pages and cells — the year-end 2023 memo, the Tail tab, the committee minutes, MV-24-07, the year-end 2024 and 2025 memo extracts, the prior audit answer and the June re-run. It waits for the appointed actuary.
- 07Before it leaves
The appointed actuary reads the paragraph, not a summary
Marguerite Ilunga · Appointed ActuaryMarguerite reads each sentence with its passage, then opens the sign-off: 9 sentences, each cited to its source, 7 attachments, and the disclosure that the tail was held without a re-run.
“The note discloses that the tail was held without a re-run and that the June 2026 data indicates 1.145 (+2.0%), with the re-selection on the 5 November committee agenda.”
- 0810:42 · signed
Signed and sent, four days early
Marguerite Ilunga, FCAS, MAAA · Appointed ActuaryShe signs and sends. The note goes to Gideon Farrah at Morrow Abbott LLP with its 7 attachments on Monday 12 October at 10:42 — four days before the due date. The pick itself is unchanged: re-selecting it is a decision for the reserve committee.
- 09Next on the list
The picks an auditor would find first
Gap finderTwo picks have no support, and the auditor has asked about both. The commercial auto AY2025 expected loss ratio of 74.5% was agreed at the Reserve Committee on 19 February 2026, after the memo was issued — the memo still shows 72.0%. The memo behind the workers' comp discount rate of 3.25% refers to a “discount workbook” whose link points to a folder moved in 2025. The gap finder drafts from the minutes for the line's owner to confirm; it never closes a gap itself.
- 10The whole audit
Every request, matched to its pick
Inés Albarrán · Director, Commercial Lines ReservingSeven requests for the year-end 2026 audit planning and the Q3 2026 interim: PBC-17 sent, PBC-18 and PBC-19 flagged as gaps, PBC-15 in progress, two answered, and the state insurance department's triennial exam request with 41 documents already matched.