Calculate the Gender and Ethnicity Pay Gap in your organisation using my simple spreadsheet
Intro to the Gender Pay Gap
The Gender Pay Gap is a pressing social issue, defined as the noticeable disparity in remuneration between male and female workers. This discrepancy is typically determined by comparing the average or median salaries of these groups.
It's a complex problem that has persisted, representing a form of inequality. It's not simply about men and women being paid differently for doing the same job, but rather the overall systemic factors that contribute to women, on average, earning less than men in the workforce.
Reporting requirements in the UK
In the UK, the requirement to report on the gender pay gap applies to private, voluntary, and public sector organisations that have 250 or more employees. That being said, there is a growing trend for companies that do not meet the 250 employee threshold to report their GPG to demonstrate their transparency on this topic.
The calculations required by the UK government are as follows:
- mean (average) gender pay gap in hourly pay
- median gender pay gap in hourly pay
- mean bonus gender pay gap
- median bonus gender pay gap
- proportion of males and females receiving a bonus payment
- proportion of males and females in each hourly pay quartile
You can view the list of calculations in more detail on here on the Gov.uk - Statutory guidance - Making your calculations.
You may also need to submit or publish:
- a written statement
- a supporting narrative
- an action plan
You can find more details on this here on Gov.uk - Statutory guidance Overview
Reporting dates
You are required to publish your organisation's gender pay gap report within one year of the relevant snapshot date. The snapshot dates are as follows:
- 5 April for businesses and charities
- 31 March for public sector organisations
The gender pay gap data must be submitted to the government using the following online service: Gov.uk - Report Gender Pay Gap Data. This data should be made publicly available on your organisationâs website.
How the calculator works
By inputting your organisation's salary details into the spreadsheet aka âcalculatorâ, it will calculate all the outputs required by the UK Government. You can then use this information to identify and address any gender-based pay discrepancies.
1. Enter your employees data into the sheet called âEmployeesâ.
Please refer to Gov.uk - Preparing your data for guidance on which employees to include in the report.
When modifying the spreadsheet, make sure to edit the blue cells only.
If you insert new rows, make sure to copy the formula down in the columns with the grey headers.
2. View your gender pay gap
Click on the sheet called âDashboardâ to view the âAverageâ and âMedianâ pay gaps across your whole organisation.
You can view data for both annual salaries and hourly pay.
Calculating both the mean and median Gender Pay Gap values is important as a single high value can skew the average. For instance, if your CEO is a woman earning a high salary, this could significantly inflate the average pay for females.
It also has an equality timer, that shows the number of days women (or men depending on your pay gap) work for free in a year. More reading on Womenâs Pay Day here.
3. View the ratio of males and females in each pay quartile
Part of the reporting requirements is to determine the percentage of men and women in each hourly pay quartile.
In this sheet, the calculator divides the list of both annual and hourly wages from the employee sheet into four equal quartiles.
Interpreting the data
â Positive Gender Pay Gap
A positive value indicates that your male staff are paid more (on average or median basis) compared to the female staff.
0% Gender Pay Gap
A zero percentage shows that there is equal pay between men and women in your organisation.
â Negative Gender Pay Gap
A negative value indicates that your female staff are paid more (on average or median basis) compared to the male staff.
Understanding the âUnadjustedâ vs âAdjustedâ Pay Gap
The Unadjusted Pay Gap
The unadjusted pay gap is the focus of current reporting requirements in the UK and what the calculator allows you to calculate and analyse. It provides valuable insights into the discrepancies in pay between men and women. However, it has several limitations:
- Lack of Hierarchical Insight The unadjusted pay gap does not account for differences in job roles or seniority within a company. For example, if there are more women in lower-level roles and more men in senior roles, the pay gap might not accurately reflect the true extent of gender pay disparity.
- Relevance to Small Organisations For smaller organisations, especially those with fewer than 30 employees, the unadjusted pay gap calculations might not be very informative or can be misleading due to the small sample size. The results can be significantly influenced by just a few atypical cases.
The Adjusted Pay Gap
An adjusted pay gap analysis provides a more nuanced view by considering various factors that influence pay. This method adjusts for differences in job roles, seniority, education, and experience to provide a clearer picture of potential pay discrimination.
Why It Matters
An adjusted pay gap helps organisations and policymakers design more effective strategies to address pay disparities and explain any imbalances. This approach ensures that efforts to reduce the pay gap are not superficial but consider all contributing factors.
Detailed Analysis for Adjusted Pay Gap
To ensure a fair and comprehensive understanding, it is important to examine the gender pay gap in detail:
- By Department: Assess if some departments have larger gaps than others.
- By Location: Compare the pay gap across different areas to identify location-based differences.
- By Role: Look at differences between managerial and non-managerial roles.
- By Tenure: Compare the pay gap between new employees and those with longer tenure.
- Shares/Equity: Consider how equity and share options might affect the overall compensation and skew results.
Moving Forward
By understanding the limitations of the unadjusted pay gap and incorporating an adjusted analysis, organisations can:
- Develop targeted strategies to address underlying causes of pay disparities.
- Communicate more transparently about the factors influencing their gender pay gap.
- Ensure that measures taken to close the pay gap are meaningful and effective.
Ethnicity pay gap
The calculator, using a similar logic to that used in calculating the gender pay gap, can also determine the ethnicity pay gap in your organisation.
If you want to change the ethnicity types in your calculator, watch this video here.
FAQs & Disclaimer
Whenever you're ready, there are 3ď¸âŁ ways I can help you
If youâve downloaded a template and would like help customising it, then you can book in a 30min session with me as a jumpstart to using it.
30mins = ÂŁ90
Whether youâre unsure where to begin or you have some comp âstuffâ in place but lack confidence, book some time to chat it through with me.
This website was built without code using Notion + Super âĄď¸ by Alistair
Templates