How to check all active I-9s for the first full week of billing:
Go to Canvas inside of Bullhorn
Select Run “Payroll/billing report (pay rate, bill rate, and mark up)”
Select the date range of the first full week, then click “Next” (if you click “Finish” the report will run for the entire company for the selected date range)
Scroll down and select your branch and then click “Finish”
Once the report is complete, click the download report button and download in 2007 Excel format.
When prompted click the downloaded file to open it
When the file opens, click the “Data” tab and select “Remove Duplicates”
Unselect all columns except Candidate ID, then click OK
After Excel has removed the duplicates, only your unique values will remain. Column D (Candidate Name) contains the list of the employees that need to have their I-9s checked. Column E has their candidate IDs for easier access to the record. These are the only two columns that you need.
Inside of Bullhorn, type in the candidate ID to pull the candidate up.
Navigate to the candidate’s file tab and confirm that there is an I-9 present and compliant.
