ADP Payroll Data in ABI is for organizations that use ADP as a third-party payroll company, such as ADP Workforce Now. ADP Payroll Data is located in the Staffing section of the Insights module.
Organizations can export the report, review, and upload it directly into ADP. Please note, users should complete all audits and changes at least 24 hours prior to exporting, to ensure all corrected/updated information is included for accurate reporting.
ADP Payroll Data in ABI contains the following widgets:
- Hour-3 Code
- This widget displays the total hours and # of Employees with Hour-3 Code, which allows users to see how many employees have Hour-3 Code hours for this payroll run date.
- Reg Hours
- This widget displays the total REG hours and average Reg Hours per employee.
- Adjust Ded Amount
- This widget displays the total adjusted deductible amount and drive mileages for this payroll run date.
- Hour-3 Amounts
- This widget displays the total Hour-3 related amount by service week.
- Reg Hour Amounts
- This widget displays the total REG hours related amount by service week.
- Adjust Ded Amounts
- This widget displays the adjusted deductibles amount by service week.
The grid and export at the bottom of the report contains the following columns:
Column | CR Location |
---|---|
Co Code | Human Resources module > Employees > Payroll Setup tab > “Payroll Company” field |
Batch ID | The date payroll was run and must be in the MMDDYY format.
Human Resources module > Payroll > Run Date |
File # | Human Resources module > Employees > Payroll Setup tab > “Payroll Employee #” field |
Employee Name | The employee’s name. |
Temp Rate | The rate from the timesheet. |
Hours 3 Code | The child label attached to the service code on the timesheet, from under the parent label group, “ADP Hours 3 Codes” |
Adjust Ded Code | To capture mileage reflected on the timesheet (in the “Drive Info” section), the ADP mileage code must be added as a child label under the parent label group, “ADP Mileage Code” |
REG HOURS | All “regular” hours. (i.e., Hours that are not overtime or have an “ADP Hours 3 Codes” label). |
OT HOURS | All overtime hours. |
Hours 3 Amount | The corresponding hours from the “Hours 3 Codes” column. |
Adjust Ded Amount | The total number of miles (the “Miles” field in the “Drive Info” section of the timesheet), multiplied by the mileage rate and is reflected as a negative number. |