...
DATABASICS Services Team will work to configure DATABASICS based on the customer requirements. The following fields are necessary in order to upload the custom CSV file into APS:
Company Code (Located in "Edit Company" in ADP)
Batch ID (Located in "Edit Company" in ADP)
File # Employee_Number - Employee ID number in ADP and it is configured in the employee setup API. Typically configured as other id in the DB employee setup.
Earning 3 Code is the ADP code that corresponds with reimbursement type. You may be able to locate them under Company > Earnings and Deductions.
Earning 3 Amount - Reimbursable amount.Department - Department number in APS- tied with the employee
Hours Abbreviation(s) - is the APS code that corresponds to a time code in DB, there may be multiple Abbreviations based on the customer Payroll set up.
Dollar Abbreviation - is the APS code that corresponds with a reimbursable pay type in DB
Post Approved Time / Expense Reimbursable Transactions to ADP
...
To import into ADP, log into APS as administrator.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
...
APS using Manual Process
Make sure DATABASICS Post Profile is configured as CSV output.
...
2. 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 Expense Extract Reimbursements ADPto APS 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 CSV file.
...
4. 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.
...
Expense Posting Example:
...
Earnings Code Posting Example:
...
Employee Name | Employee_Number | Department | RegHr | OvtHr | ExpRmb | Location |
Jane Doe | 123 | 1000 | 236.43 | 10 | ||
Time Posting Example:
Employee Name | Employee_Number | Department | RegHr | OvtHr | ExpRmb | Location |
Jane Doe | 123 | 1000 | 40 | 4 |
| 10 |
Jane Doe | 123 | 1000 | 40 |
| 100 |