The rule in plain words
The item "Total collateral pledge" reported in Off-balance sheet items - general (IR.03.01.01.02) should be equal to the sum of "Collateral pledged for loans received or bonds issued", "Collateral pledged for derivatives", "Assets pledged to cedants for technical provisions (reinsurance accepted)" and "Other collateral pledged"
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.03.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
Off-balance sheet items - general: value of guaranteed assets and liabilities (IR.03.01.01.02)
Rows
- R0210Collateral pledged for loans received or bonds issued
- R0220Collateral pledged for derivatives
- R0230Assets pledged to cedants for technical provisions (reinsurance accepted)
- R0240Other collateral pledged
- R0300Total collateral pledged
Column
- C0040Value of liabilities for which collateral is pledged
A worked example
With simple numbers.
Total collateral pledged 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 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 item "Total collateral pledge" reported in IR.03.01.01.02 - Off-balance sheet items - general should be equal to the sum of "Collateral pledged for loans received or bonds issued", "Collateral pledged for derivatives", "Assets pledged to cedants for technical provisions (reinsurance accepted)" and "Other collateral pledged".
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: IR.03.01.01.02, r: R0300, c: C0040} = {t: IR.03.01.01.02, r: R0210, c: C0040} + {t: IR.03.01.01.02, r: R0220, c: C0040} + {t: IR.03.01.01.02, r: R0230, c: C0040} + {t: IR.03.01.01.02, r: R0240, c: C0040}Other rules on Off-balance sheet items - general (IR.03.01)
- Off-balance sheet items - general: a total must equal the sum of its parts (IR_bv0611_01)Blocking
- Off-balance sheet items - general: a total must equal the sum of its parts (IR_bv0611_03)Blocking
- Off-balance sheet items - general: a total must equal the sum of its parts (IR_bv0611_04)Blocking
- Off-balance sheet items - general: a total must equal the sum of its parts (IR_bv0612_01)Blocking
- Off-balance sheet items - general: a total must equal the sum of its parts (IR_bv0612_02)Blocking
- Off-balance sheet items - general: a value must not be more than another (IR_bv0492)Blocking
- Off-balance sheet items - general: a value must not be more than another (IR_bv0491)Blocking
- Off-balance sheet items - general and outwards reinsurance balance sheet exposures: a value must not be less than another (IR_bv0782_01)Blocking
Every Solvency UK rule on IR.03.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.
