The rule in plain words
None of the values it checks in roll-over of funding, significant currencies can be negative.
EBA checks it for 24 columns, from maturing (0010) to new funds term (0320). And for 124 rows, from total funding (0010) to secured funding (1240). That makes 2,976 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.
Maturing: Retail funding >= 0
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Look for a value with the wrong sign in these cells, such as an amount entered as a negative number.
- 03EBA compares the values exactly here: there is no rounding tolerance.
- 04It runs only when your filing indicators mark C 70.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
Roll-over of funding, significant currencies (C 70.00.w)
Rows
- 0010Total funding
- 0020Retail funding
- 0030Unsecured wholesale funding
- 0040Secured funding
- 0050Total funding
- 0060Retail funding
- 0070Unsecured wholesale funding
- 0080Secured funding
- 0090Total funding
- 0100Retail funding
- 0110Unsecured wholesale funding
- 0120Secured funding
- 0130Total funding
- 0140Retail funding
- 0150Unsecured wholesale funding
- 0160Secured funding
- 0170Total funding
- 0180Retail funding
- 0190Unsecured wholesale funding
- 0200Secured funding
- 0210Total funding
- 0220Retail funding
- 0230Unsecured wholesale funding
- 0240Secured funding
- 0250Total funding
- 0260Retail funding
- 0270Unsecured wholesale funding
- 0280Secured funding
- 0290Total funding
- 0300Retail funding
- 0310Unsecured wholesale funding
- 0320Secured funding
- 0330Total funding
- 0340Retail funding
- 0350Unsecured wholesale funding
- 0360Secured funding
- 0370Total funding
- 0380Retail funding
- 0390Unsecured wholesale funding
- 0400Secured funding
And 84 more.
Columns
- 0010Maturing
- 0020Roll over
- 0030New Funds
- 0050Maturing
- 0060Roll over
- 0070New Funds
- 0090Maturing
- 0100Roll over
- 0110New Funds
- 0130Maturing
- 0140Roll over
- 0150New Funds
- 0170Maturing
- 0180Roll over
- 0190New Funds
- 0210Maturing
- 0220Roll over
- 0230New Funds
- 0250Maturing
- 0260Roll over
- 0270New Funds
- 0300Maturing Funds Term
- 0310Roll-over Funds Term
- 0320New Funds Term
A worked example
The first of its checks, with simple numbers.
Retail funding, maturing must then be at least 0.
A file that reports 0 passes. One that reports -100 fails, by 100.
The numbers are illustrative.
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_70.00.w,r0420,c0010,} >= 0The next five:
{C_70.00.w,r0970,c0190,} >= 0{C_70.00.w,r0430,c0220,} >= 0{C_70.00.w,r1050,c0100,} >= 0{C_70.00.w,r0460,c0130,} >= 0{C_70.00.w,r0820,c0110,} >= 0And 2,970 more, the same formula for the other cells it covers.
Checks like this one, run at the point of submission, are the first step to real-time supervision.
