The rule in plain words
Loans and advances, households must equal these nine added up, all for households:
- Carrying amount in F 04.02.1
- Carrying amount in F 04.02.2
- Carrying amount in F 04.03.1
- Carrying amount in F 04.04.1
- Carrying amount in F 04.07
- Carrying amount in F 04.08, financial assets not subject to impairment
- Carrying amount in F 04.08, financial assets subject to impairment
- Carrying amount in F 04.09
- Carrying amount in F 04.10
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
F_05.01: LOANS AND ADVANCES, Households = F_04.02.1: Households, Carrying amount + F_04.02.2: Households, Carrying amount + F_04.03.1: Households, Carrying amount + F_04.04.1: Households, Carrying amount + F_04.07: Households, Carrying amount + F_04.08: Households, Financial assets not subject to impairment, carrying amount + F_04.08: Households, Financial assets subject to impairment, carrying amount + F_04.09: Households, Carrying amount + F_04.10: Households, Carrying amount
What to do if your filing fails it
- 01Open the templates below and find the cells the rule reads.
- 02Add up the parts in your file and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong column, or the total is out of date.
- 04EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark F 05.01, F 04.02.1, F 04.02.2, F 04.03.1, F 04.04.1, F 04.07, F 04.08, F 04.09 or F 04.10 as reported.
- 06This 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
Row
- 0170Households
Column
- 0010Carrying amount
Row
- 0180Households
Column
- 0010Carrying amount
Row
- 0170Households
Column
- 0010Carrying amount
Breakdown of financial assets by instrument and by counterparty sector: financial assets at amortised cost (F 04.04.1)
Row
- 0130Households
Column
- 0010Carrying amount
Row
- 0180Households
Column
- 0010Carrying amount
Row
- 0180Households
Columns
- 0010Carrying amount
- 0035Carrying amount
Row
- 0130Households
Column
- 0050Carrying amount
Row
- 0180Households
Column
- 0010Carrying amount
Row
- 0080LOANS AND ADVANCES
Column
- 0060Households
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{F_05.01,r0080,c0060,} = {F_04.02.1,r0170,c0010,} + {F_04.02.2,r0180,c0010,} + {F_04.03.1,r0170,c0010,} + {F_04.04.1,r0130,c0010,} + {F_04.07,r0180,c0010,} + {F_04.08,r0180,c0010,} + {F_04.08,r0180,c0035,} + {F_04.09,r0130,c0050,} + {F_04.10,r0180,c0010,}Other rules on F 04.02.1
- Loans and advances, non-financial corporations must equal the sum of its nine parts (v1381_m)Warning
- Loans and advances, other financial corporations must equal the sum of its nine parts (v1380_m)Warning
- Loans and advances, general governments must equal the sum of its nine parts (v1378_m)Warning
- Equity instruments cannot be less than the sum of three rows (v5124_m)Blocking
- Debt securities, gross carrying amount or nominal amount must equal a calculation over four cells (v5170_m)Blocking
- Debt securities: central banks, gross carrying amount or nominal amount must equal a calculation over four cells (v5171_m)Blocking
- Debt securities: general governments, gross carrying amount or nominal amount must equal a calculation over four cells (v5172_m)Blocking
- Debt securities: credit institutions, gross carrying amount or nominal amount must equal a calculation over four cells (v5173_m)Blocking
Every FINREP 9 rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
