8 min readWarningEBA reporting framework 4.2Updated 10 November 2026

L2B collateral 30 day outflows, value / percentage must equal a calculation over 93 cells (C 76.00.a, EBA rule v10185_m)

A warning in the liquidity coverage ratio return (LCR), on templates C 72.00.a, liquidity coverage , liquid assets, total (DA), C 74.00.a, liquidity coverage, inflows, total (DA), C 75.01.a, liquidity coverage, collateral swaps, total (DA) and C 76.00.a, liquidity coverage, calculations, total (DA).

The rule in plain words

L2B collateral 30 day outflows, value / percentage must equal these 93 worked out:

  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0331)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0323)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0335)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0283)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0287)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0291)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0323)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0327)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0283)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0327)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0287)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0323)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0295)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0283)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0287)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0295)
  • Collateral received meets operational requirements, exempted from the cap on inflows (row 0331)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0335)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0327)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0295)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0291)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0331)
  • Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0291)
  • Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0335)
  • Minus memorandum items secured by L2B, exempted from the cap on inflows
  • Minus memorandum items secured by L2B, subject to the 90% cap on inflows
  • Minus memorandum items secured by L2B, subject to the 75% cap on inflows
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0310)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0970)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2030)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1460)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2330)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2140)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2520)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1970)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2480)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1180)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2650)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0780)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0650)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1290)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2350)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1500)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0840)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1120)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0330)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0460)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1630)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0670)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0120)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0800)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0950)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2010)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2540)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1350)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1010)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2160)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2370)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2690)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2200)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1520)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2710)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0630)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0990)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1990)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0100)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2670)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0500)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0290)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1480)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1650)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0820)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0440)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1840)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2310)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1820)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1140)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1670)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0610)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1860)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1310)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2500)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1330)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0140)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2180)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0270)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1800)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0160)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1160)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1690)
  • Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0480)
  • Minus collateral borrowed is L2B, liquidity value of collateral borrowed
  • Central institutions: Level 2B assets which are considered liquid assets for the depositing credit institution, value according to Article 9
How the Line4 Check report words itShow

Word for word as the report shows it when the rule fails.

C_76.00.A: L2B collateral 30 day outflows = C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0331) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0323) + C_74.00.A: Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6, of which collateral received meets operational requirements, Exempted from the cap on inflows + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0283) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0287) + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0291) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0323) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0327) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0283) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0327) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0287) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0323) + C_74.00.A: Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6, of which collateral received meets operational requirements, Exempted from the cap on inflows + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0283) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0287) + C_74.00.A: Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6, of which collateral received meets operational requirements, Subject to the 90% cap on inflows + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0331) + C_74.00.A: Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6, of which collateral received meets operational requirements, Subject to the 75% cap on inflows + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0327) + C_74.00.A: Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6, of which collateral received meets operational requirements, Subject to the 75% cap on inflows + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0291) + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0331) + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0291) + C_74.00.A: Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6, of which collateral received meets operational requirements, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L2B, Exempted from the cap on inflows - C_74.00.A: of which: secured by L2B, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L2B, Subject to the 75% cap on inflows + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0310) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0970) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2030) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1460) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2330) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2140) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2520) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1970) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2480) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1180) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2650) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0780) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0650) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1290) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2350) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1500) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0840) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1120) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0330) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0460) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1630) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0670) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0120) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0800) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0950) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2010) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2540) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1350) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1010) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2160) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2370) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2690) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2200) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1520) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2710) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0630) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0990) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1990) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0100) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2670) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0500) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0290) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1480) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1650) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0820) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0440) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1840) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2310) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1820) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1140) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1670) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0610) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1860) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1310) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2500) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1330) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0140) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2180) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0270) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1800) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0160) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1160) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1690) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0480) - C_75.01.A: of which: collateral borrowed is L2B, Liquidity value of collateral borrowed + C_72.00.A: Central institutions: Level 2B assets which are considered liquid assets for the depositing credit institution, Value according to Article 9

