The rule in plain words
The item "Investments (other than assets held for index-linked and unit-linked contracts)" reported in Balance sheet (IRR.02.01) [RFF/MP/RM] should be equal to the sum of "Property (other than for own use)", "Holdings in related undertakings, including participations", "Equities", "Bonds", "Collective Investments Undertakings", "Derivatives", "Deposits other than cash equivalents", and "Other investments"
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
- R0070Investments (other than assets held for index-linked and unit-linked contracts)
- R0080Property (other than for own use)
- R0090Holdings in related undertakings, including participations
- R0100Equities
- R0130Bonds
- R0180Collective Investments Undertakings
- R0190Derivatives
- R0200Deposits other than cash equivalents
- R0210Other investments
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 "Investments (other than assets held for index-linked and unit-linked contracts)" reported in IRR.02.01 - Balance sheet [RFF/MP/RM] should be equal to the sum of "Property (other than for own use)", "Holdings in related undertakings, including participations", "Equities", "Bonds", "Collective Investments Undertakings", "Derivatives", "Deposits other than cash equivalents", and "Other investments".
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: R0070, c: C0010, z: Z0001} = {t: IRR.02.01.07.01, r: R0080, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0090, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0100, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0130, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0180, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0190, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0200, c: C0010, z: Z0001} + {t: IRR.02.01.07.01, r: R0210, 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_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_bv0891_01)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0891_02)Blocking
- Content of the submission and balance sheet: a conditional check (IR_bv0891_03)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_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
- The item "Equities" reported in Balance sheet [RFF/MP/RM] should be equal to the sum of "Equities - listed" and "Equities - unlisted" (IR_bv0893_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.
