The rule in plain words
For central banks: these three added up must equal defaulted gross carrying amount (all sheets added up):
- Defaulted gross carrying amount or nominal amount (row 0020)
- Defaulted gross carrying amount or nominal amount (row 0182)
- Defaulted gross carrying amount or nominal amount (row 0212)
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
F_18.00.A: Debt securities, central banks, Of which: defaulted (row 0020) + F_18.00.A: Debt securities, central banks, Of which: defaulted (row 0182) + F_18.00.A: Debt securities, central banks, Of which: defaulted (row 0212) = F_20.04: Central banks, Of which: defaulted (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
- 0020Central banks
- 0182Central banks
- 0212Central banks
Column
- 0110Of which: defaulted
Geographical breakdown of assets by residence of the counterparty (F 20.04)
Row
- 0090Central banks
Column
- 0026Of which: defaulted
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
sum({F_18.00.a,r0020,c0110,},{F_18.00.a,r0182,c0110,},{F_18.00.a,r0212,c0110,}) = sum({F_20.04,r0090,c0026,})Other rules on F 18.00.a
- The sum of three rows must equal debt securities, defaulted gross carrying amount (all sheets added up) (v7826_m)Warning
- Debt securities: the sum of three rows must equal general governments, defaulted gross carrying amount (all sheets added up) (v7828_m)Warning
- The sum of three rows must equal loans and advances, defaulted gross carrying amount (all sheets added up) (v7825_m)Warning
- Debt securities: the sum of three rows must equal credit institutions, defaulted gross carrying amount (all sheets added up) (v7829_m)Warning
- Loans collateralised by residential immovable property in F 18.02.a must equal the sum of its three parts (v7824_m)Warning
- Debt securities: the sum of three rows must equal other financial corporations, defaulted gross carrying amount (all sheets added up) (v7830_m)Warning
- Loans collateralised by commercial immovable property in F 18.02.a must equal the sum of its three parts (v7823_m)Warning
- The sum of three rows must equal non-financial corporations, defaulted gross carrying amount (all sheets added up) (v7831_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.
