The rule in plain words
The "Total" value of the item "Excess of assets over liabilities" should be equal to sum of "Own shares (held directly and indirectly)", "Foreseeable dividends, distributions and charges", "Other basic own fund items", "Adjustment for restricted own fund items in respect of ring fenced funds" and "Reconciliation reserve", reported in S.23.01.02.02
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 tables 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.
- 04EIOPA allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark S.23.01 as reported.
- 06This is a warning. It does not stop the return on its own, but your supervisor may ask you to explain it.
The cells it reads
Balance sheet (S.02.01.02.01)
Row
- R1000Excess of assets over liabilities
Column
- C0010Solvency II value
Own funds (S.23.01.02.01)
Row
- R0130Reconciliation reserve
Column
- C0010Total
Own funds: reconciliation reserve (S.23.01.02.02)
Rows
- R0710Own shares (held directly and indirectly)
- R0720Foreseeable dividends, distributions and charges
- R0730Other basic own fund items
- R0740Adjustment for restricted own fund items in respect of ring fenced funds
Column
- C0060Value
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS) return on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly ECB solo (QES) and quarterly solo (QRS) returns, as a warning.
EIOPA’s own words and formula
The plain words above are EIOPA’s own, word for word, from its list of validations.
Show the formulaShowHide
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
{t: S.23.01.02.02, r: R0700, c: C0060, z: Z0001} = sum({t: S.23.01.02.02, r: R0710; R0720; R0730; R0740; R0760, c: C0060, z: Z0001})Other rules on Balance sheet (S.02.01)
- Balance sheet and own funds: a total must equal the sum of its parts (BV2027)
- Balance sheet and life and health SLT technical provisions: a value must not be less than another (BV1538)
- Balance sheet and life and health SLT technical provisions: a value must not be less than another (BV1537)
- Balance sheet and life and health SLT technical provisions: a value must not be more than another (BV1530)
- Balance sheet and life and health SLT technical provisions: a value must not be more than another (BV1529)
- Balance sheet and premiums, claims and expenses by line of business: a conditional check (BV972)
- Balance sheet and non-life technical provisions: a total must equal the sum of its parts (BV730)Blocking
- Balance sheet and non-life technical provisions: a total must equal the sum of its parts (BV729)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.
