ADP Export - Tipped Employees

ADP Export for Tipped Employees
Before setting up your FOCUS ADP Integration, you must have the following values (provided by ADP):

• ADP Restaurant Code
• ADP External Job ID (the ADP Job Code for each Job in your system)
• ADP Employee IDs (the ADP ID for each of your employees)

Prepare your FOCUS System to integrate with ADP

1. Enter the ADP External Job ID into your Job Setup
   1. Go to FOCUS Setup > Employees > Jobs > Timekeeping
   2. Enter the ADP Job ID into the ADP External ID field.
2. Enter your ADP Restaurant Code into your core FOCUS Setup
   1. Go to Miscellaneous > General > Restaurant
   2. Locate the ADP Restaurant Code field and enter the restaurant code provided to you by ADP
3. Setup your FOCUS System to accept ADP Employee IDs
   1. ADP should provide you with ID codes for each of your employees. These codes will be entered into the ID2 field for each employee in your FOCUS system.
   2. We strongly suggest that you make ID2 mandatory, so that future managers will not forget to enter the ID2 when bringing on-boarding a new employee.
   3. Go to Miscellaneous > General > Timekeeping
   4. Check the box ID2 Mandatory
4. Add the ADP Employee ID to each of your employees
   1. Go to Employees > Employees
   2. Locate the ID2 field and enter the code provided by ADP for each employee
      1. Note: Salary employees may not need a code depending on your ADP setup.

Create your ADP Export Report & File
Once your FOCUS System is prepared (outlined above) you will need to create a FOCUS Report that will be used to integrate to ADP.

1. Go to FOCUS Setup > Reports > Setup
2. Locate an unused Report field
   1. Unused reports are typically blank report spots that do not have a Name
3. Use the following settings:
   1. Reports Tab
      1. Name:
         1. ADP Payroll
      2. Type:
         1. Payroll Report
      3. Payroll Report Options:
         1. Check each job that will be exported.
         2. Note - only export jobs that are set to be imported by ADP. If you are unsure what jobs these are, contact ADP
      4. Detail:
         1. Individual Times
      5. Sort
         1. Employee
      6. Payroll Format
         1. ADP
      7. Revenue Centers
         1. Do not check any revenue centers, as you will not be filtering by revenue center.
   2. Output Tab
      1. Destination
         1. E-mail
      2. E-mail Attachment Name
         1. ADPPayroll.csv
         2. Note - you must append the filename with .csv for the export to be received properly by ADP.
      3. E-mail Address (To)
         1. Enter your email address, or the email address provided to you by ADP.
      4. Format Options
         1. Leave as default
      5. Security Code
         1. Any number between 4 and 7
      6. ID
         1. Blank
      7. File Option
         1. Overwrite
      8. Screen Options
         1. Display
            1. Checked
         2. Screen Format
            1. Any
         3. Sort Position
            1. Any
         4. Image File Name
            1. Any
   3. File Format Tab
      1. The file format tab is where you link ADP info to specific FOCUS info.
      2. You may need to contact ADP support to properly link FOCUS fields to your specific ADP configuration
      3. Below is a description of each ADP Field and each Payroll Field
         1. ADP Field
            1. Earning 3
               1. The 3rd ADP Earnings option.
               2. Typically this will correlate to Cash Tips, Charge Tips or Gratuity depending on your configuration
            2. Earnings 4
               1. The 4rd ADP Earnings option.
               2. Typically this will correlate to Cash Tips, Charge Tips or Gratuity depending on your configuration.
               3. Note this earnings field may not be used by all ADP clients.
            3. Memo Code
               1. A generic Memo Field provided by ADP.
               2. Most commonly this field is mapped to "TIpped Sales" so that ADP can import in what the employees total sales were
         2. Payroll Field
            1. Declared Tips
               1. The total tips declared by the employee upon clock out.
               2. Do not confuse this with Total Tips as total tips is the sum of Declared Tips + Charge Tips.
            2. % Tips
               1. The percentage of tips calculated by FOCUS based on Tipped Sales multiplied by the Tip % located in Miscellaneous > General > Timekeeping
            3. Charge Tips
               1. The total of all credit card tips received by the employee.
            4. Tipped Sales
               1. Total amount of Tipped Sales generated by the Employee.
               2. Tipped Sales are controlled by the individual Order Type which are enabled in FOCUS Setup > Order Entry > Order Types > Tipped Sales
            5. Gratuity
               1. Total of all automatic gratuities received the employee.
               2. Typically referred to as "Auto-Grats"
            6. Total Tips
               1. Total Tips received by the employee. This is the sum of Gratuities, Charge Tips and Declared Tips.
         3. ADP Batch Identifier
            1. This identifier is provided by ADP and is only necessary if ADP indicates you need it.

Generating the ADP Export
Now that all components of the Setup have been performed, you're ready to generate your first ADP Export.

1. Go to FOCUS Setup > Reports
2. Locate the Report Button labeled ADP Export
3. Click on the Report Button
4. Enter the date range that you want to export.
   1. If your Payroll Periods are programmed into FOCUS properly, the default date range should be your current pay period.
5. Press OK
6. The report will be emailed to the email address specified above in the step: Create your ADP Export Report & File 3.2.3
7. Once you receive the report, you will need to import it into ADP's system.
8. Instructions for importing the report can be obtained from ADP.