The rule in plain words
The value for "Total value of all currencies" reported in Liabilities by currency (S.02.02) must 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 S.02.02 as reported.
The cells it reads
Balance sheet (S.02.01.01.01)
Rows
- R0690Technical provisions - index-linked and unit-linked
- R0740Contingent liabilities
- R0790Derivatives
- R0900Total liabilities
Column
- C0010Solvency II value
Balance sheet (S.02.01.07.01)
Rows
- R0690Technical provisions - index-linked and unit-linked
- R0740Contingent liabilities
- R0790Derivatives
- R0900Total liabilities
Column
- C0010Solvency II value
Liabilities by currency: all currencies (S.02.02.01.01)
Rows
- 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
Liabilities by currency: material currencies (S.02.02.01.02)
Rows
- 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
Which returns it applies to
Line4 Check runs it on annual solo (ARS), annual group (ARG) and annual branch (ARB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to annual branch (ARB), annual solo (ARS), annual ECB solo (AES), annual ECB branch (AEB) and annual group (ARG) returns, as a blocking check.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
The value for "Total value of all currencies" reported in S.02.02 - Liabilities by currency must 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
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
{t: S.02.02.01.01, c: C0020, z: Z0001} = {t: S.02.02.01.01, c: C0030, z: Z0001} + {t: S.02.02.01.01, c: C0040, z: Z0001} + sum({t: S.02.02.01.02, c: C0050, z: Z0001})Other rules on Balance sheet (S.02.01)
- Balance sheet and 2 other templates: a total must equal the sum of its parts (BV189)Blocking
- Balance sheet: a total must equal the sum of its parts (BV188)Blocking
- Balance sheet: a total must equal the sum of its parts (BV187)Blocking
- The item "Excess of assets over liabilities" reported in Balance sheet must be equal to the "Total assets" minus "Total liabilities" (BV186)Blocking
- The item "Total liabilities" reported in Balance sheet must be equal to the sum of the different items reported above (BV184)Blocking
- Balance sheet: a total must equal the sum of its parts (BV162)Blocking
- The item "Total assets" reported in Balance sheet must be equal to the sum of the different items reported above (BV238_1)Blocking
- Balance sheet and share of reinsurers (including finite reinsurance and SPV's): a value must not be less than another (BV140)Blocking
Every Solvency II rule on S.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.