v7870_m

warningactivewithin F 18.0114 cells · general rule

Expression · DPM 2.0, verbatim

with {tF_18.01, c*, default: 0, interval: true}: {r0130} = {r0010} + {r0020} + {r0030} + {r0040} + {r0050} + {r0100}

EBA description {r0130} = {r0010} + {r0020} + {r0030} + {r0040} + {r0050} + {r0100}

Precondition p_388 (its meaning is not in the data yet)

Cells involved

F 18.01 Inflows and outflows of non-performing exposures - loans and advances by counterparty sector

Open template →

	c0010Inflows to non-performing exposures	c0020(-) Outflows from non-performing exposures
0010LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING › Central banks	in rule	in rule
0020LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING › General governments	in rule	in rule
0030LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING › Credit institutions	in rule	in rule
0040LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING › Other financial corporations	in rule	in rule
0050LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING › Non-financial corporations	in rule	in rule
0100LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING › Households	in rule	in rule
0130TOTAL INFLOWS / OUTFLOWS › LOANS AND ADVANCES OTHER THAN HELD FOR TRADING OR TRADING	in rule	in rule

Scope by module

Module	Severity	Status	From
FINREP9 3.3.0	warning	active	2026-03-31
FINREP9DP 1.0.0	warning	active	2026-03-31
FINREP9DP 1.1.0	warning	active	2026-03-31

VALIDATION RULE

v7870_m

What it is

Type: Validation rule · within one template, general rule
Release: FINREP 4.4 validation · reported from 2026-03-31
Source: DPM 2.0 4.4 · operation 17250 · official

Regulation19

From the rows and columns of the cells involved.

Annex V Part 1 §42 F 18.01 r0010, r0020, r0030, r0040, r0050, r0100
Where a breakdown by counterparty is required the following counterparty sectors shall be used: (a) central banks; (b) general governments: central governments, state or regional governments, and local governments, including administrative bodies and non-commercial undertakings, but excluding public companies and private companies held by these administrations that have a commercial activity (which shall be reported under ‘credit institutions’, ‘other financial corporations’ or ‘non-financial corporations’ depending on their activity); social security funds; and international organisations, such as institutions of the European Union, the International Monetary Fund and the Bank for International Settlements; (c) credit institutions: any institution covered by the definition in point (1) of Article 4(1) CRR (‘undertaking the business of which is to take deposits or other repayable funds from the public and to grant credits for its own account’) and multilateral development banks (MDBs); (d) other financial corporations: all financial corporations and quasi-corporations, other than credit institutions, such as investment firms, investment funds, insurance companies, pension funds, collective investment undertakings, and clearing houses as well as remaining financial intermediaries, financial auxiliaries and captive financial institutions and money lenders; (e) non-financial corporations (NFCs): corporations and quasi-corporations not engaged in financial intermediation but principally in the production of market goods and non-financial services, as defined in the Table of Part 3 of Annex II to the ECB BSI Regulation; (f) households: individuals or groups of individuals as consumers and producers of goods and non-financial services exclusively for their own final consumption, and as producers of market goods and non-financial and financial services provided that their activities are not those of quasi-corporations. Non-profit institutions which serve households (‘NPISH’) and which are principally engaged in the production of non-market goods and services intended for particular groups of households shall be included.
Annex V Part 2 §213 F 18.01 c0010, c0020
For the purposes of template 18, non-performing exposures shall be exposures listed in Article 47a(3) CRR.
Annex V Part 2 §215 F 18.01 c0010, c0020
Under IFRS, for the purpose of template 18, impaired exposures shall be those that have been found credit-impaired (Stage 3). Exposures included in impairment stages other than Stage 3 and those that are purchased or originated credit-impaired shall be considered as non-performing where they meet the criteria to be considered as non-performing in accordance with Article 47a (3) CRR.
Annex V Part 2 §216 F 18.01 c0010, c0020
Exposures shall be categorised for their entire amount and without taking into account the existence of any collateral. With reference to the exposures referred to in point (a) of Article 47a(3) CRR, materiality shall be assessed in accordance with Article 178 CRR and the Commission Delegated Regulation (EU) 2018/171 (RTS on materiality threshold for credit obligations past due).
Annex V Part 2 §217 F 18.01 r0130
For the purpose of template 18, ‘exposures’ shall include all debt instruments (debt securities and loans and advances, including cash balances at central banks and other demand deposits) and off-balance sheet exposures, except those held for trading exposures.
Annex V Part 2 §226 F 18.01 c0010, c0020
Exposures classified as non-performing in accordance with paragraph 213 shall be categorised as either non-performing on an individual basis (‘transaction based’) or as non-performing for the overall exposure to a given debtor (‘debtor based’). For the categorisation of non-performing exposures on an individual basis or to a given debtor, the following categorisation approaches shall be used for the different types of non-performing exposures: (a) for non-performing exposures classified as defaulted in accordance with Article 178 CRR, the categorisation approach of that Article shall be applied; (b) for exposures that are classified as non-performing due to impairment under the applicable accounting framework, the recognition criteria for impairment under the applicable accounting framework shall be applied; (c) for other non-performing exposures that are neither classified as defaulted nor as impaired, the provisions of Article 178 CRR for defaulted exposures shall be applied.

