Worked Reserve Reconciliation Case

Why a Reserve Reconciliation Matters

A change in a claim liability is not, by itself, the amount of incurred loss recognized during a period. Claims may be paid during the period, new claims may occur, and estimates for earlier accident years may change. A reconciliation brings these pieces together and makes the reported incurred amount traceable to the opening and closing liabilities.

The calculations below use a consistent scope: undiscounted loss liabilities, one currency, and the same portfolio and valuation basis at both dates. Unless an example explicitly says otherwise, there are no portfolio transfers, changes in accounting scope, or other adjustments. Expenses are excluded. These assumptions matter because an unexplained change in scope cannot be interpreted as claim development.

Definition: The claim liability at a valuation date is the estimated unpaid amount for the claim costs in the stated scope. Paid claims are amounts paid during the reporting interval. Incurred losses for that interval are the loss amounts recognized for the interval on the same basis as the liability. Positive development on earlier accident years is an increase in their estimated ultimate losses; negative development is a decrease.

The Liability Rollforward

Let $L_0$ be the opening claim liability, $L_1$ the closing claim liability, and $P$ the claims paid between those valuation dates. For a consistent, loss-only rollforward, incurred losses $I$ satisfy:

$$ L_0 + I = P + L_1 $$

The opening liability plus the loss amount recognized during the interval must account for both the cash paid and the unpaid liability remaining at the end. Rearranging gives the working form:

$$ I = P + L_1 - L_0 $$

This identity applies only when the amounts use the same scope and basis. For example, if the opening liability is net of reinsurance but payments and the closing liability are gross, the terms cannot be combined directly. Likewise, changes caused by transfers or accounting adjustments need separate reconciliation lines rather than being silently treated as incurred losses.

Key result: Incurred losses for a period equal paid claims plus the increase in the claim liability. The liability increase can be negative; it does not make the identity invalid.

Separating Current-Year Losses and Prior-Year Development

Suppose the reporting interval includes losses from the current accident year and changes in estimates for earlier accident years. Write $I_{\text{total}}$ for total incurred losses, $I_{\text{current}}$ for incurred losses from the current accident year, and $D_{\text{prior}}$ for development on earlier accident years. With consistent cohort definitions:

I_{\text{total}} = I_{\text{current}} + D_{\text{prior}}

For the earlier accident years taken together, their development can be calculated from their opening reserve, their payments during the interval, and their closing reserve:

D_{\text{prior}} = P_{\text{prior}} + L_{1,\text{prior}} - L_{0,\text{prior}}

This is the same rollforward applied only to the earlier-year claims. The current accident year has no opening liability for its own claims under this setup, so its incurred amount is its paid claims plus its closing unpaid liability:

I_{\text{current}} = P_{\text{current}} + L_{1,\text{current}}

These relationships are useful checks, not competing ways to define the same number. Adding current-year incurred losses and prior-year development should reproduce the total incurred amount from the aggregate liability rollforward.

Fix the scope.
Confirm that opening and closing liabilities, payments, and incurred amounts refer to the same portfolio, loss basis, and gross or net treatment.

Calculate aggregate incurred losses.
Use paid claims plus closing liability minus opening liability.

Calculate earlier-year development.
For earlier accident years, combine their payments and closing liability, then subtract their opening liability.

Infer and check current-year incurred losses.
Subtract prior-year development from aggregate incurred losses, then check against current-year paid claims plus their closing liability.

Worked Example: Aggregate Rollforward With Favorable Prior-Year Development

A hypothetical insurer has an opening loss liability of $2,400 thousand and a closing loss liability of $2,600 thousand. It paid $1,100 thousand in claims during the year. Of those payments, $700 thousand relate to earlier accident years and $400 thousand relate to the current accident year. The closing liability consists of $1,400 thousand for earlier accident years and $1,200 thousand for the current accident year. Calculate total incurred losses, prior-year development, and current-year incurred losses. Identify the sign trap.

Method: apply the liability rollforward to the total and to the earlier-year claims. First calculate aggregate incurred losses:

I_{\text{total}} = 1{,}100 + 2{,}600 - 2{,}400 = 1{,}300

