Aggregating Claim Transactions Into Cells

From Claim Records to Triangle Cells

A loss development triangle is built from claim-level records, but its entries are aggregated amounts. The aggregation must preserve the quantity being measured: a paid triangle records payments, while an incurred triangle records paid-to-date amounts plus outstanding case reserves at the valuation date. Combining these measures incorrectly can distort the development pattern before any development factors are calculated.

For each claim, the data include an origin period, payment transactions with their amounts and dates, and—when constructing incurred values—a case reserve observed at a specified valuation date. The origin period and development age determine the cell to which an amount belongs. Development age is measured from the start of the origin period to the relevant transaction date or valuation date, using the intervals selected for the triangle. For example, an annual triangle may group transactions into successive 12-month development intervals.

Definition: For origin period $o$ and development interval $a$, let $P_{o,a}$ be the aggregate paid amount from payment transactions assigned to that cell. Let $C_{o,a}$ be cumulative paid through the end of that interval, $R_{o,a}$ the aggregate case reserve at the valuation date for claims in that cell, and $I_{o,a}$ the incurred amount at that valuation date. Thus, an incurred cell is constructed from cumulative paid and the reserve snapshot, not by adding reserve changes as though they were payments.

A cell's meaning depends on the loss measure and valuation date being used. A payment is a transaction: it contributes to the interval in which it is paid. A case reserve is a point-in-time estimate of the unpaid amount on a claim. It is not another payment, and it should not be assigned to a payment interval. For an incurred triangle, the reserve is measured as of the cell's valuation date and combined with paid-to-date amounts.

Aggregating Paid Transactions

First assign each payment transaction to its origin period and development interval. Then sum the transaction amounts in each cell to get incremental paid. To obtain cumulative paid at a given age, add the incremental amounts from the first development interval through that age. This is a running total, not a second aggregation of all claim records without regard to payment timing.

C_{o,a_k}=\sum_{j=1}^{k} P_{o,a_j}

Here $a_1,\ldots,a_k$ are the successive development intervals through age $a_k$. The formula applies when the intervals are successive and each transaction is assigned once to the interval in which it occurred. It does not turn an incremental cell into a cumulative cell by multiplying it by the number of intervals; the actual amounts paid in each earlier interval are needed.

Worked Example: Building Annual Paid Cells From Transactions

A hypothetical insurer is preparing an annual paid triangle for claims from accident year 2025. The first valuation is December 31, 2025 (12 months of development), and the second is December 31, 2026 (24 months). The claim payment records are: Claim A, $900 on April 10, 2025 and $300 on February 20, 2026; Claim B, $700 on November 1, 2025; Claim C, $500 on July 15, 2026. Calculate the incremental paid amount at each age and cumulative paid at 24 months.

Method. Assign each payment to the annual interval in which it occurs. The first interval runs through December 31, 2025; the second covers January 1 through December 31, 2026.

At 12 months. Claim A contributes $900 and Claim B contributes $700. Claim C has no payment in this interval. Therefore, incremental paid is $900+700=\$1{,}600$, and cumulative paid is also $1,600.

At 24 months. The second-interval payments are $300 for Claim A and $500 for Claim C, so incremental paid is $300+500=\$800$. Cumulative paid through 24 months is $1{,}600+800=\$2{,}400$.

Check and common mistake. Summing all listed transactions gives $900+300+700+500=\$2{,}400$, matching the 24-month cumulative amount. A common mistake is to place Claim A's $300 payment in the first interval because Claim A first had a payment there. Transactions are assigned by their own payment dates, not by the date of the claim's first payment.

Adding Case Reserves for Incurred Cells

An incurred cell combines cumulative paid through the valuation date with case reserves at that date. For each claim assigned to the cell, take its total paid to date and its outstanding case reserve as of the valuation date. Sum the two claim-level quantities across the eligible claims. Claims with no payments can still contribute an incurred amount through a positive case reserve; a closed claim with no remaining reserve contributes its paid amount only.

