The rule in plain words
For outstanding amount: total must equal these eight added up:
- Households
- Non-financial corporations (SMEs)
- Non-financial corporations (non-SMEs)
- Credit institutions
- Other financial corporations
- General governments & central banks
- Non-identified, listed on a trading venue
- Non-identified, not listed on a trading venue
EBA checks it for 51 rows, from liabilities excluded from bail-in (0100) to (part of) subordinated liabilities recognised as own funds (0531). That makes 51 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.
of which: residual maturity >= 2 years, Total, outstanding Amount = of which: residual maturity >= 2 years, Households, outstanding Amount + of which: residual maturity >= 2 years, Non-financial corporations (SMEs), outstanding Amount + of which: residual maturity >= 2 years, Non-financial corporations (non-SMEs), outstanding Amount + of which: residual maturity >= 2 years, Credit institutions, outstanding Amount + of which: residual maturity >= 2 years, Other financial corporations, outstanding Amount + of which: residual maturity >= 2 years, General governments & Central banks, outstanding Amount + of which: residual maturity >= 2 years, Non-identified, listed on a trading venue, outstanding Amount + of which: residual maturity >= 2 years, Non-identified, not listed on a trading venue, outstanding Amount
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Add up the parts in your file and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong cell, or the total is out of date.
- 04EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark Z 02.00 as reported.
- 06This is a blocking check. A filing that fails it is normally rejected, so fix it before you submit.
The cells it reads
Liability structure (LIAB) (Z 02.00.a)
Rows
- 0100Liabilities excluded from bail-in
- 0120Secured liabilities - collateralized part
- 0130Client liabilities, if protected in insolvency
- 0140Fiduciary liabilities, if protected in insolvency
- 0161System (operator) and CCP liabilities < 7 days
- 0180Liabilities critical to operational daily functioning
- 0300Liabilities not excluded from bail-in
- 0310Deposits, not covered but preferential
- 0311of which: residual maturity <= 1 month
- 0312of which: residual maturity > 1 month < 1 year
- 0313of which: residual maturity >= 1 year and < 2 years
- 0314of which: residual maturity >= 2 years
- 0320Deposits, not covered and not preferential
- 0321of which: residual maturity <= 1 month
- 0322of which: residual maturity > 1 month < 1 year
- 0323of which: residual maturity >= 1 year and < 2 years
- 0324of which: residual maturity >= 2 years
- 0340Uncollateralized secured liabilities
- 0341of which: residual maturity <= 1 month
- 0342of which: residual maturity > 1 month < 1 year
- 0343of which: residual maturity >= 1 year and < 2 years
- 0344of which: residual maturity >= 2 years
- 0350Structured notes
- 0351of which: residual maturity <= 1 month
- 0352of which: residual maturity > 1 month < 1 year
- 0353of which: residual maturity >= 1 year and < 2 years
- 0354of which: residual maturity >= 2 years
- 0360Senior unsecured liabilities
- 0361of which: residual maturity <= 1 month
- 0362of which: residual maturity > 1 month < 1 year
- 0363of which: residual maturity >= 1 year and < 2 years
- 0364of which: residual maturity >= 2 years
- 0365Senior non-preferred liabilities
- 0366of which: residual maturity <= 1 month
- 0367of which: residual maturity > 1 month < 1 year
- 0368of which: residual maturity >= 1 year and < 2 years
- 0369of which: residual maturity >= 2 years
- 0370Subordinated liabilities (not recognised as own funds)
- 0371of which: residual maturity <= 1 month
- 0372of which: residual maturity > 1 month < 1 year
And 11 more.
Columns
- 0010Outstanding Amount
- 0020Outstanding Amount
- 0030Outstanding Amount
- 0040Outstanding Amount
- 0050Outstanding Amount
- 0060Outstanding Amount
- 0070Outstanding Amount
- 0080Outstanding Amount
- 0090Outstanding Amount
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}.
{Z_02.00.a,r0382,c0090,} = {Z_02.00.a,r0382,c0010,} + {Z_02.00.a,r0382,c0020,} + {Z_02.00.a,r0382,c0030,} + {Z_02.00.a,r0382,c0040,} + {Z_02.00.a,r0382,c0050,} + {Z_02.00.a,r0382,c0060,} + {Z_02.00.a,r0382,c0070,} + {Z_02.00.a,r0382,c0080,}The next five:
{Z_02.00.a,r0314,c0090,} = {Z_02.00.a,r0314,c0010,} + {Z_02.00.a,r0314,c0020,} + {Z_02.00.a,r0314,c0030,} + {Z_02.00.a,r0314,c0040,} + {Z_02.00.a,r0314,c0050,} + {Z_02.00.a,r0314,c0060,} + {Z_02.00.a,r0314,c0070,} + {Z_02.00.a,r0314,c0080,}{Z_02.00.a,r0300,c0090,} = {Z_02.00.a,r0300,c0010,} + {Z_02.00.a,r0300,c0020,} + {Z_02.00.a,r0300,c0030,} + {Z_02.00.a,r0300,c0040,} + {Z_02.00.a,r0300,c0050,} + {Z_02.00.a,r0300,c0060,} + {Z_02.00.a,r0300,c0070,} + {Z_02.00.a,r0300,c0080,}{Z_02.00.a,r0381,c0090,} = {Z_02.00.a,r0381,c0010,} + {Z_02.00.a,r0381,c0020,} + {Z_02.00.a,r0381,c0030,} + {Z_02.00.a,r0381,c0040,} + {Z_02.00.a,r0381,c0050,} + {Z_02.00.a,r0381,c0060,} + {Z_02.00.a,r0381,c0070,} + {Z_02.00.a,r0381,c0080,}{Z_02.00.a,r0323,c0090,} = {Z_02.00.a,r0323,c0010,} + {Z_02.00.a,r0323,c0020,} + {Z_02.00.a,r0323,c0030,} + {Z_02.00.a,r0323,c0040,} + {Z_02.00.a,r0323,c0050,} + {Z_02.00.a,r0323,c0060,} + {Z_02.00.a,r0323,c0070,} + {Z_02.00.a,r0323,c0080,}{Z_02.00.a,r0365,c0090,} = {Z_02.00.a,r0365,c0010,} + {Z_02.00.a,r0365,c0020,} + {Z_02.00.a,r0365,c0030,} + {Z_02.00.a,r0365,c0040,} + {Z_02.00.a,r0365,c0050,} + {Z_02.00.a,r0365,c0060,} + {Z_02.00.a,r0365,c0070,} + {Z_02.00.a,r0365,c0080,}And 45 more, the same formula for the other cells it covers.
Other rules on Z 02.00.a
- Outstanding amount, total must equal the sum of its seven parts (row 0110, v6475_m)Blocking
- Outstanding amount: total must equal credit institutions plus other financial corporations (v6476_m)Blocking
- Outstanding amount, total must equal outstanding amount, households (v6477_m)Blocking
- Outstanding amount: total must equal general governments & central banks (v6478_m)Blocking
- Households: liabilities excluded from bail-in must equal the sum of its seven parts (v6480_m)Warning
- Non-financial corporations (non-SMEs): liabilities excluded from bail-in must equal the sum of its seven parts (v6482_m)Blocking
- Credit institutions: liabilities excluded from bail-in must equal the sum of its eight parts (v6484_m)Blocking
- Liabilities excluded from bail-in must equal the sum of its nine parts (v6486_m)Blocking
Every RESOL1 rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
