Skip to main content

Exporting to ADP

Leonard Steele
  • Updated

What ADP products does Deputy export to?

Deputy can export to the following ADP products:
  • ADP PayLine (AU)
  • ADP Run (US)
  • ADP Workforce Now (US) 

How are timesheets exported to ADP?

Timesheets from Deputy can be exported to ADP either:

  • by exporting a file that can be downloaded onto your computer and then uploaded into ADP
    OR
  • by a direct connection to the ADP system called 'over the air'. Before exporting using this method you will need to connect Deputy to your ADP Account. Learn how to connect to ADP Run or Workforce Now. 

Note: Both of these options are only available for ADP in the US. If using ADP PayLine in Australia, you will only have the option to export timesheets as a file download.

See the below table for a summary of these options and links to our instructions for performing the export.

ADP Product File download Over the air (no file download required)
ADP Payline (AU) Yes - click here for help ❌ - not available
ADP Run (US) Yes - click here for help Yes - click here for help
ADP Workforce Now (US) Yes - click here for help Yes - click here for help

 

How to export timesheets to ADP

1. Before you begin to export timesheets ensure:

  • you have entered your employee's Payroll IDs in Deputy to match their Employee Export ID or Time clock ID in ADP. Note: this is found in the ADP Payroll info tab in ADP. Without this information entered in Deputy you will receive the following error when exporting.
    Web_template_-_2022-11-11T120521.154.png
  • that if you pay your employees different rates depending on the area they work in or the role they perform, you have read Pay by area for ADP Run OR Pay by area for ADP WFN.
  • you have approved timesheets for the date range you wish to export to that marches the pay run period in ADP.

2. When you are ready to export, select Export Timesheets from the Timesheets page.  Select the employees you would like to export timesheets for in the date range that matches your pay run in ADP. Click on Export selected items.

Web_template_-_2022-11-11T124608.374.png

3. In the pop-up window that appears, select the ADP system you would like to export to then follow the system-specific instructions as detailed below:

Web_template_-_2022-11-11T162104.003.png

 

ADP PayLine (AU) - File Download 

1. Complete the first steps to exporting timesheets to ADP then select ADP PayLine (AU) - file download from the menu dropdown.

2. When exporting timesheets to download a file for ADP PayLine (AU) you can modify:

  • the Export Client ID and 
  • the Export file name if desired.

3. Click Export. 

Note: This action will download a file to your computer. Please ensure you know where you are saving the file on your computer as you will need it to upload to ADP.

Web_template_-_2022-11-11T125009.555.png

 

ADP Run (US) - File Download

1. Complete the first steps for exporting timesheets to ADP then select ADP Run (US) - file download from the menu dropdown.

2. When exporting timesheets to download a file for ADP Run (US) - file download you can modify:

  • the Export Client ID and
  • Whether to map Deputy Areas or Deputy Locations to Worked Departments within ADP Run. If you would like to do this then:
    • set the IIQ to the Customer ID. In ADP go to ADP Run Home > Scroll to bottom > The first 8 digits next to the header “Customer ID”.
    • If you choose to map Deputy Areas as a worked location within ADP Run, please ensure that area names match with an ADP Run department code. In ADP go to Setup > Validation Tables > Department > Code).
    • If you choose to use a Deputy Location as a worked location within ADP Run, please match the location export code to a valid ADP Run department code.
  • the export file name if desired.

3. Click Export. 

Note: This action will download a file to your computer. Please ensure you know where you are saving the file on your computer as you will need it to upload to ADP.

Web_template_-_2022-11-11T141502.131.png

 

ADP Workforce Now (US) - File Download

1. Complete the first steps for exporting timesheets to ADP then select ADP WFN (US) - file download from the menu dropdown.

2. When exporting timesheets to download a file for ADP WFN (US) - file download you can modify:

  • Whether to export as a timesheet or leave.
    • Select from Payroll or Time off in the drop-down.
  • Export Company Code
    • This Company Code should be equal to the Co Code within ADP. In ADP go to Setup > Payroll > Company Options > Cocode.
  • Batch ID
  • Pay #

3. Click the Export and you will be prompted to name this file.

4. When naming this file, you must use the following format:

PR[Export Co Code]EPI

So, if the Export Co Code is UHQ, then your file should be named PRUHQEPI.csv when exported.

Note: This action will download a file to your computer. Please ensure you know where you are saving the file on your computer as you will need it to upload to ADP.

Web_template_-_2022-11-11T141454.646.png

Timesheet files you have downloaded can then be imported into ADP by going to Process > Import > Paydata.

Leave files you have downloaded can then be imported into ADP by going to Process > Import > Time and Attendance.

 

Exporting to ADP (US) - Over the Air

In order to export timesheets to ADP over the air, you first must connect your ADP account to Deputy.

Read our guide for connecting your ADP account to Deputy.

 

ADP RUN (US) - Over the Air

The ADP RUN timesheet export will allow you to send approved timesheets from Deputy into your ADP account. This will allow you to process payroll inside of ADP using the Deputy timesheet data. The timesheet export must be run manually in the Export Timesheet screen in your Deputy account.

For more details, see our guide on how to configure and run the ADP RUN Timesheet Export: Exporting to ADP Run

 

ADP Workforce Now (US) - Over the Air

The ADP WFN Timesheet Export will allow you to send approved timesheets from Deputy into your ADP account. This will allow you to process payroll inside of ADP using the Deputy timesheet data.

The timesheet export must be run manually in the Export Timesheet screen in your Deputy account.

For more details, see our guide on how to configure and run the ADP WFN Timesheet Export:

Exporting to ADP Workforce Now

 

Tips

Related articles