Gender pay gap calculator
Load a payroll export and get the seven indicators of art. 9(1), the quartile pay bands and the gap in each category of workers. The file is read by your browser and never uploaded.
Your data stays on this device
The calculation runs in this page. Once it has loaded you can go offline and the calculator still works.
1. Load your data
CSV or TSV export from payroll, one row per worker. For Excel files, save the sheet as CSV (UTF-8) first.
Demo data: 120 fictitious workers of an Italian retailer in 8 collective-agreement levels. All figures are invented.
Expected columns: worker id, sex (F, M or X), category, base pay and variable pay for the year, paid hours, FTE, months employed. Only id, sex and base pay are required.
2. Check the columns
We matched your column headers. Check each field and pick another column where needed.
First rows as read
3. Method
Where the directive leaves room for interpretation, these options show the choice made. The defaults are a draft proposal.
Results
Legal basis of the indicators
Article text
‘pay level’ means gross annual pay and the corresponding gross hourly pay;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
‘gender pay gap’ means the difference in average pay levels between female and male workers of an employer expressed as a percentage of the average pay level of male workers;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
‘category of workers’ means workers performing the same work or work of equal value grouped in a non-arbitrary manner based on the non-discriminatory and objective gender-neutral criteria referred to in Article 4(4), by the workers’ employer and, where applicable, in cooperation with the workers’ representatives in accordance with national law and/or practice.Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the gender pay gap;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the gender pay gap in complementary or variable components;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the median gender pay gap;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the median gender pay gap in complementary or variable components;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the proportion of female and male workers receiving complementary or variable components;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the proportion of female and male workers in each quartile pay band;Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
the gender pay gap between workers by categories of workers broken down by ordinary basic wage or salary and complementary or variable components.Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
Member States shall take appropriate measures to ensure that employers who are subject to pay reporting pursuant to Article 9 conduct, in cooperation with their workers’ representatives, a joint pay assessment where all the following conditions are met: (a) the pay reporting demonstrates a difference in the average pay level between female and male workers of at least 5 % in any category of workers; (b) the employer has not justified such a difference in the average pay level on the basis of objective, gender-neutral criteria; (c) the employer has not remedied such an unjustified difference in the average pay level within six months of the date of submission of the pay reporting.Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
Member States may decide that, where the disclosure of information pursuant to Articles 7, 9 and 10 would lead to the disclosure, either directly or indirectly, of the pay of an identifiable worker, only the workers’ representatives, the labour inspectorate or the equality body shall have access to that information. The workers’ representatives or the equality body shall advise workers regarding a possible claim under this Directive without disclosing actual pay levels of individual workers performing the same work or work of equal value. For the purposes of monitoring pursuant to Article 29, the information shall be made available without restriction.Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
Article text
Where Member States’ authorities act in accordance with Article 38(7), point (a), of Directive 2014/23/EU, Article 57(4), point (a), of Directive 2014/24/EU, or Article 80(1) of Directive 2014/25/EU in conjunction with Article 57(4), point (a), of Directive 2014/24/EU, contracting authorities may exclude or may be required by Member States to exclude any economic operator from participation in a public procurement procedure where they can demonstrate by any appropriate means an infringement of the obligations referred to in paragraph 1 of this Article, related either to a failure to comply with pay transparency obligations or a pay gap of more than 5 % in any category of workers which is not justified by the employer on the basis of objective, gender-neutral criteria.Source: EUR-Lex, © European Union, https://eur-lex.europa.eu
This tool helps you check your figures. It is not legal advice, and national rules can differ.