The rule in plain words
The "Total" value of "Excess of assets over liabilities-attribution of valuation differences/Excess of assets over liabilities attributable to basic own fund items (excluding the reconciliation reserve)" reported in the template Detailed information by tiers on own funds (IR.23.02) should be equal to the "Total" value of the Reconciliation reserve/Other basic own fund items" reported in the template Own funds (IR.23.01)
The headline gives only the template and the kind of check, because the rule is too long to say in a headline. The plain words above say all of it.
What to do if your return fails it
- 01Open the tables below and find the cells the rule reads.
- 02The two values must be the same. Find which of the two is right, and correct the other one.
- 03It runs only when your filing indicators mark IR.23.01 and IR.23.02 as reported.
- 04This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Own funds: reconciliation reserve (IR.23.01.04.02)
Row
- R0730Other basic own fund items
Column
- C0060c
Detailed information by tiers on own funds: excess of assets over liabilities - attribution of valuation differences (IR.23.02.04.03)
Row
- R0660Excess of assets over liabilities attributable to basic own fund items (excluding the reconciliation reserve)
Column
- C0110Total
A worked example
With simple numbers.
Excess of assets over liabilities attributable to basic own fund items (excluding the reconciliation reserve), Total must then be 1,200.
A file that reports 1,200 passes. One that reports 1,300 fails, by 100.
The numbers are illustrative.
Which returns it applies to
Line4 Check runs it on annual group (ARG) return on Bank of England taxonomy 2.2.0. The Bank of England applies it to annual group (ARG) returns, as a blocking check.
The Bank’s own words and formula
In the Bank of England’s list of validations, word for word:
The "Total" value of "Excess of assets over liabilities-attribution of valuation differences/Excess of assets over liabilities attributable to basic own fund items (excluding the reconciliation reserve)" reported in the template IR.23.02 - Detailed information by tiers on own funds should be equal to the "Total" value of the Reconciliation reserve/Other basic own fund items" reported in the template IR.23.01 - Own funds.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: IR.23.02.04.03, r: R0660, c: C0110, z: Z0001} = {t: IR.23.01.04.02, r: R0730, c: C0060, z: Z0001}Other rules on Own funds (IR.23.01)
- Own funds and detailed information by tiers on own funds: two values must match (IR_bv0530_01)Blocking
- Own funds: two values must match (IR_bv0532)Blocking
- Own funds: two values must match (IR_bv0527)Blocking
- The "Total" value reported in Own funds should be equal to the sum of "Tier 2" and "Tier 3" (IR_bv0534)Blocking
- Own funds: two values must match (IR_bv0536)Blocking
- Own funds: two values must match (IR_bv0537_01)Blocking
- Own funds: two values must match (IR_bv0537_02)Blocking
- The "Total" value reported in Own funds should be equal to the same item for "Tier 2" (IR_bv0538_01)Blocking
Every Solvency UK rule on IR.23.01
Checks like this one, run at the point of submission, are the first step to real-time supervision. Line4 builds SupTech software for financial regulators that runs checks like these as each return arrives.
