The rule in plain words
In PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07): "Total Usable Liquidity Resources" in column "Day 46" (row 7420, column 7300) must equal the sum of "Cash" in column "Day 46" (row 7380, column 7300) and "Outflows which can be met by posting securities (Total)" in column "Day 46" (row 7240, column 7300) in PRA110. Overnight and higher maturity. Total (CL66.01.01.01).
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.
- 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 CL66.01.01 as reported.
- 06This 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
- C7300Day 46
PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07)
Rows
- R7380Cash
- R7420Total Usable Liquidity Resources
Column
- C7300Day 46
A worked example
With simple numbers.
Total Usable Liquidity Resources, Day 46 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 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_b2023_47_m: T1: CL66.01.01.07; T2: CL66.01.01.01; Expression: {CL66.01.01.07, r7420, c7300} = {CL66.01.01.07, r7380, c7300} + {CL66.01.01.01, r7240, c7300}
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: CL66.01.01.07, r: 7420, c: 7300} = {t: CL66.01.01.07, r: 7380, c: 7300} + {t: CL66.01.01.01, r: 7240, c: 7300}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 total must equal the sum of its parts (boe_b2023_1_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_3_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_4_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_5_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_6_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_7_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_8_m)
- PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total: a total must equal the sum of its parts (boe_b2023_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.
