The rule in plain words
EXPOSURE VALUE cross-template consistency for TOTAL RETAIL exposures
In Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1) (OF09.01.01.01): "Retail" in column "Exposure value" (row 0080, column 0075) (where country where the exposure is generated is "All countries") must equal "Total exposures" in column "Exposure value" (row 0010, column 0200) on sheet "Retail" (sheet 0009) in Credit and counterparty credit risks and free deliveries: standardised approach to capital requirements (CR SA) (OF07.00.01.01).
What to do if your return fails it
- 01Open the tables below and find the cells the rule reads.
- 02The two values must be the same. Find which of the two is right, and correct the other one.
- 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 OF07.00.01 and OF09.01.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
Credit and counterparty credit risks and free deliveries: standardised approach to capital requirements (CR SA) (OF07.00.01.01)
Row
- R0010Total exposures
Column
- C0200Exposure value
Sheet
- S0009Retail
Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1) (OF09.01.01.01)
Row
- R0080Retail
Column
- C0075Exposure value
Credit and counterparty credit risks and free deliveries: standardised approach to capital requirements for SDDTs (CR SA SDDT) (SC07.00.01.01)
Row
- R0010Total exposures
Column
- C0200Exposure value
Sheet
- S0009Retail
Geographical breakdown of exposures by residence of the obligor (SA EXPOSURES) (CR GB 1) (SC09.01.01.01)
Row
- R0080Retail
Column
- C0075Exposure value
Which returns it applies to
Line4 Check runs it on the own funds (PRA001) and own funds for SDDTs (PRA116) returns on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to own funds for SDDTs (PRA116) and own funds (PRA001) returns, as a warning.
The Bank’s own words and formula
The first paragraph of the plain words above is the Bank of England’s own, word for word, from its list of validations. The second spells out its formula, with each cell named from its templates.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: OF09.01.01.01, r: 0080, c: 0075, filter: [eba_dim:CEG] = [eba_GA:x1]} = {t: OF07.00.01.01, r: 0010, c: 0200, z: 0009}Other rules on Geographical breakdown of exposures by residence of the obligor: SA exposures (OF CR GB 1) (OF09.01.01.01)
- Original exposure pre conversion factors cross-template consistency for total retail Exposures (boe_b0228)
- Risk-weighted exposure amount cross-template consistency for total retail exposures (boe_b0230)
- Risk-weighted exposure amount cross-template consistency for s0008 Total Corporates exposures of which SME (boe_b0227)
- Original exposure pre conversion factors cross-template consistency for retail: of which SME exposures (boe_b0231)
- Exposure value cross-template consistency for s0008 Corporates of which SME (boe_b0226)
- Exposure value cross-template consistency for retail: of which SME exposures (boe_b0232)
- Original exposure pre conversion factors cross-template consistency for s0008 Corporates of which SME (boe_b0225)
- Risk-weighted exposure amount cross-template consistency for retail: of which SME exposures (boe_b0233)
Every PRA banking rule on OF09.01.01.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.
