Claim Counts by Claim Status

Why Claim Status Requires a Clear Counting Rule

A claim record can contain several payments, reserve changes, notes, and status updates. Those records describe the history of a claim; they are not necessarily separate claims. If an analyst counts transaction rows as claims, a claim with many updates may be counted several times while a claim with one update is counted once. The result can be misleading even when every transaction amount is recorded correctly.

A second distinction is between claims reported during a time period and claims in a particular status on a valuation date. The first is a count of reporting events, one for each claim first reported in the period. The second is a snapshot of the status of claims as of a specified date. A claim reported during the period may be open or closed by the valuation date. A claim reported earlier may still be open at that date.

The definitions below use a hypothetical insurer's claim records. Operational status labels can vary, so an analysis should use the insurer's stated coding rules and a consistent valuation date. The concepts are aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus.

Definitions: A reported claim is a claim for which the insurer has received notice and established a claim record. A claim is open at a valuation date if it remains subject to adjustment, such as further investigation, payment, or reserve review. A claim is closed at that date if the insurer has concluded its adjustment under its operating rules and records it as closed. A reopened claim is a previously closed claim whose adjustment resumes, for example because new information or a further payment is required. Reopening changes the status of the existing claim; it does not, by itself, create a new reported claim.

Period Counts and Status Snapshots

A period count of claims reported answers, “How many claims were first reported during this interval?” It is based on the claim's initial report date. By contrast, a status count answers, “How many claims are open or closed as of this date?” It is based on the latest applicable status as of the valuation date. The two counts refer to different measurements and need not have the same population.

For a defined group of claims already reported by a valuation date, each claim should have one current status at that date. In a simple open/closed classification, every such claim is assigned to exactly one of those categories. A claim that was closed and later reopened is counted according to its current status—not once as closed and again as reopened. If an insurer uses additional statuses, such as pending or disputed, the classification rules must say how those claims are handled rather than silently forcing them into open or closed.

This can be expressed with an indicator for each claim. Let \(C\) be the set of distinct claims in the population being classified at valuation date \(t\). Let \(I_j(t)=1\) if claim \(j\) is open at \(t\), and \(I_j(t)=0\) otherwise. If every claim is classified as either open or closed, then the open and closed counts are:

N_{\mathrm{open}}(t)=\sum_{j\in C} I_j(t), \qquad N_{\mathrm{closed}}(t)=\sum_{j\in C}\bigl(1-I_j(t)\bigr).

Each claim contributes one to exactly one count, so \(N_{\mathrm{open}}(t)+N_{\mathrm{closed}}(t)=|C|\). This identity holds because the indicator and its complement sum to one for every claim. It does not imply that the number of claims reported during a period equals the number of claims in the status snapshot: the snapshot can include claims reported before the period.

The same logic explains why a transaction count is not a claim count. If several transaction rows belong to one claim, the rows may be useful for summarizing payments and status changes, but the claim contributes only once to a count of distinct claims. The key is to define the counting unit before aggregating.

Worked Example: Reported Claims and a June Status Snapshot

A hypothetical insurer reviews claims first reported from January 1 through June 30. Its claim-level register shows the following history: A was reported in January and is open; B was reported in January and is closed; C was reported in February, closed in April, and reopened in June; D was reported in March and is open; E was reported in April and is closed; F was reported in May and is open; G was reported in June and is closed; and H was reported in June and is open. Find the number reported during the interval and the open and closed counts at June 30.

Method and counting unit. Count distinct claims by initial report date for the period total, then classify each of those claims once using its latest status at June 30. This avoids counting C twice just because it has both a closure and a reopening in its history.

Step 1: Count claims reported during the interval. The register lists A through H, each with an initial report date from January through June. Thus the period report count is \(8\) claims.

Step 2: Classify by status at June 30. The open claims are A, C, D, F, and H, giving \(5\). C is open because its June reopening is later than its April closure. The closed claims are B, E, and G, giving \(3\).

Step 3: Check the total. The status counts add to \(5+3=8\), equal to the eight claims in this period's reported-claim population. The result is \(8\) reported, \(5\) open, and \(3\) closed at June 30.

Common mistake avoided: Counting C once as closed and once as reopened would produce nine status assignments from eight claims. Reopening replaces the prior status in the June 30 snapshot; it does not add a claim.

Reading a Claim's History Without Counting Each Update

Claim systems often store a sequence of transactions or status events. To determine a count, first identify the distinct claim being represented, then apply the question's time rule. For a count of claims reported during a period, use the initial report date. For a count of open or closed claims at a valuation date, use the status in effect at that date. Payments or reserve changes do not change either rule by themselves.

Define the question.
Decide whether the requested measure is claims first reported during an interval or claims in a status at a specified date.

Use the claim as the unit.
Group the history belonging to each claim. Do not treat each payment, reserve change, or status event as a new claim.

Apply the relevant date.
Use the first report date for a period report count. For a status snapshot, use the latest status effective by the valuation date.

Reconcile the result.
Check that each claim in a two-category open/closed snapshot appears once, and only once, in the status totals.

Worked Example: Several Transactions and a Reopened Claim

