Icon

How to Import and Manage Payroll Registers in ADP Payroll Dashboard

Step-by-step guide on importing payroll registers, managing commissions, and downloading payroll reports in the ADP Payroll dashboard. Learn how to handle common issues and ensure accurate payroll processing.

By Elisha Hicks

In this guide, we'll learn how to import, review, and adjust payroll check registers using the ADP Payroll dashboard. This process includes uploading a saved file, making necessary changes for commissions, and verifying the payroll register for accuracy. The goal is to ensure payroll data is correct before finalizing and downloading the register.

Let's get started

Okay. Continuing from the ADP Payroll dashboard. Several registers will be listed here. Find the one labeled HX0 with the pay date you need. Click Manage Payroll.

1
Click on "Manage payroll"
Step #1: Click on "Manage payroll"

Click Import File.

2
Click on "Import file"
Step #2: Click on "Import file"

We will add the file we just saved to the payroll check registers.

3
Click on "↑ Upload files"
Step #3: Click on "↑ Upload files"

Click Open below.

4
Click on "PRXHOEPI.csv"
Step #4: Click on "PRXHOEPI.csv"
5
Click on "Open"
Step #5: Click on "Open"

Now, it isn't a magical import. It may take some time. Sometimes, you can close it as it says, but other times it may not work.

6
Click on "Close"
Step #6: Click on "Close"
7
Click here
Step #7: Click here

If you refresh, you'll return to the payroll dashboard. Wait a few minutes, then go back. I'll show you how to do that shortly.

8
Click on "← → C"
Step #8: Click on "← → C"

Okay. Let's check if everything imported correctly. It has. I forgot to mention this earlier when I was creating or discussing how to export the file to check the number. But it was 93.

You need to open that because we have to make some changes. First, for the people who receive the $250 commission, we need to add a column for other earnings. Code is commission. I always delete this part because it appears on their pay stub. Click Done.

I check my notes and see it was Rick Gilbert and Weston Radke. Return to ADP, enter the last name, and move the entry from regular earnings to the commission column. Autobalance. Radke. Scroll until it appears.

Past it. There we go. Autobalance it, then click Done. Calculate. I will discuss this.

This is another file we use to add a worksheet for benefit recoupment for anyone who has been on leave. Not very typical, so I didn't address that. We can discuss that in more detail if it comes up in the future. Calculate payroll. A new screen will appear. Select the option to download the payroll register.

Once the payroll register downloads, I review it. This screen appears. Take a moment to think. We want to choose a time when it isn't blocked out. We will select the payroll register. It usually doesn't take this long.

It’s ready. Click the checkbox, scroll down, and select "Download Selected." It will appear in your downloads. Click it to open your register. Okay, the register opens. Go to the company totals page. I'm used to this, but I scan through to check for anything unusual, like errors or excessive spending.

Okay. The screen also displays the total amount due to us. I will continue in another video to discuss managing payroll errors.

9
Click on "Manage payroll"
Step #9: Click on "Manage payroll"
10
Click on "202585"
Step #10: Click on "202585"
11
Click on "INSERT ▼"
Step #11: Click on "INSERT ▼"
12
Click on "Column"
Step #12: Click on "Column"
13
Type "other"
14
Click here
Step #14: Click here
15
Click on "Entered at runtime"
Step #15: Click on "Entered at runtime"
16
Click on "Entered at runtime"
Step #16: Click on "Entered at runtime"
17
Type "com"
18
Click on "C - COMMISSION"
Step #18: Click on "C - COMMISSION"
19
Click on "Other Earnings - COMMI"
Step #19: Click on "Other Earnings - COMMI"
20
Drag "Other Earnings - COMMI"
Step #20: Drag "Other Earnings - COMMI"
21
Click on "DONE"
Step #21: Click on "DONE"
22
Click here
Step #22: Click here
23
Click on "Search Employee by File # or Name"
Step #23: Click on "Search Employee by File # or Name"
24
Type "gilb"
25
Click on "Q"
Step #25: Click on "Q"
26
Click on "Reg Earnings Rate Code"
Step #26: Click on "Reg Earnings Rate Code"
27
Type "Ctrl + X"
28
Click here
Step #28: Click here
29
Type "Ctrl + V"
30
Click on "2.50"
Step #30: Click on "2.50"
31
Type "Ctrl + X"
32
Click here
Step #32: Click here
33
Type "Ctrl + V"
34
Click here
Step #34: Click here
35
Click on "AUTO BALANCE"
Step #35: Click on "AUTO BALANCE"
36
Double-click here
Step #36: Double-click here
37
Type "radke"
38
Click here
Step #38: Click here
39
Type "Ctrl + X"
40
Click here
Step #40: Click here
41
Type "Ctrl + V"
42
Click here
Step #42: Click here
43
Type "Ctrl + X"
44
Click here
Step #44: Click here
45
Type "Ctrl + V"
46
Click here
Step #46: Click here
47
Click on "AUTO BALANCE"
Step #47: Click on "AUTO BALANCE"
48
Click on "DONE"
Step #48: Click on "DONE"
49
Click on "Calculate payroll"
Step #49: Click on "Calculate payroll"
50
Right-click here
Step #50: Right-click here
51
Click here
Step #51: Click here
52
Click on "Payroll Register ( Excel ) Payroll Register - Pay Check Level Totals"
Step #52: Click on "Payroll Register ( Excel ) Payroll Register - Pay Check Level Totals"
53
Click on "Payroll"
Step #53: Click on "Payroll"
54
Click here
Step #54: Click here
55
Click on "Download selected"
Step #55: Click on "Download selected"
56
Click on "↓"
Step #56: Click on "↓"
57
Click here
Step #57: Click here
58
Click on "PR_PayrollRegister_XH0_32-"
Step #58: Click on "PR_PayrollRegister_XH0_32-"
59
Click on "Company Totals"
Step #59: Click on "Company Totals"
60
Click here
Step #60: Click here
61
Drag "$ 284,817.72"
Step #61: Drag "$ 284,817.72"
62
Type "Ctrl + C"