ADP Alternate Export

Prev Next

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

The My Reports search bar can be used to search R365's entire catalog of reports.

  1. Navigate to My Reports
  2. Enter all or part of the report name in the search bar.
  3. The Results tab will open with the list of search results.
  4. From beneath the report name, click Run to run the report with the selected report view.
    -OR-
    Click Customize to adjust the report parameters and run the report. 



Report Parameters

Field

Description

Filter By

A listing of all location categories.

Filter

A listing of all locations associated with the chosen location category.

Start Date

The beginning date for the report.

End Date

The end date for the report.

Eight Percent Flag

The numeric value which will calculate the sales tax percentage and then compare that to the amount of tips the employee earned.

Run Button

Runs the report.

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


Report Columns

Field

Description

Co Code

The ADP company code. This must be manually added before importing to ADP.

Batch ID

The batch ID of the import. This must be manually added before importing to ADP.

File #

Employee payroll ID.

Temp Department

The number associated with the job title.

Temp Rate

The rate of pay.

Reg Hours

The amount of hours worked.

O/T Hours

The amount of overtime hours worked.

Hours 3 Code

Set to 'D' for double overtime hours.

Hours 3 Amount

The amount of double overtime hours worked.

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.

Memo Amount

The total sales amount and gross receipts associated with the employee. This must be manually added before importing to ADP.

Earnings 3 Code

Set as 'T' for the tip amount. This must be manually added before importing to ADP.

Earnings 3 Amount

The tip amount based on whichever is greater: the percentage of sales, receipt logic, or total tips. This must be manually added before importing to ADP.