ADP Time Integration

Mapping Time to ADP Hrs 3 Codes

ADP payroll is mainly related to worked hours, handled as REG and OT in the system. Exception classes of time is handled in ADP as Hrs 3 Codes these can be set up per customer requirement (ref?) in ADP and mapped to equivalent Time Codes in DATABASICS.

Example list or ADP Hrs 3 Codes Mapped to Time Codes in DATABASICS:

ADP Hrs 3 Code	DATABASICS Time Code	Time Code Name
BRV	BEREAVEMENT	Bereavement
HOL	HOL	Holiday
JUR	JUR	Jury Duty
SCK	SCK	Sick
DBL	DT	Double Time

Note that Hrs 3 Codes can be both worked hours and non-worked hours.

Post Approved Timesheets to ADP

DATABASICS will configure a profile to post all approved timesheets to ADP Payroll for labor payroll processing.

The output will be arranged per ADP Company.

INSERT INTEGRATION DETAILS

DATABASICS Time

Posting to ADP

Manual Process

Make sure DATABASICS Post Profile is configured as CSV output.

You could schedule the extract or run it as needed. To run the extract go to Admin --> Data Piping → All Profile Task --> click on

Run Now for Timesheet Post to ADP profile.

Once it runs it will take you to Job Instances to view the status and once it completed you will be able to download the CSV file.

Download the CVS file to Downloads folder on your computer. Click Upload when you are ready. Once you have added your payroll file from DATABASICS to your import, select the appropriate file(s) using the check box and click Done. ADP Workforce Now will bring you back to your unprocessed payroll files.

Importing into ADP Workforce Now Payroll

To import into ADP, log into Workforce Now at workforcenow.adp.com. You will need to have Practitioner or Limited Practitioner rights.

You will need to begin by starting a new payroll cycle. If you have already done so, please skip these steps. Once you have started a new payroll cycle, or if you would like to import your data into an existing payroll cycle, select Process from the top navigation bar. The options will vary depending on your role within ADP Workforce Now. Select Utilities and choose Import. Then select Paydata. Upload the file Select your exported payroll file from DATABASICS that you already downloaded by clicking Add Files. ADP Workforce Now will bring you back to your unprocessed payroll files. Select the appropriate file(s) using the check box and click Other Actions. Click Start to begin processing payroll.

NOTE: DATABAICS has the ability to rollback a posted batch as long as it is not processed in ADP yet. You may need to contact support@data-basics.com or submit a ticket online to request a rollback to a posted timesheet batch.