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?

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. 

• Learn about the chart of accounts in QuickBooks
• Set up a clearing account
• Various Reports

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

Gave a thumbs up by mistake.  Other payroll companies sync with QBO and QBO Payroll is not necessarily the best answer.  For sure.

i am able to import the file but only without matching up the employees to the transactions.  I have tried making the employees venders as well but nothing works.  I have far too many employees to have to edit the GJE everyweek to reflect the employee.  Anyone have any thoughts?

Hi there, Wendy. I appreciate you for providing details of your concern. I'm here to help you match your transactions. 

You'll want to review the Payroll Settings screen and check if you're using the correct bank account.

Here's how:

1. Click the Gear icon and choose Payroll Settings.
2. Select the Accounting link under Preferences.
3. Verify if you're using the correct bank account (see the screenshot below).
4. Update if needed.
5. Click OK.

If you've selected a different bank account whem importing, you can set up a clearing account and transfer funds or create a journal entry.

You can check this article for more details about this. : Set up a clearing account.

I’d also recommend working with your accountant for additional guidance. They can advise you on what account A/R or A/P account to use. If you’re not affiliated with one, you can check our ProAdvisor page and we’ll help you find one from there.

Once you're all set, you might want to check out this resource for your reference. This can help you seamlessly match your bank balance and QuickBooks balance: Reconcile an account in QuickBooks Online.

Let me know if there’s anything else you need help in managing your accounts in QuickBooks. I’d be more than happy to assist you. Take care, and keep safe.

Thanks for the info about Zed Axis.  What a relief!  I spent days trying to get ADP Payroll automatically into Quickbooks and was getting an error about my clearing account.   I then tried to import into quickbooks Online, again errors.  Not sure why, names were correct, numbers were correct etc.  ADP blamed Quickbooks and Quickbooks said my ADP file was wrong.  Frustrating!  Zed Axis came and frustration was gone.