cancel
Showing results for 
Search instead for 
Did you mean: 
yatpui
Level 2

Remove duplicate transactions

quickbooks erroneously creates 5 or more duplicate transactions, how to fix this bug?
8 Comments 8
Angelyn_T
QuickBooks Team

Remove duplicate transactions

Hi there, @yatpui. I'm here to help you with removing the duplicate transactions recorded in QuickBooks Online (QBO).

 

There are no ongoing issues about users getting duplicate transactions in QBO. To isolate the issue, you can remove the double entries by deleting them manually.

 

Here's how:

 

  1. Open the transaction.
  2. Go to the More tab, then select Delete.
  3. Hit Yes to confirm the action.
  4. Repeat the steps for other transactions.

 

Once done, I recommend signing in to QuickBooks using a private browser. It's the best place to check browser-related issues while working with your account. From there, try to create a dummy transaction and see if a duplicate record is created. 

 

You can use either of these keyboard shortcuts to save you time:

 

  • Google Chrome: Ctrl Shift N
  • Safari 11 or newer: ⌘ Shift N
  • Mozilla Firefox: Ctrl Shift P
  • Microsoft Edge: Ctrl Shift P

 

If it works fine, I recommend going back to your original browser and clear its cache to start fresh. You can also use another supported and up-to-date browser to narrow down the result.

 

If you have downloaded banking transactions, please make sure to categorize them accordingly to avoid identical records.

 

Please let me know if you have any other follow-up questions about your transactions. I'm more than happy to help. Wishing you a good one!

Fiat Lux - ASIA
Level 15

Remove duplicate transactions

@yatpui 

Another option, utilize a deleter tool

https://transactionpro.grsm.io/qbo

 

User120
Level 1

Remove duplicate transactions

Just as an FYI, I also experienced this issue today in QuickBooks Desktop Pro 2019. I downloaded a handful of bank transactions and posted them as usual, and one of them posted five times. This hasn't ever happened before. Only one instance of the transaction appeared in the Bank Feeds Center. It's possible that this was an issue with the bank (Chase) as I was having issues on their website initiating the download.

Perfalum520
Level 1

Remove duplicate transactions

Hi I did this and now it shows open balance for that vendor.

MMB2023
Level 1

Remove duplicate transactions

I have a question as I'm new to QBO.

We have our bank accounts linked to QBO. We consistently have duplicate transactions that are related to bank transfers. We move funds between checking and savings accounts. When the transactions is visible in QBO, I would record it as always. During reconciliation process I basically see an automatic transfer and a manual transfer (that's the best I can describe it). I'm not sure where its coming from.

Also, during reconciliation process I can select the amounts and the reconciliation will tie to the statements, but that does not adjust the GL. All other transactions are still on there.

Do I just go in and simply delete all those? If yes, is there a quick way to do it, vs going one by one?

Thanks!

QueenC
Moderator

Remove duplicate transactions

Hello there, @MMB2023. I know a way we can perform to prevent duplicates of your bank transfers in QuickBooks Online. 

 

Since your banks are linked with QuickBooks Online, it's recommended to match the transfer in your imported bank transactions after you've downloaded them. 

 

I can see that you're consistently recording them but I'd still like to include the steps for your guidance:

 

  1. Go to the Banking menu then select Banking.
  2. Select the tile for the account where the transfer funds are coming from.
  3. Find and click the transaction to open it.
  4. Choose Record as transfer then select the account where you transferred the funds in the Transferred to dropdown ▼.
  5. Select Record transfer.

 

After which, we can then match the transaction from the other account:

 

  1. Select the bank account where the transfers are going.
  2. Go to the For review tab then select the Recognized from the dropdown beside the Date filter.
  3. Locate the transaction and hit Match from the Action column so the transactions will match for both accounts.

 

For more information about the process, check out this article: Transfer funds between accounts in QuickBooks Online. You can also exclude the duplicates that are sitting on your banking page.

 

Let me also share these articles that can serve as additional guides when reconciling your bank:

 

 

I'll jump right back if you have follow-up questions. Other members of the forum and the QuickBooks Team is always here to help. 

MMB2023
Level 1

Remove duplicate transactions

Thank you for the answer! What do I do about all the duplicates already out there. It looks like, before my arrival, there was a JE done to reverse duplicates. 

Would it not be better to simply delete all the duplicates? Can I simply go in and delete all the duplicates that have occured this year? 

If yes, do I need to go to the ledger and do one by one or is there a quicker way?

Thanks!

JamesAndrewM
QuickBooks Team

Remove duplicate transactions

I'll share information that could help you clear this duplicate transaction.

 

You can exclude these transactions if they are on the banking page. You may follow these steps:

 

  1. Go to the For Review tab.
  2. Select the checkbox for each transaction you want to exclude.
  3. Click Exclude.

 

Please refer to this article for detailed information: Categorize online bank transactions in QuickBooks Online.

 

On the other hand, if the transactions are already in QuickBooks, I recommend consulting your accountant to explore the possibility of deleting them. It is because there is a JE to reverse duplicate transactions. However, the option batch delete transactions in QBO is currently unavailable. You can only manually delete them.

 

You may visit these links to guide you on how to reconcile your account flawlessly: Reconcile an account in QuickBooks Online.

 

The Community always welcomes you for further inquiries about transactions. Have a great day ahead!

Need to get in touch?

Contact us