Line4

2 min readWarningBank of England banking taxonomy 4.1.1Updated 11 November 2026

"Total HQLA" must equal the sum of "Cash", "Level 1 Tradable assets", "Level 2A Tradable Assets" and "Level 2B Tradable Assets" (CL66.01.01.07, Bank of England check boe_b2019_m)

A warning on the PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total template (CL66.01.01.07), in the liquidity pillar II (PRA110) return.

Line4 Check runs it on the liquidity pillar II (PRA110) return, proven on test files, check by check: the same outcome on all three test files of that return.

Check your file for this ruleWhat to do if it fails

The rule in plain words

In each of 106 columns (listed below) of PRA110. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07): "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

  1. 01Open the table below and find the cells the rule reads.
  2. 02Add up the parts in your return and compare the result with the total.
  3. 03If they differ, a part is missing, a value sits in the wrong cell, or the total is out of date.
  4. 04The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
  5. 05It runs only when your filing indicators mark CL66.01.01 as reported.
  6. 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. HQLA and usable liquidity. Overnight and higher maturity. Total (CL66.01.01.07)

Rows

  • R7370Total HQLA
  • R7380Cash
  • R7390Level 1 Tradable assets
  • R7400Level 2A Tradable Assets
  • R7410Level 2B Tradable Assets

Columns

  • C020Overnight
  • C030Greater than overnight up to 2 days
  • C040Greater than 2 days up to 3 days
  • C050Greater than 3 days up to 4 days
  • C060Greater than 4 days up to 5 days
  • C070Greater than 5 days up to 6 days
  • C080Greater than 6 days up to 7 days
  • C090Greater than 7 days up to 2 weeks
  • C100Greater than 2 weeks up to 3 weeks
  • C110Greater than 3 weeks up to 30 days
  • C120Greater than 30 days up to 5 weeks
  • C130Greater than 5 weeks up to 2 months
  • C140Greater than 2 months up to 3 months
  • C150Greater than 3 months up to 4 months
  • C160Greater than 4 months up to 5 months
  • C170Greater than 5 months up to 6 months
  • C180Greater than 6 months up to 9 months
  • C190Greater than 9 months up to 12 months
  • C200Greater than 12 months up to 2 years
  • C210Greater than 2 years up to 5 years
  • C220Greater than 5 years
  • C6020Day 8
  • C6030Day 9
  • C6040Day 10
  • C6050Day 11
  • C6060Day 12
  • C6070Day 13
  • C6080Day 14
  • C6090Day 15
  • C7000Day 16
  • C7010Day 17
  • C7020Day 18
  • C7030Day 19
  • C7040Day 20
  • C7050Day 21
  • C7060Day 22
  • C7070Day 23
  • C7080Day 24
  • C7090Day 25
  • C7100Day 26

And 66 more.

A worked example

With simple numbers.

Illustrative values
Cash1,200
Level 1 Tradable assets800
Level 2A Tradable Assets450
Level 2B Tradable Assets300
Together2,750
What the rule then expects

Total HQLA must then be 2,750.

2,750Passes
2,850Fails

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_b2019_m: T1: CL66.01.01.07; columns: {CL66.01.01.07, c020;c030;c040;c050;c060;c070;c080;c6020;c6030;c6040;c6050;c6060;c6070;c6080;c6090;c7000;c7010;c7020;c7030;c7040;c7050;c7060;c7070;c7080;c7090;c7100;c7110;c7120;c7130;c7140;c7150;c7160;c7170;c7180;c7190;c7200;c7210;c7220;c7230;c7240;c7250;c7260;c7270;c7280;c7290;c7300;c7310;c7320;c7330;c7340;c7350;c7360;c7370;c7380;c7390;c7400;c7410;c7420;c7430;c7440;c7450;c7460;c7470;c7480;c7490;c7500;c7510;c7520;c7530;c7540;c7550;c7560;c7570;c7580;c7590;c7600;c7610;c7620;c7630;c7640;c7650;c7660;c7670;c7680;c7690;c7700;c7710;c7720;c7730;c7740;c7750;c7760;c090;c100;c110;c120;c130;c140;c150;c160;c170;c180;c190;c200;c210;c220}; Expression: {CL66.01.01.07, r7370} = {CL66.01.01.07, r7380} + {CL66.01.01.07, r7390} + {CL66.01.01.07, r7400} + {CL66.01.01.07, r7410}
Show the formulaShow

The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.

{t: CL66.01.01.07, r: 7370} = {t: CL66.01.01.07, r: 7380} + {t: CL66.01.01.07, r: 7390} + {t: CL66.01.01.07, r: 7400} + {t: CL66.01.01.07, r: 7410}

Where it applies, in the Bank's words (its scope):

scope({t: CL66.01.01.07, c: 020; 030; 040; 050; 060; 070; 080; 6020; 6030; 6040; 6050; 6060; 6070; 6080; 6090; 7000; 7010; 7020; 7030; 7040; 7050; 7060; 7070; 7080; 7090; 7100; 7110; 7120; 7130; 7140; 7150; 7160; 7170; 7180; 7190; 7200; 7210; 7220; 7230; 7240; 7250; 7260; 7270; 7280; 7290; 7300; 7310; 7320; 7330; 7340; 7350; 7360; 7370; 7380; 7390; 7400; 7410; 7420; 7430; 7440; 7450; 7460; 7470; 7480; 7490; 7500; 7510; 7520; 7530; 7540; 7550; 7560; 7570; 7580; 7590; 7600; 7610; 7620; 7630; 7640; 7650; 7660; 7670; 7680; 7690; 7700; 7710; 7720; 7730; 7740; 7750; 7760; 090; 100; 110; 120; 130; 140; 150; 160; 170; 180; 190; 200; 210; 220, seq: False, f: banking, fv: liquidity_pillarii})

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.