The rule in plain words
The sum of 'Gross Reported but not Settled Claims (RBNS)' reported in IR.19.01.01.05, in the latest diagonal, for the line of business '12 - 12 and 24 Miscellaneous financial loss' should be higher or equal to the sum of 'Gross RBNS at the end of the period' reported in IR.20.01.01.01, (column c0050, rows (r0010 to r0150); column c0130, rows (r0010 to r0150 and r0170); column c0190, rows (r0010 to r0150), for the line of business '12 - Miscellaneous financial loss insurance'
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 tables below and find the cells the rule reads.
- 02Compare the values in your return. If the first is bigger than it may be, one of them is wrong: check both before you change either.
- 03The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark IR.19.01 and IR.20.01 as reported.
- 05This 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
Non-life claim development: gross reported but not settled claims (RBNS) - development year (absolute amount) (IR.19.01.01.05)
Rows
- R0100Prior
- R0110N-14
- R0120N-13
- R0130N-12
- R0140N-11
- R0150N-10
- R0160N-9
- R0170N-8
- R0180N-7
- R0190N-6
- R0200N-5
- R0210N-4
- R0220N-3
- R0230N-2
- R0240N-1
- R0250N
Columns
- C04000
- C04101
- C04202
- C04303
- C04404
- C04505
- C04606
- C04707
- C04808
- C04909
- C050010
- C051011
- C052012
- C053013
- C054014
- C055015 & +
Development of the distribution of claims incurred: development of the distribution of the claim incurred (IR.20.01.01.01)
Rows
- R0010Prior years
- R0020N-14
- R0030N-13
- R0040N-12
- R0050N-11
- R0060N-10
- R0070N-9
- R0080N-8
- R0090N-7
- R0100N-6
- R0110N-5
- R0120N-4
- R0130N-3
- R0140N-2
- R0150N-1
- R0170N
Columns
- C0050Gross RBNS at the end of the period
- C0130Gross RBNS at the end of the period
- C0190Gross RBNS at the end of the period
Which returns it applies to
Line4 Check runs it on annual solo (ARS) and annual third-country branch (ARB) returns on Bank of England taxonomy 2.2.0. The Bank of England applies it to annual solo (ARS) and annual third-country branch (ARB) 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}.
sum({t: IR.20.01.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150, c: C0050, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:BL] = [s2c_LB:x146]}) + sum({t: IR.20.01.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150, c: C0050, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:BL] = [s2c_LB:x146]}) + sum({t: IR.20.01.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150; R0170, c: C0130, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:BL] = [s2c_LB:x146]}) + sum({t: IR.20.01.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150; R0170, c: C0130, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:BL] = [s2c_LB:x146]}) + sum({t: IR.20.01.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150, c: C0190, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:BL] = [s2c_LB:x146]}) + sum({t: IR.20.01.01.01, r: R0010; R0020; R0030; R0040; R0050; R0060; R0070; R0080; R0090; R0100; R0110; R0120; R0130; R0140; R0150, c: C0190, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:BL] = [s2c_LB:x146]}) <= {t: IR.19.01.01.05, r: R0100, c: C0550, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0110, c: C0540, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0120, c: C0530, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0130, c: C0520, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0140, c: C0510, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0150, c: C0500, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0160, c: C0490, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0170, c: C0480, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0180, c: C0470, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0190, c: C0460, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0200, c: C0450, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0210, c: C0440, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0220, c: C0430, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0230, c: C0420, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0240, c: C0410, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0250, c: C0400, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x88] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0100, c: C0550, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0110, c: C0540, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0120, c: C0530, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0130, c: C0520, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0140, c: C0510, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0150, c: C0500, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0160, c: C0490, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0170, c: C0480, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0180, c: C0470, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0190, c: C0460, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0200, c: C0450, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0210, c: C0440, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0220, c: C0430, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0230, c: C0420, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0240, c: C0410, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]} + {t: IR.19.01.01.05, r: R0250, c: C0400, z: Z0001, filter: [s2c_dim:AX] = [s2c_AM:x4] and [s2c_dim:OC] = [s2c_CU:x0] and [s2c_dim:BL] = [s2c_LB:x70]}Other rules on Non-life claim development (IR.19.01)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1858)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1859)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1860)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1861)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1862)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1863)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1864)
- Non-life claim development and development of the distribution of claims incurred: a value must not be more than another (IR_bv1865)
Every Solvency UK rule on IR.19.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.