Skip to main content
All CollectionsTime Tracking, Scheduling, and the Jobs TabTime ClockPayroll Integrations
How to Use ADP Workforce Now Export Template
How to Use ADP Workforce Now Export Template

A step-by-step guide to seamlessly use the ADP Workforce Now Export Template

E
Written by Eilon Morgenstern
Updated over 3 months ago

Welcome to a simpler payroll experience with Connecteam! In this guide, we'll show you how to efficiently export timesheets from Connecteam to ADP WFN using a formatted CSV file, helping you save time and focus on what matters in your business.

Before we begin, here's a quick overview of what can be transferred:

  • Regular hours

  • Overtime hours

  • Double overtime hours

  • Paid Time Off (PTO)

  • Jobs

What you need to do before using the export

  • Ensure that you have created a user custom field in Connecteam to represent the ADP WFN Employee File Number and that it has been updated accordingly for all employees.

  • Ensure that you have already set up your overtime policies in Connecteam.

  • Ensure that you have already set up your time off policies in Connecteam.

  • Record the following information from your ADP WFN account:

    • Company code

    • Earnings codes and hour types

    • Department code for each job (or sub-job)

    If you need help finding this information, contact your ADP representative.
    ​

Setting up your export

Step 1: Click on "Export" and then click on "Discover integrations"

Step 2: Open the time clock integration settings tab and click on ADP WFN "Setup"

Step 3: Enter your ADP WFN Company Code

Step 4: Select the user custom field that represents the ADP WFN Employee File Number

Step 5: Match payroll items with the ADP WFN Code and Hour type

  • For each Connecteam's payroll item (Double time hours, PTO policies, Sick leave policies, Holiday policies), set the matching ADP WFN Code and Hour type, to ensure users are paid the correct rate for their work.

  • For each Connecteam's payroll item, select the matching policies from the Time off policies dropdown.

  • If no Code or Hour type has been inserted, the payroll item will not be included in the export.

Step 6: Match jobs with ADP WFN Department code

  • Here, you will decide how to export working hours from Connecteam. There are three options:

    • Don't include jobs: This option exports only the regular hours, overtime (multiplier 1.5x), and double overtime (multiplier 2.0x) and disregards any job-related information.

    • Export hours by job: This option provides a breakdown of regular, overtime (multiplier 1.5x), and double overtime (multiplier 2.0x) for each job.

    • Export hours by job and sub-job: This option provides a breakdown of regular, overtime (multiplier 1.5x), and double overtime (multiplier 2.0x) for each sub-job and for jobs without sub-jobs.

  • If you selected to include jobs, set the matching ADP WFN Department code for each job (or sub-job).

  • If no Department code has been inserted, the job (or sub-job) will not be included in the export.

Once you have completed the setup, click on 'Continue' and then 'Save changes' on the integration page.

Exporting timesheets to ADP WFN

Now that you have configured your ADP WFN export it’s time to export it!

  • Go back to the time clock timesheets and select the required date range and users for the export.

  • Then click on "Export".

  • Then click on "Export to ADP WFN" and your CSV file will download.
    ​Do not modify the file name; if you change the name it will fail to import into ADP WFN.

  • Upload the CSV file to ADP WFN. If you need assistance with this step, contact your ADP representative.

Understanding your export file

Here's a detailed breakdown of the CSV file's structure for ADP WFN exports:

  • Co Code: This is a unique 3-character company code supplied by ADP.

  • Batch ID: Each individual export requires a 6-digit batch ID value to be processed by ADP. Connecteam auto-populates this value with a 6-digit number corresponding to the export date in YYMMDD format. For example, if the export is run on May 1st, 2022, the value in the Batch ID field will be 220501.

  • File #: This is the unique employee identifier used by ADP.

  • Temp Dept: The ADP department code.

  • Temp Rate: These values are left blank for all users exported, as the pay rates are based on the rates in ADP WFN.

  • Reg Hours: The regular hours employees worked for the defined time period (and department code if defined).

  • O/T Hours: The overtime hours (calculated at a 1.5X multiplier) for the defined time period (and department code if defined).

  • Hours 3/4 Code: The ADP WFN earning code for a configured Connecteam payroll item.

  • Hours 3/4 Amount: The number of hours related to the earning code on the left column to the amount column.

Want an Expert to do the work for you? 🤓 Click here to learn more.

Need more guidance? 🙋 Our LIVE support team (at the bottom right corner of your screen) replies to ANY question.

Did this answer your question?