The rule in plain words
In column "Initial stock" (column 010) of PRA110. HQLA and usable liquidity. Initial Stock. Total (CL66.01.01.06): "Total HQLA" (row 7370) must equal the sum of "Cash" (row 7380), "Level 1 Tradable assets" (row 7390), "Level 2A Tradable Assets" (row 7400) and "Level 2B Tradable Assets" (row 7410).
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. Initial stock. Total (CL66.01.01.02)
Rows
- R750Level 1 tradable assets
- R820Level 2A tradable assets
- R860Level 2B tradable assets
Column
- C010Initial stock
PRA110. HQLA and usable liquidity. Initial Stock. Total (CL66.01.01.06)
Rows
- R7370Total HQLA
- R7380Cash
Column
- C010Initial stock
A worked example
With simple numbers.
Total HQLA, Initial stock 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 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_b2018_m: T1: CL66.01.01.06; columns: {CL66.01.01.06, c010}; Expression: {CL66.01.01.06, r7370} = {CL66.01.01.06, r7380} + {CL66.01.01.06, r7390} + {CL66.01.01.06, r7400} + {CL66.01.01.06, r7410}
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: CL66.01.01.06, r: 7370} = {t: CL66.01.01.06, r: 7380} + {t: CL66.01.01.06, r: 7390} + {t: CL66.01.01.06, r: 7400} + {t: CL66.01.01.06, r: 7410}Where it applies, in the Bank's words (its scope):
scope({t: CL66.01.01.06, c: 010, seq: False, f: banking, fv: liquidity_pillarii})Other rules on PRA110. HQLA and usable liquidity. Initial Stock. Total (CL66.01.01.06)
Every PRA banking rule on CL66.01.01.06
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.
