Calculate the Gender and Ethnicity Pay Gap in your organisation using my simple spreadsheet

https://www.loom.com/share/4f0800a991c845ed8255f68722ab70a4?sid=107811fa-221e-4f6f-9a5d-a512bb24abc5

<aside> 👉 Buy this spreadsheet on Gumroad for £20 →

</aside>

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 and people often mix up the terms "gender pay gap" and "equal pay," but they are not the same.

The gender pay gap refers to the disparity between the average earnings of men and women within an organisation, considering all job levels. Essentially, this means that if women are more likely to occupy lower-paid roles, the gender pay gap tends to be wider.

In contrast, equal pay is a legal mandate that ensures men and women receive the same compensation for doing the same job or work of comparable value.

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: