Why Triangle Reconciliation Begins With Definitions
A triangle total is an aggregation of claim information under specified rules. It will agree with a claim-system extract only when both calculations use the same valuation date, origin-period assignment, coverage scope, and financial measure. A difference is therefore a signal to check the definitions and filters—not a reason to insert an unexplained adjustment.
A triangle cell usually summarizes claims belonging to one origin period at one development age. For a cumulative paid triangle, the cell contains paid amounts accumulated through the cell’s valuation date. For an incurred triangle, it contains paid amounts plus case outstanding amounts at that date. The source extract may instead show transactions, current claim balances, or values from a different snapshot. Those values cannot be compared directly until the bases match.
A useful reconciliation states the comparison explicitly. For example: “Accident year 2024, 12 months, as of December 31, 2024; coverage X; incurred loss; claims assigned to accident year by date of loss.” This is much more informative than “the 2024 total.” Earlier material on assigning claims with multiple date fields and keeping coverage and loss bases consistent provides important background: the reconciliation must use those established definitions rather than quietly substituting new ones.
What Must Match
Before summing source records, identify the dimensions that define the target. A practical checklist is:
- Origin period: State the period and the field used to assign a claim to it, such as accident year based on date of loss.
- Valuation date: Use the same snapshot date as the triangle. A balance shown in a later extract may include payments or reserve changes that were not known at the triangle valuation.
- Development age: Use the same period end and age convention as the cell. For example, an accident-year row at 12 months is valued at the end of the first development year under that convention.
- Coverage and population: Match the included coverages and claim population. A cell for one coverage should not be compared with a source total containing additional coverages.
- Financial measure: Compare paid with paid, incurred with incurred, and the same loss or expense basis. Incurred is not simply another name for paid.
- Amount treatment: Apply the triangle’s rules for currency, sign, and any specified adjustments consistently to the source values.
These conditions distinguish a meaningful residual from a comparison of unlike quantities. For instance, if a triangle contains incurred loss at December 31 but the source report shows paid loss at January 31, a difference is expected even if both reports are otherwise accurate.
From Claim Records to a Cell
Suppose the claim system provides one row per claim with paid-to-date and case outstanding amounts at a particular valuation. For an incurred cell, first determine which claims meet the cell’s inclusion rules, calculate each eligible claim’s incurred amount, and then add those amounts. The same steps apply to a paid cell, except that only paid amounts are summed.
The aggregation works because addition is preserved when the same records and amounts are grouped in two different ways. If \(I\) is the set of claims included in a cell, and \(x_k(V)\) is the claim amount on the chosen basis at \(V\), then the cell total is \(\sum_{k\in I}x_k(V)\). A source-system query that selects exactly \(I\) and sums exactly \(x_k(V)\) must produce the same total. A mismatch means at least one of those sets or amount definitions differs, or a calculation has been made incorrectly.
Here \(I(i,j,V)\) is the set of records satisfying the cell’s origin, development-age, valuation, and scope rules. This identity is a reconciliation principle, not a way to infer missing records: the source sum and triangle value agree only when the underlying definitions and data are aligned.
Worked Example: Reconciling an Incurred Cell to a Claim Snapshot
A hypothetical insurer is checking the accident-year 2024, 12-month incurred cell for coverage X, valued at December 31, 2024. The agreed origin rule assigns claims by date of loss. A claim-system snapshot at that date contains the following records:
| Claim | Date of loss | Coverage | Paid | Case outstanding |
|---|---|---|---|---|
| A | March 12, 2024 | X | $8,000 | $2,000 |
| B | November 4, 2024 | X | $5,000 | $0 |
| C | December 20, 2023 | X | $4,000 | $1,000 |
| D | July 8, 2024 | Y | $3,000 | $2,000 |
Method. Rebuild the cell from the claim snapshot using accident year, coverage, valuation date, and incurred-loss basis.
Step 1: Apply the origin rule. Claims A, B, and D have 2024 dates of loss. Claim C has a 2023 date of loss, so it does not belong in accident year 2024.
Step 2: Apply the coverage scope. Claim D is coverage Y, while the target cell is coverage X. Exclude D. Claims A and B satisfy both the origin and coverage rules.
Step 3: Calculate incurred by claim. Claim A is $8,000 + $2,000 = $10,000. Claim B is $5,000 + $0 = $5,000.
Step 4: Sum the eligible incurred amounts. The source total is $10,000 + $5,000 = $15,000. The triangle cell should therefore be $15,000 if it uses the stated definitions and valuation.
Check and mistake avoided. The result is internally consistent: eligible paid totals $13,000, eligible case outstanding totals $2,000, and $13,000 + $2,000 = $15,000. A common mistake is to include claim D because its date of loss falls in 2024. That would produce $20,000, but it would compare the coverage-X cell with an all-coverage total.
Reconcile at the Same Valuation, Not Just the Same Origin
A claim’s value is time-dependent. Paid amounts accumulate as payments are made, and case outstanding amounts can be revised. Thus, a claim summary prepared after the triangle’s valuation date may not reproduce the triangle, even if it contains the same claims and coverage. For a valid comparison, the paid and outstanding amounts must both be as of the target valuation date.
For a cumulative triangle row, each development age represents a different valuation of the same origin period. A reconciliation of the 12-month cell uses the 12-month snapshot; a reconciliation of the 24-month cell uses the 24-month snapshot. Those cell values are not separate pieces of an origin-period total to be added together. The later cumulative value already includes amounts recognized in the earlier value.
Worked Example: Reconciling Two Cumulative Ages in One Origin Row
For a hypothetical accident-year 2023 portfolio, the incurred triangle shows $28,000 at 12 months and $43,000 at 24 months. Claim-level snapshots are available at the corresponding valuation dates:
| Claim | 12-month paid | 12-month case | 24-month paid | 24-month case |
|---|---|---|---|---|
| A | $10,000 | $4,000 | $12,000 | $4,000 |
| B | $6,000 | $2,000 | $7,000 | $3,000 |
| C | $3,000 | $3,000 | $8,000 | $9,000 |
Method. Calculate incurred separately at each valuation, then sum across claims.
Step 1: Calculate the 12-month incurred amounts. Claim A is $10,000 + $4,000 = $14,000; claim B is $6,000 + $2,000 = $8,000; and claim C is $3,000 + $3,000 = $6,000.
Step 2: Sum the 12-month amounts. The source total is $14,000 + $8,000 + $6,000 = $28,000. This agrees with the 12-month triangle cell.
Step 3: Calculate the 24-month incurred amounts. Claim A is $12,000 + $4,000 = $16,000; claim B is $7,000 + $3,000 = $10,000; and claim C is $8,000 + $9,000 = $17,000.
Step 4: Sum the 24-month amounts. The source total is $16,000 + $10,000 + $17,000 = $43,000. This agrees with the 24-month cell.
Check and mistake avoided. Both cell totals match their own valuation-date snapshots. A common mistake is to add the cumulative cells and report $28,000 + $43,000 = $71,000 as the origin-period total. That double counts amounts carried from the first age into the second; the 24-month cumulative total is $43,000, not $71,000.
Cell Totals and Origin-Period Totals Have Different Scope
A selected cell can be narrower than an origin-period total. For example, a cell may be restricted to one coverage, while an origin-period total may include every coverage in the triangle’s defined portfolio. Before comparing totals, state whether “origin-period total” means a particular cell total, an all-coverage total at a specified valuation, or some other aggregation.
When the total is the sum of several mutually exclusive coverage groups, a useful bridge shows each group separately. It should also show the measure and valuation used for every amount. The groups must cover the intended scope without overlapping; otherwise the bridge either omits amounts or counts them more than once.
Worked Example: Bridging a Coverage Cell to an Origin-Period Total
At December 31, 2025, a hypothetical triangle reports accident-year 2024 incurred loss for coverage X of $49,000. The insurer also wants to reconcile the all-coverage origin-period total. At the same valuation, the claim extract has the following eligible totals:
| Coverage | Paid | Case outstanding |
|---|---|---|
| X | $36,000 | $13,000 |
| Y | $4,000 | $2,000 |
Method. First reconcile the coverage-X cell on incurred basis; then add the other included coverage to form the all-coverage origin total.
Step 1: Reconcile coverage X. Its paid amount plus case outstanding is $36,000 + $13,000 = $49,000. This matches the coverage-X triangle cell.
Step 2: Calculate coverage Y incurred. Its incurred amount is $4,000 + $2,000 = $6,000.
Step 3: Form the all-coverage total. Add the non-overlapping coverage amounts: $49,000 + $6,000 = $55,000. Equivalently, total paid is $36,000 + $4,000 = $40,000, total case outstanding is $13,000 + $2,000 = $15,000, and total incurred is $40,000 + $15,000 = $55,000.
Check and mistake avoided. The all-coverage total exceeds the coverage-X cell by $6,000, exactly the coverage-Y incurred amount. Comparing $49,000 directly with $55,000 without recognizing the different scopes would incorrectly suggest a $6,000 error.
Use a Reconciliation Bridge to Explain Differences
A reconciliation should make its steps visible. A compact bridge can show the source population, the financial measure, and the exclusions or additions needed to reach the triangle scope. For example:
Record origin period, development age, valuation date, coverage scope, and paid or incurred basis.
Use claim values as of the target valuation and identify the amount fields being summed.
Filter source records using the target origin assignment and coverage and population definitions.
For incurred, add paid and case outstanding at the claim level, then sum eligible claims; for paid, sum eligible paid amounts.
Show the source sum, triangle value, and residual. If they differ, review whether the date, scope, or measure actually matches before changing a value.
The residual can be written as triangle amount minus source amount, provided the sign convention is stated. A zero residual confirms arithmetic agreement under the chosen definitions, but it does not by itself establish that every underlying record is correct. Conversely, a nonzero residual does not identify its cause automatically. The reconciliation is useful because it makes the comparison precise enough to investigate.
Common Reconciliation Traps
- Using a current balance for a historical valuation. A current claim snapshot can include later payments or reserve changes. Compare values from the triangle’s valuation date.
- Mixing paid and incurred. Incurred includes case outstanding as well as paid. Add the two only when the target is incurred on that basis.
- Changing scope mid-comparison. A coverage-specific cell and an all-coverage extract are different quantities, even when they share an origin period.
- Adding cumulative ages. Each cumulative age is a total through its own valuation date. Use the relevant age’s value rather than summing ages in the same row.
- Forgetting to state the origin rule. A period label alone does not specify how claims are assigned. Use the agreed date field and rule consistently.
Careful reconciliation is a basic control on the construction and use of loss-development triangles. It supports a traceable link from summarized cells back to source amounts and helps distinguish a genuine calculation discrepancy from a mismatch in valuation, scope, or measure. The procedure is aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus.
Check Your Understanding
For each problem, state the matching basis and calculate the requested reconciliation.
- A hypothetical accident-year 2025, 12-month coverage-A incurred cell is valued at December 31, 2025. Two eligible claims have paid and case outstanding amounts of $2,400 and $600, and $1,100 and $900. A third claim from coverage B has paid of $3,000 and case outstanding of $500. What is the coverage-A cell total? (Answer: $5,000 incurred.)
- A claim has paid-to-date of $7,200 and case outstanding of $1,800 at June 30. At December 31, paid is $8,500 and case outstanding is $1,000. What incurred amount should be compared with a triangle cell valued at December 31? (Answer: $9,500.)
- At a specified valuation, an origin-period incurred total includes coverage A and B. Coverage A has paid of $18,000 and case outstanding of $7,000; coverage B has paid of $2,500 and case outstanding of $1,500. What is the all-coverage total, and how much greater is it than the coverage-A cell? (Answer: $29,000 total, which is $4,000 greater than coverage A.)
- A cumulative incurred row has a 12-month cell of $32,000 and a 24-month cell of $47,000. The 24-month source snapshot sums to $30,000 paid and $17,000 case outstanding. Does it reconcile, and what is the error in adding the two triangle cells as the row total? (Answer: Yes, $30,000 + $17,000 = $47,000; adding the cells gives $79,000 and double counts the earlier cumulative amount.)
- A target is an accident-year 2024, coverage C, paid cell valued at December 31, 2024. An extract for that exact scope and date shows paid amounts of $6,400 and $2,100, plus case outstanding amounts of $900 and $700. What is the paid-cell total, and what incurred total would result if the case amounts were also included? (Answer: Paid-cell total $8,500; incurred total $10,100.)