cancel
Showing results for 
Search instead for 
Did you mean: 
mikelu9661
Level 3

Can I delete and readd a bank account in QBO

Hello,

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.

9 Comments 9
katherinejoyceO
QuickBooks Team

Can I delete and readd a bank account in QBO

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: 

 

  1. In the Banking pageselect the bank account that has duplicate transactions. 
  2. In the For Review section, look for duplicates and ensure to check the box for the transactions you want to exclude.
  3. In the Batch actions drop-down list, select Exclude Selected

 

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. 

 

 

mikelu9661
Level 3

Can I delete and readd a bank account in QBO

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.

 

https://quickbooks.intuit.com/learn-support/en-us/bank-transactions/exclude-or-delete-transactions/0...

mikelu9661
Level 3

Can I delete and readd a bank account in QBO

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

AileneA
QuickBooks Team

Can I delete and readd a bank account in QBO

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: 

 

  1. Click Banking then select the transaction you've import. 
  2. Under Action tap Add

bank100.PNG

 

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!

jaradc
Level 3

Can I delete and readd a bank account in QBO

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.

Fiat Lux - ASIA
Level 15

Can I delete and readd a bank account in QBO

@jaradc 

Another option, utilize a deleter tool.

https://transactionpro.grsm.io/qbo

 

bobbyslam2010
Level 1

Can I delete and readd a bank account in QBO

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...

Charies_M
Moderator

Can I delete and readd a bank account in QBO

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:

  • Duplicate transactions.
  • The transaction was associated with a different bank account.
  • Previously reconciled transactions were modified or deleted.
  • Incorrect opening balance or account.

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.

jaradc
Level 3

Can I delete and readd a bank account in QBO

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.

Need to get in touch?

Contact us