cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
hateu1
Level 1

duplicated bank accounts

Until, recently bank statements were added manually, but we decided to connect clients account online, instead connected existing account, new one was created resulting in 3 months of duplicated transactions now. I know its possible to merge accounts but how to do it correctly so i keep the new live bank account and all the transactions from the old one that are already matched? 

Old account is is done up to a march, new one starts from January. And Does the old one has to be reconciled first ?

1 Comment 1
MichelleBh
Moderator

duplicated bank accounts

I'll provide you with the initial steps before merging the duplicate account, @hateu1.

 

Let me help you clean your client's bank account in QuickBooks Online Accountant (QBOA) so reports and books are always accurate.

 

If your previous banking transactions are already reconciled, I suggest you leave the data untouched. We can exclude the new bank transactions (January to March) to fix the duplicates.

 

Go as follows:

 

  1. Go to the Banking tab on the left side.
  2. If the data is still in the For review, select all the January to March transactions and click Exclude
  3. If it's already classified, go to the Categorized section and undo them.
  4. Go back to the For review and undo them. 

 

For more details, see this link: Unmatch downloaded bank transactions or move them to another account.

 

After that, you can now merge the accounts. Before that, ensure to save the reconciliation reports, so the transactions remain on the linked account and stay reconciled.

 

  1. Go to the Accounting tab and then select the Chart of Accounts.
  2. For that account you want to keep, take note of the Account TypeDetail Type, and Tax form information. 
  3. Go to the Chart of Accounts again and edit the bank you won't keep. 
  4. Enter the data your take note of in Step 2
  5. Select Save and then Yesmerge accounts.

 

Furthermore, check out these articles below on how to fix incomplete transactions and fix some reconciliation errors in QBOA:

 

 

If you need further help with managing your banking, please leave a comment below. Happy to offer my support in any way I can.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

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