Versions Compared

Key

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

...

...

Mapping Time to ADP Earning 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 Earning 3 Codes these can be set up (ref?) in ADP and mapped to equivalent Time Codes in DATABASICS.

The

of expenses is primarily using the Earnings Code feature in ADP. Most often Expense Reimbursement is one Earnings Code in ADP (e.g. “Expense Reimbursement”). However, ADP Earnings or Deduction Codes can be mapped to either Expense Type Group or Expense Type in DATABASICS.  

For example if the Earning Code is “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 ensure the data is 100% validated before it gets posted to ADP.   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.

  • 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 - Reimbursable amount

Post Approved Expense Reimbursable Transactions to ADP

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

INSERT INTEGRATION DETAILS

DATABASICS Time to ADP Payroll to labor payroll processing.

...