The rule in plain words
Loans collateralised by commercial immovable property (under total EU area) plus loans collateralised by commercial immovable property (under total non-EU area) cannot be negative.
All the values are in the 0; <= 100 column (0020) of D 02.00.a.
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
0; <= 100: Total EU area, of which Loans collateralised by commercial immovable property + Total non-EU area, of which Loans collateralised by commercial immovable property >= 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 allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark D 02.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
Rows
- 0020Of which Loans collateralised by commercial immovable property
- 0070Of which Loans collateralised by commercial immovable property
Column
- 00200; <= 100
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{D_02.00.a,r0020,c0020,} + {D_02.00.a,r0070,c0020,} >= 0Other rules on D 02.00.a
- The sum of two rows cannot be negative (row 0030, v89289_m)Warning
- The sum of two rows cannot be negative (row 0020, v89291_m)Warning
- The sum of two rows cannot be negative (row 0030, v89288_m)Warning
- The sum of four rows cannot be negative (row 0020, v89287_m)Warning
- The sum of four rows cannot be negative (row 0020, v89286_m)Warning
- The sum of 24 cells cannot be negative (v89285_m)Warning
- The sum of four cells cannot be negative (row 0050, v89284_m)Warning
- The sum of four cells cannot be negative (row 0050, v89283_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.