The rule in plain words
The "Total" value of the item reported in column "Total" reported in Own funds (S.23.01) must be equal to the sum of the same item of "Tier 1 - unrestricted", "Tier 1 - restricted", "Tier 2" and "Tier 3"
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.
EIOPA writes it out as separate checks, one for each table or return it covers. Line4 Check runs three of them (BV537-5 to BV537-7), and a failure names the one that failed.
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 blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Own funds (S.23.01.02.01)
Row
- R0290Total basic own funds after deductions
Columns
- C0010Total
- C0020Tier 1 - unrestricted
- C0030Tier 1 - restricted
- C0040Tier 2
- C0050Tier 3
Own funds (S.23.01.05.01)
Row
- R0290Total basic own funds after deductions
Columns
- C0010Total
- C0020Tier 1 - unrestricted
- C0030Tier 1 - restricted
- C0040Tier 2
- C0050Tier 3
Own funds (S.23.01.08.01)
Row
- R0290Total basic own funds after deductions
Columns
- C0010Total
- C0020Tier 1 - unrestricted
- C0030Tier 1 - restricted
- C0040Tier 2
- C0050Tier 3
A worked example
The first of its checks, with simple numbers.
Total must then be 2,750.
A file that reports 2,750 passes. One that reports 2,850 fails, by 100.
The numbers are illustrative, reported to the unit, so the rounding tolerance does not change the result.
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG) and quarterly branch (QRB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly ECB solo (QES), quarterly solo (QRS), quarterly ECB branch (QEB), quarterly branch (QRB) and quarterly group (QRG) returns, as a blocking check.
EIOPA’s own words and formula
In EIOPA’s list of validations, word for word:
The "Total" value of the item reported in column "Total" reported in S.23.01 - Own funds must be equal to the sum of the same item of "Tier 1 - unrestricted", "Tier 1 - restricted", "Tier 2" and "Tier 3".
Show the formulaShowHide
EIOPA's formula, for BV537-5. Cells are written as {t: table, r: row, c: column}.
{t: S.23.01.02.01, c: C0010, z: Z0001} = {t: S.23.01.02.01, c: C0020, z: Z0001} + {t: S.23.01.02.01, c: C0030, z: Z0001} + {t: S.23.01.02.01, c: C0040, z: Z0001} + {t: S.23.01.02.01, c: C0050, z: Z0001}BV537-6:
{t: S.23.01.08.01, c: C0010, z: Z0001} = {t: S.23.01.08.01, c: C0020, z: Z0001} + {t: S.23.01.08.01, c: C0030, z: Z0001} + {t: S.23.01.08.01, c: C0040, z: Z0001} + {t: S.23.01.08.01, c: C0050, z: Z0001}BV537-7:
{t: S.23.01.05.01, c: C0010, z: Z0001} = {t: S.23.01.05.01, c: C0020, z: Z0001} + {t: S.23.01.05.01, c: C0030, z: Z0001} + {t: S.23.01.05.01, c: C0040, z: Z0001} + {t: S.23.01.05.01, c: C0050, z: Z0001}Other rules on Own funds (S.23.01)
- Own funds: a total must equal the sum of its parts (BV536)Blocking
- Own funds: two values must match (BV539)Blocking
- Own funds: two values must match (BV540)Blocking
- Own funds: two values must match (BV541)Blocking
- The value reported in column "Total" reported in Own funds must be equal to the value reported as "Tier 2" (BV532)Blocking
- Own funds: values must agree (BV542)Blocking
- The value reported in column "Total" reported in Own funds must be equal to the value reported as "Tier 3" (BV531)Blocking
- Own funds: a conditional check (BV543_1)
Every Solvency II rule on S.23.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.
