ADP Alternate Export

The ADP Alternate Export is similar to the ADP Workforce Export in that it runs R365's system to produce a listing of all Employee IDs, Pay Rates, Labor Hours, and more used for Payroll Processing. Rather than simply listing out these details, this report is exported as a CSV to then be sent to ADP for payroll. This export is only beneficial for Users who have ADP as their payroll provider.

Navigation

1. In the Reports section of the left navigation pane, select My Reports.
   The My Reports screen appears.

2. At the top of the My Reports screen, select Labor.
   The screen generates a list of reports in alphabetical order.

3. Locate the ADP Alternate Export.

4. Select Customize to adjust the report parameters and run the report.

Report Parameters

1. Filter By - A listing of all Location categories

2. Filter - A listing of all Locations associated with the selected Location category

3. Start Date - The beginning date the report is ran for

4. End Date - The end date the report is ran for

5. Percentage of Sales - The percentage of Sales that is taken for tips

6. Download Button - Downloads the report

Click here to learn more about Report Views and their added functionality.

Report Columns

1. Co Code - The ADP company code.

   This must be manually added before importing to ADP.

2. Batch ID - The Batch ID of the import.

   This must be manually added before importing to ADP.

3. File # - Employee Payroll ID.

4. Temp Department - The number associated with the job title.

5. Temp Rate - The rate of pay.

6. Reg Hours - The amount of hours worked.

7. O/T Hours - The amount of overtime hours worked

8. Hours 3 Code - Set to 'D' for Double Overtime hours..

9. Hours 3 Amount - The amount of Double Overtime hours worked.

10. Memo Code - Set to '2', which distinguishes that this is Gross Receipts (Sales Total) for the Employee.

    This must be manually added before importing to ADP.

11. Memo Amount - The Total Sales amount and Gross Receipts associated with the Employee.

    This must be manually added before importing to ADP.

12. Earnings 3 Code - Set as 'T' for the tip amount.

    This must be manually added before importing to ADP.

13. Earnings 3 Amount - The tip amount based on whichever amount is greater: the Percentage of Sales, Receipt Logic, or Total Tips.

    This must be manually added before importing to ADP.