Before processing payroll or reviewing labor metrics, it's essential to generate an accurate time and attendance report from your internal system. This report provides a detailed overview of employee hours worked, tips earned, and any adjustments made during a specific pay period. The steps below guide you through accessing the reporting tools within the Joe Coffee management platform to ensure all data is correct and formatted properly for import into ADP.

✅ Example: Importing a Report into ADP

1. Generate Report from Joe Coffee System

• Action:
  Log into manage.joe.coffee using your credentials.
• Navigation Path:
  Go to Teams and Roles Tab → scroll to the "Reports" section.
• Report Type:
  Select "Time and Attendance".
• Set Date Range:
  Choose the relevant two-week period for payroll.
• Outcome:
  The system generates a detailed time and attendance report, including hours worked, tips, and any adjustments.

2. Review and Export the Report

• Action:
  Carefully review the report for accuracy (check hours, missed punches, duplicate entries, etc.).
• Export Format:
  Export the report as CSV or Excel (.xlsx).
• Outcome:
  The report is saved to your computer and is ready to be imported into ADP.

3. Import Report into ADP

• Action:
  Log into your ADP account.
• Navigation Path:
  Go to Payroll or Time and Attendance, depending on your ADP setup.
• Steps to Import:
  1. Click on "Import Data" or "File Import."
  2. Select the data type: Time and Attendance.
  3. Upload the exported file from Joe Coffee.
  4. Map Fields: Ensure each column from the file matches the correct ADP fields (e.g., employee ID, regular hours, overtime, tips).

4. Verify and Finalize Payroll

• Action:
  Review the imported data in ADP for completeness and accuracy.
• Check for:
  • Correct hours for each employee
  • Proper tip reporting
  • Any manual adjustments
• Outcome:
  Once everything is verified, finalize payroll to process payments for the selected period.

💡 Pro Tips:

• Double-check time zones and pay codes before finalizing.
• Save a backup of the exported file in a secure folder.
• Use ADP’s import validation tool (if available) to catch format or mapping errors.
   

Still Having Issues?

If you’ve followed the steps above and are still experiencing issues, please don’t hesitate to reach out to the Joe Success Team at support@joe.coffee. We’re here to help!