UK Ethnicity Pay Gap Calculator and Reporting Tool 2024

Easily complete your Ethnicity Pay Gap Reporting with This Downloadable, Excel-Based Ethnicity Pay Gap Calculator and Reporting App.

Employers are not required by law to conduct ethnicity pay gap reporting but many employers including the NHS, Network Rail, Shell, Lloyds Banking Group, charities such as Barnardos, and WWF do so voluntarily. The UK government provides a framework to follow when doing ethnicity pay gap reporting. The measures that they believe are worth monitoring are:

percentage of each ethnic group in each hourly pay quarter
mean (average) ethnicity pay gap using hourly pay
median ethnicity pay gap using hourly pay
percentages of employees in different ethnic groups in your organisation
percentage of employees who did not disclose their ethnicity – they either answered ‘prefer not to say’ or gave no answer when you attempted to

If your organization provides bonuses you could also choose to monitor the:

the percentage of each ethnic group receiving bonus pay
the mean (average) pay gap for bonus pay
median ethnicity pay gap for bonus pay.
This smart Excel template will automatically calculate your Ethnicity pay gap.

FEATURES

Easy to use, one-click, automated data import system
Can take up to 100,000 records
Will automatically perform ethnpay calculations
Automatically produces tabular and graphical reports.
BENEFITS

A time-saving process that will streamline your ethnicity pay gap analysis
Privacy guaranteed as data stored in Excel on your machine, not online.
Simplifies the Ethnicity pay reporting process