UK Ethnicity Pay Gap Calculator and Reporting Tool 2025
UK Ethnicity Pay Gap Calculator and Reporting Tool 2025
Easily complete your Ethnicity Pay Gap Reporting with This Downloadable, Excel-Based Ethnicity Pay Gap Calculator and Reporting App.
.
Need help? Try our: Ethnicity Pay Gap Consulting Service
PRODUCT SUMMARY
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
PRODUCT DEMO
PRODUCT DETAIL
As soon as you have downloaded our Ethnicity Pay Gap Calculator, smart excel template, you can get started with your Ethnicity pay gap analysis. Save a spare copy of the file, just in case you make a mistake in your working file. After the file is opened you will need to “Enable Editing” and “Enable Content” in order to make changes and allow totals to calculate.
Getting Started
There is a sheet titled, “instructions” which tells you how to use the document.
Preparing Your Data Ready for Import.
Before you can use the system you will need to submit your Ethnicity pay data. Before, you can submit your Ethnicity pay data, you will need to prepare your data file. You can find advice on preparing your data file in this help article: How To Calculate and Report on The Ethnicity Pay Gap in Your Organization.
Once your data file is ready, you can import your data into Ethnicity Pay Gap Calculator
Submitting Your Data – On mass
You can group submit your employee data using the ‘total list’ worksheet. Cut and paste or import your data. You can submit ‘name’ data if you wish, but if anonymity is needed, leave the name section blank. You can hide the name column, but don’t delete it or you will break the macro. You must as a minimum submit data for ‘ethnicity’, ‘hourly salary’ and ‘bonus’ for the model to work.
Reporting and Verifying Data
Once you have imported/submitted your data successfully, go to the ‘dashboard’ worksheet and view your automatically calculated Ethnicity pay gap calculations and report.
You may choose to publish this data on your own public facing website but ensure that the data is fully anonymized to ensure compliance with General Data Protection Law. While thecareercafe.co.uk has taken every precaution to ensure the correctness of the analytical calculations used in these programs, we do not guarantee the results will be error-free.
You can find further advice in this help article: How To Calculate and Report on The Ethnicity Pay Gap in Your Organization.
——————————————————————————————————————————————————————————————————————————————————————–
UK Ethnicity Pay Gap Calculator and Reporting Tool 2025
Easily complete your Ethnicity Pay Gap Reporting with This Downloadable, Excel-Based Ethnicity Pay Gap Calculator and Reporting App.
.
Need help? Try our: Ethnicity Pay Gap Consulting Service
Disclaimer: While thecareercafe.co.uk has taken every precaution to ensure the correctness of the analytical calculations used in these programs, we do not guarantee the results will be error-free.
The results generated in our Ethnicity Pay Gap Tool, as well as the information contained in the Dataset, is greatly dependent on the accuracy and quality of the Employee Data imported by the users, we therefore offer no guarantee or warranty of any kind, express or implied, concerning the accuracy, level of performance, comprehensiveness or suitability of the information delivered by our app.
The responsibilities for correctly fulfilling your Ethnicity pay reporting obligations remains with the user, and you should check all reports carefully to ensure you are satisfied with their accuracy
In no event shall thecareercafe.co.uk be liable to you or any third parties for any damages whatsoever, including, without limitation, those resulting from loss of use, data or profits, whether or not the thecareercafe has been advised of the possibility of such damages, and on any theory of liability, arising out of or in connection with the use of this software.
