v7911_m

warningactivewithin F 23.01147 cells · general rule

Expression · DPM 2.0, verbatim

with {tF_23.01, r*, default: 0, interval: true}: {c0100} = {c0120} + {c0130} + {c0140} + {c0150} + {c0160} + {c0170}

EBA description {c0100} = {c0120} + {c0130} + {c0140} + {c0150} + {c0160} + {c0170}

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

Cells involved

F 23.01 Loans and advances: Number of instruments

Open template →

	c0100Past due > 90 days	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
0010Loans and advances	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0020Loans and advances › of which: Households	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0030of which: Households › of which: Loans collateralised by residential immovable property	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0040Loans and advances › of which: Non-financial corporations - SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0050of which: Non-financial corporations - SMEs › of which: Commercial Real Estate (CRE) loans to SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0060Loans and advances › of which: Non-financial corporations - other than SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0070of which: Non-financial corporations - other than SMEs › of which: Commercial Real Estate (CRE) loans to NFCs other than SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0080Loans and advances in pre-litigation status	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0090Loans and advances in pre-litigation status › of which: Households	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0100of which: Households › of which: Loans collateralised by residential immovable property	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0110Loans and advances in pre-litigation status › of which: Non-financial corporations - SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0120of which: Non-financial corporations - SMEs › of which: Commercial Real Estate (CRE) loans to SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0130Loans and advances in pre-litigation status › of which: Non-financial corporations - other than SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0140of which: Non-financial corporations - other than SMEs › of which: Commercial Real Estate (CRE) loans to NFCs other than SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0150Loans and advances in litigation status	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0160Loans and advances in litigation status › of which: Households	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0170of which: Households › of which: Loans collateralised by residential immovable property	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0180Loans and advances in litigation status › of which: Non-financial corporations - SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0190of which: Non-financial corporations - SMEs › of which: Commercial Real Estate (CRE) loans to SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0200Loans and advances in litigation status › of which: Non-financial corporations - other than SMEs	in rule	in rule	in rule	in rule	in rule	in rule	in rule
0210of which: Non-financial corporations - other than SMEs › of which: Commercial Real Estate (CRE) loans to NFCs other than SMEs	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

v7911_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 17292 · official

Regulation14

From the rows and columns of the cells involved.

Annex V Part 1 §32 F 23.01 r0010, r0080, r0150
‘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.01 r0020, r0040, r0060, r0090, r0110, r0130, r0160, r0180, r0200
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 1 §44 F 23.01 r0010, r0080, r0150
The immediate counterparties in the following transactions shall be: (a) for loans and advances, the immediate borrower. For trade receivables, the immediate borrower shall be the counterparty obliged to pay the receivables, except in transactions with recourse, where the immediate borrower shall be the transferor of receivables where the reporting institution does not acquire substantially all the risks and rewards of ownership of the transferred receivables; (b) for debt securities (including securitisation instruments) and equity instruments, the issuer of the securities; (c) for deposits, the depositor; (d) for short positions, the counterparty of the securities borrowing transaction or reverse repurchase agreement; (e) for derivatives, the direct counterparty of the derivative contract. For centrally cleared OTC derivatives, the direct counterparty shall be the clearing house acting as a central counterparty. Counterparty breakdown for credit risk derivatives refers to the sector where the counterparty of the contract (buyer or seller of protection) belongs; (f) for financial guarantees given, the counterparty shall be the direct counterparty of the underlying guaranteed debt instrument; (g) for loan commitments and other commitments given, the counterparty whose credit risk is assumed by the reporting institution; (h) for loan commitments, financial guarantees and other commitments received, the guarantor or the counterparty that has provided the commitment to the reporting institution.
Annex V Part 2 §86 F 23.01 r0030, r0100, r0170
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 23.01 r0030, r0100, r0170
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 §222 F 23.01 c0100, 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.

Show all (13)

Annex V Part 2 §234i F 23.01 r0030
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.01 c0100, 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.01 c0100, 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 §239ix F 23.01 r0050, r0070, r0120, r0140, r0190, r0210
‘Commercial real estate (CRE) loans’ shall comprise exposures as defined in section 2, chapter 1, paragraph 1 of the ESRB Recommendation on closing real estate data gaps.
Annex V Part 2 §319 F 23.01 r0010, r0080, r0150
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 §321 F 23.01 r0080
An exposure shall be ‘in pre-litigation status’ where the debtor has been formally notified that the institution will take legal action against the debtor within a defined time period, unless certain contractual or other payment obligations are met. That shall also include cases where the contract has been terminated by the reporting institution because the debtor is in formal breach of the terms and conditions of the contract and the debtor has been notified accordingly, but no legal action against the debtor has formally been taken by the institution yet. Exposures classified as ‘in pre-litigation status’ can exit this classification if the outstanding amounts are paid or if they enter into litigation status as defined in the following paragraph.
Annex V Part 2 §322 F 23.01 r0150
An exposure shall be ‘in litigation status’ where legal action against the debtor has formally been taken. This comprises cases where a court of law confirmed that formal judiciary proceedings have occurred or the judiciary system has been notified of the intention to commence legal proceedings.

Other acts

SME Rec. art 1 2(a)

Controls24

24 other rules use at least one of these cells.

Other rules on the same cells

v8307_swarning147
with {tF_23.01, r*, default: null, interval: false}: {(c0010, c0020, c0060, c0070, c0080, c0090, c0100, c0110, c0120, c0130, c0140, c0150, c0160, c0170)} >= 0
v7913_mwarning28
{r0010} >= {r0020} + {r0040} + {r0060}
v7917_mwarning28
{r0040} + {r0060} >= {r0050} + {r0070}
v7922_mwarning28
{r0080} >= {r0090} + {r0110} + {r0130}
v7923_mwarning28
{r0110} + {r0130} >= {r0120} + {r0140}
v7924_mwarning28
{r0150} >= {r0160} + {r0180} + {r0200}
v7925_mwarning28
{r0180} + {r0200} >= {r0190} + {r0210}
v7912_mwarning21
{c0100} >= {c0110}
v7914_mwarning21
{r0010} >= {r0080} + {r0150}
v7915_mwarning21
{r0020} >= {r0090} + {r0160}
v7916_mwarning21
{r0030} >= {r0100} + {r0170}
v7918_mwarning21
{r0040} >= {r0110} + {r0180}
v7919_mwarning21
{r0050} >= {r0120} + {r0190}
v7920_mwarning21
{r0060} >= {r0130} + {r0200}
v7921_mwarning21
{r0070} >= {r0140} + {r0210}
v8119_mwarning14
{r0020} >= {r0030}
v8120_mwarning14
{r0040} >= {r0050}
v8121_mwarning14
{r0060} >= {r0070}
v8122_mwarning14
{r0090} >= {r0100}
v8123_mwarning14
{r0110} >= {r0120}
v8124_mwarning14
{r0130} >= {r0140}
v8125_mwarning14
{r0160} >= {r0170}
v8126_mwarning14
{r0180} >= {r0190}
v8127_mwarning14
{r0200} >= {r0210}

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.