I-9 E-Verification Tracker

How to Download the Required Excel File
  1. Go to ADP -> Reports & Analytics -> Report Output -> Search Form I-9 and E-Verify Information.
  2. Run the report -> Scroll down and click Run on the bottom right.
  3. Once the status shows Completed, click the Name of the Report to download.

Save the downloaded Excel file and upload it below.

Drag & drop Excel file here
or click to browse

Section 1 Status
  • Terminated -> "Terminated"
  • Sent back to employee -> "Sent Back to Employee"
  • Tentative Nonconfirmation (TNC) -> "Tentative Nonconfirmation (TNC)"
  • No submission but Active/Leave -> days left/overdue based on Hire Date
  • Submitted -> "OK" if on/before Hire Date, otherwise days late
  • Overdue -> still shows "X days overdue" in Section 1 Status, but Notes highlights as URGENT - Check Submission
Section 2 Status
  • Terminated -> "Terminated"
  • Sent back to employee -> "Sent Back to Employee"
  • Submitted -> "OK"
  • No submission -> days left/overdue based on Hire Date + 3 days
  • Deadline day or past deadline -> shows "X days overdue" in Section 2 Status, and Notes highlights as URGENT - Check Submission
Notes
  • Blank or special names -> blank
  • Terminated -> blank
  • Both Section 1 & 2 OK -> blank
  • Section 2 not yet submitted:
    • Day 0-1 after Hire Date -> Alert Submit Now
    • Day 2-3 after Hire Date -> URGENT Submit Now
  • Section 1 or Section 2 overdue -> URGENT - Check Submission
  • Otherwise -> "Check Submission"

These are the conditions used to generate the report.
For updates or changes, please contact Ryan TGO Projects Team.

Back to Home