v5015_m

warningactivecross-template · F 06.01 ↔ F 18.005 cells · specific check

Expression · DPM 2.0, verbatim

with {default: 0, interval: true}: sum ({tF_06.01, r0190, c0021-0022}) = {tF_18.00.b, r0120, c0130} + {tF_18.00.b, r0196, c0130} + {tF_18.00.b, r0226, c0130}

EBA description 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}

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

Cells involved

F 06.01 Breakdown of loans and advances other than held for trading, trading or held for sale assets to non-financial corporations by NACE codes

Open template →

	c0021Accumulated impairment	c0022Accumulated negative changes in fair value due to credit risk on non-performing exposures
0190Loans and advances	in rule	in rule

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
0120Loans and advances › Non-financial corporations	in rule
0196Loans and advances › Non-financial corporations	in rule
0226Loans and advances › Non-financial corporations	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

v5015_m

What it is

Type: Validation rule · cross-template, specific check
Release: FINREP 4.4 validation · reported from 2026-03-31
Source: DPM 2.0 4.4 · operation 16410 · official

Regulation8

From the rows and columns of the cells involved.

Annex V Part 1 §32 F 06.01 r0190
‘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 06.01 c0021, c0022 · F 18.00 r0120, r0196, r0226
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 §69 F 06.01 c0022
For the purposes of Annexes III and IV as well as this Annex, ‘accumulated negative changes in fair value due to credit risk’ means, for non-performing exposures, accumulated changes in fair value due to credit risk where the accumulated net change is negative. The accumulated net change in fair value due to credit risk shall be calculated by adding all negative and positive changes in fair value due to credit risk that have occurred since recognition of the debt instrument. That amount shall only be reported where the addition of positive and negative changes in fair value due to credit risk results in a negative amount. The valuation of the debt instruments shall be performed on the level of single financial instruments. For each debt instrument, ‘Accumulated negative changes in fair value due to credit risk’ shall be reported until the derecognition of the instrument.
Annex V Part 2 §70 F 06.01 c0021
For the purposes of Annexes III and IV as well as this Annex, ‘accumulated impairment’ shall have the following meaning: (a) for debt instruments measured at amortised cost or at a cost-based method, that are not purchased or originated credit-impaired financial assets, accumulated impairment is the cumulative amount of impairment losses, net of use and reversals that has been recognised, where appropriate for each of the impairment stages. Accumulated impairment reduces the carrying amount of the debt instrument through the use of an allowance account under IFRS and national GAAP based on BAD, or via direct reductions that do not constitute a derecognition event under national GAAP based on BAD; (b) for debt instruments measured at fair value through other comprehensive income under IFRS that are not purchased or originated credit-impaired financial assets, accumulated impairment is the sum of expected credit losses and their variations recognised as a reduction of fair value on a given instrument since initial recognition; (c) for debt instruments at fair value through equity under national GAAP based on BAD subject to impairment, accumulated impairment is the cumulative amount of impairment losses, net of use and reversals that has been recognised. The reduction in the carrying amount is either made through use of an allowance account or via direct reductions that do not constitute a derecognition event. (d) for purchased or originated credit-impaired financial assets, the initial estimate of lifetime expected credit losses is incorporated into the calculation of the credit-adjusted effective interest rate and accumulated impairment is the sum of subsequent changes in lifetime expected credit losses since initial recognition that are recognized as a variation of carrying amount/fair value on a given instrument. Accumulated impairment for purchased or originated credit-impaired financial assets can be positive in case of impairment gains exceeding any previously recognised impairment losses (IFRS 9.5.5.14).
Annex V Part 2 §71 F 06.01 c0021
Under IFRS, accumulated impairment shall include the allowance for expected credit losses for financial assets under each of the impairment stages specified by IFRS 9 and the allowance for purchased or originated credit-impaired financial assets. Under national GAAP based on BAD, it shall include specific and general allowance for credit risk, as well as the general allowance for banking risk where it reduces the carrying amount of debt instruments. Accumulated impairment shall also include the credit risk-induced value adjustments on financial assets under LOCOM.
Annex V Part 2 §90 F 06.01 r0190
Gross carrying amount of loans and advances to non-financial corporations other than those included in the held for trading, trading or held for sale portfolios shall be classified by sector of economic activities using NACE Codes on the basis of the principal activity of the counterparty.

