Retro adjustment date calculations in payroll exports with offset

These formulas are used to calculate the adjustment window for the current pay period export:

• Adjustment Start Date = Min (Current Pay Period Start Date + Offset, Last Pay Period Export Time)
• Adjustment End Date = Min (Current Pay Period End Date + 1 Day + Offset, Current Pay Period Export Time)

For example a retro adjustment eligibility is calculated for a pay group configured with an offset of five days. In this example, you have configured the parameters as follows:

• The previous pay period dates are 03/01/2026 to 03/14/2026 exported on 03/20/2026.
• The current pay period dates are 03/15/2026 to 03/28/2026 exported on 04/03/2026.
• The Adjustment Offset (Days) field is set to 5 and the payroll is run after the offset date, for example on 04/03 instead of Monday 03/30 when the payroll team is in the office.

When this pay group is assigned to an employee, the current pay period loaded on the employee timesheet is 03/15/2026-03/28/2026. During payroll export, verify these information after running the Legacy Payroll Export task:

• Verify that the records from 03/15/2025 to 03/28/2026 are exported.
• Verify that the paypd_export_started field is populated on the PAY_PERIOD table. This field contains the timestamp when the payroll was run, for example, 04/03/2026 07:24.394.
• Verify that the pay period advances from 03/29/2026 to 04/11/2026.

After confirming that the pay period has advanced correctly, you can create retro adjustments in the previous pay period. This table lists retro adjustments and the payrolls in which they are exported.

Work Date	Adjustment Date	Exported for Pay Period 03/15 to 03/28 with an Offset of 5?
02/25/2026	03/14/2026 12:00:00	Exported on 03/20 as part of pay period 03/01 to 03/14; will not export again.
02/13/2026	03/15/2026 16:00:00	Exported on 03/20 as part of pay period 03/01 to 03/14; will not export again.
02/01/2026	03/16/2026 09:15:00	Exported on 03/20 as part of pay period 03/01 to 03/14; will not export again.
02/18/2026	03/19/2026 20:15:00	Exported on 03/20 as part of pay period 03/01 to 03/14; will not export again.
02/20/2026	03/19/2026 23:00:00	Exported on 03/20 as part of pay period 03/01 to 03/14; will not export again.
	Payroll is run on 03/20.
03/10/2026	03/20/2026 03:25:32	Yes
03/12/2026	03/28/2026 23:25:32	Yes
03/12/2026	04/01/2026 12:30:00	Yes
03/10/2026	04/01/2026 23:10:00	Yes
03/08/2026	04/02/2026 23:00:00	Yes
	Payroll is run on 04/03
03/07/2026	04/03/2026 01:45:00	No
03/13/206	04/03/2026 03:25:32	No

When you run the payroll export for the current pay period after creating adjustments, you can apply the formulas to calculate the adjustment window to get these values:

• Adjustment Start Date: Min (03/15 00:00:00 + 5, 03/20 17:00)

  The Adjustment Start Date is on 03/20 00:00:00.

• Adjustment End Date: Min (03/28 00:00:00 + 1 + 5, null)

  The Adjustment End Date is 04/03 00:00:00. This adjustment end date means that adjustments created before 04/03 00:00 are not included in the export. For example, an adjustment created on 04/02 23:59 is included, while an adjustment created on 04/03 00:00 is excluded.