ADP Canada Workforce Now Export

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

Activating the ADP Canada Workforce Now Export
Preparing your Export File
🇨🇦This feature is only available for ADP Canada Workforce Now and you will need to be using ADP WFN Essential Time. 

Learn more here about accessing the ADP Workforce Now Payroll Export (US) 🇺🇸.
⚠️ The ADP Canada Workforce Now export currently only supports one ADP Company Code per 7shifts account.
⚠️ Access to this feature may require an upgrade from your current plan.

Activating the ADP Canada Workforce Now Export

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

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

2. Search and select 'ADP Canada WFN Export':

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 Export.

Click on 'Complete Set Up.'



5. Alternatively, you can find these settings under Apps & Integrations > My Integrations > ADP Canada WFN Export > Settings.


6. In order to match employees in 7shifts to those in ADP, you will need to input your ADP File Numbers in 7shifts.

Under the 'Payroll Mapping' tab click on 'Edit employee IDs' or 'Map Roles.'

7. In the 'Employees' tab, enter the corresponding ADP File Number for each employee. 

Remember to scroll down and click 'Save.'


8. Select the 'Roles' tab to enable and map 'Department Codes' with APD (optional).

Enter the corresponding ADP Department Code for each Role in 7shifts.  Be sure to click 'Save' before changing locations.

Entering Department Codes ensures that employees get paid the correct wage rate for the hours under each role. If they are left blank, your employees will be paid their default rates listed in ADP. For each position in 7shifts, set an ADP Department Code.

⚠️You can come back to this screen to update or edit these codes by going to Apps & Integrations > My Integrations > ADP Canada WFN Export > Settings.

Preparing your Export File

Before you can run the ADP Canada Workforce Now 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're ready to close and export the Timesheet.

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

4. Once the Timesheet is closed, you can export the Timesheet as a CSV by selecting 'Export' then 'ADP WFN Canada Export.'

The columns included in the ADP Canada Workforce Now Export file are:


DCT Address

Time Punch Code

Punch Time

Defined Field 17 (if department codes are enabled)


Was this article helpful?
3 out of 5 found this helpful