The rule in plain words
The value for "Total value of all currencies" reported in Assets and liabilities by currency (IR.02.02) should be equal to the sum of "Value of the solvency II reporting currency", "Value of remaining other currencies" and "Value of material currencies" for all currencies reported
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.
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.02 as reported.
The cells it reads
Balance sheet (IR.02.01.01.01)
Rows
- R0070Investments (other than assets held for index-linked and unit-linked contracts)
- R0220Assets held for index-linked and unit-linked contracts
- R0270Reinsurance recoverables from:
- R0500Total assets
- R0740Contingent liabilities
- R0790Derivatives
- R0900Total liabilities
Column
- C0010Solvency II value
Assets and liabilities by currency: all currencies (IR.02.02.01.01)
Rows
- R0020Investments (other than assets held for index-linked and unit-linked contracts)
- R0030Other assets: Property, plant & equipment held for own use, Cash and cash equivalents, Loans on policies, Loans & mortgages to individuals and Other loans & mortgages (other than index-linked and unit-linked contracts)
- R0040Assets held for index-linked and unit-linked contracts
- R0050Reinsurance recoverables
- R0060Deposits to cedants, insurance and intermediaries receivables and reinsurance receivables
- R0070Any other assets
- R0100Total assets
- R0110Technical provisions (excluding index-linked and unit-linked contracts)
- R0120Technical provisions - index-linked and unit-linked contracts
- R0130Deposits from reinsurers and insurance, intermediaries and reinsurance payables
- R0140Derivatives
- R0150Financial liabilities
- R0160Contingent liabilities
- R0170Any other liabilities
- R0200Total liabilities
Columns
- C0020Total value of all currencies
- C0030Value of the solvency II reporting currency
- C0040Value of remaining other currencies
Assets and liabilities by currency: material currencies (IR.02.02.01.02)
Rows
- R0020Investments (other than assets held for index-linked and unit-linked contracts)
- R0030Other assets: Property, plant & equipment held for own use, Cash and cash equivalents, Loans on policies, Loans & mortgages to individuals and Other loans & mortgages (other than index-linked and unit-linked contracts)
- R0040Assets held for index-linked and unit-linked contracts
- R0050Reinsurance recoverables
- R0060Deposits to cedants, insurance and intermediaries receivables and reinsurance receivables
- R0070Any other assets
- R0100Total assets
- R0110Technical provisions (excluding index-linked and unit-linked contracts)
- R0120Technical provisions - index-linked and unit-linked contracts
- R0130Deposits from reinsurers and insurance, intermediaries and reinsurance payables
- R0140Derivatives
- R0150Financial liabilities
- R0160Contingent liabilities
- R0170Any other liabilities
- R0200Total liabilities
Column
- C0050Value of material currencies
Life technical provisions (IR.12.01.01.01)
Row
- R0200Technical provisions - total
Column
- C0020Index-linked and unit-linked insurance
Which returns it applies to
Line4 Check runs it on annual solo (ARS) and annual group (ARG) returns on Bank of England taxonomy 2.2.0. The Bank of England applies it to annual solo (ARS) and annual group (ARG) 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 value for "Total value of all currencies" reported in IR.02.02 - Assets and liabilities by currency should be equal to the sum of "Value of the solvency II reporting currency", "Value of remaining other currencies" and "Value of material currencies" for all currencies reported.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: IR.02.02.01.01, c: C0020, z: Z0001} = {t: IR.02.02.01.01, c: C0030, z: Z0001} + {t: IR.02.02.01.01, c: C0040, z: Z0001} + sum({t: IR.02.02.01.02, c: C0050, z: Z0001})Other rules on Balance sheet (IR.02.01)
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0720)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0709_01)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0709_02)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0721)Blocking
- Balance sheet: a total must equal the sum of its parts (IR_bv0708_01)Blocking
- Balance sheet: a total must equal the sum of its parts (IR_bv0708_02)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0733_01)Blocking
- Balance sheet and list of assets: a total must equal the sum of its parts (IR_bv0733_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.
