ADP Workforce Now (US) Payroll Export

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

Things to Know

Review these critical requirements before enabling the export:

• Access to this integration may require a plan upgrade.
• The ADP Workforce Now export currently supports only one ADP Company Code per 7shifts account.
• This export is specifically for ADP Workforce Now (US). For Canadian accounts, please see the ADP Canada Workforce Now guide.
• If Split Hours by Role is enabled, PTO will not export to prevent accrual errors within ADP.

Add the ADP Worforce Now Integration

Follow these steps to activate the ADP Workforce Now export and configure your custom codes:

Employee and Role Mapping

Mapping connects 7shifts profiles to ADP records using ADP File Numbers to ensure labor data flows to the correct person.

1. Go to Apps & Integrations > My Integrations > ADP WFN Export > Settings.
2. Under the Payroll Mapping tab, click Edit employee IDs.
3. In the Employees tab, enter the corresponding ADP File Number for each employee.
   • If the Employee ID field in an employee’s profile contains a value, that value will sync to the Payroll Export File Number fields.

   • If Employee Sync is enabled with a POS, Employee IDs will be automatically imported upon the first sync and will be used in Payroll Export Mappings. This means that when the ADP WFN Payroll Export is generated, the File # column will reflect these imported Employee IDs.

     

4. (Optional) Select the Roles tab to map Department Codes. 
   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. Contact your ADP Representative if you need assistance. 
   
5. Click Save.

What’s included in your export

7shifts exports worked hours, including regular, overtime, and holiday hours, alongside tips and paid leave into the ADP-ready format.

Including Tips in Payroll

To include tips in your ADP export, you must first configure Hours & Earnings Codes and Memo codes within your ADP WFN account:

1. Login to your ADP WFN account and go to Setup > Tools > Validation Tables.
2. On the Validation Tables page, use the search bar or head to the Payroll column:
   
    
3.  Scroll down to Paydata.
4.  Find and click on the Hours & Earnings Codes and Memo options:
   
5. Under Hours & Earnings Codes complete the following:
   • Click on Add.
   • In the Type dropdown, select the appropriate Hour/Earnings code.
   • Enter 'T' in the Code field (no accumulators or mapped pay codes are required).
   • Ensure the Active setting is toggled on.
   • Ensure the Use default pay statement labels setting is toggled on.
   • The Short Name field can be anything, such as Tips.
   • Click on 'Done' when you're finished. 
6. Under Memo complete the following:

• Click on Add.
• Enter '5' in the Code field.
• The Description field can be anything, such as Tips.
• Ensure the Active setting is toggled on.
• Click on Done when you're finished. 

Tip Management & Integrations defines the universal rules for including tip data from your POS or Tip Pooling in 7shifts. Please review carefully to see if your POS or tip source is compatible with your payroll provider.

Including Paid Time Off (PTO)

To include PTO, Sick Time, or Unpaid Time Off, these must be enabled in 7shifts Company Settings. You can set custom export codes for these in the Custom Export Codes tab. If left blank, they will export with default labels (PTO, SPTO, UPTO). 

Enter your custom codes for the ADP WFN Export by:

1. Heading to Apps & Integrations > My Integrations > ADP WFN Export > Settings.
2. Under the Custom Export Codes tab, set the optional codes for 'Paid Time Off', 'Sick Paid Time Off', and 'Unpaid Time Off' hours:
   
3. Be sure to hit Save.

For any further assistance with these steps, please reach out to your ADP rep.

Preparing and Exporting Payroll Data

Before exporting, all punches must be approved and the timesheet must be closed.

1. Go to Time Clocking and select the Pay Period.
2. Review and Approve all punches:
   

3. Click Close Timesheet.

   Note: For multi-Location users, you can close and export Timesheets on a Location basis using the Location dropdown before selecting Export.

4. Click Export and select ADP WFN Export to download your CSV file. Your file will look similar to this:
   

   The columns included in the ADP Workforce Now export are:

   Co Code

   Batch ID

   File #

   Employee Name

   Temp Dept

   Temp Rate

   Reg Hours

   O/T Hours

   ---

   Hours 3 Code

   Hours 3 Amount

   • # Holiday Code if provided, otherwise entered as Regular Hours

   ---

   Hours 4 Code

   Hours 4 Amount

   • # Paid Time Off, if provided

   ---

   Hours 4 Code

   Hours 4 Amount

   • # Unpaid Time Off, if provided

   ---

   Hours 4 Code

   Hours 4 Amount

   • # Sick Paid Time Off, if provided

   ---

   Earnings 5 Code

   Earnings 5 Amount

   • # Paid Tips, if provided

   ---

   Earnings 5 Code

   Earnings 5 Amount 

   • # Tips to be Paid, if provided
5. Upload the file in ADP via Process > Import Paydata (or, Payroll Dashboard > Import File).