Reimbursement Reconciliation By Claim

Why Reconcile at the Claim Level?

In a large-deductible arrangement, an insurer may pay covered claim amounts and then invoice the insured for amounts allocated to the insured under the contract. Payments, recoveries, invoices, credit notes, and remittances can occur at different times and in partial amounts. A total account balance may appear reasonable even when one claim is overbilled and another remains unbilled. Claim-level reconciliation makes those differences visible.

The purpose here is to establish a consistent accounting bridge. It is not to recalculate the deductible allocation method: the applicable contract and the loss-and-expense allocation determine which paid amounts are reimbursable. Reconciliation takes that allocation as an input, traces the amount through billing and cash application, and identifies what remains unexplained or unpaid.

Definition: For claim $i$, the net reimbursable obligation $D_i$ is the cumulative amount the insured is contractually responsible for reimbursing, after applying the contract’s treatment of covered payments, eligible expenses, limits, and allocated recoveries. The net invoiced amount $I_i$ is invoice debits less credit notes. The applied remittance $M_i$ is insured cash specifically assigned to that claim.

All amounts in this tutorial are nominal dollars. No interest, mortality, or probability model is used: the task is an accounting reconciliation, not a present-value or loss-distribution calculation. If a contract uses a different ordering for payments, recoveries, or expenses, apply that contract’s rules before recording $D_i$.

The Claim-Level Reconciliation

The reconciliation compares four amounts: the obligation established by the contract, the amount billed, the cash applied to the claim, and any portion of cash received but not yet assigned. Define the unbilled amount $U_i$, the outstanding invoiced balance $A_i$, and the unpaid net obligation $O_i$ as follows.

U_i = D_i-I_i,\qquad A_i = I_i-M_i,\qquad O_i = D_i-M_i

A positive $U_i$ indicates an obligation not yet invoiced. A negative $U_i$ indicates that net invoices exceed the current contractual obligation. A positive $A_i$ is an unpaid invoice balance; a negative $A_i$ can indicate that applied cash exceeds net invoices. The signed amounts are useful for diagnosing the ledger, but any resulting credit, refund, or offset must follow the contract and billing procedures.

Reconciliation identity: For each claim, $O_i=U_i+A_i$. The unpaid net obligation is the sum of the unbilled amount and the outstanding invoiced balance, including any signed overbilling or overpayment components.

The identity follows directly from the definitions:

$$ U_i+A_i=(D_i-I_i)+(I_i-M_i)=D_i-M_i=O_i $$

The invoiced amount cancels. Thus, whether an obligation has been invoiced changes its presentation, but not the total contractual amount remaining after applied cash. This is a useful control: if the two sides do not agree, a transaction may be missing, duplicated, assigned to the wrong claim, or recorded with the wrong sign.

Build the Ledger in a Controlled Sequence

Establish the contractual obligation.
Start from actual insurer-paid amounts, not reserves or projected ultimate losses. Apply the contract’s reimbursement allocation to paid loss and eligible expense, then apply recoveries using the contract’s allocation rule. Record the resulting cumulative amount as $D_i$.

Net invoices and credit notes.
Sum invoice debits and subtract credit notes attributable to the claim. Keep the underlying transactions visible so that a later credit can be traced to its reason.

Apply remittances to claims.
Use the remittance advice or documented cash-application rule. A cash receipt without a reliable claim assignment is unapplied cash, not a payment to an arbitrarily selected claim.

Classify the remaining balances.
Calculate $U_i$, $A_i$, and $O_i$; identify disputed invoice amounts as a status within the billed balance; and investigate any overbilling, unapplied cash, or unreconciled difference.

A partial insurer payment generally supports only the reimbursement attributable to that payment under the contract; an unpaid reserve is not itself a paid amount to invoice when reimbursement is based on paid claims. Likewise, a partial insured remittance reduces the claim balance only by the amount actually applied to that claim. If the insurer later receives a recovery, do not automatically subtract it from the insured’s obligation: first determine how the contract allocates that recovery.

Worked Reconciliations

Worked Example: One Claim With a Recovery and a Dispute

Scenario. Under a hypothetical contract, the insurer has paid $18,000 of covered loss and $2,000 of eligible claim expense. The contract allocation schedule assigns $9,000 of these payments to the insured’s reimbursable deductible layer. The insurer later receives a $1,000 recovery, and the contract allocates that recovery entirely to the insured’s layer. Net invoices are $6,000, and the insured has remitted $4,500, all applied to this claim. Of the remaining invoice balance, $900 is disputed. Find the net obligation, billed balance, unbilled amount, and unpaid obligation.

Method. First calculate the contractually reimbursable obligation after the allocated recovery; then reconcile invoices and applied cash. All figures are nominal dollars; interest, mortality, and distribution assumptions do not apply.

