The rule in plain words
L1 excl. EHQCB 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 0271)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0271)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0271)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0311)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0311)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0311)
- Minus memorandum items secured by L1 excl. EHQCB, subject to the 90% cap on inflows
- Minus memorandum items secured by L1 excl. EHQCB, subject to the 75% cap on inflows
- Minus memorandum items secured by L1 excl. EHQCB, exempted from the cap on inflows
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0210)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1570)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1740)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0040)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0380)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2420)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2250)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0720)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0550)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2590)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1060)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2080)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1400)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0890)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1910)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1230)
- Minus collateral borrowed is L1 excl. EHQCB, liquidity value of collateral borrowed
- Central institutions: Level 1 assets excl. EHQ CB 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.W: L1 excl. EHQCB collateral 30 day outflows = C_74.00.W: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0271) + C_74.00.W: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0271) + C_74.00.W: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0271) + C_74.00.W: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0311) + C_74.00.W: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0311) + C_74.00.W: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0311) - C_74.00.W: of which: secured by L1 excl. EHQCB, Subject to the 90% cap on inflows - C_74.00.W: of which: secured by L1 excl. EHQCB, Subject to the 75% cap on inflows - C_74.00.W: of which: secured by L1 excl. EHQCB, Exempted from the cap on inflows + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0210) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1570) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1740) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0040) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0380) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2420) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2250) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0720) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0550) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2590) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1060) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2080) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1400) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0890) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1910) + C_75.01.W: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1230) - C_75.01.W: of which: collateral borrowed is L1 excl. EHQCB, Liquidity value of collateral borrowed + C_72.00.W: Central institutions: Level 1 assets excl. EHQ CB 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, significant currencies (DA) (C 72.00.w)
Row
- 0160Central institutions: Level 1 assets excl. EHQ CB which are considered liquid assets for the depositing credit institution
Column
- 0040Value according to Article 9
Liquidity coverage, inflows, significant currencies (DA) (C 74.00.w)
Rows
- 0271of which collateral received meets operational requirements
- 0311of which collateral received meets operational requirements
- 0530of which: secured by L1 excl. EHQCB
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, significant currencies (DA) (C 75.01.w)
Rows
- 0040Of which collateral swapped meets operational requirements
- 0210Of which collateral swapped meets operational requirements
- 0380Of which collateral swapped meets operational requirements
- 0550Of which collateral swapped meets operational requirements
- 0720Of which collateral swapped meets operational requirements
- 0890Of which collateral swapped meets operational requirements
- 1060Of which collateral swapped meets operational requirements
- 1230Of which collateral swapped meets operational requirements
- 1400Of which collateral swapped meets operational requirements
- 1570Of which collateral swapped meets operational requirements
- 1740Of which collateral swapped meets operational requirements
- 1910Of which collateral swapped meets operational requirements
- 2080Of which collateral swapped meets operational requirements
- 2250Of which collateral swapped meets operational requirements
- 2420Of which collateral swapped meets operational requirements
- 2590Of which collateral swapped meets operational requirements
- 2750of which: collateral borrowed is L1 excl. EHQCB
Column
- 0040Liquidity value of collateral borrowed
Liquidity coverage, calculations, significant currencies (DA) (C 76.00.w)
Row
- 0050L1 excl. EHQCB 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.w,r0050,c0010,} = sum({C_74.00.w,r0271,c0110,},{C_74.00.w,r0271,c0120,},{C_74.00.w,r0271,c0130,}) + sum({C_74.00.w,r0311,c0110,},{C_74.00.w,r0311,c0120,},{C_74.00.w,r0311,c0130,}) - sum({C_74.00.w,r0530,c0120,},{C_74.00.w,r0530,c0110,},{C_74.00.w,r0530,c0130,}) + sum({C_75.01.w,r0210,c0040,},{C_75.01.w,r1570,c0040,},{C_75.01.w,r1740,c0040,},{C_75.01.w,r0040,c0040,},{C_75.01.w,r0380,c0040,},{C_75.01.w,r2420,c0040,},{C_75.01.w,r2250,c0040,},{C_75.01.w,r0720,c0040,},{C_75.01.w,r0550,c0040,},{C_75.01.w,r2590,c0040,},{C_75.01.w,r1060,c0040,},{C_75.01.w,r2080,c0040,},{C_75.01.w,r1400,c0040,},{C_75.01.w,r0890,c0040,},{C_75.01.w,r1910,c0040,},{C_75.01.w,r1230,c0040,}) - {C_75.01.w,r2750,c0040,} + {C_72.00.w,r0160,c0040,}Other rules on C 72.00.w
- L1 EHQCB collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.w, v10194_m)Warning
- L2A collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.w, v10196_m)Warning
- L2B collateral 30 day outflows, value / percentage must equal a calculation over 93 cells (C 76.00.w, v10198_m)Warning
- Applicable weight cannot be negative (v8639_s)Warning
- Amount or market value cannot be negative (v7686_s)Warning
- Value according to Article 9 cannot be negative (v7684_s)Warning
- If amount or market value is zero or more, applicable weight cannot be negative (v7616_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 (v7615_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
