The rule in plain words
The item "Loans and mortgages" reported in Balance sheet (IR.02.01.07.01) should be equal to the sum of "Loans on policies"; "Loans and mortgages to individuals" and "Other loans and mortgages"
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 table below and find the cells the rule reads.
- 02Add up the parts in your return and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong cell, or the total is out of date.
- 04The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark IR.02.01 as reported.
- 06This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Balance sheet (IR.02.01.07.01)
Rows
- R0230Loans and mortgages
- R0240Loans on policies
- R0250Loans and mortgages to individuals
- R0260Other loans and mortgages
Column
- C0020Branch management accounts 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 "Loans and mortgages" reported in IR.02.01.07.01 - Balance sheet should be equal to the sum of "Loans on policies"; "Loans and mortgages to individuals" and "Other loans and mortgages".
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: IR.02.01.07.01, r: R0230, c: C0020} = sum({t: IR.02.01.07.01, r: R0240; R0250; R0260, c: C0020})Other rules on Balance sheet (IR.02.01)
- Balance sheet: a total must equal the sum of its parts (IR_bv0912_01)Blocking
- Balance sheet: a total must equal the sum of its parts (IR_bv0913_01)Blocking
- Balance sheet: a total must equal the sum of its parts (IR_bv0913_02)Blocking
- The item "Equities" reported in Balance sheet should be equal to the sum of "Equities - listed" and "Equities - unlisted" (IR_bv0914_01)Blocking
- The item "Equities" reported in Balance sheet should be equal to the sum of "Equities - listed" and "Equities - unlisted" (IR_bv0914_02)Blocking
- Balance sheet: a total must equal the sum of its parts (IR_bv0907)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0867_01)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0867_02)Blocking
Every Solvency UK rule on IR.02.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.
