The rule in plain words
Loans and advances cannot be negative.
EBA writes it out 58 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Reconciliation between IFRS and CRR scope of consolidation: assets (F 17.01)
Row
- 0144Loans and advances
Column
- 0010Accounting scope of consolidation [carrying 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}.
{F_17.01,r0144,c0010,} >= 0And 57 more, the same formula for the other cells it covers.
Other rules on F 17.01
- Non-trading financial assets mandatorily at fair value through profit or loss must equal the sum of its three parts (v5145_m)Warning
- Financial assets at amortised cost must equal debt securities plus loans and advances (v5146_m)Warning
- Non-trading non-derivative financial assets measured at a cost-based method must equal the sum of its three parts (v5147_m)Warning
- Haircuts for trading assets valued at fair value cannot be more than zero (v5694_s)Warning
- Tax assets must equal deferred tax assets plus current tax assets (v1976_h)Warning
- Intangible assets must equal goodwill plus other intangible assets (v1975_h)Warning
- Other non-trading non-derivative financial assets must equal the sum of its three parts (v1768_m)Warning
- Non-trading non-derivative financial assets measured at fair value to equity must equal the sum of its three parts (v1767_m)Warning
Every FINREP 9 rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.