All amounts are in thousands of dollars. Earlier-year development is their payments plus their closing liability minus their opening liability. Since the entire opening liability of $2,400 thousand relates to earlier accident years:

D_{\text{prior}} = 700 + 1{,}400 - 2{,}400 = -300

The negative result is favorable development: the estimated unpaid amount for earlier years has declined after accounting for payments. Current-year incurred losses are therefore:

I_{\text{current}} = I_{\text{total}} - D_{\text{prior}} = 1{,}300 - (-300) = 1{,}600

Check by current-year claims: current-year incurred losses equal current-year payments plus the current-year closing liability:

$$ 400 + 1{,}200 = 1{,}600 $$

The cohort closing liabilities also add to the stated total: $1{,}400 + 1{,}200 = 2{,}600$. The complete check is $1{,}600 + (-300) = 1{,}300$, matching aggregate incurred losses.

Common mistake avoided: Treating the $-$300$ thousand development as $+$300$ thousand when inferring current-year incurred losses would give $1{,}300-300=$1{,}000$ thousand instead of $1,600 thousand, an understatement of $600 thousand. Total incurred losses remain $1,300 thousand under the aggregate rollforward.

Why the Cohort Calculation Works

The development formula for earlier accident years follows directly from the rollforward, rather than from an assumption that the reserve change alone is development. For those claims, opening liability plus incurred amount equals payments plus closing liability. The incurred amount for the earlier-year claims is precisely the change in their estimated losses recognized during the interval. Rearranging yields:

D_{\text{prior}} = P_{\text{prior}} + L_{1,\text{prior}} - L_{0,\text{prior}}

Payments must be included because they reduce the unpaid liability without representing favorable development. For instance, if the opening liability is $1,000 and $200 is paid while the closing liability is still $800, then development is $200+800-1{,}000=0$, not a favorable $200. The estimate has not changed; $200 of the opening liability has simply been paid.

Worked Example: Reconciling Development by Accident Year

A hypothetical commercial property portfolio has two earlier accident years, A and B. For year A, the opening liability is $1,200 thousand, payments are $300 thousand, and the closing liability is $1,000 thousand. For year B, the corresponding amounts are $800 thousand, $500 thousand, and $600 thousand. Current-year claims have $250 thousand paid and a $950 thousand closing liability. Reconcile total incurred losses to prior-year development and current-year incurred losses.

Method: calculate development separately for each earlier accident year. For A:

D_A = 300 + 1{,}000 - 1{,}200 = 100

For B:

$$ D_B = 500 + 600 - 800 = 300 $$

Total prior-year development is $100+300=400$ thousand, which is unfavorable. Current-year incurred losses are current-year payments plus the current-year closing liability:

I_{\text{current}} = 250 + 950 = 1{,}200

Thus, total incurred losses are $400+1{,}200=1{,}600$ thousand. Now check the aggregate rollforward. Opening liabilities total $1{,}200+800=2{,}000$ thousand. Payments total $300+500+250=1{,}050$ thousand. Closing liabilities total $1{,}000+600+950=2{,}550$ thousand. Therefore:

I_{\text{total}} = 1{,}050 + 2{,}550 - 2{,}000 = 1{,}600

The cohort and aggregate calculations agree. The common mistake is to call the earlier-year reserve decrease $2{,}000-1{,}600=400$ thousand development without considering payments. In this example the result happens to match the development only because earlier-year payments total $800 thousand while the earlier-year closing liability is $1,600 thousand; their net change is $-$400$ thousand, the opposite of the $400 thousand development. The rollforward calculation, not the reserve decrease alone, determines the sign and amount.

Keeping Gross and Net Reconciliations Consistent

A claim liability may be reported gross of reinsurance, while a separate ceded recoverable is recognized as an asset. To calculate a net incurred amount, the gross loss and ceded recovery pieces must each be rolled forward consistently. In the example below, ceded incurred losses mean ceded cash recoveries plus the increase in the ceded recoverable. Net incurred losses equal gross incurred losses less ceded incurred losses.

Worked Example: Reconciling Gross and Net Incurred Losses

