The rule in plain words
The item "Equities" reported in Balance sheet (IRR.02.01) [RFF/MP/RM] should be equal to the sum of "Equities - listed" and "Equities - unlisted"
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
- R0100Equities
- R0110Equities - listed
- R0120Equities - unlisted
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 "Equities" reported in IRR.02.01 - Balance sheet [RFF/MP/RM] should be equal to the sum of "Equities - listed" and "Equities - unlisted".
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: R0100, c: C0010, z: Z0001} = {t: IRR.02.01.07.01, r: R0110, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0120, c: C0010, z: Z0001} else true()Other rules on Content of the submission (IRR.01.01)
- The item "Equities" reported in Balance sheet [RFF/MP/RM] should be equal to the sum of "Equities - listed" and "Equities - unlisted" (IR_bv0893_01)Blocking
- The item "Equities" reported in Balance sheet [RFF/MP/RM] should be equal to the sum of "Equities - listed" and "Equities - unlisted" (IR_bv0893_02)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0892_01)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0892_02)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0892_03)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
- Content of the submission and balance sheet: a conditional check (IR_bv0894_03)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.
