The rule in plain words
The item "Excess of assets over liabilities" reported in Balance sheet (S.02.01) must be equal to the "Total assets" minus "Total liabilities"
EIOPA writes it out as separate checks, one for each table or return it covers. Line4 Check runs three of them (BV186-1 to BV186-5), and a failure names the one that failed.
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.01 as reported.
The cells it reads
Balance sheet (S.02.01.01.01)
Rows
- R0500Total assets
- R0900Total liabilities
- R1000Excess of assets over liabilities
Column
- C0020Statutory accounts value
Balance sheet (S.02.01.07.01)
Rows
- R0500Total assets
- R0900Total liabilities
- R1000Excess of assets over liabilities
Column
- C0020Branch management accounts value
Which returns it applies to
Line4 Check runs it on annual solo (ARS), annual group (ARG), annual branch (ARB) and financial stability group (QFG) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to annual solo (ARS), annual group (ARG), annual branch (ARB) and financial stability group (QFG) returns. It is blocking for ARS, ARG and ARB, and a warning for QFG.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
The item "Excess of assets over liabilities" reported in S.02.01 - Balance sheet must be equal to the "Total assets" minus "Total liabilities".
Show the formulaShowHide
EIOPA's formula, for BV186-1. Cells are written as {t: table, r: row, c: column}.
{t: S.02.01.01.01, r: R1000} = {t: S.02.01.01.01, r: R0500} - {t: S.02.01.01.01, r: R0900}BV186-3:
{t: S.02.01.07.01, r: R1000} = {t: S.02.01.07.01, r: R0500} - {t: S.02.01.07.01, r: R0900}BV186-5:
{t: S.02.01.01.01, r: R1000} = {t: S.02.01.01.01, r: R0500} - {t: S.02.01.01.01, r: R0900}Other rules on Balance sheet (S.02.01)
- Balance sheet: a total must equal the sum of its parts (BV187)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 (BV188)Blocking
- Balance sheet and 2 other templates: a total must equal the sum of its parts (BV189)Blocking
- Balance sheet and liabilities by currency: values must agree (BV191)Blocking
- Balance sheet: a total must equal the sum of its parts (BV162)Blocking
- Balance sheet and share of reinsurers (including finite reinsurance and SPV's): a value must not be less than another (BV140)Blocking
- Balance sheet and own funds: two values must match (BV139)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.
