Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DATABASICS Expense Reporting system integrates to ADP Payroll for expense reimbursement.

...

DATABASICS will configure a profile to post all approved expenses in the following format:

·       REVIEW  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.

REPLACE

...

Posting to ADP

Manual Process

  1. 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 Expense 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 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.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.

...

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

  1. 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 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:

...