The rule in plain words
The item "Property, other than for own use" reported in the template S.02.01- Balance sheet must be equal to the total "Property, other than own use" that is not held in index-linked and unit-linked contracts reported in template List of assets (S.06.02) (CIC '##91', ##92', '##94', '##99')
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 four of them (BV135-1 to BV135-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.02.01 and S.06.02 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
Balance sheet (S.02.01.01.01)
Row
- R0080Property (other than for own use)
Column
- C0010Solvency II value
Balance sheet (S.02.01.02.01)
Row
- R0080Property (other than for own use)
Column
- C0010Solvency II value
Balance sheet (S.02.01.07.01)
Row
- R0080Property (other than for own use)
Column
- C0010Solvency II value
Balance sheet (S.02.01.08.01)
Row
- R0080Property (other than for own use)
Column
- C0010Solvency II value
List of assets: information on positions held (S.06.02.01.01)
Columns
- C0090Asset held in unit linked and index linked contracts
- C0170Total Solvency II amount
List of assets: information on assets (S.06.02.01.02)
Column
- C0290CIC
List of assets: information on positions held (S.06.02.07.01)
Columns
- C0090Asset held in unit linked and index linked contracts
- C0170Total Solvency II amount
List of assets: information on assets (S.06.02.07.02)
Column
- C0290CIC
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly branch (QRB), annual solo (ARS) and annual branch (ARB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to annual solo (ARS), quarterly solo (QRS), annual branch (ARB) 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 item "Property, other than for own use" reported in the template S.02.01- Balance sheet must be equal to the total "Property, other than own use" that is not held in index-linked and unit-linked contracts reported in template S.06.02 - List of assets (CIC '##91', ##92', '##94', '##99').
Show the formulaShowHide
EIOPA's formula, for BV135-3. Cells are written as {t: table, r: row, c: column}.
{t: S.02.01.02.01, r: R0080, c: C0010} = sum({t: S.06.02.01.01, c: C0170, z: Z0001})BV135-1:
{t: S.02.01.01.01, r: R0080, c: C0010} = sum({t: S.06.02.01.01, c: C0170, z: Z0001})BV135-5:
{t: S.02.01.07.01, r: R0080, c: C0010} = sum({t: S.06.02.07.01, c: C0170, z: Z0001})BV135-7:
{t: S.02.01.08.01, r: R0080, c: C0010} = sum({t: S.06.02.07.01, c: C0170, 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 (BV137)Blocking
- Balance sheet and 2 other templates: a total must equal the sum of its parts (BV138)Blocking
- Balance sheet and own funds: two values must match (BV139)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 liabilities by currency: a total must equal the sum of its parts (BV125)Blocking
- Balance sheet: a total must equal the sum of its parts (BV162)Blocking
- Balance sheet and liabilities by currency: a total must equal the sum of its parts (BV104)Blocking
- The item "Total liabilities" reported in Balance sheet must be equal to the sum of the different items reported above (BV184)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.
