The rule in plain words
Total inflows must equal these five worked out:
- Inflows from unsecured transactions or deposits
- Inflows from secured lending and capital market-driven transactions
- Total inflows from collateral swaps
- Minus (difference between total weighted inflows and total weighted outflows arising from transactions in third countries where there are transfer
- Minus excess inflows from a related specialised credit institution
EBA checks it for three columns, all for cap on inflows: subject to the 75%, subject to the 90% and exempted from the. That makes three 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.
Exempted from the cap on inflows: TOTAL INFLOWS = Inflows from unsecured transactions/deposits + Inflows from secured lending and capital market-driven transactions + Total inflows from collateral swaps - (Difference between total weighted inflows and total weighted outflows arising from transactions in third countries where there are transfer - (Excess inflows from a related specialised credit institution)
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, significant currencies (DA) (C 74.00.w)
Rows
- 0010TOTAL INFLOWS
- 0020Inflows from unsecured transactions/deposits
- 0263Inflows from secured lending and capital market-driven transactions
- 0410Total inflows from collateral swaps
- 0420(Difference between total weighted inflows and total weighted outflows arising from transactions in third countries where there are transfer
- 0430(Excess inflows from a related specialised credit institution)
Columns
- 0140Subject to the 75% cap on inflows
- 0150Subject to the 90% cap on inflows
- 0160Exempted from the cap on inflows
A worked example
The first of its checks, with simple numbers.
Total inflows must then be 2,000.
A file that reports 2,000 passes. One that reports 2,100 fails, by 100.
The numbers are illustrative, reported to the unit, so the rounding tolerance does not change the result.
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.w,r0010,c0160,} = {C_74.00.w,r0020,c0160,} + {C_74.00.w,r0263,c0160,} + {C_74.00.w,r0410,c0160,} - {C_74.00.w,r0420,c0160,} - {C_74.00.w,r0430,c0160,}The next two:
{C_74.00.w,r0010,c0150,} = {C_74.00.w,r0020,c0150,} + {C_74.00.w,r0263,c0150,} + {C_74.00.w,r0410,c0150,} - {C_74.00.w,r0420,c0150,} - {C_74.00.w,r0430,c0150,}{C_74.00.w,r0010,c0140,} = {C_74.00.w,r0020,c0140,} + {C_74.00.w,r0263,c0140,} + {C_74.00.w,r0410,c0140,} - {C_74.00.w,r0420,c0140,} - {C_74.00.w,r0430,c0140,}Other rules on C 74.00.w
- Total inflows must equal the sum of its two parts (v4670_m)Warning
- Inflows within a group or an institutional protection scheme must equal the sum of its five parts (v4669_m)Warning
- Inflows from secured lending and capital market-driven transactions must equal the sum of its two parts (v4667_m)Warning
- Collateral that does not qualify as a liquid asset must equal the sum of its two parts (v4666_m)Warning
- Counterparty is central bank: collateral that qualifies as a liquid asset must equal the sum of its seven parts (v4665_m)Warning
- Inflows from unsecured transactions or deposits must equal the sum of its eleven parts (v4664_m)Warning
- Monies due from central banks and financial customers must equal the sum of its two parts (v4663_m)Warning
- Monies due from central banks and financial customers not being classified as operational deposits must equal the sum of its two parts (v4662_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
