Why Reconcile Indication Inputs?
An indication can only be reviewed effectively if its inputs can be traced to their source totals. A selected amount may differ from the corresponding source amount for a valid reason, such as a documented correction or a defined data adjustment. A reconciliation makes those explanations visible and isolates whatever remains unexplained.
The key is to compare like with like: the same experience period, data component, units, and basis. A total that agrees across several periods may still conceal offsetting differences within individual periods or components. Reconciliation is therefore both a calculation and a control on the way inputs are selected and documented.
Build the Reconciliation at the Right Level
A useful reconciliation identifies each period and each component separately. Depending on the input set, components might include premium, losses, exposures, or expenses. The table should not combine components merely because they appear in the same indication. First reconcile each selected amount to its own corresponding source amount; only then consider totals.
A practical table includes the source amount, each documented adjustment (or their signed total), the adjusted source amount, the selected input, and the residual. Keep units consistent throughout—for example, record every amount in dollars or every amount in thousands. Record adjustments as signed values: an addition is positive and a subtraction is negative.
| Period | Component | Source \(S\) | Documented adjustments \(A\) | Adjusted source \(S+A\) | Selected input \(I\) | Residual \(R\) |
|---|---|---|---|---|---|---|
| Period 1 | Premium | Source total | Signed amounts | Source plus adjustments | Selected amount | \(I-(S+A)\) |
| Period 1 | Losses | Source total | Signed amounts | Source plus adjustments | Selected amount | \(I-(S+A)\) |
| Period 2 | Premium | Source total | Signed amounts | Source plus adjustments | Selected amount | \(I-(S+A)\) |
The row definitions matter. If a selected input covers a different period or component from its source total, the arithmetic may still produce a number, but that number is not a meaningful reconciliation. Confirm the comparison basis before interpreting the residual.
Confirm that the selected input and source amount refer to the same period, component, units, and scope.
Record each adjustment with its sign and enough description to trace it to supporting documentation.
First compute \(S+A\), then compute \(I-(S+A)\). Do this for each row.
Trace nonzero residuals to records or selection decisions. Add an adjustment only when there is evidence supporting it.
Why the Residual Formula Has This Sign
The formula follows from the accounting identity used to organize the comparison. If the selected input is fully explained by the source amount, documented adjustments, and a remaining unexplained amount, then
Subtracting the adjusted source amount \(S+A\) from both sides gives \(I-(S+A)=R\). This derivation also fixes the sign convention: when \(I\) exceeds \(S+A\), the residual must be positive. A reconciliation is complete for a row when its residual is zero, subject to any stated rounding tolerance.
A zero residual is evidence of arithmetic agreement, not proof that the underlying data or selection is appropriate. The source, adjustments, and selected input must still be valid for their intended use.
Worked Example: Applying a Negative Adjustment Correctly
For a hypothetical experience period, the source premium total is $3,250,000. A documented correction reduces that total by $25,000, and the selected premium input is $3,210,000. Calculate the adjusted source and unexplained residual. Then identify a common sign error.
Method. Treat the reduction as a signed adjustment, \(A=-\$25{,}000\). The adjusted source is
Now subtract the adjusted source from the selected input:
The selected input is $15,000 below the source total after the documented correction. The row can also be checked by adding the residual back: \(\$3{,}225{,}000+(-\$15{,}000)=\$3{,}210{,}000\).
Common mistake avoided. Calculating \(I-S+A\) gives \(\$3{,}210{,}000-\$3{,}250{,}000+(-\$25{,}000)=-\$65{,}000\). That expression applies the adjustment in the wrong direction relative to the selected-input comparison. The correct expression is \(I-(S+A)\), which gives \(-\$15{,}000\).
Reconcile Periods and Components Separately
Reconciliation by period and component helps locate the source of a difference. A single aggregate can conceal whether a mismatch comes from one period, one data component, or several rows. It is also possible for two large residuals to offset, leaving an aggregate residual of zero even though neither row reconciles.
Worked Example: Finding Which Rows Do Not Reconcile
A hypothetical insurer reviews premium and loss inputs for two experience periods. Amounts are in dollars. For each row, calculate the adjusted source and residual, then calculate the aggregate residual.
| Period | Component | Source \(S\) | Adjustment \(A\) | Selected input \(I\) |
|---|---|---|---|---|
| 1 | Premium | $4,800,000 | −$35,000 | $4,790,000 |
| 1 | Losses | $2,900,000 | +$120,000 | $3,040,000 |
| 2 | Premium | $5,200,000 | +$40,000 | $5,240,000 |
| 2 | Losses | $3,100,000 | −$50,000 | $3,080,000 |
Period 1 premium. The adjusted source is \(\$4{,}800{,}000-\$35{,}000=\$4{,}765{,}000\). The residual is \(\$4{,}790{,}000-\$4{,}765{,}000=+\$25{,}000\).
Period 1 losses. The adjusted source is \(\$2{,}900{,}000+\$120{,}000=\$3{,}020{,}000\). The residual is \(\$3{,}040{,}000-\$3{,}020{,}000=+\$20{,}000\).
Period 2 premium. The adjusted source is \(\$5{,}200{,}000+\$40{,}000=\$5{,}240{,}000\). The residual is \(\$5{,}240{,}000-\$5{,}240{,}000=\$0\).
Period 2 losses. The adjusted source is \(\$3{,}100{,}000-\$50{,}000=\$3{,}050{,}000\). The residual is \(\$3{,}080{,}000-\$3{,}050{,}000=+\$30{,}000\).
The aggregate residual is \(+\$25{,}000+\$20{,}000+\$0+\$30{,}000=+\$75{,}000\). As a check, total selected input is $16,150,000. Total source is $16,000,000 and total signed adjustment is \( -\$35{,}000+\$120{,}000+\$40{,}000-\$50{,}000=+\$75{,}000\), so adjusted source is $16,075,000. The difference is again \( \$16{,}150{,}000-\$16{,}075{,}000=+\$75{,}000\).
Method and mistake avoided. Reconcile row by row before aggregating. Reporting only the $75,000 total would hide that three rows have nonzero residuals; reporting only the zero residual for Period 2 premium would also give an incomplete picture.
Investigate Residuals Without Inventing Adjustments
A residual identifies a difference to investigate; it does not explain the difference by itself. Useful follow-up checks include tracing the selected amount to its calculation or data extract, confirming the period boundaries, checking units and component definitions, and verifying that each adjustment is supported and recorded once. Keep the investigation separate from the initial reconciliation so that the original difference remains visible.
If supporting records establish a previously omitted adjustment, document its amount, sign, and source, then recalculate the residual. Do not create an adjustment merely to make a row balance. If a difference remains unexplained, report it as a residual and describe the investigation status.
Worked Example: Documenting a Difference After Investigation
A hypothetical selected loss input is $1,555,000. Its source total is $1,460,000, and the reconciliation already includes a documented adjustment of +$60,000. During follow-up, records establish two additional items not yet in the reconciliation: a supported +$25,000 correction and a supported +$10,000 timing item. Calculate the initial residual, the revised residual, and the amount of the new adjustments.
Initial reconciliation. The adjusted source before follow-up is \(\$1{,}460{,}000+\$60{,}000=\$1{,}520{,}000\). Therefore,
Record the supported items. Their signed total is \(+\$25{,}000+\$10{,}000=+\$35{,}000\). The revised adjustment total is \(+\$60{,}000+\$35{,}000=+\$95{,}000\).
Recalculate. The revised adjusted source is \(\$1{,}460{,}000+\$95{,}000=\$1{,}555{,}000\). The revised residual is \(\$1{,}555{,}000-\$1{,}555{,}000=\$0\). The check is exact: source plus all documented adjustments equals the selected input.
Method and mistake avoided. Add the new items only after their support is established, retain the initial residual in the audit trail, and then show the revised result. Do not label the original $35,000 as an adjustment before it is explained.
Common Reconciliation Traps
- Reversing adjustment signs. Enter reductions as negative amounts and additions as positive amounts. Calculate \(I-(S+A)\), not \(I-S+A\).
- Comparing unlike totals. Check period, component, units, and scope before treating a difference as meaningful.
- Relying on a net total. Opposing residuals can cancel. Preserve the row-level results and use the aggregate only as an additional check.
- Confusing an adjustment with a residual. An adjustment is supported and documented; a residual is what remains after the documented adjustments.
- Forcing the table to balance. A zero residual obtained by an unsupported plug is not a valid reconciliation.
Check Your Understanding
For each problem, calculate the unexplained residual using selected input minus (source plus documented adjustments), with adjustments applied using their stated signs.
- A source premium total is $3,250,000, a documented adjustment is −$25,000, and the selected input is $3,210,000. What is the residual? (Answer: −$15,000)
- A period's source premium is $6,400,000, its documented adjustment is +$80,000, and its selected input is $6,500,000. What is the residual? (Answer: +$20,000)
- A source loss total is $2,750,000, a documented adjustment is +$90,000, and the selected loss input is $2,810,000. What is the residual? (Answer: −$30,000)
- For one period, premium has source $8,000,000, adjustment −$100,000, and selected input $7,950,000. Losses have source $5,000,000, adjustment +$200,000, and selected input $5,250,000. What are the two row residuals and their aggregate? (Answer: Premium +$50,000; losses +$50,000; aggregate +$100,000)
- A source total is $1,200,000. Two documented adjustments are −$30,000 and +$15,000, and the selected input is $1,190,000. What is the residual after both adjustments? (Answer: +$5,000)