Three reports cover the calculations of all the required statistics. These reports appear for UK payrolls only under the Global Reports menu. Each report shows the stages in the calculation as well as the final statistics.
Employers must calculate and report:
The mean gender pay gap.
The median gender pay gap.
The mean bonus gender pay gap.
The median bonus gender pay gap.
The proportion of males and females receiving a bonus payment.
The proportion of males and females in each quartile band.
It is important to note that there are some situations where Coins ERP+ may not be able to get the results exactly correct. For example the non-bonus pay gap calculations require you to include everyone who is employed on the snapshot date and who is being paid their usual full pay during the pay period which includes this snapshot date. Any employee who is paid less than normal due to being on leave must be omitted, though any employee who is paid less than normal for any other reason must still be included. Coins ERP+ will make the best guess it can on this, but it may be imperfect. You can however take the Excel version of the report produced, manually modify the employees included as appropriate and use Excel to recalculate totals and averages and recalculate the required statistics.
Gender Pay Gap Report
The Gender Pay Gap Report calculates the mean and the median gender pay gap.
PAYE Schemes
A CAN-DO list of PAYE schemes to include (with a default of ‘*’ for all schemes).
Date
The snapshot date. This would usually be the previous 5th April (the default), but users will be able to report on any date they like.
Ordinary Pay Items
A list of items which give the ordinary pay.
Bonus Pay Items
A list of items which give the bonus pay.
Hours Items
A list of items which give the hours worked (in the input field). These are used for hourly-paid employees only to calculate the weekly working hours as a 12 week average. For salaried employees, the report uses the value set in Employee Maintenance as at the period being reported on.
Bonus Gender Pay Gap Report
The Bonus Gender Pay Gap Report calculates the mean and the median bonus gender pay gap and the proportion of males and females receiving a bonus.
Fields
Field
Description
PAYE Schemes
A CAN-DO list of PAYE schemes to include (with a default of ‘*’ for all schemes).
Date
The snapshot date. This would usually be the previous 5th April (the default), but users will be able to report on any date they like.
Bonus Pay Items
A list of items which give the bonus pay.
Quartile Gender Pay Gap Report
The Quartile Gender Pay Gap Report calculates the proportion of males and females in each quartile band.
PAYE Schemes
A CAN-DO list of PAYE schemes to include (with a default of ‘*’ for all schemes).
Date
The snapshot date. This would usually be the previous 5th April (the default), but users will be able to report on any date they like.
Ordinary Pay Items
A list of items which give the ordinary pay.
Bonus Pay Items
A list of items which give the bonus pay.
Hours Items
A list of items which give the hours worked (in the input field). These are used for hourly-paid employees only to calculate the weekly working hours as a 12 week average. For salaried employees, the report uses the value set in Employee Maintenance as at the period being reported on.