I_{o,a}=C_{o,a}+R_{o,a}

The identity follows directly from the claim-level definition. If claim $i$ has cumulative paid $p_i$ and case reserve $r_i$ at the valuation date, its incurred amount is $p_i+r_i$. Summing over claims $i$ assigned to the same origin-age cell gives:

\sum_i (p_i+r_i)=\sum_i p_i+\sum_i r_i=C_{o,a}+R_{o,a}=I_{o,a}.

This derivation relies on paid and reserve amounts referring to the same claims, loss measure, and valuation date. If the paid total is cumulative through one date but reserves are taken from a different date, the sum does not represent incurred at a single valuation. The formula also does not mean that reserves should be added repeatedly to cumulative paid as the claim develops; each incurred cell uses the reserve snapshot at its own valuation date.

Worked Example: Calculating an Incurred Cell From Claim Snapshots

For a hypothetical accident-year 2026 portfolio at the 12-month valuation, four claims have the following records: Claim A has $1,200 paid to date and an $800 case reserve; Claim B has $900 paid and is closed with no reserve; Claim C has no payments and a $1,500 case reserve; Claim D has $400 paid and a $600 case reserve. Calculate the aggregate paid, case reserve, and incurred cell.

Method. Sum paid-to-date amounts to obtain cumulative paid, sum the valuation-date case reserves, and add those two totals.

Cumulative paid. The claim-level payments total $1{,}200+900+0+400=\$2{,}500$.

Case reserves. The reserves total $800+0+1{,}500+600=\$2{,}900$. Claim C is included even though it has no payment because it has an outstanding reserve at the valuation date.

Incurred cell. Incurred is $2{,}500+2{,}900=\$5{,}400$. As a claim-level check, the amounts are $2{,}000+900+1{,}500+1{,}000=\$5{,}400$.

Check and common mistake. The cell agrees whether calculated from aggregate paid and reserves or from the four claim-level incurred amounts. A common mistake is to count Claim C as zero because it has no paid transaction. That would omit its $1,500 case reserve and understate incurred.

Putting Origin Periods and Development Ages Together

A triangle usually contains several origin-period rows observed to different development ages at a common valuation date. The same aggregation rules apply to each cell, but the available ages differ with the origin period. For each cell, determine which claims belong to its origin period, total the payments in the relevant development intervals, and—if the triangle is incurred—add the applicable case reserves at the valuation date.

Define the cell.
Identify its origin period, development age, valuation date, and loss measure before summing records.

Aggregate payments.
Assign each payment to its interval and sum the transactions for incremental paid. Add prior incremental cells when cumulative paid is required.

Include reserve snapshots only for incurred.
For an incurred cell, sum case reserves at the cell's valuation date and add them to cumulative paid through that date.

Check the cell.
Confirm that its totals can be traced to the claim-level payment and reserve records used for that origin period and age.

Worked Example: Building Two Incurred Cells at One Valuation

A hypothetical insurer values its annual accident-year triangle at December 31, 2025. For accident year 2024, payments were $1,000 in the first development year and $500 and $1,200 in the second development year. At the valuation date, the 2024 claims have case reserves of $300, $0, and $900. For accident year 2025, payments in its first development year were $600, $400, and $700; valuation-date case reserves are $500, $0, $300, and $800. Calculate the observed incurred cells for 2024 at 24 months and 2025 at 12 months.

Method. Build each origin-age cell separately. For 2024, accumulate both years of payments; for 2025, use its first-year payments. Then add the reserves at the common valuation date for the claims in each origin period.

Accident year 2024, age 24 months. The first-year incremental paid amount is $1,000. The second-year incremental amount is $500+1{,}200=\$1{,}700$. Cumulative paid at 24 months is $1{,}000+1{,}700=\$2{,}700$. Reserves total $300+0+900=\$1{,}200$. Therefore, incurred is $2{,}700+1{,}200=\$3{,}900$.

