The rule in plain words
IR.12.06 should not have data if there is data in IRR.12.06
What to do if your return fails it
- 01Open the tables below and find the cells the rule reads.
- 02The check applies only when its first part holds in your return. When it does, the second part must hold too: fix the second part, or correct the first.
- 03It runs only when your filing indicators mark IR.12.06 and IRR.12.06 as reported.
- 04This 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
With-profits liabilities and assets (IRR.12.06.01.01)
Rows
- R0010With-profits benefits reserve
- R0020Asset shares where applicable
- R0030Total past miscellaneous surplus included in WPBR
- R0040Miscellaneous surplus added at valuation date included in WPBR
- R0050Prospective reserve where asset shares not applicable
- R0060Future policy related liabilities
- R0070Future costs of contractual guarantees
- R0080Future costs of non-contractual commitments
- R0090Future costs of financial options
- R0100Future costs of smoothing (possibly negative)
- R0110Financing costs
- R0120Other with-profits insurance liabilities
- R0130Planned deductions for guarantees, options and smoothing
- R0140Planned deductions for other costs
- R0150Total with-profits best estimate liabilities
- R0160Overall investment return post investment costs but pre-tax
- R0170Investment return allocated to non taxable 'asset shares'
- R0180Investment return allocated to taxable 'asset shares'
- R0190Miscellaneous surplus adjustment to investment return
- R0200Government bonds
- R0210Corporate bonds
- R0220Equity
- R0230Property
- R0240Cash
- R0250Other assets
- R0260Government bonds
- R0270Corporate bonds
- R0280Equity
- R0290Property
- R0300Cash
- R0310Other assets
Column
- C0030Amount
Life technical provisions (IR.12.01.01.01)
Row
- R0030Gross Best Estimate
Column
- C0010Insurance with profit participation
Life best estimate liabilities by country (IR.12.03.01.01)
Row
- R0030Gross Best Estimate
Column
- C0010Insurance with profit participation
With-profits liabilities and assets (IR.12.06.01.01)
Rows
- R0010With-profits benefits reserve
- R0020Asset shares where applicable
- R0030Total past miscellaneous surplus included in WPBR
- R0040Miscellaneous surplus added at valuation date included in WPBR
- R0050Prospective reserve where asset shares not applicable
- R0060Future policy related liabilities
- R0070Future costs of contractual guarantees
- R0080Future costs of non-contractual commitments
- R0090Future costs of financial options
- R0100Future costs of smoothing (possibly negative)
- R0110Financing costs
- R0120Other with-profits insurance liabilities
- R0130Planned deductions for guarantees, options and smoothing
- R0140Planned deductions for other costs
- R0150Total with-profits best estimate liabilities
- R0160Overall investment return post investment costs but pre-tax
- R0170Investment return allocated to non taxable 'asset shares'
- R0180Investment return allocated to taxable 'asset shares'
- R0190Miscellaneous surplus adjustment to investment return
- R0200Government bonds
- R0210Corporate bonds
- R0220Equity
- R0230Property
- R0240Cash
- R0250Other assets
- R0260Government bonds
- R0270Corporate bonds
- R0280Equity
- R0290Property
- R0300Cash
- R0310Other assets
Column
- C0030Amount
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 warning.
The Bank’s own words and formula
The plain words above are the Bank of England’s own, word for word, from its list of validations.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
if not(isNull({t: IRR.12.06.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150; R0160; R0170; R0180; R0190; R0200; R0210; R0220; R0230; R0240; R0250; R0260; R0270; R0280; R0290; R0300; R0310, c: C0030, z: Z0001})) then isNull({t: IR.12.06.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150; R0160; R0170; R0180; R0190; R0200; R0210; R0220; R0230; R0240; R0250; R0260; R0270; R0280; R0290; R0300; R0310, c: C0030}) else true()Other rules on With-profits liabilities and assets (IRR.12.06)
- With-profits liabilities and assets: R0020 (asset shares) >= 0 (IR_bv1814)
- With-profits liabilities and assets: R0010 (with-profits benefits reserve) = r0020 (asset shares) + r0050 (prospective reserve) (IR_bv1815)Blocking
- With-profits liabilities and assets: values must agree (IR_bv1818)Blocking
- With-profits liabilities and assets: values must agree (IR_bv1820)Blocking
- With-profits liabilities and assets: values must agree (IR_bv1825)Blocking
Every Solvency UK rule on IRR.12.06
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.
