The rule in plain words
For subject to the 90% cap on inflows: inflow must equal amount times applicable weight.
EBA checks it for 43 rows, from monies due from non-financial customers (except for central banks) not corresponding to principal repayment (0040) to any other inflows within a group or an institutional protection scheme (0510). That makes 43 checks. A failure names the one that failed.
How the Line4 Check report words itShowHide
The first of its checks, word for word as the report shows it when it fails. The others read the same, with their own column, row or sheet.
Level 2B high quality covered bonds collateral, Inflow, subject to the 90% cap on inflows = Level 2B high quality covered bonds collateral, Amount, subject to the 90% cap on inflows × Level 2B high quality covered bonds collateral, Applicable weight, subject to the 90% cap on inflows
What to do if your filing fails it
- 01Open the template 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 74.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, inflows, total (DA) (C 74.00.a)
Rows
- 0040monies due from non-financial customers (except for central banks) not corresponding to principal repayment
- 0060monies due from retail customers
- 0070monies due from non-financial corporates
- 0080monies due from sovereigns, multilateral development banks and public sector entities
- 0090monies due from other legal entities
- 0120monies due from financial customers being classified as operational deposits where the credit institution is able to establish a correspondi
- 0130monies due from financial customers being classified as operational deposits where the credit institution is not able to establish a corresp
- 0150monies due from central banks
- 0160monies due from financial customers
- 0170inflows corresponding to outflows in accordance with promotional loan commitments referred to in Article 31(9) of Commission delegated regul
- 0180monies due from trade financing transactions
- 0190monies due from securities maturing within 30 days
- 0201loans with an undefined contractual end date
- 0210monies due from positions in major index equity instruments provided that there is no double counting with liquid assets
- 0230inflows from the release of balances held in segregated accounts in accordance with regulatory requirements for the protection of customer t
- 0240inflows from derivatives
- 0250inflows from undrawn credit or liquidity facilities provided by members of a group or an institutional protection scheme where the competent
- 0260other inflows
- 0269Level 1 collateral excluding extremely high quality covered bonds
- 0273Level 1 collateral which is extremely high quality covered bonds
- 0277Level 2A collateral
- 0281Level 2B asset backed securities (residential or auto) collateral
- 0285Level 2B high quality covered bonds collateral
- 0289Level 2B asset backed securities (commercial or individuals) collateral
- 0293Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6
- 0301collateral is non-liquid equity
- 0303all other non-liquid collateral
- 0309Level 1 collateral excluding extremely high quality covered bonds
- 0313Level 1 collateral which is extremely high quality covered bonds
- 0317Level 2A collateral
- 0321Level 2B asset backed securities (residential or auto) collateral
- 0325Level 2B high quality covered bonds collateral
- 0329Level 2B asset backed securities (commercial or individuals) collateral
- 0333Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6
- 0341margin loans: collateral is non-liquid
- 0343collateral is non-liquid equity
- 0345all other non-liquid collateral
- 0450FX inflows
- 0470Monies due from non-financial customers (except for central banks)
- 0480Monies due from financial customers
And 3 more.
Columns
- 0020Subject to the 90% cap on inflows
- 0090Subject to the 90% cap on inflows
- 0150Subject to the 90% cap on inflows
Show the rule as writtenShowHide
EBA's formula, as written out for the first of its checks. Cells are written as {template, row, column, sheet}.
{C_74.00.a,r0285,c0150,} = {C_74.00.a,r0285,c0020,} * {C_74.00.a,r0285,c0090,}The next five:
{C_74.00.a,r0490,c0150,} = {C_74.00.a,r0490,c0020,} * {C_74.00.a,r0490,c0090,}{C_74.00.a,r0190,c0150,} = {C_74.00.a,r0190,c0020,} * {C_74.00.a,r0190,c0090,}{C_74.00.a,r0277,c0150,} = {C_74.00.a,r0277,c0020,} * {C_74.00.a,r0277,c0090,}{C_74.00.a,r0309,c0150,} = {C_74.00.a,r0309,c0020,} * {C_74.00.a,r0309,c0090,}{C_74.00.a,r0180,c0150,} = {C_74.00.a,r0180,c0020,} * {C_74.00.a,r0180,c0090,}And 37 more, the same formula for the other cells it covers.
Other rules on C 74.00.a
- Subject to the 75% cap on inflows: inflow must equal amount times applicable weight (v4511_m)Warning
- Exempted from the cap on inflows: inflow must equal amount times applicable weight (v4513_m)Warning
- Other monies due from non-financial customers (except for central banks) must equal the sum of its four parts (v4520_m)Warning
- Monies due from non-financial customers (except for central banks) must equal the sum of its two parts (v4521_m)Warning
- Monies due from financial customers being classified as operational deposits must equal the sum of its two parts (v4522_m)Warning
- Monies due from central banks and financial customers not being classified as operational deposits must equal the sum of its two parts (v4523_m)Warning
- Monies due from central banks and financial customers must equal the sum of its two parts (v4524_m)Warning
- Inflows from unsecured transactions or deposits must equal the sum of its eleven parts (v4525_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
