Deputy has the ability to export timesheets to the following ADP products:

  • ADP PayLine (AU) 
  • ADP Run (US) 
  • ADP Workforce Now (US)

Timesheets from Deputy can be export via file download, or over the air (no file download required). 

File Download Supported:

  • ADP PayLine (AU) - File Download
  • ADP Run (US) - File Download
  • ADP Workforce Now (US) - File Download

Over the Air supported:

  • ADP Run (US) - Over the Air

For in depth guides about syncing and export Deputy data with the following ADP products, simply click the links below:

Exporting to ADP - File Downloads

For file download exports, you will need to ensure that the file is downloaded to a place on your computer that is easy to find. You will need to find this file when importing into ADP.

Ensure that you have timesheets approved before you begin the export process. Please note: Employees need to have assigned payroll IDs before you can export them. If they do not, you cannot export those particular employee's timesheets.

Navigate to the Export Timesheets tab and select the employees you would like to export.

In the pop-up window that appears, select between ADP PayLine (AU) - File Download or ADP Run (US) - File Download, depending on which system you would like to export to, then click 'Export' when you are done.

ADP PayLine (AU) - File Download 

With ADP PayLine (AU), you can change the export file name, and you can also modify the Export Client ID.

ADP Run (US) - File Download

In this export, you can edit the file name and the export co code. You can also choose to mark specific O/T items in the export. You can:

  • Mark any hours over 8 hours per day as O/T hours
  • Mark any hours over 10 hours per day as O/T hours
  • Mark any hours over 12 hours per day as O/T hours
  • Mark over 40 hours as O/T hours
  • Mark Sunday timesheets as O/T hours
  • Mark Public Holiday timesheets as O/T hours

ADP Workforce Now (US) - File Download

From here, you can edit the following:

  • Export file name
  • Export Co Code
  • Batch ID
  • Pay #

You can also mark specific O/T items. You can mark:

  • any hours over 8 hours per day as O/T hours
  • any hours over 10 hours per day as O/T hours
  • any hours over 12 hours per day as O/T hours
  • over 40 hours as O/T hours
  • Sunday timesheet as O/T hours
  • Public Holiday timesheet as O/T hours

When you are down, click the 'Export' button.

ADP Run (US) - Over the Air

In order to export timesheets to ADP over the air, you first must connect you ADP account to Deputy. View our guide for ADP Run (US) on connecting your ADP account to Deputy.

*Please note that we can only export timesheet hours for 1099 CONTRACTORS  if the account only contains 1099 CONTRACTORS. We do not export timesheet hours for 1099 CONTRACTORS if the account also has W2 employees.

At the top of your screen in Deputy click Timesheets, then Export Time Sheets.

Use the location selector in the top left corner to choose a specific location to export, or all locations. Use the date selector to match the export dates in Deputy with your Pay Frequency Period start and end dates (find these in ADP Run under Company->Pay Frequency).

If the dates above do not match, you will not be able to export. If you are exporting for multiple Pay Frequencies in ADP Run, export only the employees associated with a given Frequency. Each unique Pay Frequency must be exported separately, and between exporting different Frequencies you will need to finalize the export in ADP.

Once the date and location have been selected, select employees to export by clicking them on the list to the left.

After selecting the employees, click the blue Export Selected Items button. In the window that appears, select ADP (US) - Over the Air.

There are two options for exporting timesheets to ADP Run:

  • Use Deputy Award Library pay rates*
  • Manually select overtime rules during export

*If your company uses semi-monthly payroll periods, you MUST use the Deputy Award Library export method.

Use Deputy Award Library pay rates

Using the Award Library rates requires that all employees be setup with an award rate (e.g. FLSA Standard, California, Labor Law) in their employee profile. If the employee does not have an award rate setup, or they are using the wrong award, then their pay, overtime or shift loadings will not be properly calculated if using the new Award Library rate option. You can learn more about the using the Award Library and US labor laws here: Custom Awards Library and USA State Labor Laws.

You will need to select the correct ADP earnings codes for each type of pay you wish to export. You can do so by selecting the correct code from the drop down menu for each of the following:

  • Ordinary Hours
  • Overtime
  • Double Time
  • Sick Leave
  • Annual Leave/Vacation 
  • Shift Loadings (Eg. Allowances)

Once you have chosen the options you need, click "Export".

Manually select overtime rules during export


In the list displayed use the dropdown menus to designate which rate codes your hours in Deputy should be exported to. Ordinary Hours are any hours worked that do not fall into Overtime categories. Shift Loadings (tips) can be exported to your desired rate code. For help on setting up tips, contact our support team at experience@deputy.com.

Overtime hours are any hours that fall within your chosen overtime buckets. You can select the following overtime categories by ticking them in any combination:

-Any hours over 8/10/12 per day
-Any hours over 40 in a week
-Any hours worked on a Sunday
-Any hours worked on a public holiday

You will need to select the correct ADP earnings codes for each type of pay you wish to export. You can do so by selecting the correct code from the drop down menu for each of the following:

  • Ordinary Hours
  • Overtime
  • Double Time
  • Sick Leave
  • Annual Leave/Vacation 
  • Shift Loadings (Eg. Allowances)

Once you have chosen the options you need, click "Export".

You will receive a notification that it has gone through successfully. 

Did this answer your question?