Ceridian Powerpay Payroll Export


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.

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:


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.


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. 


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:

⚠️ Contact your Ceridian representative if you have questions about this step.
Was this article helpful?
1 out of 1 found this helpful