Annex VII – Data quality checks

Row Data quality check

The number of staff reported under the columns management body should be 1 and 9 integer numbers.

The total fixed remuneration should be the sum of rows 3, EU 4a, 5, EU5x and 7; 2 where identified staff are reported the amount should be > zero

The number of staff reported should not be higher than the number of staff 9 reported in row 1

The total variable remuneration should be the sum of rows 11, EU-13a, EU-13b, 10 EU-14x and 15

The total variable remuneration should not be lower than the sum of severance 10 payments and guaranteed variable remuneration in table REM2 rows 2 and 7

The sum of deferred remuneration in rows 12, EU-14a, EU-14b, EU-14y and 16 - should not be higher than the value in row 10

Ratio of deferred remuneration: the sum of deferred remuneration in rows 12, EU-14a, EU-14b, EU-14y and 16 should be higher than or equal to 0.4 times the value in row 10 after the deduction of guaranteed variable remuneration (table REM2 row 3) as well as severance payments (table REM2 row 10) and the amounts of variable remuneration awarded to staff where the derogation under Article 94(3)(b) applies (see Annex II). - Institutions should bear in mind that this simplified validation rule is for benchmarking purposes only and is not a validation of compliance with the remuneration requirements regarding guaranteed variable remuneration and severance payments, i.e. while the full amounts are deducted, parts of the amounts are possibly subject to the requirement to pay out parts of the variable remuneration under deferral arrangements.

14 The ITS is available under: https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:32021R0637&from=EN

This validation rule does not apply to institutions where all identified staff benefit from the derogation from the requirement to pay out parts of the variable remuneration under deferral arrangements under Article 94 (3) (a) of Directive 2013/36/EU.

11 and 12 The value in row 12 must not be higher than the value in row 11

EU-13a and The value in row EU-14a must not be higher than the value in row EU-13a EU-14a

EU-13b and The value in row EU-14b must not be higher than the value in row EU-13b EU-14b

EU-14x and The value in row EU-14y must not be higher than the value in row EU-14x EU-14y

15 and 16 The value in row 16 must not be higher than the value in row 15

The ratio between fixed (row 2) and variable (row 10) remuneration must not be

• - higher than, as applicable, 100% or 200%, after excluding rows 3 and 10 of table REM2 (bonus cap)

Payout in instruments: the sum of rows EU 13-a, EU 13-b and EU-14x should be equal to or higher than 50% of the total variable remuneration (REM2 row 10) after deducting the variable remuneration of staff where the derogation under Article 94(3)(b) applies (see Annex II), guaranteed variable remuneration (table REM2 row 3) and severance payments (table REM2 row 10).

severance payments, i.e. while the full amounts are deducted, parts of the amounts are possibly subject to the requirement to pay out parts of the variable remuneration in instruments.

This validation rule does not apply to institutions where all identified staff benefit from the derogation from the requirement to pay out parts of the variable remuneration in instruments under Article 94 (3) (a) of Directive 2013/36/EU.

Table REM2

1, 4 and 6 Number of staff reported under columns ‘ a ’ and ‘ b ’ should be integer numbers.

1 and 2 If row 2 has a positive value, row 1 needs to have a positive value as well, and vice versa.

2 The value of row 3 should not be higher than the value in row 2

6 and 7 If row 7 has a positive value, row 6 needs to have a positive value as well, and vice versa.

7 The value of the sum of rows 8 and 9 must be equal to the value in row 7

10 The value of row 10 must not be higher than the value of row 8

11 The value of row 11 must not be higher than the value in row 7

Table REM3

1 The values must be equal to the sum of the values of rows 2, 3, 4, 5 and 6 for each column

The values must be equal to the sum of the values of rows 8, 9, 10, 11 and 12 for each 7 column

The values must be equal to the sum of the values of rows 14, 15, 16, 17 and 18 for each 13 column

The values must be equal to the sum of the values of rows 20, 21, 22, 23 and 24 for each 19 column

25 The values must be equal to the sum of the values of rows 1, 7, 13 and 19 for each column

The value in column ‘ a ’ must be equal to the sum of the values of columns ‘ b ’ and ‘ c ’ for - each row

30

Table REM5

The number in column ‘ j ‘ must be equal to the sum of row 2 column ‘ c ’ , row 3 columns ‘ d ’ 1 to ‘ i ’ and row 4 columns ‘ d ’ to ‘ i ’

2 Column ‘c’ must be equal to the sum of columns ‘a’ and ‘b’

3 The sum of the numbers in column ‘d’ to ‘i’ must be equal to the number in row 1 column ‘c’ of table REM1

4 The sum of the numbers in column ‘d’ to ‘i’ must be equal to the number in row 1 column ‘d’ of table REM1

The value in each column ‘ a ’ to ‘ i ’ must be equal to the sum of rows 6 and 7 of the 5 respective column

The sum of column ‘c’ to ‘i’ must be equal to the sum of columns ‘a’ to ‘d’ of row 17 in 5 table REM1

The values in columns ‘ a ’ and ‘ b ’ must be equal to the values in columns ‘ a ’ and ‘ b ’ in row 6 10 in table REM1, respectively

The sum of columns ‘c’ to ‘i’ must be equal to the sum of columns ‘a’ to ‘d’ of row 10 in 6 table REM1

The values in columns ‘ a ’ and ‘ b ’ must be equal to the values in columns ‘ a ’ and ‘ b ’ in row 7 2 in table REM1, respectively

The sum of columns ‘c’ to ‘i’ must be equal to the sum of columns ‘a’ to ‘d’ of row 2 in table 7 REM1

31