Show all (19)

Annex V Part 2 §227 F 18.01 c0010, c0020
Where an institution has on-balance sheet exposures to a debtor that are past due by more than 90 days and the gross carrying amount of the past due exposures represents more than 20% of the gross carrying amount of all on-balance sheet exposures to that debtor, all on- and off-balance sheet exposures to that debtor shall be considered as non-performing. Where a debtor belongs to a group, the need to consider also exposures to other entities of the group as non-performing shall be assessed, except for exposures affected by isolated disputes that are unrelated to the solvency of the counterparty.
Annex V Part 2 §228 F 18.01 c0010, c0020
Exposures shall be considered to have ceased being non-performing where all of the conditions provided in Article 47a(4) CRR are met.
Annex V Part 2 §230 F 18.01 c0010, c0020
The classification of a non-performing exposure as non-current asset held for sale in accordance with IFRS 5 shall not discontinue their classification as non-performing exposure in accordance with Article 47a(5) CRR.
Annex V Part 2 §231 F 18.01 c0010, c0020
Granting forbearance measures to a non-performing exposure shall not discontinue the non-performing status of this exposure. Where exposures are non-performing with forbearance measures, as referred to in paragraph 262, those exposures shall be considered to have ceased being non-performing where all the conditions provided in Article 47a(6) CRR are met.
Annex V Part 2 §232 F 18.01 c0010, c0020
Where the conditions referred to in paragraph 231 of this Part of this Annex are not met at the end of the one year period specified in point (b) of Article 47a(6) CRR, the exposure shall continue to be identified as non-performing forborne exposure until all conditions are met. The conditions shall be assessed at least on a quarterly basis.
Annex V Part 2 §233 F 18.01 c0010, c0020
The accounting portfolios under IFRS listed in paragraph 15 of Part 1 of this Annex and under relevant national GAAP based on BAD listed in paragraph 16 of Part 1 of this Annex shall be reported as follows in template 18: (a) ‘Debt instruments at cost or at amortised cost’ shall encompass debt instruments included in any of the following: (i) ‘Financial assets at amortised cost’ (IFRS); (ii) ‘Non-trading non-derivative financial assets at a cost based method’, including debt instruments under moderate LOCOM (national GAAP based on BAD); (iii) ‘Other non-trading non-derivative financial assets’, except debt instruments measured at strict LOCOM (national GAAP based on BAD); (b) ‘Debt instruments at fair value through other comprehensive income or through equity subject to impairment’ shall encompass debt instruments included in any of the following: (i) ‘Financial assets at fair value through other comprehensive income’ (IFRS); (ii) ‘Non-trading non-derivative financial assets measured at fair value to equity’, where instruments in that measurement category can be subject to impairment in accordance with the applicable accounting framework under national GAAP based on BAD; (c) ‘Debt instruments at strict LOCOM, or at fair value through profit or loss or through equity not subject to impairment’ shall encompass debt instruments included in any of the following: (i) ‘Non-trading financial assets mandatorily at fair value through profit or loss’ (IFRS); (ii) ‘Financial assets designated at fair value through profit or loss’ (IFRS); (iii) ‘Non-trading non-derivative financial assets measured at fair value through profit or loss’ (national GAAP based on BAD); (iv) ‘Other non-trading non-derivative financial assets’ where debt instruments are measured under strict LOCOM (national GAAP based on BAD); (v) ‘Non-trading non-derivative financial assets measured at fair value through equity’, where debt instruments in that measurement category are not subject to impairment in accordance with the applicable accounting framework under GAAP based on BAD.
Annex V Part 2 §234 F 18.01 c0010, c0020
Where IFRS or the relevant national GAAP based on BAD provide for the designation of commitments at fair value through profit and loss, the carrying amount of any asset resulting from that designation and measurement at fair value shall be reported in ‘Financial assets designated at fair value through profit or loss’ (IFRS) or ‘Non-trading non-derivative financial assets measured at fair value through profit or loss’ (national GAAP based on BAD). The carrying amount of any liability resulting from that designation shall not be reported in template 18. The notional amount of all commitments designated at fair value through profit or loss shall be reported in template 9.
Annex V Part 2 §239i F 18.01 c0010, c0020
Template 18.1 shall provide the inflows and outflows of loans and advances, excluding loans and advances classified as trading financial assets or held for trading, that were classified into or out of the category of non-performing exposures as defined in paragraphs 213 to 239 or 260of this Part. Inflows and outflows of non-performing loans and advances shall be broken down by counterparty sector.
Annex V Part 2 §239ii F 18.01 c0010
Inflows to the non-performing exposures category shall be reported on a cumulative basis since the beginning of the financial year. The inflow shall reflect the gross carrying amount of exposures that have become non-performing as defined in paragraphs 213 to 239 or 260 of this Part during the period, including purchased non-performing exposures. An increase in the gross carrying amount of a non-performing exposure due to accrued interest or due to an increase in the accumulated negative changes in fair value due to credit risk shall be reported as an inflow as well.
Annex V Part 2 §239iii F 18.01 c0010
For an exposure that during the period has been reclassified multiple times from non-performing to performing or vice versa, the amount of inflows and outflows shall be identified based on a comparison between the status of the exposure (performing or non-performing) at the beginning of the financial year or at initial recognition and its status at the reporting reference date.
Annex V Part 2 §239vi F 18.01 c0010, c0020
The reclassification of a non-performing exposure from one accounting portfolio to another shall be reported neither as inflow nor as outflow. As an exception, the reclassification of a non-performing exposure from any accounting portfolio to ‘held for sale’ shall be reported as outflow from the original accounting portfolio and inflow to ‘held for sale’.
Annex V Part 2 §239iv F 18.01 c0020
Outflows from the non-performing exposures category shall be reported on a cumulative basis since the beginning of the financial year. The outflow shall reflect the sum of the gross carrying amounts of exposures that cease to be non-performing during the period, and, where applicable, shall include the amount of write-offs made in the context of the partial or full derecognition of the exposure. A decrease in the gross carrying amount of a non-performing exposure due to interest paid or a decrease in the accumulated negative changes in fair value due to credit risk shall be reported as an outflow as well.
Annex V Part 2 §239v F 18.01 c0020
An outflow shall be reported in the following cases: (a) a non-performing exposure meets the criteria for ceasing to be classified as non-performing as laid out in paragraphs 228 – 232 of this Part and is reclassified as performing not forborne or performing forborne; (b) a non-performing exposure is partially or totally repaid; in case of partial repayment, only the repaid amount shall be classified as outflow; (c) collateral is liquidated, including outflows due to other liquidation or legal procedures, such as the liquidation of assets other than collateral obtained via legal procedures, and the voluntary sale of the collateral; (d) the institution takes possession of the collateral as referred in paragraph 175 of this Part including cases of debt asset swaps, voluntary surrenders and debt equity swaps; (e) a non-performing exposure is sold; (f) the risk pertaining to a non-performing exposure is transferred and the exposure meets the criteria to be derecognised; (g) a non-performing exposure is written-off partially or totally; in case of partial write-offs, only the written-off amount shall be classified as outflow; (h) a non-performing exposure, or parts of a non-performing exposure, ceases to be non-performing for other reasons.

Controls11

11 other rules use at least one of these cells.

Other rules on the same cells

v8269_swarning7
with {tF_18.01, default: null, interval: false}: {r*, c0010} >= 0
v8270_swarning7
with {tF_18.01, default: null, interval: false}: {r*, c0020} <= 0
v23564_hwarning2
with{tF_18.01, c*, default: 0, interval: true}: abs({r0050}) >= abs({r0060})
v7822_mwarning2
The (net) flow of non-performing loans and advances during the period is less than or equal to the stock of non-performing loans and advances at the reference date
v7871_mwarning2
{r0150} = {r0130} + {r0140}
v7866_mwarning1
{r0050} >= {r0070} + {r0080}
v7867_mwarning1
{r0050} >= {r0090}
v7868_mwarning1
{r0100} >= {r0110}
v7869_mwarning1
{r0100} >= {r0120}
v8114_mwarning1
{r0050} >= {r0060}
v8116_mwarning1
{r0050} <= {r0060}

Interpretation—

No EBA Q&A cites this rule.

Changes—

No change to this rule between the releases loaded.

Source: the DPM 2.0 database of the release shown above (expression, description, scope, cells; official). References inherited from Annex I (verbatim) and EBA instructions 4.2; links and counts are derived.