The rule in plain words
Loans and advances cannot be negative.
EBA writes it out 59 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Balance sheet statement: assets (F 01.01)
Row
- 0099Loans and advances
Column
- 0010Carrying 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_01.01,r0099,c0010,} >= 0And 58 more, the same formula for the other cells it covers.
Other rules on F 01.01
- If financial assets held for trading, carrying amount is more than zero, the sum of three columns must be more than zero (v4962_m)Warning
- If financial assets designated at fair value through profit or loss, carrying amount is more than zero, the sum of three columns must be more than zero (v4963_m)Warning
- If financial assets at fair value through other comprehensive income, carrying amount is more than zero, the sum of three columns must be more than zero (v4964_m)Warning
- If derivatives, hedge accounting, carrying amount is more than zero, the sum of three columns must be more than zero (v4965_m)Warning
- Trading financial assets in F 15.00.a cannot be more than trading financial assets in F 01.01 (v4969_m)Warning
- The sum of two columns cannot be more than financial assets held for trading, carrying amount in F 01.01 (v4970_m)Warning
- An upper-limit check across derecognition and financial liabilities associated with transferred financial assets, and balance sheet statement: assets (F 15.00.a, v4971_m)Warning
- Non-trading non-derivative financial assets measured at fair value to equity in F 15.00.a cannot be more than non-trading non-derivative financial assets measured at fair value to equity in F 01.01 (v4972_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.