The rule in plain words
The "Total" value of "Reconciliation reserve before deduction for participations" reported in the template Own funds (S.23.01) must be equal to sum of the same item "Excess of assets over liabilities" less "Other basic own fund items" less "Adjustment for restricted own fund items in respect of ring fenced funds"
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.23.01 as reported.
The cells it reads
Balance sheet (S.02.01.08.01)
Row
- R1000Excess of assets over liabilities
Column
- C0010Solvency II value
Own funds (S.23.01.08.01)
Row
- R0130Reconciliation reserve
Column
- C0010Total
Own funds: reconciliation reserve (S.23.01.08.02)
Rows
- 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 branch (QRB) return on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly ECB branch (QEB) and quarterly branch (QRB) returns, as a blocking check.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
The "Total" value of "Reconciliation reserve before deduction for participations" reported in the template S.23.01 - Own funds must be equal to sum of the same item "Excess of assets over liabilities" less "Other basic own fund items" less "Adjustment for restricted own fund items in respect of ring fenced funds".
Show the formulaShowHide
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
{t: S.23.01.08.02, r: R0760, z: Z0001} = {t: S.23.01.08.02, r: R0700, z: Z0001} - {t: S.23.01.08.02, r: R0730, z: Z0001} - {t: S.23.01.08.02, r: R0740, z: Z0001} - {t: S.23.01.08.02, r: R0720, z: Z0001}Other rules on Balance sheet (S.02.01)
- Balance sheet and own funds: values must agree (BV551)Blocking
- If the item "Best estimate" reported in Balance sheet is not equal to zero, the item "Risk margin" should be strictly positive (BV708)
- Balance sheet and own funds: a value must not be more than another (BV395)Blocking
- If the item "Best estimate" reported in Balance sheet is not equal to zero, the item "Risk margin" should be strictly positive (BV709)
- If the item "Best estimate" reported in Balance sheet is not equal to zero, the item "Risk margin" should be strictly positive (BV710)
- If the item "Best estimate" reported in Balance sheet is not equal to zero, the item "Risk margin" should be strictly positive (BV711)
- If the item "Best estimate" reported in Balance sheet is not equal to zero, the item "Risk margin" should be strictly positive (BV712)
- The item "Total assets" reported in Balance sheet should be positive (BV714)
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.
