Gender Pay Gap Report

The solution provides payroll and HR administrators with 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 organisations can produce mean and median pay gaps, bonus and benefit-in-kind proportions, part-time and temporary comparisons, and quartile splits.

Assignment-level data extract for Ireland gender pay gap reporting

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.

  • 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.
  • New balances and an information element are provided for clients to feed hours and payment types so totals for the reporting period (1 Jul to 30 Jun) are captured (IE_GPGR_OPAY, IE_GPGR_BPAY, IE_GPGR_BIKPAY, IE_GPGR_HOURS).
  • Report parameters allow selection of payroll statutory unit, tax reporting unit, snapshot year (hidden snapshot date = 30th Jun) and process configuration group.
  • A new extract delivers the raw assignment level dataset required to calculate Ireland gender pay gap metrics. The extract includes pay balances, hours, employment and assignment attributes and is designed to be loaded into the provided spreadsheet template to produce the statutory report.

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 (weekly, monthly, etc.), 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 deduplicate or aggregate where required (for example, headcount deduplication 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.

Provides a new Ireland specific gender pay gap reporting extract and spreadsheet-based report configuration for organisations required to report under Irish legislation. Intended for payroll and HR administrators preparing gender pay gap submissions.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

Considerations:

  • 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.
  • Load the extract .csv file into the provided Microsoft Excel template (IEGenderPayGapAnalysis-v1.0-Template.xlsx) to generate statutory metrics and quartile breakdowns.
  • Snapshot date is fixed to 30 June of the selected snapshot year; reporting period is 1 July (previous year) to 30 June (snapshot year).
  • Assignments flagged INACTIVE on the snapshot date are excluded. Each active assignment row counts as one headcount unless deduplicated in the spreadsheet.
  • If adjusted FTE is populated it will be used to identify part time employees; otherwise standard FTE applies.
  • Hours should include overtime and any hours worked outside normal hours; clients must feed those hours into the IE_GPGR_HOURS element to ensure accurate hourly rate calculations.
  • The extract supplies raw data only; all statutory calculations (means, medians, quartiles, proportions) are performed in the spreadsheet template.