In a hypothetical equipment-insurance portfolio, claim K is reported on February 8, receives two payments and a case-reserve update, and is closed on September 20. Claim L is reported on March 12, receives one payment, is closed on July 5, then is reopened on November 18 after additional repair information arrives; a further payment and reserve update follow. Claim M is reported on November 30 and has two payments recorded by December 31, but remains open. Find the number reported during the year and the open and closed counts at December 31.

Method and counting unit. Use one claim per claim record, not one claim per transaction. Determine the period count from first report dates and the year-end status from each claim's latest status by December 31.

Step 1: Count reports. K, L, and M each have an initial report date during the year. Therefore, the reported-claim count is \(3\). K's two payments and L's later transactions do not create additional reports.

Step 2: Determine year-end status. K is closed by September 20 and has no later reopening stated, so K is closed at December 31. L's November 18 reopening is later than its July 5 closure, so L is open at year-end. M is stated to remain open, so M is also open.

Step 3: Count and check. The open claims are L and M, for \(2\). The closed claim is K, for \(1\). The check is \(2+1=3\), matching the three distinct claims reported in the year and included in this example's year-end population.

Common mistake avoided: Counting L as both closed and open because both events occurred during the year confuses a history of status changes with a snapshot. At December 31, its current status is open.

When the Reported Population and Status Population Differ

A reconciliation is not always expected to make period reports equal a status total. For example, a year-end inventory can contain claims reported in earlier years, while claims first reported this year can be in the inventory only if they remain within the population definition. Before comparing totals, check that both measures use the same claim scope and time basis.

A useful reconciliation labels each number explicitly: “claims first reported during the year,” “claims open at year-end,” and “claims closed at year-end.” The first is a flow over an interval; the latter two are counts at a point in time. A claim closed during the year and reopened before year-end is included in the open snapshot, while a claim that was reported in an earlier year can also be open in that snapshot.

Worked Example: Existing Claims Plus New Reports

At January 1, a hypothetical insurer has three distinct claims: P is open, while Q and R are closed. During the year, P closes and stays closed; Q reopens and remains open; R stays closed. The insurer also receives two new claims, S and T. S is reported and closed before December 31, while T is reported and remains open. Find the number of claims reported during the year and the open and closed counts at year-end for all claims in this described population.

Method and counting unit. The reported count includes only claims with first report dates during the year. The year-end snapshot includes both the three claims already present at January 1 and the two new claims.

Step 1: Count claims reported this year. Only S and T are new reports, so the reported count is \(2\). P, Q, and R were already present at January 1 and are not counted as new reports this year.

Step 2: Classify all five claims at year-end. P is closed; Q is open after reopening; R is closed; S is closed; and T is open. Therefore, the open claims are Q and T, giving \(2\), while P, R, and S are closed, giving \(3\).

Step 3: Check the snapshot population. There are five distinct claims, and \(2+3=5\). The year-end status total is five, not two: the number reported during the year excludes the three claims already present at the start.

Common mistake avoided: Using the period report count as the denominator for the year-end status split would omit P, Q, and R. The two measures have different populations in this example.

Common Counting Errors

Equating transactions with claims. A single claim can have several payments and reserve changes. Count the claim once when the requested unit is claims.
Counting a reopening as a new report. A reopening is a status event on an existing claim. Keep the initial report date unless a question explicitly defines a different measure.
Mixing periods and valuation dates. “Reported during the year” is a period measure; “open at year-end” is a snapshot. State which date rule is being used.
Double-counting a status history. If a claim closes and later reopens, use the status in effect at the valuation date for a snapshot, rather than adding both historical labels.
Comparing mismatched populations. A year-end status inventory may include claims reported in earlier periods. Reconcile the scope before expecting status totals to equal new reports.

Key takeaway: A claim count needs a defined unit, population, and time basis. Count each distinct claim once; use its initial report date for a period report count, and its current status at the valuation date for an open/closed snapshot.

Check Your Understanding

For each problem, state the requested count using the specified period or valuation date.

A hypothetical insurer records claims J, K, and L as first reported during April. J is open on April 30, K was closed and then reopened on April 27, and L is closed. How many claims were reported in April, and how many are open and closed on April 30? (Answer: 3 reported; 2 open and 1 closed.)
Claim A has four payment transactions and one reserve update, all under the same claim record. Claim B has one payment transaction. Both were reported during the quarter. How many claims were reported in the quarter? (Answer: 2 claims.)
At June 30, claims C and D are open, and claim E is closed. E reopens on July 3. What are the open and closed counts for these three claims at June 30 and July 3? (Answer: June 30: 2 open and 1 closed; July 3: 3 open and 0 closed.)
At January 1, a hypothetical book has claims F and G, both open. During the year, H and I are first reported; H closes and I remains open. F closes, and G remains open. Find the number reported during the year and the year-end open and closed counts for all claims. (Answer: 2 reported; 2 open and 2 closed at year-end.)
Three claims are first reported during a hypothetical quarter. By quarter-end, claim M has closed and reopened, claim N remains closed, and claim O remains open. A transaction extract contains 11 rows across these claims. How many claims were reported, and what are the quarter-end open and closed counts? (Answer: 3 reported; 2 open and 1 closed.)

What You'll Learn