What to do if your filing fails it

  1. 01Open the templates below and find the cells the rule reads.
  2. 02Work out both sides from your file, as the rule in plain words sets out, and compare them.
  3. 03EBA allows a small rounding difference, worked out from the decimals each value is reported with.
  4. 04It runs only when your filing indicators mark C 76.00 as reported.
  5. 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

  • 0470Central institutions: Level 2B 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

  • 0283of which collateral received meets operational requirements
  • 0287of which collateral received meets operational requirements
  • 0291of which collateral received meets operational requirements
  • 0295of which collateral received meets operational requirements
  • 0323of which collateral received meets operational requirements
  • 0327of which collateral received meets operational requirements
  • 0331of which collateral received meets operational requirements
  • 0335of which collateral received meets operational requirements
  • 0560of which: secured by L2B

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

  • 0100Of which collateral swapped meets operational requirements
  • 0120Of which collateral swapped meets operational requirements
  • 0140Of which collateral swapped meets operational requirements
  • 0160Of which collateral swapped meets operational requirements
  • 0270Of which collateral swapped meets operational requirements
  • 0290Of which collateral swapped meets operational requirements
  • 0310Of which collateral swapped meets operational requirements
  • 0330Of which collateral swapped meets operational requirements
  • 0440Of which collateral swapped meets operational requirements
  • 0460Of which collateral swapped meets operational requirements
  • 0480Of which collateral swapped meets operational requirements
  • 0500Of which collateral swapped meets operational requirements
  • 0610Of which collateral swapped meets operational requirements
  • 0630Of which collateral swapped meets operational requirements
  • 0650Of which collateral swapped meets operational requirements
  • 0670Of which collateral swapped meets operational requirements
  • 0780Of which collateral swapped meets operational requirements
  • 0800Of which collateral swapped meets operational requirements
  • 0820Of which collateral swapped meets operational requirements
  • 0840Of which collateral swapped meets operational requirements
  • 0950Of which collateral swapped meets operational requirements
  • 0970Of which collateral swapped meets operational requirements
  • 0990Of which collateral swapped meets operational requirements
  • 1010Of which collateral swapped meets operational requirements
  • 1120Of which collateral swapped meets operational requirements
  • 1140Of which collateral swapped meets operational requirements
  • 1160Of which collateral swapped meets operational requirements
  • 1180Of which collateral swapped meets operational requirements
  • 1290Of which collateral swapped meets operational requirements
  • 1310Of which collateral swapped meets operational requirements
  • 1330Of which collateral swapped meets operational requirements
  • 1350Of which collateral swapped meets operational requirements
  • 1460Of which collateral swapped meets operational requirements
  • 1480Of which collateral swapped meets operational requirements
  • 1500Of which collateral swapped meets operational requirements
  • 1520Of which collateral swapped meets operational requirements
  • 1630Of which collateral swapped meets operational requirements
  • 1650Of which collateral swapped meets operational requirements
  • 1670Of which collateral swapped meets operational requirements
  • 1690Of which collateral swapped meets operational requirements

And 25 more.

Column

  • 0040Liquidity value of collateral borrowed

Liquidity coverage, calculations, total (DA) (C 76.00.a)

Row

  • 0230L2B collateral 30 day outflows

Column

  • 0010Value / Percentage
Show the rule as writtenShow

EBA's formula. Cells are written as {template, row, column, sheet}.

