{"id":4854,"date":"2023-10-04T12:00:50","date_gmt":"2023-10-04T11:00:50","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=4854"},"modified":"2024-01-05T12:43:32","modified_gmt":"2024-01-05T12:43:32","slug":"latest-gender-pay-gap-data-2022","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/latest-gender-pay-gap-data-2022\/","title":{"rendered":"Pay Gap Data #6 – Where can I find gender pay gap data for 2022?"},"content":{"rendered":"

This post was updated on 4th October 2023 with the latest data.<\/em><\/p>\n

The government requires all employers with a headcount of 250 or more on their snapshot date to submit gender pay gap data.\u00a0 All data is available to the public and can be found on the government’s gender pay gap website<\/a>.\u00a0 I have downloaded this data and created a spreadsheet tool to present the data in a more user-friendly and visual format.<\/p>\n

<\/p>\n

Download my spreadsheet!<\/strong><\/span><\/h5>\n
Gender Pay Gap Data & Chart Tool – 2023 v7.2<\/a><\/strong><\/span><\/h5>\n

You are very welcome make use of the charts and tables within this spreadsheet but I would appreciate it if you could credit me with the creation of the charts.<\/p>\n

IMPORTANT!<\/strong> – The workbook is currently optimised for Excel in Windows.\u00a0 It does work in Excel for a Mac but I am aware of some features not working as intended on a Mac.\u00a0 I am in the process of trying to correct the Mac issues.<\/p>\n

I will make a point of keeping this spreadsheet up to date as employers upload new data so please bookmark this page and come back to see if the version number has changed.\u00a0 Alternatively why not subscribe to my newsletter to be notified of updates (details are at the bottom of the page).\u00a0 I will also let you know via my twitter feed<\/a> if changes have been made.<\/p>\n

What data is included?<\/strong><\/span><\/h5>\n

This spreadsheet includes data submitted by 13,300+ employers for the April snapshot pay period for the years of 2017, 2018, 2019, 2020, 2021 & 2022.\u00a0 As of now, 10,825 employers have submitted 2022 data.\u00a0 This compares with 10,530 employers who reported data for 2021 but as explained below only 10,462 are included in the GEO downloads and my spreadsheet.<\/p>\n

Employers can now submit their 2023 data and not wait for the deadline of April 2024 but so far, only 365 have done so.<\/p>\n

Update 9\/7\/23 – The GEO have removed around 110 employers who apparently no longer report pay gaps<\/a> from their downloads.\u00a0 An issue here is this includes employers who have merged to create a new employer.\u00a0 The data for the old employers is then removed from the downloads which is incorrect in my opinion.\u00a0 A high profile example is the Foreign & Commonwealth Office<\/a> and Department for International Development<\/a> who merged in 2021 to create the Foreign, Commonwealth & Development Office<\/a>.\u00a0 The old data can still be found on the GEO website (click the names to see) but not in the downloads and hence not in my spreadsheet.\u00a0 I intend to try and restore the lost data if possible but you can download older versions of my spreadsheet at the bottom of this page which will include these lost employers.<\/em><\/p>\n

Update 6\/3\/23 – I have added some new features to the downloadable spreadsheet which flag suspicious data based on a comparison between the median hourly pay for women and the gender swap number per 1,000 employees<\/a>.<\/em><\/p>\n

Update 8\/4\/22 – There appears to be some employers who have reported pay gaps but not the pay quarter data.\u00a0 Curiously this only affects 2020 & 2021.\u00a0 I have been told this is the result of the GEO changing their portal and inadvertently allowing some employers to do this.<\/em><\/p>\n

Update 5\/4\/22 – Even more cleaning of names have been done by the GEO and me so you may need to check for your employer under a different name.\u00a0 So far, 9900 employers have reported 2021 data so it looks like 500 to 600 are late reporting.\u00a0 Therefore the 2021 data included may yet change again.<\/em><\/p>\n

Update 10\/2\/22 – The Government Equalities Office continues to do a lot work to resolve inconsistencies in employer names.\u00a0 I had already done most of this work in the past but it is possible that an employer you used to look for in earlier versions of the downloadable spreadsheet is now appearing under a different name.<\/em><\/p>\n

Update 20\/2\/21 – The Equalities & Human Rights Commission the deadline for submitting 2020 data to 5th October 2021.\u00a0 Employers are required to submit 2020.\u00a0 The deadline for submitting 2021 data is still 5th April 2022.<\/em><\/p>\n

Update 24\/3\/20 –\u00a0 On 24th March, the government suspended enforcement of the deadline for reporting 2019 gender pay gaps<\/a> due to the coronavirus outbreak<\/a>.\u00a0 Just over 60% of employers reported their 2019 data and the remainder are no longer required to do so.<\/em><\/p>\n

Overview of Spreadsheet<\/strong><\/span><\/h5>\n

The EMPLOYERSUMMARY<\/strong> sheet summarises an employer’s gender pay gap data as shown in the graphic below for the latest year’s data submitted.\u00a0 You can\u00a0 select the employer you want to view from the dropdown box (please note there can be over 13,000 employers!).\u00a0\u00a0There are also some calculations of year on year trends and these provide clues as to whether the employer has entered its data correctly and you can find out more about this in my article “Year on Year Trends, the Good, Bad & Unilever<\/em><\/a>“.<\/p>\n

\"\"<\/p>\n

The COMPAREEMPLOYERS<\/strong> sheet is a feature that allows you to choose 20 employers for a specific year and compare them side by side.\u00a0 It is currently preloaded with the 20 teams from the English Premier League for the 2021\/22 season but you can overwrite these with your chosen employers.\u00a0 A full list of employers in given in column L of this sheet.\u00a0 On the EMPLOYERSUMMARY<\/strong> sheet you can restrict the list of employers in the menu box to just your chosen list of 20 employers.\u00a0 Instructions are given in the HELP<\/strong> and COMPAREEMPLOYERS<\/strong> sheet.<\/p>\n

There is a HELP<\/strong> sheet which you can read for more information.\u00a0 The spreadsheet contains links which provide more explanation of what is being presented but you will find most of this information in my article “7 ways to misuse gender pay gap data<\/em><\/a>“.<\/p>\n

Where can I find older versions of this spreadsheet?<\/strong><\/span><\/h5>\n

Older versions of this spreadsheet for previous years are listed below.\u00a0 The value of looking at these is that some employers gone back and retrospectively changed their reported in earlier years.\u00a0 By crosschecking one of the older versions here with the latest version, you can see if that has happened.\u00a0 In addition, given the issue highlighted in July 2023 (see above), these files will contain data for employers incorrectly removed by the GEO.<\/p>\n