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

Duplicate bank accounts and entries

A new client has asked me to help clean up their books (QBO) When she moved to online she or a bookkeeper connected the bank account and also created a new bank account, but they are the same account.  Now there are duplicate entries for the past year and to date.  What is the easiest and fastest way to clean this up?  Intuit really needs to give us a batch option to do this.  Clients just don't understand the bank feed section....ugh!

6 Comments 6
Kristine Mae
Moderator

Duplicate bank accounts and entries

Let me help you clean your client's bank account, SCampbell3.

 

You'll have to undo or unmatch the transactions. This way, it will no longer create any duplicate entries.

 

Feel free to follow these steps:

  1. Click Banking, then go to the Banking tab.
  2. Go to the Categorized tab.
  3. Select the transactions you want to undo or unmatch.
  4. Click Undo.

They will be transferred to the For Review tab. We'll have to exclude them again by selecting the transactions, then clicking Exclude

 

Once done, they will be transferred to the Excluded tab. From there, you can delete the transactions.

 

I'll add this article to better guide you: Unmatch downloaded bank transactions or move them to another account.

 

If you need something else, don't hesitate to leave a comment below. We'll reply as soon as we can. Take care!

Big Rons
Level 2

Duplicate bank accounts and entries

I would just do a Journal Entry.

SCampbell3
Level 1

Duplicate bank accounts and entries

Thanks...but would excluding them remove them for the ledger?

SCampbell3
Level 1

Duplicate bank accounts and entries

Thanks....that is what I am leaning towards.....I can't believe the "bookkeeper" says she has 20 years experience and would duplicate the same checking account...ugh!!!

AmyK2775
Level 1

Duplicate bank accounts and entries

I think our account was set up incorrectly, prior to me arriving, is there someone who can assist me getting it straightened out? I spoke to someone in the QB Priority Circle, but I feel like he did his best, but didn't figure out exactly what is going on?! Multiple bank accounts linked together, that don't have anything to do with the accounts in question. 

 

Any advice will be fantastic!! 

Mich_S
QuickBooks Team

Duplicate bank accounts and entries

You've come to the right place for help, @AmyK2775.

 

I'll ensure your bank accounts are set up correctly in QuickBooks Online.

 

I recommend undoing the bank transactions to ensure that the accounts are correctly linked. Then, double-check that it's linked to the correct account assigned through Banking. If this is not the case, you can disconnect the bank account.

 

 

Here's how:

 

  1. Open the Banking menu or Transactions menu. Then go to the Banking tab.
  2. Choose the tile for the bank account.
  3. Click the pencil ✎ icon, then choose Edit account info.
  4. Choose the Disconnect this account on save checkbox.
  5. Hit Save and Close.

 

After that, you can reconnect the appropriate bank account.

 

 

You'll also want to make sure that you only add transactions that aren't already in QuickBooks, and that you match any current transactions in QuickBooks. For your guidance, take a look at this article: Categorize and match online bank transactions in QuickBooks Online.

 

 

I'm also adding this article setting up subaccounts in your online banking: About bank or credit card subaccount setup.

 

 

Keep us updated by replying back to this thread. We are more than happy to help. Take care always!

Need to get in touch?

Contact us