GL Splits in People - Autopay Earnings by Business Date

Payroll administrators have the option to generate autopay earnings by business date, including the Labour % and General Ledger (GL) splits tied to the employee record. You can set up these organizations for GL splits across multiple cost centers and assignments in the Payroll > GL Splits screen in People. For example, you can allocate multiple cost centers to a single employee with a single or multiple work assignments. This allocation can be either EWA % or GL splits, and contain an effective date to ensure the GL output respects this effective date for all hourly paid and salaried employees.

Generate Autopay Earnings by Business Dates

When you apply EWA Labor % and GL Splits to be effective per their respective business days instead of the pay period end, Dayforce respects business dates outside of the current pay run when applying GL splits. For example, payroll administrators can run an off-cycle pay run for employees with multiple default labor allocations or GL splits in a particular pay period, and it is reflected in the general ledger.

To support Labour/GL splits, autopay earnings must be distributed by business date in a payroll policy rule. Set this by adding a new Auto Pay Rule (or editing an exiting Autopay rule) in Payroll Setup > Payroll Policies. The Working days - 5 days a week option for the Mid-period proration and the Generate autopay By Business Date checkbox must be selected:

Dayforce respects business dates outside of the current pay run when applying GL splits. For example, payroll administrators can run an off-cycle pay run for employees with multiple default labor allocations or GL splits in a particular pay period and it is reflected in the general ledger.

The following example shows weekly autopay employees in the GL Preview tab of the Employee Preview slide-out panel before and after selecting the Generate Autopay by business date option.

The Payroll GL Export definitions require an update to ensure the GL splits and earning dates are listed. The following XML export was updated with the token: earning_business_date:

The Generate Autopay by Business Date option overrides the following payroll policy options:

• Itemize intra pay period rate change. The rate per business day is used instead.
• Enable mid-proration on work assignment charges.

When you choose mid-period proration of Autopay by Business Days - 5 Days A Week, you configure the rule to prorate the amount of autopay employees earn based on days in the week (Monday to Friday). Monday to Friday are considered as business days to calculate the total number of days in a pay period. Dayforce calculates the employees' daily hours based on the formula { Normal pay period hours} / {number of business days in the period}. For example, when an employee is hired on the Wednesday of a weekly pay period and only works three business days, the rule autopays the employee a prorated amount for the three days worked.

To set up mid-period proration by Working days - 5 days a week for a payroll policy:

1. Go to Payroll Setup > Payroll Policies.
2. Expand an existing payroll policy, or create a payroll policy.
3. Click the add icon (+) and click Ruleset.
4. Enter a name and, optionally, a description for the ruleset.
5. Click the add icon (+) and click Rule.
6. Enter a name and, optionally, a description for the rule.
7. Enter a start date for the rule in the Effective From field. Rules are only active during their effective date range.
8. Verify that the Active checkbox is selected.
9. In the Type drop-down list, select Auto Pay Rule.
10. In the Mid-period proration drop-down list, select Working Days - 5 days a week
11. Select the Generate autopay by business date checkbox to distribute autopay earnings by business date.
12. Click Save, and then click Refresh.

Apply Labour % and GL Splits by Working Day

You must change the Apply EWA Labor % and GL split in the General Ledger screen, so that the setting is applied per respective business day instead of by the pay period end.

To apply Labour % and GL splits by working day:

1. Go to Payroll Setup > General Ledger.
2. Click the Default run settings tab and select the Apply Labour% and GL Splits by working day checkbox.
3. Click Save.

Important: Select both the Generate autopay by business date and the Apply Labour% and GL splits by working day checkboxes. The Apply Labour% and GL splits by working day option does not function if it is selected on its own.

In the following example, an employee has two active work assignments in two different locations and labour percentages listed in the Work > Work Assignments screen of People:

In the following screenshot, you can view the salary splits in the GL Preview before and after the Labour % split is applied, for example:

1. AUS Melbourne - 70%
2. AUS Sydney - 30%

GL Report Example

The last column of the GL report includes the Labour Percentage that is reported as part of the export definition:

Apply GL Splits Allocation for Work Assignments

In the Payroll > GL Splits screen in People, you need to apply the Labor and GL Splits allocation for employee work assignments based on its respective business day instead of the pay period date.

GL Report Example

The last column of the GL report includes the Labour Percentage that is reported as part of the export definition:

Considerations

• The Generate Autopay by business date function splits autopay earnings by business date on previously committed pay runs. After you enable this feature, it is recommended to run a calculation to ensure the changes are made, as reflected in the GL preview.
• What is reported in your GL report is dependent on the configuration of the Payroll GL Export definitions.
• You must update the Payroll GL Export definitions with the token,
  earning_business_date.
  
  XML example:
  <Column Name="Business_Date" DataType="DateTime" Source="data" Value="earning_business_date" />
• Customers who configured XSLT must update this specific area.
• Different hourly rates might be shown due to new rounding methods.