Claim Transactions and Claim-Level Totals

From Transaction Rows to Claim-Level Measures

A claim system records events: an indemnity payment is issued, a recovery is received, or an adjuster changes the case reserve. The resulting ledger may have several rows for one claim, and those rows do not each represent a separate claim or a complete claim total. For ratemaking analysis, the transactions must be classified, signed consistently, and aggregated by claim before paid and incurred measures are calculated.

The calculation also needs a common valuation date, meaning a specified date through which payments and reserve information are included. This tutorial treats all amounts as loss amounts, excludes loss adjustment expenses, and assumes the claim identifiers have already been checked for duplicate or inconsistent records. The aim is to calculate totals at claim level, not to assign claims to an experience period.

Definition: For one claim at a stated valuation date, gross paid loss is the total of valid loss payment disbursements through that date, before recoveries. Net paid loss is gross paid loss less applicable recoveries. Ending case reserve is the case-reserve balance at the valuation date. Incurred loss is net paid loss plus ending case reserve, provided paid loss and reserve use the same gross or net basis.

For a ledger, use a consistent sign and classification convention. Record a valid payment disbursement as a positive gross payment. Record a payment reversal or void as a negative adjustment to gross paid. Record a recovery, such as salvage or subrogation, separately and subtract it to obtain net paid. Record reserve increases as positive changes and reserve releases as negative changes. A recovery is not the same as a payment reversal: a recovery offsets a valid payment, while a reversal corrects a payment transaction that should not remain in gross paid.

Classify Each Transaction Before Summing

A claim-level total depends on what each row means, not just on whether its amount is positive or negative. A reliable calculation therefore starts by identifying the transaction type and claim identifier. For reserve changes, it also requires a starting reserve balance. Summing reserve changes alone gives the movement in the reserve, not the ending reserve.

Group by claim.
Use the claim identifier to collect all transactions for that claim. Do not treat each transaction row as a separate claim.

Separate transaction categories.
Identify payment disbursements, payment reversals, recoveries, and reserve changes. Do not combine them into one undifferentiated sum.

Calculate paid amounts and ending reserve.
Net valid payment disbursements and reversals to obtain gross paid; subtract recoveries for net paid. Add signed reserve changes to the opening case reserve.

Calculate and reconcile incurred.
Add net paid and ending case reserve on the same basis. Check that claim-level amounts sum to the corresponding portfolio totals.

In symbols, let $P_0$ be cumulative net paid at the beginning of an interval, let $Q$ be net payments during the interval (payment disbursements and reversals, less recoveries), and let $R_0$ be the opening case reserve. If the signed reserve changes during the interval sum to $\Delta R$, then:

P_1=P_0+Q,\qquad R_1=R_0+\Delta R,\qquad I_1=P_1+R_1.

Here $P_1$, $R_1$, and $I_1$ are, respectively, net paid, ending case reserve, and incurred loss at the end of the interval. This makes the distinction between a reserve balance and a reserve movement explicit: $R_1$ is not generally equal to $\Delta R$.

Worked Example: Aggregating Payments, Recoveries, and Reserve Changes

A hypothetical insurer is preparing claim-level loss measures for two claims at a common valuation date. All amounts are in dollars. The opening case reserves are the balances before the listed reserve changes.

Claim	Transaction	Amount
A	Payment disbursements	8,400 and 2,100
A	Salvage recovery	700
A	Opening reserve; reserve changes	3,000; +1,200 and −500
B	Payment disbursement	5,000
B	Subrogation recovery	1,500
B	Opening reserve; reserve change	2,400; −900

Claim A paid amounts. Gross paid is $8{,}400+2{,}100=\$10{,}500$. Net paid is $\$10{,}500-\$700=\$9{,}800$.

Claim A ending reserve. The signed reserve changes total $1{,}200-500=\$700$. Therefore the ending reserve is $\$3{,}000+\$700=\$3{,}700$.

Claim A incurred. Net paid plus ending reserve is $\$9{,}800+\$3{,}700=\$13{,}500$.

Claim B paid amounts. Gross paid is $\$5{,}000$. Net paid is $\$5{,}000-\$1{,}500=\$3{,}500$.

Claim B ending reserve. The reserve release is a negative change, so the ending reserve is $\$2{,}400-\$900=\$1{,}500$.

