Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello,
I downloaded a whole list of duplicate transaction in one of my bank account and now its showing literally duplicate of 100+ transaction, I feel that being very messy now. Due to the fact that the view/register of the bank doesn't even match what's on the feed is even more off. I was wondering what's the easier way to clean this? I was thinking to delete bank account permanently and readding it as nothing is match/done on that account so no data is necessary needed.
Hi there, @mikelu9661.
Thanks for visiting the Community. Yes, you can delete the connected bank account in QuickBooks. However, this would not resolve the duplicate issues when you reconnect it.
I understand that the duplicates are coming from the list of transactions you've manually added in one of your connected bank account. The easiest way to clean this up is to use the Batch action to exclude and delete the duplicate ones.
Here's how:
This will move all the excluded transactions in the Excluded section. You can now assign, categorize, edit, and add your downloaded banking transactions. It helps you learn about how to add and find a match of the downloaded transaction with the one you already entered in QuickBooks.
Feel free to message again. We're always delighted to be of your service. Stay safe.
Thanks, I didn't know you can exclude then delete from the exclude page, if I decide to a full cleanup of every transaction within that bank account because there's only 100+ duplicate, seems time consuming to examine every transaction of which is duplicate, rather I feel it if I exclude everything then delete, then reimport the wanted transaction date, would that work?
Lastly i notice this page link below states that "excluded transaction are not deletable", but I was able to delete it from the excluded page, not sure if I'm reading it wrong or something is wrong.
Also wanted to add to above comment, if what i mentioned above works, can i also delete everything within bank register charter account then when the manual transaction imports, will it bring it in correctly within the register as well? my goal is to fresh cleanse & reimport transaction of the account correctly
Hi there, @mikelu9661.
Please allow me to join the thread and help share information about the Excluded transaction. When you Exclude or Delete the transaction, it won't track or reported as part of your business finances. Yes, you can delete the duplicate transaction by excluding it. However, if you delete the transaction under the bank register and import them manually, it will go through to your banking page, though you need to add them and it will add in the bank register.
Let me show you how to Add the transaction to your Bank register:
Once done, you can go to the Accounting the Chart of accounts, then choose the specific bank click View register. This will show up all the transaction you've import manually.
I've got an article for more detailed information about deleting or void transaction: Void or delete transactions in QuickBooks Online.
Also for future reference you can check out this article on how to Assign, categorize and edit your downloaded bank transaction: Assign, categorize, edit, and add your downloaded banking transactions.
Please don't hesitate to let me know if you should have any questions about this or anything else QuickBooks related. Have a wonderful day ahead of you!
I feel like this is not the "easiest" way to do this since a person would have to manually do this for hundreds of transactions and is highly prone to human-error.
Isn't there a way to simply say: "Undo my last manual import"? That would be the easiest way.
I've hit a bit of a wall trying to reconcile a certain account, and feel I may have made an error in the beginning balance number I entered at some point during the reconciliation process, resulting in a significant "difference". (That balance is not displayed in the account register.) What are my options? Up to and including deleting and re adding the account to simply start over? I'd like to avoid the labor of that of course but, I'm getting a bit frazzled here...
I'd be happy to assist you with reconciliation, bobbyslam2010.
Let's begin by determining the factors that cause reconciliation discrepancies. Among these are the following:
I suggest reviewing your previous period's reconciliation to determine which of the above mentioned is causing the error.
Here's a guide for instructions on how to fix common issues when reconciling: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.
In addition to that, you visit these links about reconciliation in QBO:
Should you have anything else you'd like to go over while reconciling, feel free to reach out to us again. I'm always here to assist you further.
I figured out how to delete a bank account and start over. If that's the route you want to go down, you can see my other post here.
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