---
title: "ADP Alternate Export"
slug: "adp-alternate-export"
description: "Export employee IDs, pay rates, and labor hours in ADP CSV format with an Eight Percent Flag for tip compliance."
updated: 2025-08-28T18:53:31Z
published: 2025-08-28T18:53:31Z
canonical: "docs.restaurant365.com/adp-alternate-export"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

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

1. Open the **Reports** app.
2. Navigate to **My Reports**.
3. Enter all or part of the report name in the **search bar**.
4. The **Results** tab will open with the list of search results.
5. 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.

![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png)

---

## Report Parameters

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-NYEPGMRH.png)

| **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](/doc/docs/my-reports-using-my-reports#report-views) and their added functionality.

---

## Report Columns

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/6e80e0f6-faed-429b-a47f-d44c1569e84d.png)

| **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. |