...
ADP Payroll
...
Pay Code Mapping to EDP Earnings / Deduction Code
ADP Earnings or Deduction Codes can be mapped to either Pay Code Group or Pay Code in DATABASICS. Here are some examples of ADP Pay Code Mapping to AD Number and ADP Hours 3 code.
...
Pay Code
...
Pay Code Group
...
Name
...
ADP Number
...
ADP Hour 3 code
...
AT
...
AT
...
Administrative Leave
...
D
...
D
...
FMLA
...
FMLA
...
Family Medical Leave Act
...
L
...
L
...
PT
...
PERSONALTIME
...
Personal Time Off
...
V
...
V
...
ST
...
ST
...
Standard
...
R
...
R
Here are some references to help you in regards the earnings codes https://support.adp.com/adp_payroll/content/hybrid/%40runcomplete/doc/pdf/edqr.pdf
The ADP file contains the following:
DATABASICS team create a custom CSV file to export into ADP. The following fields are necessary in order to upload the custom CSV file into ADP:
Company Code (Located in "Edit Company" in ADP)
Batch ID (Located in "Edit Company" in ADP)
File # - Employee ID number in ADP and it is configured in the employee setup as other id in the employee setup.
Earning 3 Code is the ADP code that corresponds to a payroll account. You may be able to locate them under Company > Earnings and Deductions.
Earning 3 Amount - Total Hours
Posting
ADP payroll is mainly related to worked hours, handled as REG and O/T in the system. Other date elements may form part of the posting based on customer’s requirements.
Mapping Time to ADP Hours 3 Codes
Exception classes of time is handled in ADP as Hours 3 Codes. These can be set up per customer requirement in ADP and mapped to equivalent Time Codes in DATABASICS.
Example list or ADP Hours 3 Codes Mapped to Time Codes in DATABASICS:
ADP | DATABASICS Time Code |
|
BRV | BEREAVEMENT | Bereavement |
HOL | HOL | Holiday |
JUR | JUR | Jury Duty |
SCK | SCK | Sick |
DBL | DT | Double Time |
Note that Hours 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 in the following format:
· CSV - For Manually Quick Entry
...
·
to ADP Payroll for labor payroll processing. The file produced will identify the ADP Company the reimbursement will be generated from, along with the payroll details to show up on the user’s paystub.
The Post to ADP profile configured in DATABASICS with query to retrieve only approved timesheets . These queries are for the payroll period. The query is fully configurable by the customer depending on the requirements.
...
Posting to ADP
Manual Process
Make sure DATABASICS Post Profile is configured as CSV output.
...
2. 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.
3. 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 file CSV file.
...
...
The output will be arranged per ADP Company and will include logic supporting customer requirements, like auto payroll considerations and possibly calculated values for OT and DT.
DATABASICS can post directly to ADP Workforce Now, other for other ADP Programs we will provide a tailored file output to support the payroll process.
Example DATABASICS Post Timesheets for payroll profile:
...
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 posted expense batch.
Importing Into ADP using Manual Process
Make sure DATABASICS Post Profile is configured as CSV output.
...
You can 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 ADP - Extract Approved Timesheets 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.
...
2. Download the CSV 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.
ADP Payroll Posting Example:
...
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.