I'm glad you've reached out to us. Let me help guide you on how to get rid the download duplicate bank transaction.
If you have duplicate bank transactions, you can exclude it from the transactions downloaded from your bank or financial institution.
To exclude transactions, here's how:
The excluded transactions are listed on the Excluded tab for reference or review.
For additional reference, you can check this article: Remove duplicate transactions from bank feeds.
You may also visit this article to learn more on how to reconcile your accounts in QuickBooks Online.
This will get you on the right track. Please know that I'm just a post away if you have any other questions about the duplicate transactions or reconciliation in QBO. Wishing you and your business continued success.
Is there an easy way for me to delete (duplicated) transactions that were "Added" via the bank feed in error? I have the honor of cleaning up an account that was mismanaged for a few years. Now I am battling with a balance sheet nightmare because of all the duplication, even though I have now reconciled 2018-2019 (accounts were never reconciled).
Any advice would be amazing, I am terrified that this is going to turn into much more work that the client or I am willing to do.
Hello there, @Kwhitford1007.
I'd be glad to help share a little more information on how to delete duplicate transactions in QuickBooks Online (QBO).
For now, the only option to delete duplicate banking transactions is to exclude them following the steps provided by my colleague JanyRoseB. As mentioned, this transactions are listed on the Excluded tab for reference or review, but aren't tracked or reported as part of your business finances. If you wish to fully delete these transactions, you can select them and click on Delete under Batch actions.
For further details, you may check this article: How to exclude expenses from downloaded bank transactions.
You can also check this article for your future reference about adding and matching downloaded banking transactions: Add and match downloaded banking transactions.
Please stay posted if you have any other questions about deleting duplicate transactions, I'll be always here to help you. Wishing you the best!
It's very easy to exclude the duplicate transactions, BCH1450.
All transactions in the Reconcile page are the transactions that are added on your register from your Banking. It's best to exclude them on the Banking since we're unable to do it when reconciling.
Keep in touch if you need more guidance. I'm looking forward to assisting you again.
I've had this transaction show up on my reconciliation and I leave it alone but I realized I'm always going to be off with my Bank balance vs my QB balance. I can see that the transaction is a duplicate. I have 2 deposits and 2 expenses for the sam amount. The bank feed is attached, hence every time i delete one of them my beginning balance is off by that amount. I'm not sure what to do. (see attached) BTW- when i look at my registered one of the items has an R the other one is blank. Please help.
Hi there, @test32. I appreciate you providing detailed information.
The data marked as R are those reconciled transactions. It means these are part of the QuickBooks reconciliation process.
Deleting previously reconciled transactions can throw off your beginning balance. Thus, this is the reason why your beginning balance changes.
To delete duplicates showing on your register, make sure to exclude the one without the R status. Since these transactions aren't reconciled, deleting them won't change the reconciled balance.
For more information on Reconciling accounts, take a look at this article: Reconcile an account in QuickBooks Online.
If there's anything else you need or if you have additional questions in managing your transactions, just drop a comment below. I'll be around to help you more. Take care.
Thanks! I deleted the one without the R and it did change my reconciliation by that amount. I excluded but when i realized I threw my reconciliation off I added again. I'm not sure what else to do. If i look at both of the transactions they both have the bank feed attached. Any other suggestions?
You're most welcome, @test32.
I can provide other steps and info to ensure you can get rid of this balance discrepancies.
First, please check if the transactions from your actual bank statement (Bank Balance) match with that in QuickBooks (QuickBooks Balance). This is because manually entering some entries can cause balance discrepancies.
Also, make sure to categorize all transactions correctly before adding them to prevent issues like this.
For this one, I recommend consulting an accountant for further assistance. This way, you won't mess up your valuable transactions.
When you're ready, you can begin reconciling your account to ensure your books are correct. Then, you can pull up a reconciliation report to check and fix possible discrepancies, and print or export it to save a copy for future use. For more info, please check out this article: How do I view, print, or export a reconciliation report?
I'm always around to help if you have more questions about managing your banking in QBO. Just add your reply in the comment section so I can assist you right away. Take care.
Thanks! I found a transaction that appears as unreconciled i can see it was a bill payment that has a payment attached but this is an error, because this was never paid since it's a duplicate. Can i delete it or will it throw my reconciliation off? When i see the reconciliation report it appears in the column of not cleared.
Thanks for getting back here, test32.
When you're sure that the transaction is a duplicate and not reconciled, you can delete it. This process won't affect your reconciliation reports. You can also consult with your accountant to make sure your data is accurate.
To delete, here's how:
Once done, try to reconcile the account. You can see a video tutorial on how to reconcile an account in this article: Reconcile an account in QuickBooks Online.
Please feel free to add a reply on this thread if you need more assistance with reconciling your account. I'm always here to help.