{C_76.00.a,r0230,c0010,} = sum({C_74.00.a,r0331,c0110,},{C_74.00.a,r0323,c0130,},{C_74.00.a,r0335,c0130,},{C_74.00.a,r0283,c0130,},{C_74.00.a,r0287,c0130,},{C_74.00.a,r0291,c0130,},{C_74.00.a,r0323,c0120,},{C_74.00.a,r0327,c0110,},{C_74.00.a,r0283,c0110,},{C_74.00.a,r0327,c0130,},{C_74.00.a,r0287,c0110,},{C_74.00.a,r0323,c0110,},{C_74.00.a,r0295,c0130,},{C_74.00.a,r0283,c0120,},{C_74.00.a,r0287,c0120,},{C_74.00.a,r0295,c0120,},{C_74.00.a,r0331,c0130,},{C_74.00.a,r0335,c0110,},{C_74.00.a,r0327,c0120,},{C_74.00.a,r0295,c0110,},{C_74.00.a,r0291,c0120,},{C_74.00.a,r0331,c0120,},{C_74.00.a,r0291,c0110,},{C_74.00.a,r0335,c0120,}) - sum({C_74.00.a,r0560,c0130,},{C_74.00.a,r0560,c0120,},{C_74.00.a,r0560,c0110,}) + sum({C_75.01.a,r0310,c0040,},{C_75.01.a,r0970,c0040,},{C_75.01.a,r2030,c0040,},{C_75.01.a,r1460,c0040,},{C_75.01.a,r2330,c0040,},{C_75.01.a,r2140,c0040,},{C_75.01.a,r2520,c0040,},{C_75.01.a,r1970,c0040,},{C_75.01.a,r2480,c0040,},{C_75.01.a,r1180,c0040,},{C_75.01.a,r2650,c0040,},{C_75.01.a,r0780,c0040,},{C_75.01.a,r0650,c0040,},{C_75.01.a,r1290,c0040,},{C_75.01.a,r2350,c0040,},{C_75.01.a,r1500,c0040,},{C_75.01.a,r0840,c0040,},{C_75.01.a,r1120,c0040,},{C_75.01.a,r0330,c0040,},{C_75.01.a,r0460,c0040,},{C_75.01.a,r1630,c0040,},{C_75.01.a,r0670,c0040,},{C_75.01.a,r0120,c0040,},{C_75.01.a,r0800,c0040,},{C_75.01.a,r0950,c0040,},{C_75.01.a,r2010,c0040,},{C_75.01.a,r2540,c0040,},{C_75.01.a,r1350,c0040,},{C_75.01.a,r1010,c0040,},{C_75.01.a,r2160,c0040,},{C_75.01.a,r2370,c0040,},{C_75.01.a,r2690,c0040,},{C_75.01.a,r2200,c0040,},{C_75.01.a,r1520,c0040,},{C_75.01.a,r2710,c0040,},{C_75.01.a,r0630,c0040,},{C_75.01.a,r0990,c0040,},{C_75.01.a,r1990,c0040,},{C_75.01.a,r0100,c0040,},{C_75.01.a,r2670,c0040,},{C_75.01.a,r0500,c0040,},{C_75.01.a,r0290,c0040,},{C_75.01.a,r1480,c0040,},{C_75.01.a,r1650,c0040,},{C_75.01.a,r0820,c0040,},{C_75.01.a,r0440,c0040,},{C_75.01.a,r1840,c0040,},{C_75.01.a,r2310,c0040,},{C_75.01.a,r1820,c0040,},{C_75.01.a,r1140,c0040,},{C_75.01.a,r1670,c0040,},{C_75.01.a,r0610,c0040,},{C_75.01.a,r1860,c0040,},{C_75.01.a,r1310,c0040,},{C_75.01.a,r2500,c0040,},{C_75.01.a,r1330,c0040,},{C_75.01.a,r0140,c0040,},{C_75.01.a,r2180,c0040,},{C_75.01.a,r0270,c0040,},{C_75.01.a,r1800,c0040,},{C_75.01.a,r0160,c0040,},{C_75.01.a,r1160,c0040,},{C_75.01.a,r1690,c0040,},{C_75.01.a,r0480,c0040,}) - {C_75.01.a,r2780,c0040,} + {C_72.00.a,r0470,c0040,}

Every LCR rule, by template

Checks like this one, run at the point of submission, are the first step to real-time supervision.