The rule in plain words
The item "Excess of assets over liabilities" reported in Balance sheet (IR.02.01.02.01) should be equal to the "Total assets" minus "Total liabilities"
This is a blocking check. A return that fails it is normally rejected, so fix it before you submit. It runs only when your filing indicators mark IR.02.01 as reported.
The cells it reads
Balance sheet (IR.02.01.02.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 quarterly solo (QRS) and quarterly group (QRG) returns on Bank of England taxonomy 2.2.0. The Bank of England applies it to quarterly solo (QRS) and quarterly group (QRG) 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 IR.02.01.02.01 - Balance sheet 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}.
{t: IR.02.01.02.01, r: R1000, c: C0010} = {t: IR.02.01.02.01, r: R0500, c: C0010} - {t: IR.02.01.02.01, r: R0900, c: C0010}Other rules on Balance sheet (IR.02.01)
- The item "Excess of assets over liabilities" reported in Balance sheet should be equal to the "Total assets" minus "Total liabilities" (IR_bv0548_01)Blocking
- The item "Excess of assets over liabilities" reported in Balance sheet should be equal to the "Total assets" minus "Total liabilities" (IR_bv0548_03)Blocking
- Balance sheet and assets and liabilities by currency: a total must equal the sum of its parts (IR_bv0551)Blocking
- Balance sheet and assets and liabilities by currency: a total must equal the sum of its parts (IR_bv0554)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0555_01)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0555_02)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0555_03)Blocking
- Balance sheet and 2 other templates: a total must equal the sum of its parts (IR_bv0572_01)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.
