v8017_m

warningactivewithin F 23.0568 cells · general rule

Expression · DPM 2.0, verbatim

with {tF_23.05, c*, default: 0, interval: true}: {r0080} >= {r0090} + {r0110} + {r0130}

EBA description {r0080} >= {r0090} + {r0110} + {r0130}

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

Cells involved

F 23.05 Loans and advances: Collateral received and financial guarantees received

Open template →

	c0010Maximum amount of the collateral or guarantee that can be considered	c0020of which: Exposures with forbearance measures	c0030Performing	c0040of which: Past due > 30 days <= 90 days	c0050of which: Exposures with forbearance measures	c0060Non Performing	c0070of which: Exposures with forbearance measures	c0080Unlikely to pay that are not past due or past due <= 90 days	c0090of which: Exposures with forbearance measures	c0100Past due > 90 days	c0110of which: Exposures with forbearance measures	c0120Past due > 90 days <= 180 days	c0130Past due > 180 days <= 1 year	c0140Past due > 1 years <= 2 years	c0150Past due > 2 years <= 5 years	c0160Past due > 5 years <= 7 years	c0170Past due > 7 years
0080Collateral received on loans and advances	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	in rule
0090Collateral received on loans and advances › of which: Households	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	in rule
0110Collateral received on loans and advances › of which: Non-financial corporations - SMEs	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	in rule
0130Collateral received on loans and advances › of which: Non-financial corporations - other than SMEs	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	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

v8017_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 17413 · official

Regulation32

From the rows and columns of the cells involved.

Annex V Part 1 §32 F 23.05 c0010
‘Loans and advances’ are debt instruments held by the institutions that are not securities. That item includes loans as defined in the Table of Part 2 of Annex II to the ECB BSI Regulation (including demand deposits at credit institutions and central banks, irrespective of their classification as per the applicable accounting framework) as well as advances that cannot be classified as ‘loans’ defined in the Table of Part 2 of Annex II to the ECB BSI Regulation. ‘Advances that are not loans’ are further characterized in paragraph 85(g) of Part 2 of this Annex.
Annex V Part 1 §42 F 23.05 r0090, r0110, r0130
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 §171 F 23.05 c0010, c0020, c0030, c0040, c0050, c0060, c0070, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170
The collateral and guarantees backing the loans and advances included in the accounting portfolios, independently of their legal form, shall be reported by type of pledges: loans collateralised by immovable property and other collateralised loans, and by financial guarantees received. The loans and advances shall be broken down by counterparties and purpose. In the item ‘of which: non-performing’, loans and advances shall be reported as defined in paragraphs 213 to 239 or 260 of this Part.
Annex V Part 2 §172 F 23.05 c0010, c0020, c0030, c0040, c0050, c0060, c0070, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170
In template 13.1, the ‘maximum amount of the collateral or guarantee that can be considered’ shall be reported. The sum of the amounts of the financial guarantee and/or collateral shown in the related columns of template 13.1 shall not exceed the carrying amount of the related loan.
Annex V Part 2 §174 F 23.05 c0010, c0020, c0030, c0040, c0050, c0060, c0070, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170
For loans and advances that have simultaneously several types of collateral or guarantee, the amount of the ‘Maximum collateral/guarantee that can be considered’ shall be allocated according to its quality, starting from the one with the best quality. For loans collateralised by immovable property, immovable property collateral shall always be reported first, irrespective of its quality compared to other collateral. Where the ‘Maximum collateral/guarantee that can be considered’ exceeds the value of immovable property collateral, its remaining value shall be allocated to other collateral types and guarantees according to its quality, starting from the one with best quality.
Annex V Part 2 §213 F 23.05 c0030, c0060
For the purposes of template 18, non-performing exposures shall be exposures listed in Article 47a(3) CRR.

Show all (31)

