The rule in plain words
In each of 9 columns (listed below) of Intragroup financial reporting (detailed breakdown) Financial assets subject to impairment that are past due (SR07.01.04.01): "Total debt instruments" (row 0190) must equal the sum of "Debt securities" (row 0060) and "Loans and advances" (row 0120).
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 SR07.01.04 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
Intragroup financial reporting (detailed breakdown) Financial assets subject to impairment that are past due (SR07.01.04.01)
Rows
- R0060Debt securities
- R0120Loans and advances
- R0190Total debt instruments
Columns
- C0010<= 30 days
- C0020> 30 days <= 90 days
- C0030> 90 days
- C0040<= 30 days
- C0050> 30 days <= 90 days
- C0060> 90 days
- C0070<= 30 days
- C0080> 30 days <= 90 days
- C0090> 90 days
A worked example
With simple numbers.
Total debt instruments must then be 2,000.
A file that reports 2,000 passes. One that reports 2,100 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 the intragroup financial reporting (core and detailed breakdowns) (RFB004) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to intragroup financial reporting (core and detailed breakdowns) (RFB004) returns, as a blocking check.
The Bank’s own words and formula
The plain words above spell out the Bank’s formula, with each cell named from its templates. In the Bank of England’s list of validations, word for word:
boe_v0826_m: T1: SR07.01.04.01; columns: {SR07.01.04.01, c0010-0090}; Expression: {SR07.01.04.01, r0190} = {SR07.01.04.01, r0060} + {SR07.01.04.01, r0120}
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: SR07.01.04.01, r: 0190} = {t: SR07.01.04.01, r: 0060} + {t: SR07.01.04.01, r: 0120}Where it applies, in the Bank's words (its scope):
scope({t: SR07.01.04.01, c: 0010; 0020; 0030; 0040; 0050; 0060; 0070; 0080; 0090, seq: False, f: banking, fv: structural_reform})Other rules on Intragroup financial reporting (detailed breakdown) Financial assets subject to impairment that are past due (SR07.01.04.01)
- Every value in the cells it covers must be zero or more (boe_v5677_s)Blocking
Every PRA banking rule on SR07.01.04.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.
