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?
There is a HELP sheet in this spreadsheet which you can read.
To use the tool, enter your employee data in the yellow columns on the RAWDATA sheet. The calculations are done on the CALCULATIONS sheet and the results (which can be uploaded) 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. 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.
— Want to know more about the gender pay gap? —
I have written a number of articles about the gender pay gap covering these topics:-
- Where can I find gender pay gap data for an organisation in the UK?
- What gender pay gap data tells us, what it doesn’t tell us and how it can be misused
- 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
- My 12 steps to improve public confidence in gender pay gap data