How to Sync Payroll Records Between Sage and ADP Using The Bridge and Review Records to match to ADP

Learn step-by-step how to import and reconcile payroll records from ADP into Sage using GetPayroll. Ensure accurate payroll data, handle deductions, and resolve common syncing issues.

August 6, 2025 By Elisha Hicks

In this guide, we'll learn how to sync payroll records between Sage and ADP using the GetPayroll bridge. This process helps ensure that payroll data is accurate and matches across both systems. We will also cover how to verify and adjust payroll details for each employee to resolve any differences.

Let's get started

Okay. Now that payroll has been completed for HX0 for Old Hot, we can return to Sage and open the bridge to GetPayroll.

This will begin communication with ADP to import all payroll records into Sage.

It only takes a second. Payroll—what is it? Excuse me, Employees and Payroll 93. Let me click this box below, since that number is correct.

Step #4: Click on "By checking" — Click on "By checking"

Click Sync.

Step #5: Click on "Sync" — Click on "Sync"

Click the first box to reset. If anyone has federal income set to zero, this will ensure it stays at zero, as Sage may try to overwrite it.

Step #6: Click on "Reset FIT to $ 0 before Sync" — Click on "Reset FIT to $ 0 before Sync"

Click that, then click Continue, and select Yes.

Step #7: Click on "Continue" — Click on "Continue"

Step #8: Click on "Yes" — Click on "Yes"

This part only takes a moment. Okay. It finishes syncing and then notifies you that Medicare and Social Security are off by 100 pennies. Just click OK, then click OK again. This shows that the balance or Net Pay in Sage is different from what is in ADP.

Just click OK. Now we will return to the payroll records. Sorry, we need to go to the payroll folder that John set up for us with Sage. I'll install that on Deborah's computer as well. Open the folder and click "Run Query." When the box appears, select both options.

It updates all the zeros or pennies in Sage that appear because nothing was imported from ADP. It automatically resets those values, so we don't have to do it manually.

Alright.

Let's start at the beginning of our records for this payroll. I'll start again with Mark. You'll see that ADP imported everything.

You need to do this one by hand.

Step #13: Double-click on "Records" — Double-click on "Records"

We think it's somewhere in Sage, but we can't get it to zero out, so we always have to do that.

Next, go to ADP and select the list for HX0, active. Find Mark's name and verify that his payroll matches the net amount from Sage to ADP.

Step #19: Double-click here — Double-click here

Step #20: Double-click on "RunSqlQuery.exe" — Double-click on "RunSqlQuery.exe"

It does, so let me move on to the next point.

Step #32: Click on "Di 1 - Open" — Click on "Di 1 - Open"

Step #33: Double-click on "Di 1 - Open" — Double-click on "Di 1 - Open"

Go down the line and have everyone verify G1. Clear current attacks, check AP, and ensure the net matches for each person.

Step #34: Click on "* Record #" — Click on "* Record #"

Step #35: Double-click on "210 Mark K Baleme" — Double-click on "210 Mark K Baleme"

Step #36: Click on "Calculations" — Click on "Calculations"

Step #37: Click on "37.87" — Click on "37.87"

If the net doesn't match, check the section showing regular pay, overtime, holiday, or vacation. Make sure these figures match those in Sage.

38

Type "0 + Enter"

39

Type "y + Enter"

Step #41: Click on "People ▼" — Click on "People ▼"

You can also check here to see if anything is incorrect. Look under deductions to see if anything is missing or needs to be added to Sage.

Step #43: Click on "< all employees > Q" — Click on "< all employees > Q"

Step #44: Click on "< all employees > Q" — Click on "< all employees > Q"

Step #45: Click on "< all employees > Q" — Click on "< all employees > Q"

Step #47: Click on "A XHO Active & LOA" — Click on "A XHO Active & LOA"

New deductions may appear or disappear, such as child support or changes in 401K contributions. Home is used to ensure the nets match and the correct codes are entered into the employee's deduction calculations.

Step #48: Click on "Mark" — Click on "Mark"

Step #49: Click on "Mark" — Click on "Mark"

After completing those steps, we match the payroll registers from Sage to ADP.

53

Type "Enter"

Thank you.

Step #55: Click on "View details" — Click on "View details"

Step #56: Click on "View details" — Click on "View details"

Step #57: Click on "View details" — Click on "View details"

Step #58: Drag "$ 2,766.34" — Drag "$ 2,766.34"