The obligation is the allocated deductible-layer amount less the recovery allocated to that layer:

D_i=\$9{,}000-\$1{,}000=\$8{,}000

The net invoiced amount is $6,000, and $4,500 has been applied. Therefore:

U_i=\$8{,}000-\$6{,}000=\$2{,}000

A_i=\$6{,}000-\$4{,}500=\$1{,}500

O_i=\$8{,}000-\$4{,}500=\$3{,}500

The control identity checks: $U_i+A_i=\$2{,}000+\$1{,}500=\$3{,}500=O_i$. The $900 dispute is part of the $1,500 outstanding invoice balance; it is not a payment or a credit. The remaining $600 of that invoice balance is undisputed. The unpaid obligation is $3,500, comprising $2,000 not yet invoiced and $1,500 billed but unpaid.

Common mistake avoided: subtracting the full $1,000 recovery from the insurer’s total paid amount, rather than from the amount assigned to the insured’s layer, would ignore the stated contract allocation. A dispute also does not reduce the ledger obligation unless it is resolved through an accepted adjustment, such as a credit note.

Worked Example: Partial Payments, Multiple Invoices, and a Credit Note

Scenario. For a hypothetical claim, two insurer payment tranches have been processed. The contract allocation assigns $5,000 of the first tranche and $4,000 of the second tranche to the insured’s deductible layer. A later $2,000 recovery is allocated $1,200 to that layer. The insured has received two invoices: $3,000 and $4,000. A $500 credit note applies to the second invoice. The insured remitted $2,500 against the first invoice and $1,000 against the second. A further $1,200 of the second invoice’s remaining balance is disputed. Find the claim-level reconciliation.

Method. Sum the deductible-layer allocations, subtract the recovery allocated to the insured, then net the credit note and remittances. All amounts are nominal dollars; no interest, mortality, or distribution assumptions are applicable.

Before the recovery, the allocated amount is:

\$5{,}000+\$4{,}000=\$9{,}000

After the allocated recovery, the reimbursable obligation is:

D_i=\$9{,}000-\$1{,}200=\$7{,}800

Invoice debits total $3,000+$4,000=$7,000. After the $500 credit note, the net invoiced amount is:

I_i=\$7{,}000-\$500=\$6{,}500

The applied remittances total $2,500+$1,000=$3,500. Thus:

U_i=\$7{,}800-\$6{,}500=\$1{,}300

A_i=\$6{,}500-\$3{,}500=\$3{,}000

O_i=\$7{,}800-\$3{,}500=\$4{,}300

The check is $\$1{,}300+\$3{,}000=\$4{,}300$. By invoice, the first invoice has $3,000-$2,500=$500 outstanding. The second has a net balance of $4,000-$500=$3,500, less $1,000 remitted, leaving $2,500 outstanding. The two invoice balances sum to $3,000. Of that amount, $1,200 is disputed and $1,800 is not disputed.

Common mistake avoided: treating the second invoice as $4,000 after its credit note overstates the net invoices by $500. Another error is to treat the disputed $1,200 as a credit; it remains in the invoice balance until resolved.

Worked Example: Two Claims and an Overbilled Account

Scenario. A hypothetical insured’s remittance advice identifies $4,000 for Claim A and $2,000 for Claim B. The insured sent $7,000 in total, so $1,000 has not yet been assigned to a claim. Claim A has a current reimbursable obligation of $10,000, invoice debits of $8,000, and a $500 credit note. Claim B has a current reimbursable obligation of $6,500 and invoice debits of $7,000. No credit has been issued for Claim B’s excess invoice amount. Find each claim’s reconciliation and the total unpaid obligation based on applied cash.

Method. Reconcile each claim separately using only remittances assigned to it. Keep the remaining $1,000 in an unapplied-cash category. All figures are nominal dollars; interest, mortality, and distribution assumptions do not apply.

For Claim A, net invoices are $I_A=\$8{,}000-\$500=\$7{,}500$, and applied cash is $M_A=\$4{,}000$. Therefore:

U_A=\$10{,}000-\$7{,}500=\$2{,}500,\quad A_A=\$7{,}500-\$4{,}000=\$3{,}500,\quad O_A=\$10{,}000-\$4{,}000=\$6{,}000

For Claim B, net invoices are $I_B=\$7{,}000$, and applied cash is $M_B=\$2{,}000$. Therefore:

U_B=\$6{,}500-\$7{,}000=-\$500,\quad A_B=\$7{,}000-\$2{,}000=\$5{,}000,\quad O_B=\$6{,}500-\$2{,}000=\$4{,}500