Annex V Part 2 §215 F 23.05 c0030, c0060
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 23.05 c0030, c0060
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 §222 F 23.05 c0040, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170
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 §226 F 23.05 c0030, c0060
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.
Annex V Part 2 §227 F 23.05 c0030, c0060
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 23.05 c0030, c0060
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 23.05 c0030, c0060
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 23.05 c0030, c0060
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 23.05 c0030, c0060
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 23.05 c0030, c0060
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 23.05 c0030, c0060
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 §234i F 23.05 c0030, c0060
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.
Annex V Part 2 §235 F 23.05 c0030, c0040, c0060, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170
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 23.05 c0030, c0060, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170
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 23.05 c0030, c0060
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 23.05 c0030, c0060
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.
Annex V Part 2 §239 F 23.05 c0030, c0060
Information on collateral held and guarantees received on performing and non-performing exposures shall be reported separately. Amounts reported for collateral received and guarantees received shall be calculated in accordance with paragraphs 172 and 174of this Part. The sum of the amounts reported for both collateral and guarantees shall be capped at the carrying amount or nominal amount after deduction of provisions of the related exposure.
Annex V Part 2 §256 F 23.05 c0020, c0070, c0090, c0110
Forborne exposures shall be included in the non-performing exposures category or the performing exposures category in accordance with paragraphs 213 to 239 and 260 of this Part. The classification as forborne exposure shall be discontinued where all of the conditions provided in Article 47a(7) CRR are met.
Annex V Part 2 §259 F 23.05 c0020, c0050, c0070, c0090, c0110
A forborne exposure may be considered as performing from the date the forbearance measures were applied where both of the following conditions are met: (a) that extension has not led the exposure to be classified as non-performing; (b) the exposure was not considered to be a non-performing exposure at the date the forbearance measures were extended.
Annex V Part 2 §260 F 23.05 c0020, c0050, c0070, c0090, c0110
Where additional forbearance measures are applied to a performing forborne exposure under probation that has been reclassified out of non-performing category or the forborne exposure under probation reclassified out of non-performing category becomes more than 30 days past due, the exposure shall be classified as non-performing in accordance with point (c) of Article 47a(3) CRR.
Annex V Part 2 §261 F 23.05 c0020, c0050, c0070, c0090, c0110
‘Performing exposures with forbearance measures’ (performing forborne exposures) shall comprise forborne exposures that do not meet the criteria to be considered as non-performing and that are included in the performing exposures category. Performing forborne exposures shall be under probation until all the criteria laid down in Article 47a(7) CRR, including where paragraph 259 of this Part applies, are met. Performing forborne exposures under probation that have been reclassified out of the non-performing forborne exposures category shall be reported separately within the performing exposures with forbearance measures in the column ‘of which: Performing forborne exposures under probation reclassified from non-performing’.
Annex V Part 2 §262 F 23.05 c0020, c0070, c0090, c0110
‘Non-performing exposures with forbearance measures’ (non-performing forborne exposures) shall comprise forborne exposures that meet the criteria to be considered as non-performing and that are included in the non-performing exposures category. Those non-performing forborne exposures shall include the following: (a) exposures which have become non-performing due to the application of forbearance measures; (b) exposures which were non-performing prior to the extension of forbearance measures; (c) forborne exposures which have been reclassified from the performing category, including exposures reclassified in application of paragraph 260.
Annex V Part 2 §263 F 23.05 c0020
Where forbearance measures are extended to exposures which were non-performing prior to the extension of forbearance measures, the amount of those forborne exposures shall be separately identified in the column ‘of which: forbearance of exposures non-performing prior to forbearance measures’.
Annex V Part 2 §319 F 23.05 r0080
Template 23 presents additional information on loans and advances, excluding loans and advances classified as cash balances at central banks and other demand deposits, held for trading, trading financial assets and debt instruments held for sale.
Annex V Part 2 §326 F 23.05 r0080
Information on collateral held and guarantees received on the loans and advances shall be reported in accordance with paragraph 239 of this Part. Consequently, the sum of the amounts reported for both collateral and guarantees shall be capped at the carrying amount of the related exposure. Immovable property pledged as collateral shall be reported separately in addition.

Other acts

SME Rec. art 1 2(a)

Controls17

17 other rules use at least one of these cells.

Other rules on the same cells

v8337_swarning44
with {tF_23.05, default: null, interval: false}: {r0010-0210, (c0020, c0050, c0070, c0090, c0110, c0120, c0130, c0140, c0150, c0160, c0170)} >= 0
v8018_mwarning34
{r0110} + {r0130} >= {r0120} + {r0140}
v8013_mwarning28
{c0100} = {c0120} + {c0130} + {c0140} + {c0150} + {c0160} + {c0170}
v8338_swarning24
with {tF_23.05, r*, default: null, interval: false}: {(c0010, c0030, c0040, c0060, c0080, c0100)} >= 0
v8019_mwarning17
{r0150} <= {r0080}
v8011_mwarning12
{c0070} = {c0090} + {c0110}
v8335_hwarning12
(Hierarchy IM31) [Not applicable/ Total exposures] must be equal to +[Non-performing exposures] + [Performing exposures]
v8336_hwarning12
(Hierarchy IM31) [Not applicable/ Total exposures] must be equal to +[Non-performing exposures] + [Performing exposures]
v8007_mwarning8
{c0010} >= {c0020}
v8008_mwarning8
{c0030} >= {c0040}
v8009_mwarning8
{c0030} >= {c0050}
v8010_mwarning8
{c0060} >= {c0070}
v8012_mwarning8
{c0080} >= {c0090}
v8014_mwarning8
{c0100} >= {c0110}
v8022_mwarning6
{r0220} >= {r0080}
v8004_mwarning1
{F 23.05, r0080, c0010} = xsum({F 18.00.d, (r0070, r0191, r0221, c0200, c0201)})
v8006_mwarning1
{F 23.05, r0080, c0020} = sum({F 19.00.e, (r0070, r0191, r0221), c0170})

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.