Accident year 2025, age 12 months. Incremental and cumulative paid are both $600+400+700=\$1{,}700$. Reserves total $500+0+300+800=\$1{,}600$. Therefore, incurred is $1{,}700+1{,}600=\$3{,}300$.

Check and common mistake. The older origin period has two years of paid development available, while the newer one has only one. A common mistake is to add the 2025 payments to the 2024 row because both appear in the same calendar-year valuation. Origin period determines the row; valuation date determines how much development is observed. The resulting incurred cells are $3,900 for 2024 at 24 months and $3,300 for 2025 at 12 months.

Preserving the Loss Measure

Aggregation is not merely a matter of adding every monetary field in a claim extract. The cell must represent one defined measure. A paid triangle uses payment transactions and their cumulative totals. An incurred triangle uses those cumulative payments plus case reserves at the valuation date. A reserve field should not be added to a paid cell, and a payment transaction should not be treated as a case-reserve snapshot.

The distinction matters because payment timing and reserve estimates have different roles. Payments represent amounts already paid; case reserves represent estimated outstanding amounts. Incurred values can therefore change as payments occur or reserve estimates change. Paid values change when payments are made. The aggregation procedure should retain that distinction rather than forcing both measures into a single total.

Cell measure	What is summed	How age-to-age values are formed
Incremental paid	Payment transactions assigned to one development interval	Each interval is its own amount
Cumulative paid	Payments from the first interval through the stated age	Sum incremental paid through that age
Incurred	Cumulative paid plus case reserves at the valuation date	Recalculate using the reserve snapshot at each valuation

This cell-level discipline is aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus. It also provides a useful check before later development analysis: a mathematically correct factor cannot repair cells built from inconsistent claim amounts or valuation dates.

Common Aggregation Traps

Summing reserves across valuation dates. A case reserve is a snapshot at a particular date. For incurred at that date, use that date's reserve total; do not add earlier snapshots to the current one.
Using incremental paid as if it were cumulative paid. An incurred cell requires paid-to-date, so include prior development intervals as well as the current one.
Dropping claims with no payments. Such claims can have positive case reserves and therefore positive incurred amounts.
Grouping by payment date alone. The transaction date determines development age, but the claim's origin period determines its triangle row.
Combining measures without labeling them. State whether a cell is incremental paid, cumulative paid, or incurred before interpreting its value.

Key takeaway: For each origin-age cell, aggregate payment transactions by their development interval. Cumulative paid is the sum of incremental paid through the valuation age; incurred is cumulative paid plus case reserves measured at that valuation date.

Check Your Understanding

Work each problem by assigning records to the stated origin period and age before summing.

A hypothetical accident-year 2027 claim portfolio has payments of $250 and $350 in the first annual interval and $500 in the second. What are incremental paid in each interval and cumulative paid at 24 months? (Answer: Incremental paid is $600 at 12 months and $500 at 24 months; cumulative paid at 24 months is $1,100.)
At a valuation date, claims in one origin-age cell have cumulative paid of $2,200 and case reserves of $1,300. What is incurred, and should a closed claim with no reserve be omitted from the paid total? (Answer: Incurred is $3,500; no, include its paid-to-date amount even though its reserve is zero.)
A claim has payments of $400 in the first development interval and $250 in the second. Its case reserve at the second valuation is $150. Calculate incremental paid in interval two, cumulative paid at 24 months, and incurred at 24 months. (Answer: Incremental paid is $250; cumulative paid is $650; incurred is $800.)
For one origin period, first-year payments total $900 and second-year payments total $600. At the 24-month valuation, case reserves total $500. Calculate cumulative paid and incurred at 24 months. (Answer: Cumulative paid is $1,500; incurred is $2,000.)
At one valuation, an origin period has two claims: Claim A has $700 paid and a $200 reserve; Claim B has $0 paid and a $600 reserve. Calculate aggregate cumulative paid, aggregate reserve, and incurred. (Answer: Cumulative paid is $700; aggregate reserve is $800; incurred is $1,500.)

What You'll Learn