Claim B is overbilled by $500 relative to its current obligation. Its outstanding invoices are still $5,000; the negative $500 unbilled amount offsets part of that billed balance in the net-obligation reconciliation. Across the two claims, $D=\$16{,}500$, net invoices are $14,500, and applied remittances are $6,000. The total unpaid obligation is $16,500-$6,000=$10,500. The control check is $(\$2,500-\$500)+(\$3,500+\$5,000)=\$10,500$.

The additional $1,000 received but not assigned is not included in either $M_A$ or $M_B$. It should be tracked as unapplied cash until its claim assignment is supported. Once assigned, the affected claim’s applied remittance and reconciliation can be updated.

Common mistake avoided: subtracting all $7,000 of cash from the combined obligations without accounting for the remittance advice would make the claim-level records appear $1,000 more settled than the cash applications actually support. A portfolio cash total is not a substitute for claim-level assignment.

Disputes, Exceptions, and Practical Controls

A dispute is a status attached to an amount, not a separate accounting transaction. Record the disputed portion of an invoice balance, the reason for the dispute, and its resolution status. Until a correction is formally accepted and recorded, do not silently remove the amount from the obligation or count it as cash. If the dispute is upheld, issue and record a credit or otherwise adjust the contractual obligation under the applicable process; then rerun the reconciliation.

Useful exception checks include:

Payments beyond invoices: identify applied cash greater than the net invoiced amount and confirm whether it is an advance, a misapplication, or a credit balance.
Invoices beyond obligation: investigate negative $U_i$; it may reflect an overbilling, an omitted recovery, or a contract allocation that has not been updated.
Unbilled obligation: investigate positive $U_i$ to determine whether billing is pending, incomplete, or intentionally deferred.
Unapplied cash: keep receipts without a supported claim assignment separate from claim-level remittances.
Recovery allocation: verify whether a recovery reduces the insured’s reimbursable amount and by how much under the contract.

A common exam trap is to collapse the ledger into a single “balance due” too early. That can hide an overbilled claim offset by an underbilled one, count an unassigned receipt as a claim payment, or treat a disputed amount as though it has already been credited. Reconcile claim by claim first; aggregate only after the individual records are internally consistent. This approach is aligned with the CAS Exam 8 (Advanced Ratemaking) syllabus because it connects contractual deductible obligations to the operational records used to administer them.

Key takeaway: Establish the contractual obligation, net the claim’s invoices and credit notes, and apply only supported claim-specific remittances. Then verify $D_i-M_i=(D_i-I_i)+(I_i-M_i)$, while separately tracking disputes and unapplied cash.

Check Your Understanding

For each problem, calculate the requested claim-level amounts. Treat all amounts as nominal dollars; no interest, mortality, or distribution assumptions apply.

A claim has a reimbursable obligation of $5,200, invoice debits of $4,000, and a $200 credit note. Applied remittances are $2,500. Find net invoices, unbilled amount, outstanding invoices, and unpaid obligation. (Answer: Net invoices $3,800; unbilled $1,400; outstanding invoices $1,300; unpaid obligation $2,700.)
Two paid tranches generate deductible-layer allocations of $2,600 and $3,100. A $700 recovery is allocated entirely to the insured’s layer. Net invoices are $4,600, and $3,000 has been applied. Of the invoice balance, $600 is disputed. Find the obligation, unbilled amount, outstanding invoices, and unpaid obligation. (Answer: Obligation $5,000; unbilled $400; outstanding invoices $1,600, including $600 disputed; unpaid obligation $2,000.)
Claim A has an obligation of $9,000, net invoices of $6,000, and applied remittances of $5,000. Claim B has an obligation of $4,000, net invoices of $4,500, and applied remittances of $2,000. Find the unpaid obligation for each claim and in total; identify any overbilling. (Answer: Claim A unpaid $4,000; Claim B unpaid $2,000; total unpaid $6,000; Claim B is overbilled by $500.)
A contract allocation assigns $7,200 of paid amounts to the insured’s layer. Of a later $1,200 recovery, 75% is allocated to that layer. Net invoices are $7,000, and $4,500 has been applied. Find the net obligation, unbilled amount, outstanding invoices, and unpaid obligation. (Answer: Obligation $6,300; unbilled $-\$700$, indicating $700 overbilled; outstanding invoices $2,500; unpaid obligation $1,800.)
Claim A has an obligation of $6,000 and invoices of $5,000; Claim B has an obligation of $7,000 and invoices of $8,000. A $6,500 remittance is supported by advice assigning $4,000 to A and $2,000 to B, with $500 not assigned. Find each claim’s outstanding invoice balance and unpaid obligation, the total unpaid obligation based on applied cash, and unapplied cash. (Answer: A outstanding $1,000 and unpaid $2,000; B outstanding $6,000 and unpaid $5,000; total unpaid based on applied cash $7,000; unapplied cash $500.)

What You'll Learn