Why Operational Reconciliation Matters
A large-deductible program depends on records maintained for different purposes. A claim system may track approved amounts, a billing ledger may track invoices and applied receipts, a collateral register may track security instruments and their recognized values, and bank records may show cash received or disbursed. These records need not match at every instant. They do need to reconcile at a stated cutoff, with differences explained, assigned, and resolved.
A reconciliation is not permission to force two balances to agree. It is a controlled comparison that distinguishes valid timing or scope differences from errors, preserves the meaning of each balance, and creates evidence that another reviewer can follow. The procedures here concern record controls; they do not determine the appropriate collateral amount or the terms of a particular hypothetical contract.
Use Signed Adjustments, Not Assumed Subtractions
The sign of a reconciling item depends on which record contains it. Choose one record as the source and the other as the target. An item present in the target but absent from the source receives a positive adjustment; an item present in the source but absent from the target receives a negative adjustment. When both records contain the same item, it is not a reconciling adjustment.
For source balance \(S\), target balance \(T\), and signed adjustments \(a_j\), define the residual as follows. A fully explained reconciliation has a residual of zero, apart from any explicitly permitted rounding tolerance.
This convention works because each adjustment moves the source balance onto the target basis. It does not assume every difference is subtracted: a target-only item increases the adjusted source, while a source-only item decreases it. The adjustment must also be supported by evidence and described in words, not merely entered as a number.
Worked Example: Reconciling Approved Claim Amounts
In a hypothetical program, the claim system shows $244,000 of cumulative approved insurer payments at a month-end cutoff. The insurer payment register shows $236,000. Review confirms that $9,000 is in the claim system but has not yet posted to the insurer register, while a valid $1,000 register entry is not yet reflected in the claim system. Reconcile the two balances.
Method. Treat the claim system as the source and the insurer register as the target. The $9,000 claim-system-only item is subtracted from the source, so its signed adjustment is \(-\$9,000\). The $1,000 register-only item is target-side and therefore receives a positive adjustment of \(+\$1,000\).
The adjusted source is:
The residual is \(R=\$244{,}000-\$9{,}000+\$1{,}000-\$236{,}000=\$0\). The records reconcile, but both timing items remain tracked until they post or are otherwise resolved. A zero residual does not mean that either underlying record should be overwritten.
Common mistake avoided. Subtracting both timing items would give an adjusted source of $234,000 and a false residual of \(-\$2,000\). The correction is to assign each item’s sign according to which record contains it.
Control the Billing and Cash Records Separately
Billing controls should distinguish invoices, receipts, applied cash, and unapplied cash. An invoice balance is reduced by cash actually applied to that invoice. A receipt may be confirmed in a bank record but remain unapplied in the billing system because its payer, invoice, or allocation is not yet supported. Until allocation is approved and recorded, that receipt does not reduce the open invoice balance.
It can still be useful to report a separate net exposure after considering unapplied cash. That is a management view, not the open invoice balance. Label the two amounts clearly, and retain the unapplied receipt as a separate reconciling item rather than silently allocating it.
Worked Example: Separating Open Invoices From Unapplied Cash
A hypothetical insured has $318,400 of invoices in a billing ledger. Of its receipts, $302,000 has been applied to specific invoices and $7,500 has been recorded as unapplied cash. No other adjustments are supported. Find the open invoice balance after applied cash and the net invoice exposure after considering the unapplied receipt.
Step 1: Calculate the open invoice balance. Only applied cash reduces invoices:
The open invoice balance is $16,400. The separate unapplied-cash balance is $7,500.
Step 2: Calculate net exposure as a separate view. If all unapplied cash is later supported and allocated to these invoices, the net exposure would be:
Thus, the open invoice balance remains $16,400, and the net exposure after considering unapplied cash is $8,900, pending allocation. These are different measures.
Check. Applied cash plus the open invoice balance equals total invoices: \(\$302{,}000+\$16{,}400=\$318{,}400\). The $7,500 is separately accounted for and has not been used to reduce the open invoices.
Common mistake avoided. Reporting $8,900 as the open invoice balance would treat unapplied cash as though it had already been allocated. Keep it separate until the allocation is evidenced and approved.
Reconcile Collateral at a Consistent Basis
Collateral records can contain several different measures: instrument face amount, market value, recognized value after applicable valuation adjustments, and a ledger balance. A comparison is meaningful only when both sides use the same measure and cutoff. For example, comparing an instrument’s face amount with a ledger value after a valuation adjustment can create an apparent difference that is not a record error.
A collateral control should identify the instrument or asset, the source evidence, the valuation basis used in the ledger, and the person responsible for follow-up. The calculation below is a record check using a stated hypothetical haircut; it is not a general rule for choosing a haircut.
Worked Example: Checking Recognized Collateral Value
At a month-end cutoff, a hypothetical trust statement reports assets with a market value of $412,000. The collateral register records recognized value of $420,000. For this control, the approved procedure applies a 3% haircut to the statement market value. Determine the supported recognized value, the signed variance from the register, and the action if the permitted absolute difference is $2,000.
Step 1: Calculate recognized value from the source statement. A 3% haircut retains 97% of market value:
Step 2: Compare on the same basis. Define variance as supported value minus register value:
The register exceeds the supported value by $20,360. Its absolute variance, $20,360, is greater than the $2,000 tolerance, so the item is an exception and must be escalated under the control procedure.
Check. The supported value is below the register value, so the signed variance is negative. A positive result would have the wrong direction. The owner should verify the statement, cutoff, asset population, and valuation entry before proposing a correction; the original register entry should remain traceable.
Set Thresholds, Owners, and Resolution Evidence
A useful exception process specifies both quantitative thresholds and nonfinancial triggers. A dollar tolerance may identify differences requiring investigation, but an item can require action regardless of amount if it is unauthorized, unsupported, duplicated, assigned to the wrong account, or past its resolution deadline. Thresholds should reflect the control’s purpose and be approved for the program; there is no universal tolerance that makes every smaller difference acceptable.
Each exception should have one accountable owner, a due date, a status, and a reviewer when the proposed resolution affects a controlled balance. The owner investigates and assembles evidence; the reviewer checks that the explanation and any adjustment are supported. A reconciliation should preserve the original records and the history of changes.
Record the source, target, population, measurement basis, currency, and cutoff. Confirm that both records cover the same items before interpreting a residual.
For each difference, record its amount, which record contains it, its direction, reason, evidence, and expected posting or resolution date.
Route items that exceed dollar or aging limits, or meet a qualitative trigger, to the named control owner. Do not let a small amount bypass a required authorization or evidence check.
Link the posting, correction, allocation, or other disposition to its supporting evidence. A reviewer confirms the entry and recalculates the residual.
Record who prepared and reviewed the reconciliation, the dates, final residual, unresolved items, and any escalation. Retain prior versions rather than replacing them without a history.
Common Control Traps
- Giving every reconciling item the same sign. A target-only item and a source-only item move the adjusted source in opposite directions.
- Calling net exposure the open invoice balance. Unapplied cash is not applied cash; show it separately until the allocation is supported and recorded.
- Comparing unlike collateral measures. Face amount, market value, and recognized value are not interchangeable. State the basis on both sides.
- Closing a difference because it is small. A tolerance does not excuse missing evidence, unauthorized activity, or a mandatory escalation trigger.
- Using a zero residual as the only success measure. A plug entry can force agreement without explaining the underlying records. Require item-level support and independent review.
Worked Example: Reconciling an Insurer Payment to Bank Cash
At a hypothetical cutoff, an insurer’s payment register records $96,400. The insured’s bank statement shows $92,200 of deposits identified as related to the same program. Investigation supports a $5,000 payment-register item in transit and a separate $800 deposit present in the bank but not yet entered in the payment register. The control’s absolute residual threshold is $1,000. Reconcile the records and state the control outcome.
Method. Use the payment register as the source and bank deposits as the target. The $5,000 in-transit item is source-only, so its adjustment is \(-\$5,000\). The $800 bank-only deposit is target-only, so its adjustment is \(+\$800\).
The residual is \(R=\$92{,}200-\$92{,}200=\$0\). The records reconcile when both supported items are considered. The $800 still needs an owner and follow-up entry in the payment register, and the $5,000 should be checked for bank posting after the expected transit period.
Control outcome. The current residual is within the $1,000 threshold, but the two documented items remain open until their subsequent posting or disposition is verified. The zero residual does not itself close those follow-ups.
Common mistake avoided. Subtracting both items would give $90,600, which does not reconcile to the bank statement. Signs are determined by whether an item appears in the target or source, not by whether it is described as a timing difference.
Check Your Understanding
For each problem, identify the correct balance or signed adjustment and apply the stated control rule.
- A billing ledger has $142,600 of invoices, $131,200 of applied receipts, and $4,000 of unapplied cash. What is the open invoice balance after applied receipts, and what is net exposure after considering unapplied cash? (Answer: Open invoice balance $11,400; net exposure $7,400, pending allocation.)
- A claim system is the source at $187,500, and an insurer register is the target at $181,000. A supported $8,200 is source-only and a supported $1,700 is target-only. Calculate the adjusted source and residual. (Answer: Adjusted source $181,000; residual $0.)
- A collateral statement shows market value of $260,000. The approved control applies a 5% haircut, while the register shows recognized value of $249,000. If the absolute tolerance is $1,500, calculate the supported value and state whether to open an exception. (Answer: Supported value $247,000; signed variance \(-\$2,000\); open an exception.)
- A payment register shows $83,000 and the bank statement shows $79,500. Investigation supports $4,000 source-only in-transit cash and $500 target-only cash. Calculate the adjusted source and residual. (Answer: Adjusted source $79,500; residual $0.)
- A reconciliation has an absolute residual of $1,900 against a $2,000 dollar threshold. The oldest supported timing item has been open for 40 days, and the procedure requires escalation for any item older than 30 days. What is the correct action? (Answer: Escalate the aged item despite the residual being within the dollar threshold; keep it open with an owner, evidence, and resolution deadline.)