The rule in plain words
The "Reserves from financial statements adjusted for Solvency II valuation differences" reported in Detailed information by tiers on own funds (IR.23.02.01.03) should be equal to the "Difference in the valuation of assets" minus the Difference in the valuation of technical provisions" minus the "Difference in the valuation of other liabilities" plus the "Total of reserves and retained earnings from financial statements" plus "Other"
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 table 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.
- 04The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark IR.23.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
Detailed information by tiers on own funds: excess of assets over liabilities - attribution of valuation differences (IR.23.02.01.03)
Rows
- R0600Difference in the valuation of assets
- R0610Difference in the valuation of technical provisions
- R0620Difference in the valuation of other liabilities
- R0630Total of reserves and retained earnings from financial statements
- R0640Other, please explain why you need to use this line
- R0650Reserves from financial statements adjusted for Solvency II valuation differences
Column
- C0110Total
Which returns it applies to
Line4 Check runs it on annual solo (ARS) return on Bank of England taxonomy 2.2.0. The Bank of England applies it to annual solo (ARS) returns, as a blocking check.
The Bank’s own words and formula
In the Bank of England’s list of validations, word for word:
The "Reserves from financial statements adjusted for Solvency II valuation differences" reported in IR.23.02.01.03 - Detailed information by tiers on own funds should be equal to the "Difference in the valuation of assets" minus the Difference in the valuation of technical provisions" minus the "Difference in the valuation of other liabilities" plus the "Total of reserves and retained earnings from financial statements" plus "Other".
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: IR.23.02.01.03, r: R0650, c: C0110} = {t: IR.23.02.01.03, r: R0600, c: C0110} - {t: IR.23.02.01.03, r: R0610, c: C0110} - {t: IR.23.02.01.03, r: R0620, c: C0110} + {t: IR.23.02.01.03, r: R0630, c: C0110} + {t: IR.23.02.01.03, r: R0640, c: C0110}Other rules on Detailed information by tiers on own funds (IR.23.02)
- Detailed information by tiers on own funds: two values must match (IR_bv0504_01)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0504_02)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0503_01)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0503_02)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0502_01)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0502_02)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0501_01)Blocking
- Detailed information by tiers on own funds: two values must match (IR_bv0501_02)Blocking
Every Solvency UK rule on IR.23.02
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.
