If you are responsible for uploading your gender pay gap figures to the government’s portal, you may want to be sure that your figures are correct. I have analysed the 2017 data and I have identified that between 10-20% of organisations have submitted incorrect data. In most cases, this is because the existing government guidance for your calculations is poorly written and is open to misinterpretation.
Until the government rewrites its guidance to make it easier to understand, why not download my free spreadsheet which will do all the calculations for you?
I also offer an advanced pay gap calculator spreadsheet which offers more functionality including diagnostics of why you have a pay gap. This is included if you purchase either a 2 Hour 1-on-1 Coaching session which can be run on your premises at a time convenient for you or a place on my 1-day training course “Turn your Pay Gap Data into Insights & Actions“. Both options cost £395+VAT.
How to use my free pay gap calculator spreadsheet
The spreadsheet has a HELP sheet which you can should read before using it. The MYBLOGS sheet may be of interest as it summarises all of my blogs on pay gaps and diversity.
To use the tool, enter your employee data in the yellow columns on the RAWDATA sheet and copy down the formulas shown in the blue cells for all employees. The calculations are done on the CALCULATIONS sheet and the results which you need to upload to the government pay gap portal appear on the DATATOREPORT sheet. For more information on the layout of the information in this sheet, please read my article “7 ways to misuse gender pay gap data” which explains what the various charts and tables mean.
I have also added a DATATOREPORTALT sheet which presents the results in a different format, using suggestions listed in my article “12 steps to improve public confidence in gender pay gap data”. Should the government adopt my recommendations then this is the sheet that will contain the data to be uploaded. For now, this sheet is purely for information and should not be used to report figures to the government.
As this spreadsheet is free, I offer no guarantees as to its accuracy and cannot be held responsible should an error arise. Please do contact me if you think any of the calculations are not correct.
I will update this tool as and when as I see fit so please bookmark this page and check back to see if the version number has changed. I will also post an update on my twitter feed when new versions are available.
Update 4th March 2020 – Version 2 of my calculator was released. I discovered an error in version 1 which could lead to incorrect figures being calculated for employers who pay large amounts of bonuses to a large number of employees. There should have been no material error if you pay only a few employees bonuses or the size of the bonus is small.
– Need help with interpreting your pay gaps? –
I offer the following services.
- Analytics – I can dig deep into your data to identify the key drivers of your pay gaps. I can build a model using a large number of variables such as pay band, seniority, job function, location, etc and use this to identify the priority areas for closing your gaps.
- Training – I run training courses in basic statistics which are designed for non-statisticians such as people working in HR. The courses will show you how to perform the relevant calculations in Microsoft Excel, how to interpret what they mean for you and how to incorporate these in an action plan to close your gaps.
- Expert Witness – Has your gender pay gap data uncovered an issue resulting in legal action? Need an expert independent statistician who can testify whether the data supports or contradicts a claim of discrimination? I have experience of acting as an expert witness for either plaintiff or defendant and I know how to testify and explain complex data in simple language that can be easily understood by non-statisticians as can be seen from my testimony to the Treasury Select Committee.
If you would like to have a no-obligation discussion about how I can help you, please do contact me.
– Want to know more about pay gaps? –
I have written a number of articles about pay gaps covering these topics:-
- What gender pay gap data tells us, what it doesn’t tell us and how it can be misused
- Where can I find gender pay gap data for an employer?
- Why the gender pay gap is not the same as unequal pay
- Three distinct errors that have been made by at least 10% of all organisations when submitting their gender pay gap data
- How to distinguish between a true pay gap and a pay gap that arises naturally due to the laws of chance
- Why winning an equal pay tribunal can widen a gender pay gap
- My 12 steps to improve public confidence in gender pay gap data
- My evidence to the Treasury Select Committee on how gender pay gap reporting could be improved
- Calculate your gender pay gap by downloading my free spreadsheet calculator!
- Did the gender pay gap narrow in 2018?
- How to identify unusual year on year changes in gender pay gaps
- How to close your pay gap with DMAIC
- Should the UK introduce Ethnicity Pay Gap reporting?
- What is best way to do Ethnicity Pay Gap reporting?
- Frequently Asked Questions about gender pay gaps.
Finally visit my Twitter thread to see my comments on gender pay gaps in the media. Some notable ones are here.