The rule in plain words
Loans and advances in F 06.01 must equal loans and advances in F 20.07.1.
All the values are in the loans and advances subject to impairment column (0011).
EBA writes it out 20 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Row
- 0190Loans and advances
Column
- 0011of which: loans and advances subject to impairment
Row
- 0190Loans and advances
Column
- 0011Of which: loans and advances subject to impairment
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_06.01,r0190,c0011,} = sum({F_20.07.1,r0190,c0011,})And 19 more, the same formula for the other cells it covers.
Other rules on F 06.01
- A balancing check across breakdown of loans and advances other than held for trading, and information on performing and non-performing exposures (F 18.00.b, v5015_m)Warning
- Loans and advances must equal the sum of its three parts (v5014_m)Blocking
- Loans and advances, loans and advances subject to impairment must equal the sum of its two parts (v5264_m)Blocking
- Loans and advances, accumulated impairment must equal the sum of its two parts (v5265_m)Warning
- A matching-values check across breakdown of loans and advances other than held for trading, and information on performing and non-performing exposures (F 18.00.b, v5266_m)Blocking
- A calculation check across breakdown of loans and advances other than held for trading, and geographical breakdown of assets (F 20.04, v5351_m)Warning
- Loans and advances subject to impairment cannot be more than gross carrying amount (v5366_m)Blocking
- None of the 80 values it checks in breakdown of loans and advances other than held for trading can be negative (v5675_s)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.