A hypothetical insurer reports, in millions of dollars, an opening gross loss liability of $2.40 and a closing gross loss liability of $2.70. Gross claim payments are $0.80. Its ceded recoverable is $0.30 at opening and $0.38 at closing, and it receives $0.12 of ceded cash recoveries during the period. Calculate gross, ceded, and net incurred losses.

Method: roll forward the gross liability and ceded recoverable separately. Gross incurred losses are:

I_{\text{gross}} = 0.80 + 2.70 - 2.40 = 1.10

Ceded incurred losses are the ceded cash recoveries plus the change in the recoverable:

I_{\text{ceded}} = 0.12 + 0.38 - 0.30 = 0.20

Therefore net incurred losses are:

I_{\text{net}} = 1.10 - 0.20 = 0.90

Check using net amounts directly. Net payments are $0.80-0.12=0.68$. Opening net liability is $2.40-0.30=2.10$, and closing net liability is $2.70-0.38=2.32$. Thus:

I_{\text{net}} = 0.68 + 2.32 - 2.10 = 0.90

The two routes agree. A common error is to subtract ceded cash recoveries from gross payments but omit the change in the ceded recoverable. That would produce $0.68+2.70-2.40=0.98$ million, overstating net incurred losses by $0.08 million. The omitted $0.08 million is the increase from the $0.30 million opening recoverable to the $0.38 million closing recoverable.

Reporting Checks and Common Traps

A reconciliation is most useful when its components are clearly labeled. In a reporting schedule, distinguish the total incurred amount from its components, and label development as favorable or unfavorable as well as showing its signed amount. A positive prior-year development amount increases total incurred losses; a negative amount reduces them.

Do not equate reserve movement with development. Payments reduce liabilities, so they must be included when calculating incurred losses or development.
Do not reverse the sign when solving for a component. From $I_{\text{total}}=I_{\text{current}}+D_{\text{prior}}$, current-year incurred losses are $I_{\text{total}}-D_{\text{prior}}$. A negative development is subtracted as a negative number.
Do not mix gross and net values. Apply the same treatment to paid claims and liabilities, or separately reconcile the ceded component.
Do not hide unexplained changes in the rollforward. Transfers, scope changes, and other accounting adjustments should be identified separately when present.

The central check is that the cohort components add to the aggregate amount. When they do not, investigate signs, payment allocations, valuation dates, and scope before interpreting the result as a change in claim experience.

Check Your Understanding

For each hypothetical case, use a consistent loss-liability basis and check the arithmetic before interpreting the result.

An insurer has an opening liability of $1.80 million, pays $0.65 million in claims, and has a closing liability of $2.05 million. What is total incurred loss for the period? (Answer: $0.90 million.)
For earlier accident years, an insurer begins with a $1.10 million liability, pays $0.42 million, and ends with a $0.94 million liability. If total incurred losses are $0.70 million, what are prior-year development and current-year incurred losses? (Answer: prior-year development is $0.26 million; current-year incurred losses are $0.44 million.)
Total paid claims are $0.90 million, the opening liability is $1.50 million, and the closing liability is $1.70 million. Prior-year development is $-$0.15$ million. What are total and current-year incurred losses? (Answer: total incurred losses are $1.10 million; current-year incurred losses are $1.25 million.)
Gross opening and closing liabilities are $2.40 million and $2.70 million, and gross payments are $0.80 million. A ceded recoverable rises from $0.30 million to $0.38 million, with $0.12 million of ceded cash recoveries. What are gross and net incurred losses? (Answer: gross incurred losses are $1.10 million; net incurred losses are $0.90 million.)
Earlier accident year A has opening liability $0.70 million, payments $0.16 million, and closing liability $0.61 million. Earlier year B has opening liability $0.50 million, payments $0.21 million, and closing liability $0.33 million. Current-year claims have payments $0.19 million and a closing liability of $0.76 million. What are total prior-year development, current-year incurred losses, and aggregate incurred losses? (Answer: prior-year development is $0.11 million; current-year incurred losses are $0.95 million; aggregate incurred losses are $1.06 million.)

What You'll Learn