Claim B incurred. Net paid plus ending reserve is $\$3{,}500+\$1{,}500=\$5{,}000$.

Portfolio check. Gross paid is $\$10{,}500+\$5{,}000=\$15{,}500$, recoveries total $\$700+\$1{,}500=\$2{,}200$, and net paid is $\$13{,}300$. Ending reserves total $\$3{,}700+\$1{,}500=\$5{,}200$. Thus aggregate incurred is $\$13{,}300+\$5{,}200=\$18{,}500$, equal to $\$13{,}500+\$5{,}000$, the sum of the claim-level incurred amounts. The method avoids treating recoveries as reserve changes or treating reserve changes as ending balances.

Why Paid Plus Reserve Gives Incurred Loss

The paid-plus-case-reserve measure combines what has already been paid, net of recoveries, with the amount currently estimated to remain unpaid on the claim. Its reconciliation across two valuation dates follows directly from the definitions.

Derivation: At the beginning of an interval, incurred is $I_0=P_0+R_0$. During the interval, net paid changes by $Q$, so $P_1=P_0+Q$. The reserve balance changes by $\Delta R$, so $R_1=R_0+\Delta R$. Therefore,

I_1-I_0=(P_1+R_1)-(P_0+R_0) =(P_0+Q+R_0+\Delta R)-(P_0+R_0) =Q+\Delta R.

Thus, the change in incurred loss over an interval is the net paid activity during that interval plus the change in case reserve, if the same claim scope and gross-or-net basis are used at both valuations. The identity is a reconciliation, not a reason to add all historical paid transactions to a current incurred value that already includes cumulative paid.

The formula needs consistent treatment. For example, if paid amounts are net of salvage and subrogation, the reserve must also be on a net basis for the sum to represent net incurred loss. A gross reserve should not be combined with net paid without an explicit adjustment. Likewise, all amounts in the calculation must refer to the same claim and valuation date; mixing reserve balances from different dates breaks the reconciliation.

Worked Example: Distinguishing a Payment Reversal from a Recovery

A hypothetical claim has the following transactions through the valuation date: a valid payment of $\$14{,}000$, a payment of $\$2{,}500$ that was later fully reversed as a duplicate, and a $\$2{,}000$ salvage recovery. The opening case reserve is $\$4{,}000$; reserve changes are $+\$1{,}500$ and $-\$700$. Calculate gross paid, net paid, ending reserve, and incurred.

Gross paid. The duplicate payment and its reversal cancel. Gross paid is $\$14{,}000+\$2{,}500-\$2{,}500=\$14{,}000$.

Net paid. Subtract the recovery from valid gross paid: $\$14{,}000-\$2{,}000=\$12{,}000$.

Ending reserve. The reserve changes net to $\$1{,}500-\$700=\$800$. Add that movement to the opening balance: $\$4{,}000+\$800=\$4{,}800$.

Incurred. Net paid plus ending reserve is $\$12{,}000+\$4{,}800=\$16{,}800$.

A common mistake is to subtract the $\$2{,}500$ reversal as if it were a recovery and then also subtract the $\$2{,}000$ salvage recovery from a gross-paid total that already excludes the reversed duplicate. The proper calculation nets the payment and its reversal within gross paid, then subtracts the actual recovery once. The check is $\$14{,}000$ gross paid less $\$2{,}000$ recovery, giving $\$12{,}000$ net paid.

Multiple Claims and Portfolio Reconciliation

Once each claim has a paid amount and ending reserve, portfolio totals can be formed by summing the claim-level measures. Claim-level aggregation is useful because it preserves the ability to inspect unusual balances, find missing transactions, and confirm that each claim contributes once. A claim with no payment can still have incurred loss if it has an outstanding case reserve.

Worked Example: Including a Reserve-Only Claim

For three hypothetical claims at one valuation date, the ledger gives:

Claim	Gross paid	Recovery	Opening reserve	Reserve changes
A	$6,000	$500	$1,000	+$2,000
B	$0	$0	$7,000	−$4,000
C	$9,000	$1,000	$2,000	−$1,000

Claim A. Net paid is $\$6{,}000-\$500=\$5{,}500$. Ending reserve is $\$1{,}000+\$2{,}000=\$3{,}000$. Incurred is $\$5{,}500+\$3{,}000=\$8{,}500$.

