The rule in plain words
For credit institutions: these three added up must equal non-performing gross carrying amount (all sheets added up):
- Non-performing (row 0224)
- Non-performing (row 0100)
- Non-performing (row 0194)
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
F_18.00.A: Loans and advances, credit institutions, Non-performing (row 0224) + F_18.00.A: Loans and advances, credit institutions, Non-performing (row 0100) + F_18.00.A: Loans and advances, credit institutions, Non-performing (row 0194) = F_20.04: Credit institutions, Of which: non-performing (all sheets added up)
What to do if your filing fails it
- 01Open the templates below and find the cells the rule reads.
- 02Work out both sides from your file, as the rule in plain words sets out, and compare them.
- 03EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark F 18.00 and F 20.04 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
Information on performing and non-performing exposures (I) (F 18.00.a)
Rows
- 0100Credit institutions
- 0194Credit institutions
- 0224Credit institutions
Column
- 0060Non-performing
Geographical breakdown of assets by residence of the counterparty (F 20.04)
Row
- 0170Credit institutions
Column
- 0025Of which: non-performing
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
sum({F_18.00.a,r0224,c0060,},{F_18.00.a,r0100,c0060,},{F_18.00.a,r0194,c0060,}) = sum({F_20.04,r0170,c0025,})Other rules on F 18.00.a
- Loans and advances: the sum of three rows must equal general governments, non-performing gross carrying amount (all sheets added up) (v5288_m)Warning
- Loans and advances: the sum of three rows must equal other financial corporations, non-performing gross carrying amount (all sheets added up) (v5290_m)Warning
- Loans and advances: the sum of three rows must equal central banks, non-performing gross carrying amount (all sheets added up) (v5287_m)Warning
- The sum of three rows must equal loans and advances, non-performing gross carrying amount (all sheets added up) (v5286_m)Warning
- The sum of three rows must equal households, non-performing gross carrying amount (all sheets added up) (v5292_m)Warning
- The sum of three rows must equal non-financial corporations, non-performing gross carrying amount (all sheets added up) (v5285_m)Warning
- Debt securities: the sum of three rows must equal other financial corporations, non-performing gross carrying amount (all sheets added up) (v5284_m)Warning
- Debt securities: the sum of three rows must equal credit institutions, non-performing gross carrying amount (all sheets added up) (v5283_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.