Find answers in our knowledge base
 
ADP
Article

How to Integrate TSheets and ADP Workforce Now

« Go Back

Article Detail

 
Rich Text Description

How to:


How to Install and Set Up the Integration

If you have TSheets and Workforce Now

  1. In TSheets, go to SET UP > Add-ons OR Feature Add-ons > Manage Add-ons.
  2. In the list, locate ADP Workforce Now, and click Get. You will be taken to the TSheets Connector app in the ADP Marketplace.
    • Note: You may be required to sign in to the ADP Marketplace.
  3. To get the app, click Buy Now. You'll be guided through the app purchase.
  4. Once you see the “successfully connected” screen, click Go to TSheets.
  5. (Optional) If desired, click the ADP Workforce Now drop-down at the top and select Preferences > uncheck the box to disallow ADP to sync timesheets to ADP Workforce Now payroll

How to Use the Integration

Employees:

  • Make sure all employees in ADP that need to track time are added in TSheets:
    • Employees > Add Employee > enter the required fields to match ADP.
    • Once all employees are added, in the Employee Editor for each employee, add the employee’s ADP File ID to the Payroll ID field in TSheets to “link” the profiles.
    • Note: Employees can be added and updated using a .csv file upload to save some time. See: Importing and Updating Employees via CSV Spreadsheet.
  • After the initial integration is completed and existing employees are linked, the following actions in ADP will automatically sync into TSheets within 2 minutes:
    • An edit to an employee’s First name, Last name, and/or work email.
    • A newly hired employee will create a new user in TSheets.
    • A terminated employee will archive the user in TSheets.
      • Note: an employee can be archived in TSheets without affecting the employee in ADP.

Exporting Timesheets:

There are two different ways to export timesheets to ADP Workforce Now: flat file or direct export. There are some key differences:

  • Flat File Export
    • Exports Regular hours, Overtime, Doubletime, and PTO.
    • Time is uploaded to Time and Attendance.
  • Direct export:
    • Exports Regular hours, Overtime, and Doubletime.
    • Time is exported as a batch into payroll.

Flat File Export:

The Flat File must be added to your account by a TSheets support rep.

  • If you don’t have it already, call support. Be prepared with your ADP Company Code. Once it is added, you can export your flat file:
  • In TSheets
    • Go to Approvals > Run Report for the date range you want to approve (any date range can be selected) > Approve Time.
    • Go to Reports > Payroll Report > Run Report for the same date range you approved.
    • Click Report Exports at the top > click the Excel file download under ADP Workforce Now Export.
  • In ADP Workforce Now:
    • Upload the file into Time and Attendance.
    • Time can be adjusted here but will not reflect in TSheets.

Direct Export:

  • In TSheets:
    • Go to Approvals > Run Report for the date range you want to approve (any date range can be selected) > Approve Time.
    • In the Approvals report, click ADP Export Approved Time and confirm the export. A success window will display once the export is complete.
  • In ADP Workforce Now:
    • Go to Process > Payroll > Paydata.
    • The newest batch of time will display at the bottom of the displayed list.
    • Click the batch to view time details. Time can be adjusted here but will not reflect in TSheets.

Need help? We’re here for you.
Phone
us: +1 (888) 836-2720
au: +1 (800) 989-143
uk: +44 (808) 164-0610
Email
Reply within: 1-4 hours
Have a suggestion?

Was this document helpful?

 
   

Sorry this document wasn’t helpful. How can we improve it?

Characters Remaining 255