Claim B. Net paid is $\$0$. Ending reserve is $\$7{,}000-\$4{,}000=\$3{,}000$, so incurred is $\$3{,}000$. No payment does not mean no incurred loss.

Claim C. Net paid is $\$9{,}000-\$1{,}000=\$8{,}000$. Ending reserve is $\$2{,}000-\$1{,}000=\$1{,}000$. Incurred is $\$8{,}000+\$1{,}000=\$9{,}000$.

Portfolio check. Gross paid totals $\$15{,}000$, recoveries total $\$1{,}500$, and net paid totals $\$13{,}500$. Ending reserves total $\$7{,}000$. Aggregate incurred is $\$13{,}500+\$7{,}000=\$20{,}500$, which agrees with $\$8{,}500+\$3{,}000+\$9{,}000=\$20{,}500$. The reserve-only claim is included once, with its reserve contributing to incurred.

Common Errors and Control Checks

Transaction-level calculations are especially vulnerable to errors that leave plausible-looking totals. A useful control is to calculate each claim first and then compare the sum of claim-level amounts with independently aggregated transaction totals. Investigate any disagreement rather than forcing the totals to match.

Counting rows instead of claims. Several payments for one identifier remain one claim, not several claims.
Using reserve movement as the reserve balance. Add signed reserve changes to the opening balance to obtain the ending reserve.
Subtracting recoveries twice. If a reported paid field is already net of recoveries, do not subtract them again.
Confusing a reversal with a recovery. A reversal corrects a payment; a recovery offsets a valid loss payment. Classify each event before applying the sign.
Mixing gross and net amounts. Paid and reserve amounts must use a compatible basis before they are added to calculate incurred.
Mixing valuation dates. A paid amount through one date cannot be reconciled to a reserve balance from another date without accounting for the intervening transactions.

Key takeaway: For each claim, identify valid payments, reversals, recoveries, and reserve changes; calculate net paid and the ending reserve separately; then calculate incurred as net paid plus ending reserve on a consistent basis. Confirm that the claim-level totals reconcile to the portfolio totals.

Check Your Understanding

For each problem, calculate the requested claim-level amount using the stated transaction types and valuation date.

A claim has payment disbursements of $\$3{,}200$ and $\$1{,}800$, a salvage recovery of $\$400$, an opening reserve of $\$2{,}200$, and reserve changes of $+\$600$ and $-\$300$. Find net paid, ending reserve, and incurred. (Answer: net paid $\$4{,}600$; ending reserve $\$2{,}500$; incurred $\$7{,}100$)
A claim has a valid payment of $\$6{,}000$, another payment of $\$2{,}000$ that is fully reversed, and a recovery of $\$1{,}000$. Its opening reserve is $\$3{,}000$, with reserve changes of $-\$800$ and $+\$400$. Find gross paid, net paid, ending reserve, and incurred. (Answer: gross paid $\$6{,}000$; net paid $\$5{,}000$; ending reserve $\$2{,}600$; incurred $\$7{,}600$)
Claim A has gross paid $\$12{,}000$, recovery $\$2{,}000$, opening reserve $\$4{,}000$, and reserve change $-\$1{,}000$. Claim B has gross paid $\$3{,}000$, no recovery, opening reserve $\$2{,}000$, and reserve change $+\$1{,}500$. Find each incurred amount and total portfolio incurred. (Answer: Claim A $\$13{,}000$; Claim B $\$6{,}500$; total $\$19{,}500$)
At the start of an interval, a claim has cumulative net paid of $\$11{,}000$ and case reserve of $\$14{,}000$. During the interval, gross payment disbursements are $\$5{,}000$, recoveries are $\$1{,}000$, and the reserve decreases by $\$3{,}000$. Find ending net paid, ending reserve, ending incurred, and the change in incurred. (Answer: ending net paid $\$15{,}000$; ending reserve $\$11{,}000$; ending incurred $\$26{,}000$; incurred increases by $\$1{,}000$)
A two-claim portfolio has gross paid of $\$20{,}000$, recoveries of $\$2{,}500$, opening reserves of $\$8{,}000$, and total signed reserve changes of $-\$1{,}500$. Calculate portfolio net paid, ending reserves, and incurred. (Answer: net paid $\$17{,}500$; ending reserves $\$6{,}500$; incurred $\$24{,}000$)

What You'll Learn