The rule in plain words
L2A collateral 30 day outflows, value / percentage must equal these 27 worked out:
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0279)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0279)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0279)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0319)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0319)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0319)
- Minus memorandum items secured by L2A, exempted from the cap on inflows
- Minus memorandum items secured by L2A, subject to the 90% cap on inflows
- Minus memorandum items secured by L2A, subject to the 75% cap on inflows
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0930)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1950)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2290)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2460)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2630)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0590)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0250)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1270)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1440)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1100)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1610)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0080)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0420)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0760)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1780)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2120)
- Minus collateral borrowed is L2A, liquidity value of collateral borrowed
- Central institutions: Level 2A assets which are considered liquid assets for the depositing credit institution, value according to Article 9
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
C_76.00.A: L2A collateral 30 day outflows = C_74.00.A: Level 2A collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0279) + C_74.00.A: Level 2A collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0279) + C_74.00.A: Level 2A collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0279) + C_74.00.A: Level 2A collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0319) + C_74.00.A: Level 2A collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0319) + C_74.00.A: Level 2A collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0319) - C_74.00.A: of which: secured by L2A, Exempted from the cap on inflows - C_74.00.A: of which: secured by L2A, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L2A, Subject to the 75% cap on inflows + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0930) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1950) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2290) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2460) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2630) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0590) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0250) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1270) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1440) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1100) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1610) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0080) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0420) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0760) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1780) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2120) - C_75.01.A: of which: collateral borrowed is L2A, Liquidity value of collateral borrowed + C_72.00.A: Central institutions: Level 2A assets which are considered liquid assets for the depositing credit institution, Value according to Article 9
What to do if your filing fails it
- 01Open the templates below and find the cells the rule reads.
- 02Work out both sides from your file, as the rule in plain words sets out, and compare them.
- 03EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark C 76.00 as reported.
- 05This is a warning. It does not stop the filing on its own, but your authority may ask you to explain it.
The cells it reads
Liquidity coverage , liquid assets, total (DA) (C 72.00.a)
Row
- 0300Central institutions: Level 2A assets which are considered liquid assets for the depositing credit institution
Column
- 0040Value according to Article 9
Liquidity coverage, inflows, total (DA) (C 74.00.a)
Rows
- 0279of which collateral received meets operational requirements
- 0319of which collateral received meets operational requirements
- 0550of which: secured by L2A
Columns
- 0110Subject to the 75% cap on inflows
- 0120Subject to the 90% cap on inflows
- 0130Exempted from the cap on inflows
Liquidity coverage, collateral swaps, total (DA) (C 75.01.a)
Rows
- 0080Of which collateral swapped meets operational requirements
- 0250Of which collateral swapped meets operational requirements
- 0420Of which collateral swapped meets operational requirements
- 0590Of which collateral swapped meets operational requirements
- 0760Of which collateral swapped meets operational requirements
- 0930Of which collateral swapped meets operational requirements
- 1100Of which collateral swapped meets operational requirements
- 1270Of which collateral swapped meets operational requirements
- 1440Of which collateral swapped meets operational requirements
- 1610Of which collateral swapped meets operational requirements
- 1780Of which collateral swapped meets operational requirements
- 1950Of which collateral swapped meets operational requirements
- 2120Of which collateral swapped meets operational requirements
- 2290Of which collateral swapped meets operational requirements
- 2460Of which collateral swapped meets operational requirements
- 2630Of which collateral swapped meets operational requirements
- 2770of which: collateral borrowed is L2A
Column
- 0040Liquidity value of collateral borrowed
Liquidity coverage, calculations, total (DA) (C 76.00.a)
Row
- 0170L2A collateral 30 day outflows
Column
- 0010Value / Percentage
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{C_76.00.a,r0170,c0010,} = sum({C_74.00.a,r0279,c0110,},{C_74.00.a,r0279,c0130,},{C_74.00.a,r0279,c0120,}) + sum({C_74.00.a,r0319,c0110,},{C_74.00.a,r0319,c0130,},{C_74.00.a,r0319,c0120,}) - sum({C_74.00.a,r0550,c0130,},{C_74.00.a,r0550,c0120,},{C_74.00.a,r0550,c0110,}) + sum({C_75.01.a,r0930,c0040,},{C_75.01.a,r1950,c0040,},{C_75.01.a,r2290,c0040,},{C_75.01.a,r2460,c0040,},{C_75.01.a,r2630,c0040,},{C_75.01.a,r0590,c0040,},{C_75.01.a,r0250,c0040,},{C_75.01.a,r1270,c0040,},{C_75.01.a,r1440,c0040,},{C_75.01.a,r1100,c0040,},{C_75.01.a,r1610,c0040,},{C_75.01.a,r0080,c0040,},{C_75.01.a,r0420,c0040,},{C_75.01.a,r0760,c0040,},{C_75.01.a,r1780,c0040,},{C_75.01.a,r2120,c0040,}) - {C_75.01.a,r2770,c0040,} + {C_72.00.a,r0300,c0040,}Other rules on C 72.00.a
- L1 EHQCB collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.a, v10181_m)Warning
- L2B collateral 30 day outflows, value / percentage must equal a calculation over 93 cells (C 76.00.a, v10185_m)Warning
- L1 excl. EHQCB collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.a, v10179_m)Warning
- Applicable weight cannot be negative (v8642_s)Warning
- Amount or market value cannot be negative (v7683_s)Warning
- Value according to Article 9 cannot be negative (v7681_s)Warning
- If amount or market value is zero or more, applicable weight cannot be negative (v7571_m)Warning
- Qualifying CIU shares or units: underlying is corporate debt securities (CQS2/3), shares (major stock index) or non-interest bearing assets (he, applicable weight cannot be more than 0.45 (v7570_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