Show all (8)

Annex V Part 2 §91 F 06.01 c0021, c0022
The classification of the exposures incurred jointly by more than one obligor shall be done in accordance with paragraph 43 of Part 1 of this Annex.
Annex V Part 2 §238 F 18.00 c0130
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.

Controls32

32 other rules use at least one of these cells.

Other rules on the same cells

v5265_mwarning3
{F 06.01, r0190, c0021} = sum({F 18.00.b, c0130, (r0120, r0196)})
v5705_swarning3
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
v0879_merror2
{r0190} = {r0010} + {r0020} + {r0030} + {r0040} + {r0050} + {r0060} + {r0070} + {r0080} + {r0090} + {r0100} + {r0105} + {r0110} + {r0120} + {r0130} + {r0140} + {r0150} + {r0160} + {r0170} + {r0180}
v5266_merror2
{F 06.01, r0190, c0022} = {F 18.00.b, r0226, c0130}
v2704_hwarning2
(Hierarchy IM31) [Not applicable/ Total exposures] must be equal to +[Non-performing exposures] + [Performing exposures]
v4975_mwarning2
{F 05.01, r0080, c0050} = {F 06.01, r0190, c0010} + {F 06.01, r0190, c0021} + {F 06.01, r0190, c0022}
v5317_mwarning2
sum({F 18.00.b, c0130, (r0120, r0196)}) = sum({F 20.04, r0190, c0031, (sNNN)})
v5676_swarning2
with {tF_06.01, r*, default: null, interval: false}: {c0021-0022} <= 0
v903124_hwarning2
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}
v5261_merror1
{F 18.00.b, r0226, c0130} = {F 04.02.1, r0160, c0020} + {F 04.02.2, r0170, c0020}
v5536_merror1
{F 06.01, r0190, c0022} = {F 04.02.1, r0160, c0020} + {F 04.02.2, r0170, c0020}
v5537_merror1
{F 06.01, r0190, c0022} = {F 04.07, r0170, c0021} + {F 04.08, r0170, c0030} + {F 04.09, r0120, c0080} + {F 04.10, r0170, c0090}
v23558_hwarning1
with{tF_18.00.b, c*, default: 0, interval: true}: abs({r0196}) >= abs({r0900})
v23559_hwarning1
with{tF_18.00.b, (c0130, c0150, c0160, c0170, c0180, c0191, c0192, c0196, c0197), default: 0, interval: true}: abs({r0226}) >= abs({r0920})
v2713_mwarning1
{r0070} = sum(r0080, r0090, r0100, r0110, r0120, r0150)
v2722_mwarning1
{r0191} = sum(r0192, r0193, r0194, r0195, r0196, r0197)
v2750_hwarning1
(Hierarchy CT20) [Not applicable/ All counterparties] must be less than or equal to +[SME]
v2751_mwarning1
{r0140} >= {r0120}
v3144_mwarning1
{F 06.01, c0021} = sum({F 20.07.1, c0021, (sNNN)})
v5120_mwarning1
{F 06.01, c0022} = sum({F 20.07.1, c0022, (sNNN)})
v5153_mwarning1
{r0221} = {r0222} + {r0223} + {r0224} + {r0225} + {r0226} + {r0227}
v5233_mwarning1
{F 18.00.b, r0120, c0130} = sum({F 04.04.1, r0120, (c0050, c0060, c0070, c0071)})
v5247_mwarning1
{F 18.00.b, r0196, c0130} = sum({F 04.03.1, r0160, (c0050, c0060, c0070, c0071)})
v5330_mwarning1
with {default: 0, interval: true}: {tF_18.00.b, r0226, c0130} = sum ({tF_20.04, r0190, c0040})
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)})

+ 7 more: see them lit in the grid of F 06.01.

Interpretation1

2017_3527

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.