Skip to main content

Export Payroll Hours to ADP Workforce Now (WFN)

Use the ADP WFN Export to generate a payroll-ready CSV directly from your Daily Summary report.

Written by Phillip Araujo

Who Can Use This Feature

Plan: Enterprise
​Permissions: Users with POS Time Tracker access via Shopify Admin

Before You Start

You’ll need your ADP WFN Company Code (Co Code).
This is provided by ADP and is required to generate the export file.

Set Up ADP WFN Export Settings

  1. Open POS Time Tracker in your Shopify admin.

  2. Go to Settings.

  3. Scroll to ADP WFN Export.

  4. Enter your company code in Co Code.

  5. Click Save.

Map ADP File Numbers to Staff (Custom IDs)

  1. Open POS Time Tracker in Shopify Admin.

  2. Go to Staff.

  3. Click More actions → Map Custom IDs.

  4. Click Download Template.

  5. Fill in each staff member’s ADP file number in the customId column, keeping their staffId unchanged.

  6. Save the CSV, click Upload CSV, and select the completed file. Wait for Custom IDs updated. before exporting.

A blank customId in an uploaded row clears that staff member’s saved Custom ID. Staff with a blank Custom ID are excluded from the ADP export, even if they have worked hours.

Export ADP Payroll Hours

  1. Go to Reports → Daily Summary.

  2. Select a date range.

  3. Click Export and choose ADP Export.

  4. The CSV file downloads automatically.

What’s Included in the Export

The CSV contains one row per staff member with a non-blank Custom ID and more than zero combined regular and overtime hours in the selected date range. It includes:

  • Company Code (Co Code)

  • Batch ID

  • File #

  • Regular Hours

  • Overtime Hours

File Details

  • File name: PR{CoCode}EPI.csv

  • Batch ID format: YYMMDD (based on the report end date)

  • File # value: staff member’s customId

  • Regular and Overtime hours:

Troubleshooting

“Set your ADP Co Code in Settings to generate an export”

Add your Company Code in Settings → ADP WFN Export, then try again.

Missing staff in the file

Staff must have both a non-blank Custom ID and more than zero combined regular and overtime hours to appear in the ADP file.

  1. Check their hours in Reports → Daily Summary for the selected date range.

  2. Go to Staff → More actions → Map Custom IDs and download the template to check their saved customId. If it is blank, enter their ADP file number and upload the corrected CSV using the steps above.

  3. After the update succeeds, return to Reports → Daily Summary, select the date range, and choose Export → ADP Export again.

Incorrect File # in ADP

Confirm each staff member’s customId in POS Time Tracker matches their ADP file number.

Did this answer your question?