Run IE Gender Pay Gap Report

Use the Gender Pay Gap report to show the difference in the average hourly wages between men and women in your organization. It provides a gender pay gap reporting extract and spreadsheet-based report configuration for organizations required to report under Irish legislation.

Payroll and HR administrators can use the assignment level extract and a spreadsheet template needed to calculate statutory Ireland gender pay gap metrics, supporting accurate submission under legislative requirements. The combined extract and template streamline the collection and statutory calculation of pay, hours and employment attributes so organizations can produce mean and median pay gaps, bonus and benefit-in-kind proportions, part-time and temporary comparisons, and quartile splits.

If you're an organization with more than 50 employees, you need report gender pay gap. This report is calculated, including balance information, at the assignment level for all active assignments as of the snapshot date.

Only active employees are included in the report as of the snapshot date and there should be a payroll run as on the snapshot date. Snapshot date is fixed to 30 June of the selected snapshot year; reporting period is 01 July (previous year) to 30 June (snapshot year).

Ensure payroll and HR mappings send ordinary pay, bonus pay, benefit in kind and any hours (including overtime) into the predefined balances (IE_GPGR_OPAY, IE_GPGR_BPAY, IE_GPGR_BIKPAY, IE_GPGR_HOURS) prior to running the extract to avoid missing data in the spreadsheet.

The hours need to include overtime and any hours worked outside normal hours. You need to feed those hours into the IE_GPGR_HOURS element to ensure accurate hourly rate calculations.

New balances and an information element are provided to feed hours and payment types so that the totals for the reporting period (1 Jul to 30 Jun) are recorded. These balances are predefined and you can add additional balances, as required.

Base Balance Name	Balance Name	Reporting Name	Category Name
IE_GPGR_BPAY	Gender Pay Gap Reporting Bonus Pay	Bonus Pay	Information
IE_GPGR_OPAY	Gender Pay Gap Reporting Ordinary Pay	Ordinary Pay	Information
IE_GPGR_BIKPAY	Gender Pay Gap Reporting Benefit in Kind	Benefit in Kind	Information
IE_GPGR_HOURS	Gender Pay Gap Reporting Hours Worked	Actual Working Hours	Information

These balance feeds are provided:

Base Balance Name	Balance Feeds
IE_GPGR_BPAY	Bonus or similar payments
IE_GPGR_OPAY	Allowance payments (for example, salary) Overtime payments Piecework payments Sick leave payments (both SSP and OSP related) Occupational payments for absences such as maternity or paternity Garden leave payments
IE_GPGR_BIKPAY	Any Taxable Benefits
IE_GPGR_HOURS	Hours from Element IE_GPGR_HOURS

Navigation: My Client Groups > Show more > Payroll > Submit a flow

Provide the scope by the Legislative Data Group for which you want to run this flow.
Select the Run IE Gender Pay Gap Report flow.

Enter the required parameters to run the process.

Table listing parameters and descriptions

Parameter	Description
Payroll Statutory Unit	The PSU for which you want to run the process. This is a required parameter.
Tax Reporting Unit	Tax reporting unit for which you want to run the process.
Snapshot Day	Enter the day, for example, June 30.
Snapshot Year	Enter the year for which you want to run the report.
Process Configuration Group	Use a process configuration group to set rules for payroll processes, such as passwords or number of threads. If you don't select a process configuration group, the process uses the parameters in the default group.

Submit the flow.

Results:

The output file is generated under the Regulatory and Tax Reporting folder for Ireland. Load the extract CSV file into the provided Microsoft Excel template (IEGenderPayGapAnalysis-v1.0-Template.xlsx) to generate statutory metrics and quartile breakdowns.

Extract runs at assignment level and includes all assignments that are active on the snapshot date (30th Jun of the selected year). Each assignment row is counted as a headcount. The extract supplies raw data only. All statutory calculations (means, medians, quartiles, proportions) are performed in the spreadsheet template.

Returned fields including employee and assignment identifiers, gender, payscale and position, working hours and frequency, FTE (uses adjusted FTE when populated), contract type (regular and temporary), assignment status, PPSN, and predefined balances for ordinary pay, bonus pay, benefit in kind and hours.

Any assignments indicated as INACTIVE on the snapshot date are excluded. Each active assignment row counts as one headcount unless de-duplicated in the spreadsheet.

If adjusted FTE is populated, it will be used to identify part-time employees; otherwise standard FTE applies.

Spreadsheet-based report configuration and calculations: All final metrics (mean and median hourly pay gap, mean and median bonus gap, proportions receiving bonus and benefit in kind, part time and temporary contract comparisons, and quartile splits) are calculated in the template after loading the extract.

Hours for the reporting year are calculated using normal hours, frequency multipliers (such as weekly or monthly) days worked in the year, plus any hours captured in the IE_GPGR_HOURS balance; overtime hours should be fed into the hours element for accurate hourly rates.
The template will be used to de-duplicate or aggregate where required (for example, headcount de-duplication can be handled in the spreadsheet).
Quartiles and mean and median calculations follow the rules in the legislation and are implemented in the spreadsheet; the extract provides raw data only.
A provided Microsoft Excel template consumes the extract and performs all statutory calculations required by the Gender Pay Gap Information Act and associated regulations. The spreadsheet computes hourly remuneration, bonus and benefit in kind proportions, quartiles and mean and median gaps.