UC-390
Reserving Triangle Movement Explainer
Reads the claim movements behind each reserving triangle, attributes the period change to its causes and drafts the actuarial commentary.
TBDBuild Duration
XXXXIndicative ROI
XXXXBuild Cost
XXXXValue
The Challenge
Each quarter the reserving actuary rebuilds by hand the explanation of why the triangles moved. The cause sits in claim-level transactions and handler notes that nobody has time to read.
How It Works
- Reads claim transaction histories, paid and outstanding movements and the reserving triangles.
- Attributes each cell movement to new claims, revaluation, settlement or recovery by cohort.
- Drafts the movement commentary for the reserving committee with the claims behind each figure.
What It Removes
- Manual drill-down into claim transactions each quarter
- Rewriting the same reserve movement narrative by hand
- Reconciling actuarial extracts to the claims ledger
Input Data RequirementsClaim transaction extracts, paid and case reserve movements, reserving triangles, large-loss listings, handler notes, prior actuarial reports
Output FormatDrafted reserve movement commentary per class and cohort, with an attribution table and a drill-down to the claims that moved
“The number is right. Explaining which claims moved it still costs us two weeks of an actuary every quarter.”