Ceridian Powerpay Payroll Export

Updated June 24, 2024 16:02

If you are using 7punches for time-clocking, or have a POS integration that includes labor, you can export your worked hours in a Ceridian Powerpay format.

SKIP AHEAD TO:

Activating the Ceridian Powerpay Export

Preparing your Export File

⚠️ To access the export you must be using 7punches or have a POS integration that includes labor data.

⚠️ Access to this feature may require an upgrade from your current plan.

⚠️ To utilize the payroll import feature in Ceridian Powerpay, you must be on the Powerpay Plus plan or higher.

Activating the Ceridian Powerpay Export

To enable the export, you'll need to do the following:

1. In the left navigation bar, head to Apps & Integrations:

2. Search Powerpay and select Ceridian Powerpay:

Screen_Shot_2022-12-21_at_5.15.44_PM.png

3. Click on 'Complete Set Up" to add the export to your Account. From here, you will need to enable and customize some of the individual features of the integration.

Screen_Shot_2022-06-06_at_5.12.27_PM.png

4. Alternatively, you can find these settings under Apps & Integrations > My integrations > Powerpay > Settings.

5. Enter your additional Custom Export Codes, if applicable.

6. Choose whether to 'Split Hours by Role' under the 'Payroll Mapping' tab.

⚠️ If this setting is enabled, Employee hours will be split into separate columns in the spreadsheet, but will not be associated with your payroll provider’s departments, pay codes, or wage codes. (However, this can be manually added to the spreadsheet before uploading to the payroll program.)

7. Map your Employees between 7shifts and Ceridian Powerpay by updating their Employee ID’s or 'File Numbers'. This is required in order to match your Employees in 7shifts to their Ceridian Powerpay ID numbers and have those included in the CSV.

To get started, click on 'Edit Employee IDs.'

Enter the corresponding File Numbers for each Employee.

Screen_Shot_2022-06-06_at_4.41.16_PM_copy.png

Be sure to hit 'Save' at the bottom of the page when you're done updating your employee File Numbers.

Preparing your Export File

Before you can run the Ceridian Powerpay payroll export you'll need to ensure that you've properly approved all punches and closed your Timesheet.

⚠️ Only Admins can close all timesheets, a mandatory step to send payroll data to your integration successfully.

1. In the left navigation bar, select the 'Time Clocking' tab, and the appropriate Pay Period.

2. From there, review and 'Approve' or 'Edit' punches, or choose to 'Approve All.'

3. Once you've approved all punches, you can close and export the Timesheet.

To close the Timesheet, select 'Close Timesheet' in the top right corner:

⚠️ For multi-Location users, you can close the Timesheet and export it on a Location basis.

If you are using this method, be sure to select the correct Location in the 'Location' dropdown before selecting the 'Export' option.

4. With the Timesheet closed, you can export it by selecting 'Export' and then 'Powerpay.'

5. You can now import your payroll data to Ceridian Powerpay.

⚠️ In order to import your Payroll report, you must enable the 'Import Activated" within your Ceridian Powerpay account settings.

The columns included in the Ceridian Powerpay export are:

Ceridian_Branch_No

Ceridian_Payroll_Number

Employee_Number

Applicable_Period_of_Time

Earning_Code

Hours

Exception_Rate

AmountPosition_Reference_Code

Distribution_ID_Dept

Distribution_ID_Y

⚠️ Contact your Ceridian representative if you have questions about this step.