How to run and interpret the visual Gender Pay Gap report
HRLocker has integrated Gender Pay Gap reporting as part of our standard suite of reports available to all HRLocker customers.
To access this report, you need to be either a HRLocker Admin, or a Manager user type who has been granted permission to access reports and the directory.
Managers and Admins who have 'Comps and Bens' hidden in their permissions will not be able to see this report.
In order to use this report, you need for your employee's directory information to be updated to include their Gender. This can be set as either Male, Female or Undefined.
Employees can do this themselves by logging into HRLocker and editing the 'Gender' section in the Summary tab, or Managers can complete this on their behalf.
Employees will also need to have salary information uploaded to HRlocker in order to populate this report. Managers and admins can update these records in the 'Comps and Bens' section of HRLocker.
Salaries can be added based on an Hourly, Daily, Weekly, Monthly or Annual rate.
The Gender Pay Gap report will automatically convert all salaries to an annual equivalent based on an 8 hour day, 5 days a week so we can compare all your employee's even if they are paid on a different interval.
Once you're happy that your directory information is correct, you can run the gender pay gap report.
The report is available as a visual report in the Employee reports section here
The report will default to showing all employees' annualised salaries for the current calendar year.
If an employee has more than one salary entry for the year, the report will show the current salary, or if another year is selected, the salary that would be effective at the end of that calendar year.
There are a number of filters that can be applied in this report. The top level filters are the standard directory filters for office, department and teams as well as a year and a user type filter.
The 2nd level of filters are related to the types, location and duration of the employees' length of service'.
If the Salary type is selected as a filter, it will only show employees who have been allocated this salary type.
This will allow you to compare your different types and levels of employees with each other, eg, If I only want to compare newly hired, hourly paid workers, then I can set the length of service to 0-1 years, and the salary type to Hourly.
The next filters are for your interquartile range
By Default, all employees are shown, however, you can select one or more inter quartile ranges to report on.
You can select more than one range by holding ctrl while clicking on the filters. You can clear the filter with the x button
The Inter quartile range takes the total number of employees who are active in your company and puts the employees into 4 categories. The 25% lowest paid employees, the 25-50% lowest paid employees. the 25-75% highest paid employees, and the top 25% paid employees.
The last filters are 2 sets of 'Radio Buttons'
Absolute will show the results as a monetary value. Eg, the average or median salary for the selected employees
Percentage will show the percentage breakdown between Female, Male and Undefined salaries based on the selected range
Average will show the result as an average of the selected employees, eg, if there are 10 employees selected, it will add up all their salaries, and divide that number by 10
Median will show the middle point of all the selected employees. Eg, if there are 10 employees selected, the report will rank those salaries from low to high, and take the middle point between the 5th and 6th highest paid employees as the median value
Downloading the report
Due to the dynamic nature of the report and all the filters that can be applied, this cannot be downloaded in excel.
To use this report for compliance purposes, you can take screenshots of the report on a windows device using the 'Snipping tool
For Audit purposes, the raw data used to compile the report is stored in 2 reports, the Directory Export report and the Salary History report which can both be see here