How to download the correct payroll data from ADP
Log into your ADP RUN payroll account:
1. Click “Reports” in the menu bar
2. On the next "Reports Home" page select “Payroll Summary”
Note: ADP reports are by year, so you will need to run a report for 2020 and 2021
3. Under "From": Choose pay date on or before 3/13/2020 & "To": 12/31/2020
4. Name: select “All”
5. Click "Refresh" to update the report with the criteria selected
5. Select "Export to Excel" at the top of the report
6. Save the excel file as an Excel Workbook named “Business Name_Date Range”. If possible, please place all reports within the same Excel Workbook.
7. Repeat starting at #3 with the date range: 1/1/2021 - 9/30/2021.