v2751_m

warningactivewithin F 18.0032 cells · general rule

Expression · DPM 2.0, verbatim

with {tF_18.00.b, c0130-0951, default: 0, interval: true}: {r0140} >= {r0120}

EBA description {r0140} >= {r0120}

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

Cells involved

F 18.00 (NPE) Information on performing and non-performing exposures

Open template →

	c0130Accumulated impairment, accumulated negative changes in fair value due to credit risk and provisions	c0140Performing exposures - Accumulated impairment and provisions	c0910of which: Past due > 30 days <= 90 days	c0141Of which: Instruments without significant increase in credit risk since initial recognition (Stage 1)	c0142Of which: Instruments with significant increase in credit risk since initial recognition but not credit-impaired (Stage 2)	c0143Of which: purchased or originated credit-impaired financial assets	c0150Non-performing exposures - Accumulated impairment, accumulated negative changes in fair value due to credit risk and provisions	c0160Unlikely to pay that are not past-due or past-due <= 90 days	c0170Past due > 90 days <= 180 days	c0180Past due > 180 days <= 1 year	c0191Past due > 1 year <= 2 years	c0192Past due > 2 years <= 5 years	c0196Past due > 5 years <= 7 years	c0197Past due > 7 years	c0950Of which: Instruments with significant increase in credit risk since initial recognition but not credit-impaired (Stage 2)	c0951Of which: Credit-impaired instruments (Stage 3)
0120Loans and advances › Non-financial corporations	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0140Non-financial corporations › Of which: Loans collateralised by commercial immovable property	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	in rule	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

v2751_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 15853 · official

Regulation18

From the rows and columns of the cells involved.

Annex V Part 1 §42 F 18.00 r0120
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 §86 F 18.00 r0140
Loans and advances shall be classified on the basis of the collateral received as follows: (a) ‘Loans collateralized by immovable property’ shall include loans and advances formally secured by residential or commercial immovable property collateral, regardless of their loan/collateral ratio (commonly referred as ‘loan-to-value’) and the legal form of the collateral; (b) ‘Other collateralized loans’ shall include loans and advances formally secured by collateral, regardless of their loan/collateral ratio (commonly referred to as ‘loan-to-value’ (LTV) ratio) and the legal form of the collateral, other than ‘Loans collateralised by immovable property’. That collateral shall include pledges of securities, cash, and other collateral, regardless of the legal form of the collateral.
Annex V Part 2 §87 F 18.00 r0140
Loans and advances shall be classified based on the collateral and irrespective of the purpose of the loan. The carrying amount of loans and advances secured by more than one type of collateral shall be classified and reported as collateralised by immovable property where those loans and advances are secured by immovable property regardless of whether they are also secured by other types of collateral.
Annex V Part 2 §215 F 18.00 c0143
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 §222 F 18.00 c0910
For the purpose of template 18, an exposure is ‘past-due’ where it meets the criteria of paragraph 96 of this Part. For the purpose of classification of exposures as non-performing in accordance with point (a) of Article 47a(3) CRR, the counting of 90 days past due commences once the past due amount, being the sum of past due principal, interest and fees, breaches the materiality threshold as defined in paragraph 216 of this Part. If the past due part of exposures continues to be material for 90 consecutive days, the exposure should then be classified as non-performing.
Annex V Part 2 §234i F 18.00 r0140
The following exposures shall be identified in separate rows: (a) Loans collateralised by immovable property as defined in paragraphs 86(a) and 87of this Part; (b) Credit for consumption as defined in paragraph 88(a) of this Part.

Show all (10)

