DATABASICS Expense Reporting system integrates to ADP Payroll to reimburse employee for expense reportsreimbursement.
Pull Data from ADP
DATABASICS organization structure consists of the following:
Operating Unit, a Department, an Employee
Employee also has the following properties:
Employee ID
First Name
Mid Initial
Last Name
Employee Type (Such as Contractor, Full Time, Part Time , etc)
Hire Date
Termination Date
We use ADP API get employee data to map it to DATABASICS employee. All the above fields include the Operating Unit, Department, and Employee data integrated to ADP employee record. The employee load gets scheduled in DATABASICS to refresh Employee data on weekly, daily, hourly and as needed bases. The load will call ADP API to get latest employee data and refresh the data in DATABASICS for new records and existing records.
...
The loads will validate to make sure all the required fields are provided in order for the employee to be active in DATABASICS.
In cases, we might have customers with back end account systems where it will become the master record of the employee, and in that case, we will load ADP File Number and map it to the existing employee data that we are getting from backend account systems, such as Microsoft Dynamics, Intacct, NetSuite, etc.
Expense Type Mapping to EDP Earnings / Deduction Code
...
Expense Type Mapping to ADP Earnings / Deduction Code
ADP Reimbursement of expenses is using the Earnings Code or Deduction Code feature in ADP. Restrictions and validations needed can take place to ensure the data is 100% validated before it gets posted to ADP.
Earnings Codes and Deduction Codes
A customer may process expense reimbursements using ADPs Earnings Code or Deduction Code feature.
If Expense reimbursement is made using ADPs Earnings Code feature the reimbursement is posted as a positive number associated with one or more Earnings Code(s). Most often only one Earnings Code in ADP is used (e.g. “Expense Reimbursement”). However, a customer can utilize multiple ADP Earnings or Deduction Codes, be mapped to either Expense Type Group or Expense Type in DATABASICS.
For example if the Earning Code is “Travel” “TVL - Travel” in ADP then we will configure DATABASICS Expense Type Group as Travel and then we will add all the expense types such as Airfare, Car Rental, Train, Lodging, etc. to the Travel and then when we post payment to ADP payroll we will the total sum of all expenses for Travel Earning code. Restrictions and validations needed can take place to endure the data is 100% validated before it gets posted to ADP. , other expenses may post to a separate Earning Code like “EXP - Expense”.
If Expense reimbursement is made using ADPs Deduction Code feature the reimbursement is posted as a negative number associated with a Deduction Code.
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 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.
And either:
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.
Or:
Deduction Code - is the ADP code that corresponds deduction type. You may be able to locate them under Company > Earnings and Deductions.
Deduction Amount - Reimbursable amount (stated as a negative).
Post Approved Expense Reimbursable Transactions to ADP
DATABASICS will configure a profile to post all approved expenses in the following format:
· CSV - For Manually Quick Entry
...
·
according to the customer’s requirement. The file produced will identify the ADP Company the reimbursement will be generated along with the reimbursement details to show up on the user’s paystub.
The Post to ADP profile configured in DATABASICS with query to retrieve only approved expense report reports and reimbursable amount is amounts greater than zero. These queries are fully configurable by the customer depending on the requirements.
...
Posting to ADP
DATABASICS can post directly to ADP Workforce Now, other for other ADP Programs we will provide a tailored file output for
Example DATABASICS Post Expenses for reimbursement 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.
...
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 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
...
CSV file.
...
4.
...
Download the
...
CVS file
...
<INSERT ADP SCREENSHOT HERE>
Automated Process
Make sure DATABASICS Post Profile is configured as XML output.
...
2. You could schedule the extract on daily, weekly, month etc. Once you schedule it, we need to notify DATABASICS support to make sure the XML file gets picked up from DATABASICS servers and FTP to ADP FTP Servers based on the agreed scheduled between customer and ADP Team.
Once the file is uploaded to ADP, it will get processed.
<INSERT ADP SCREENSHOT HERE>
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.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.
Deduction Code Posting Example:
...
Earnings Code Posting Example:
...