The rule in plain words
In PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07): "Outflows which can be met by posting securities (Total)" in column "Greater than 4 months up to 5 months" (row 7240, column 160) in PRA110. Overnight and higher maturity. Total (CL66.01.01.01) must not be more than the sum of "Level 1 Tradable assets" in column "Greater than 4 months up to 5 months" (row 7390, column 160), "Level 2A Tradable Assets" in column "Greater than 4 months up to 5 months" (row 7400, column 160) and "Level 2B Tradable Assets" in column "Greater than 4 months up to 5 months" (row 7410, column 160).
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 CL66.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
PRA110. Overnight and higher maturity. Total (CL66.01.01.01)
Row
- R7240Outflows which can be met by posting securities (Total)
Column
- C160Greater than 4 months up to 5 months
PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07)
Rows
- R7390Level 1 Tradable assets
- R7400Level 2A Tradable Assets
- R7410Level 2B Tradable Assets
Column
- C160Greater than 4 months up to 5 months
Which returns it applies to
Line4 Check runs it on the liquidity pillar II (PRA110) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to liquidity pillar II (PRA110) returns, as a warning.
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_b2008_101_m: T1: CL66.01.01.01; T2: CL66.01.01.07; Expression: {CL66.01.01.01, r7240, c160} <= {CL66.01.01.07, r7390, c160} + {CL66.01.01.07, r7400, c160} + {CL66.01.01.07, r7410, c160}
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: CL66.01.01.01, r: 7240, c: 160} <= {t: CL66.01.01.07, r: 7390, c: 160} + {t: CL66.01.01.07, r: 7400, c: 160} + {t: CL66.01.01.07, r: 7410, c: 160}Other rules on PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_1_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_3_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_4_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_5_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_6_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_7_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_8_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a value must not be more than another (boe_b2008_9_m)
Every PRA banking rule on CL66.01.01.07
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.
