cancel
Showing results for 
Search instead for 
Did you mean: 
kaseywade
Level 1

ADP import to QuickBooks Online

How do I import payroll data from ADP into QuickBooks Online?

Solved
Best answer August 03, 2017

Best Answers
lynda
Community Champion

ADP import to QuickBooks Online

I would check with ADP on this question.  They would need to provide you with an importable file ( . qbo).   For most outside payroll services, the client generally has to make the entries via a journal entry.  Which is why I recommend using qbo payroll service.

View solution in original post

4 Comments 4
lynda
Community Champion

ADP import to QuickBooks Online

I would check with ADP on this question.  They would need to provide you with an importable file ( . qbo).   For most outside payroll services, the client generally has to make the entries via a journal entry.  Which is why I recommend using qbo payroll service.

View solution in original post

Anonymous
Not applicable

ADP import to QuickBooks Online

Hi Kasey,

 

Just to add another option here if you are using ADP and QBO.

 

We have helped a number of ADP users to export journal entries of Wages, Entitlements Withholdings etc.. as an IIF file and then use our QuickBooks Online data import utility called Zed Axis (that you can find in the Intuit QuickBooks Apps Center) that can take an IIF file and import that directly into QuickBooks Online.

 

There is a bit of setup to make sure your GL account names match between ADP and QuickBooks Online but once aligned this solution can batch process large volumes of payroll data. 

1935 1475 8633 749
Level 1

ADP import to QuickBooks Online

ADP has suggested i set up a Clearing Account in QBO. Once the ADP download brings in the payroll info. in this case the payroll checks written, how do the Clearing account transactions get cleared and reconciled?

MichelleBh
QuickBooks Team

ADP import to QuickBooks Online

Hi, 1935 1475 8633 749.

 

I'll share some knowledge about managing clearing account (CA) in QuickBooks Online. 

 

Once the money sends out to your employee, you'll need to transfer the amount from the business account to the ADP clearing account to zero out. 

 

Here's how: 

 

  1. Go to the Plus icon, then choose Transfer
  2. In the Transfer Funds From the drop-down, choose the business account. 
  3. Choose CA in the Transfer Funds To field. 
  4. Enter the Transfer Amount in the area. 
  5. Tap Save and close

 

For more guidance, check out this article: Transfer funds between accounts.

 

I've attached articles about handling COA, reports, and other topics. 

 

 

Let me know if you have any additional concerns. I'm always ready to guide you. Take care!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us