Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Working on a cleanup project for a client. They set up a bank feed for a credit card (CC#1) and loaded FY2023 transactions for the entire year. Then they disconnected the feed and connected it to another credit card account (CC#2), again loading the entire year. So we're sitting on $122K of duplicated transactions.
What I want to do is set CC#1 as inactive and delete all 2023 transactions. I've already done the due diligence of confirming everything in CC#1 is a duplicate from Jan 1 2023 forward. Is there a straightforward way to delete these 500+ transaction lines as a group, not one by one?
Solved! Go to Solution.
Let me provide an additional step on how to remove transactions that have been categorized in QuickBooks Online (QBO), @Swordbooks.
In QBO, we first need to undo the categorized transactions before you can exclude or delete them.
To undo the duplicate transactions, follow the steps below:
Once you Undo the transactions, they'll move back to the For review tab. Then, follow the steps provided by my colleague on how to exclude or delete them.
Check out this article for future reference to help you with your reconciliation process: Reconcile an account in QuickBooks Online.
If you have additional concern or queries about online banking transactions, let me know by replying to this thread. I'll be there to help.
Thank you for connecting with the QuickBooks Community, Swordbooks. Currently, the option to do a batch delete is only available for bank feed transactions that have yet to be added to QuickBooks. Let me guide you on how to delete online banking transactions:
If you need more, feel free to use this link, which provides third-party apps that integrate with QuickBooks and are associated with bulk transactions. Please update me if you need further assistance with QuickBooks. I'm here to help.
Thanks for the response @SashaMC . As you said that solution works if the transactions haven't been added to the register. Unfortunately the client had categorized all the transactions, including the duplicates. I went through the process of deleting each of the 500+ duplicates one by one.
The client has multiple credit cards and experienced a staffing turnover, so I can guess how this could have happened. But I want to believe that a digital program like QBO should have a better option to clean up an error of this size, especially for the accountant platform. I could have zeroed out the duplicate credit card balance by journal entry, but the vendor activity would reflect inaccurately if I did.
I agree with you @Swordbooks , this is a woeful oversight. I had an issue with a set of books where prior bookkeepers relied way too heavily on automatic rules to book transactions. There should be ways to do bulk corrections on transactions that have already been added to registers--or if nothing else, a way to UN-add them to registers so they can be placed back in the queue for handling.
When QuickBooks makes it so easy for users to create problems like this, it should make it equally easy for administrators to fix them.
Thanks @alex_nj. Glad to know it's not just me. I do rely on the Reclass feature to do batch corrections and it feels something similar could be developed for changes within the bank register.
Let me provide an additional step on how to remove transactions that have been categorized in QuickBooks Online (QBO), @Swordbooks.
In QBO, we first need to undo the categorized transactions before you can exclude or delete them.
To undo the duplicate transactions, follow the steps below:
Once you Undo the transactions, they'll move back to the For review tab. Then, follow the steps provided by my colleague on how to exclude or delete them.
Check out this article for future reference to help you with your reconciliation process: Reconcile an account in QuickBooks Online.
If you have additional concern or queries about online banking transactions, let me know by replying to this thread. I'll be there to help.
@LouiseG That is exactly what I was wanting to do. Thank for you for this!
You're welcome, @Swordbooks.
We're glad to know that the information provided by my colleague helped you with your concern. Please know that assisting and providing resolution for our valued customers is our top priority.
If you have any questions about managing your bank accounts in your QuickBooks, you can always drop by and post your concerns. We'll make sure to address that as soon as we can.
Take care and have a good one!
@LouiseGThis is great, but is there a way to do this in QuickBooks Desktop?
Thank you for reaching out to the QuickBooks Community, @alex_nj.
Yes, there's also a similar process for excluding or deleting bank transactions in QuickBooks Desktop. Let me share more details about it.
The duplicate transactions can be undone by following the steps below:
For more details, I have added these articles:
If you still have other questions regards the credit card feed linked to two accounts in the QuickBooks Desktop account. Just feel free to comment down below. I will be glad to answer you.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here