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.
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.
In the Banking page, select the bank account that has duplicate transactions.
In the For Review section, look for duplicates and ensure to check the box for the transactions you want to exclude.
In the Batch actions drop-down list, select Exclude Selected.
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
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:
Click Banking then select the transaction you've import.
Under Action tap Add.
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.