Annex V Part 2 §235 F 18.00 c0910
Past due exposures shall be reported separately within the performing and non-performing categories for their entire amount as defined in paragraph 96 of this Part. Exposures past due by more than 90 days but that are not material in accordance with Article 178 CRR shall be reported within performing exposures in ‘Past due > 30 days <= 90 days’.
Annex V Part 2 §236 F 18.00 c0160, c0170, c0180, c0191, c0192, c0196, c0197
Non-performing exposures shall be reported broken down by past due time bands. In case of application of the debtor approach for the classification of exposures as non-performing referred to in paragraph 226 of this Part of this Annex, the exposures of the debtor shall be reported in the past-due time bands of non-performing in accordance with their individual past-due status. Exposures that are not past due or are past due by 90 days or less, but are nevertheless identified as non-performing due to the likelihood of non-full repayment, shall be reported in a dedicated column. Exposures that present both past due amounts and a likelihood of non-full repayment shall be allocated by past-due time bands consistent with the number of days that they are past due.
Annex V Part 2 §237 F 18.00 c0910, c0141, c0142, c0143, c0950, c0951
The following exposures shall be identified in separate columns: (a) exposures which are considered to be impaired in accordance with the applicable accounting framework; under IFRS, the amount of credit-impaired assets (Stage 3) which does not include purchased or originated credit impaired assets, shall be reported; under national GAAP, the amount of impaired assets shall be reported; (b) exposures in respect of which a default is considered to have occurred in accordance with Article 178 CRR; (c) under IFRS, assets with significant increase in credit risk since initial recognition, but not credit-impaired (Stage 2) which do not include purchased or originated credit impaired assets; (d) under IFRS, for performing exposures, assets without significant increase in credit risk since initial recognition (Stage 1); (e) exposures which are considered as purchased or originated financial assets that are credit-impaired at initial recognition in accordance with IFRS 9 Appendix A, including any off-balance sheet exposures that are deemed credit-impaired upon their initial recognition; (f) for performing exposures, the amount of accumulated impairment for exposures past due by more than 30 days.
Annex V Part 2 §238 F 18.00 c0130, c0140, c0150, c0160, c0170, c0180, c0191, c0192, c0196, c0197
Accumulated impairment, accumulated negative changes in fair value due to credit risk and provisions shall be reported in accordance with paragraphs 11, 69 to 71, 106 and 110of this Part.

Other acts

IFRS 9.5.5.5 IFRS 7.35M(a)IFRS 9.5.5.3 IFRS 7.35M(b)(i)IFRS 9.5.5.13 IFRS 7.35M(c)IFRS 9.5.5.1 IFRS 9.Appendix A

Controls44

44 other rules use at least one of these cells.

Other rules on the same cells

