Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
Y
yatpui
September 23, 2021
Question

Remove duplicate transactions

  • September 23, 2021
  • 3 replies
  • 1 view
quickbooks erroneously creates 5 or more duplicate transactions, how to fix this bug?

3 replies

Angelyn_T
Angelyn_TModerator
Moderator
September 23, 2021

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!

U
User120
September 27, 2021

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.

Fiat Lux - ASIA
Fiat Lux - ASIA
Level 14
September 23, 2021

@yatpui 

Another option, utilize a deleter tool

https://transactionpro.grsm.io/qbo

 

M
MMB2023
October 12, 2023

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!

Q
QueenCModerator
Moderator
October 12, 2023

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. 

M
MMB2023
October 13, 2023

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement