Who can use this: This time export generates a CSV file that can be uploaded directly into ADP Workforce Now.
Note: Your employees' ADP Position ID (excluding Company Code) should be entered as their Employee ID in Worksana.
1. Navigate to Timecards
2. Click on Export at the top right of your screen.
3. Select ADP Export and click Export Now
The CSV file will need a little massaging to account for your specific ADP setup. Attempting to upload it without correcting Hours Codes or failing to delete unused/unneeded columns will cause ADP's import system to throw errors.
1. Note your three-character ADP Company Code and Hours and Earnings Codes. These can be found by clicking on Tools -> Validation Tables -> Hours and Earnings Codes.
2. Find your exported CSV file and rename it is as:
Format: EPI[Your Company Code]##.csv
Example: EPI6KM01.csv
Any two digits are fine.
2. Open the file
3. Editing steps
Enter your company code in column 1 and copy/paste for all rows
Create a Batch ID number. This can be any 6 digit number (like a date)
Verify your File # (Position ID/Employee ID) is correct, then delete the Name column.
Delete Tax Frequency, Temp Dept, and Temp Rate columns
Unless you are an Amazon Courier, delete what are now columns I and J ("Paid-Not Worked" and corresponding values)
Replace the Worksana exported Adjustment Activity names with their ADP Hours and Earnings Codes
If you have paid meals, paste the value into an available Hours 3 or Hours 4 Amount Column. Enter the correct ADP Hours and Earnings code into the corresponding Hours 3 or Hours 4 Code Column
Delete any unused columns
4. Upload the file into ADP Workforce Now. Click on Process -> Payroll -> Start New Cycle. Scroll down and look for Add Paydata Batch. Now click on Import from File and follow the prompts to complete your payroll.