v5705_swarning18
with {tF_18.00.b, default: null, interval: false}: {(r0005, r0010, r0020, r0030, r0040, r0050, r0060, r0070, r0080, r0090, r0100, r0110, r0120, r0130, r0140, r0150, r0160, r0170, r0180, r0181, r0182, r0183, r0184, r0185, r0186, r0191, r0192, r0193, r0194, r0195, r0196, r0197, r0201, r0211, r0212, r0213, r0214, r0215, r0216, r0221, r0222, r0223, r0224, r0225, r0226, r0227, r0231, r0330, r0335, r0900, r0903, r0910, r0913, r0920, r0923, r0930, r0933), (c0130, c0150, c0160, c0170, c0180, c0191, c0192, c0196, c0197)} <= 0
v2705_mwarning16
{c0150} = sum(c0160, c0170, c0180, c0191, c0192, c0196, c0197)
v2713_mwarning16
{r0070} = sum(r0080, r0090, r0100, r0110, r0120, r0150)
v2750_hwarning16
(Hierarchy CT20) [Not applicable/ All counterparties] must be less than or equal to +[SME]
v23161_swarning14
with {tF_18.00.b, default: null, interval: false}: {(r0005, r0010, r0020, r0030, r0040, r0050, r0060, r0070, r0080, r0090, r0100, r0110, r0120, r0130, r0140, r0150, r0160, r0170, r0180, r0181, r0182, r0183, r0184, r0185, r0186, r0191, r0192, r0193, r0194, r0195, r0196, r0197, r0201, r0330, r0335, r0900, r0903, r0910, r0913), (c0140, c0141, c0142, c0143, c0910, c0950, c0951, c0952)} <= 0
v10613_mwarning6
{c0150} <= +{c0950} + {c0951} + {c0952}
v2704_hwarning6
(Hierarchy IM31) [Not applicable/ Total exposures] must be equal to +[Non-performing exposures] + [Performing exposures]
v903124_hwarning6
with{tF_18.00.b.dp, (r0010, r0020, r0030, r0040, r0050, r0060, r0070, r0080, r0090, r0100, r0110, r0120, r0130, r0140, r0150, r0160, r0170, r0180, r0181, r0182, r0183, r0184, r0185, r0186, r0191, r0192, r0193, r0194, r0195, r0196, r0197, r0201, r0330, r0335, r0340, r0350, r0360, r0370, r0380, r0390, r0400, r0410, r0420, r0430, r0440, r0450, r0460, r0470, r0480, r0490, r0500, r0510, r0520, r0530, r0540, r0550), default: 0, interval: true}: {c0130} = {c0150} + {c0140}
v12028_mwarning4
if {F 00.01, r0010, c0010} = [eba_AS:x2] then ({F 18.00.b, r0120, c0140} = +{F 18.00.b, r0120, c0141} + {F 18.00.b, r0120, c0142} + {F 18.00.b, r0120, c0143})
v12030_mwarning4
if {F 00.01, r0010, c0010} = [eba_AS:x2] then ({F 18.00.b, r0140, c0140} = +{F 18.00.b, r0140, c0141} + {F 18.00.b, r0140, c0142} + {F 18.00.b, r0140, c0143})
v903277_hwarning3
with{tF_18.00.b.dp, c*, default: 0, interval: true}: abs({r0120}) >= abs({r0130})
v09623_mwarning1
{F 18.00.b, r0120, c0910} = +{F 23.04, r0130, c0040} + {F 18.00.b, r0130, c0910}
v11947_mwarning1
{F 18.00.d, r0120, c0200} + {F 18.00.c, r0120, c0210} <= {F 18.00.a, r0120, c0060} + {F 18.00.b, r0120, c0150}
v11949_mwarning1
{F 18.00.d, r0140, c0200} + {F 18.00.c, r0140, c0210} <= {F 18.00.a, r0140, c0060} + {F 18.00.b, r0140, c0150}
v5015_mwarning1
sum({F 06.01, r0190, (c0021, c0022)}) = {F 18.00.b, r0120, c0130} + {F 18.00.b, r0196, c0130} + {F 18.00.b, r0226, c0130}
v5233_mwarning1
{F 18.00.b, r0120, c0130} = sum({F 04.04.1, r0120, (c0050, c0060, c0070, c0071)})
v5265_mwarning1
{F 06.01, r0190, c0021} = sum({F 18.00.b, c0130, (r0120, r0196)})
v5317_mwarning1
sum({F 18.00.b, c0130, (r0120, r0196)}) = sum({F 20.04, r0190, c0031, (sNNN)})
v5487_mwarning1
{F 18.00.b, r0120, c0130} = sum({F 04.09, r0120, (c0030, c0041, c0045, c0080)}) + sum({F 04.10, r0170, (c0030, c0040, c0050)})
v7820_mwarning1
{F 18.00.d, c0201} + {F 18.00.c, c0205} <= {F 18.00.a, c0020} + {F 18.00.b, c0140}
v8446_mwarning1
{F 18.00.d, r0140, c0201} + {F 18.00.c, r0140, c0205} <= {F 18.00.a, r0140, c0020} + {F 18.00.b, r0140, c0140}
v8687_mwarning1
sum({F 18.00.b, c0130, (r0140, r0903)}) = sum({F 20.04, r0210, c0031, (sNNN)})
v89860_hwarning1
with{default: 0, interval: true}: {tF_18.00.b, r0120, c0130} = {tF_23.04, r0110, c0010} + {tF_23.04, r0130, c0010}
v89861_hwarning1
with{default: 0, interval: true}: {tF_18.00.b, r0120, c0130} = {tF_18.00.b, r0130, c0130} + {tF_23.04, r0130, c0010}
v89862_hwarning1
with{default: 0, interval: true}: {tF_18.00.b, r0120, c0150} = {tF_23.04, r0110, c0060} + {tF_23.04, r0130, c0060}

+ 19 more: see them lit in the grid of F 18.00.

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.