The rule in plain words
The item "Excess of assets over liabilities" reported in Balance sheet (IRR.02.01) [RFF/MP/RM] should be equal to the "Total assets" minus "Total liabilities"
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 check applies only when its first part holds in your return. When it does, the second part must hold too: fix the second part, or correct the first.
- 03The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark IRR.01.01 and IRR.02.01 as reported.
- 05This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Content of the submission (IRR.01.01.07.01)
Row
- R0790IRR.02.01.07 - Balance Sheet
Column
- C0010c
Balance sheet (IRR.02.01.07.01)
Rows
- R0500Total assets
- R0900Total liabilities
- R1000Excess of assets over liabilities
Column
- C0010Solvency II value
Which returns it applies to
Line4 Check runs it on annual third-country branch (ARB) return on Bank of England taxonomy 2.2.0. The Bank of England applies it to annual third-country branch (ARB) 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 item "Excess of assets over liabilities" reported in IRR.02.01 - Balance sheet [RFF/MP/RM] should be equal to the "Total assets" minus "Total liabilities".
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
if ({t: IRR.01.01.07.01, r: R0790, c: C0010, z: Z0001} = $[s2c_CN:x1]) then {t: IRR.02.01.07.01, r: R1000, c: C0010, z: Z0001} = {t: IRR.02.01.07.01, r: R0500, c: C0010, z: Z0001} - {t: IRR.02.01.07.01, r: R0900, c: C0010, z: Z0001} else true()Other rules on Content of the submission (IRR.01.01)
- Content of the submission and balance sheet: a conditional check (IR_bv0897_01)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0897_02)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0896_01)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0896_02)Blocking
- The item "Total assets" reported in Balance sheet [RFF/MP/RM] should be equal to the sum of the different items reported above (IR_bv0895_01)Blocking
- The item "Total assets" reported in Balance sheet [RFF/MP/RM] should be equal to the sum of the different items reported above (IR_bv0895_02)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0894_01)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0894_02)Blocking
Every Solvency UK rule on IRR.01.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.
