How to delete or exclude a transaction from an old bank account that is no longer connected on Quickbooks online

GraceH · ‎May 05, 2021

I am trying to delete or exclude three transactions from an old disconnected bank account that are messing up my profit and loss as expenses. I can only find 'categorize expense" in my batch actions. I'm on Quickbooks online. I do not want to have to relink that bank account to take the action.

LauraAB · ‎May 05, 2021

Hi again, GraceH.

I appreciate those additional details as they help shed light on what's going on. Since you mentioned that you're getting a prompt about the transaction being linked to an inactive account, the first thing you'll want to do is make sure the account is active in the chart of accounts. When I mentioned going to the account in the chart of accounts, I meant the bank account—the one that was originally connected to the link in the bank feed. It sounds like you've made it inactive, but don't worry, you can bring it back.

In the Accounting section, click the small gear icon above the Action column.
Check off Include inactive.
Find the inactive account in the list of accounts.
Click Make active.

Once it's active, you should then see the Account history option for that bank account and can handle the transactions through there, or you can navigate back to the expense transactions to delete them there. Afterward, you can make the account inactive again in the chart of accounts. If you're still in the account register, select Back to Chart of Accounts first. Once you're back in the chart of accounts, select the down arrow in the Action column, then Make inactive.

Let me know how it goes!

View solution in original post

LauraAB · ‎May 05, 2021

Hi there GraceH,

Making sure that there aren't any stray transactions throwing off your reporting, and I'm glad to see you're narrowed it down to these ones. I can help you make sure that you're able to get rid of these three transactions in QuickBooks Online so your books can become balanced once again.

When you disconnect an account from the banking feed, it's still possible to manage the transactions added or matched from it since the account still exists without the connection in the chart of accounts. From what you describe, it sounds like you're working in the Expenses section, but you can also manage these transactions from the chart of accounts as well.

In both cases, there isn't a batch delete option, and it means selecting and going through them one by one to delete the transaction. This article goes over how to do it through the Expenses tab: Void or delete transactions in QuickBooks Online

If you'd like to take care of them from the chart of accounts, here are those steps.

Click Accounting from the left menu.
Select Account history for the chart of accounts entry that was connected to the banking feed.
Click one of the transactions you'd like to delete.
Select Delete.
Click Yes on the warning message that comes up.
Repeat this for all the transactions you'd like to delete.

I know how having a batch option to handle transactions would be handy, and I encourage you to submit feedback about this to our product development team using these steps: How do I submit feedback? Your feedback helps our team see how they can enhance the program and overall user experience so that QuickBooks Online can continue to grow.

I'll be here if you have other questions about the processes or options I've mentioned. Don't hesitate to reply to this thread.

GraceH · ‎May 05, 2021

Thank you so much for your response. I tried going through the expenses as lined out in the link you sent me, but it says that the transaction is linked to an inactive account, and will not proceed. It's highlighted red.

I am attempting going through the Chart of accounts. I can't find a way to select the transaction, just run a report for the category it's in. Is there some step I'm missing?

LauraAB · ‎May 05, 2021

Hi again, GraceH.

I appreciate those additional details as they help shed light on what's going on. Since you mentioned that you're getting a prompt about the transaction being linked to an inactive account, the first thing you'll want to do is make sure the account is active in the chart of accounts. When I mentioned going to the account in the chart of accounts, I meant the bank account—the one that was originally connected to the link in the bank feed. It sounds like you've made it inactive, but don't worry, you can bring it back.

In the Accounting section, click the small gear icon above the Action column.
Check off Include inactive.
Find the inactive account in the list of accounts.
Click Make active.

Once it's active, you should then see the Account history option for that bank account and can handle the transactions through there, or you can navigate back to the expense transactions to delete them there. Afterward, you can make the account inactive again in the chart of accounts. If you're still in the account register, select Back to Chart of Accounts first. Once you're back in the chart of accounts, select the down arrow in the Action column, then Make inactive.

Let me know how it goes!

GraceH · ‎May 05, 2021

You are the best!!!! Totally solved my problem. Thank you very much!!!!

LauraAB · ‎May 05, 2021

You're very welcome! I'm thrilled that my steps helped you get the job done. I hope you now have time to enjoy the rest of your day. :)

GraceH · ‎May 05, 2021

I am thrilled as well. It definitely will help me enjoy the rest of my day! I hope you enjoy yours.

Clanart70 · ‎August 27, 2023

Hello, I'm trying delete an old bank account (not connected) with a QB balance on it. However, I keep getting the following error message. "This account can't be deleted because it has a non-zero balance" I don't have the Account History option under the Action column so I'm confused how I can put the balance to Zero. Thx for you help//C

JamesM4 · ‎August 28, 2023

Hello Clanart70. Thanks for chiming in on this thread. I'd like to help make sure you get the resolution you need so you can delete the bank account in question. Based on what you're experiencing, I recommend clearing cache and cookies on your browser. Clearing cache and cookies helps with fixing most browser issues. You can do this by following the steps in this article: Clear Cache and Cookies. If you're still having issues after verifying the info above, I recommend contacting our support team so they can take a closer look at the issue. You can contact our support team using the details below:

Phone: Call us at 1-855-253-1536 from Monday to Friday between the hours of 9 AM and 8 PM EST.
Schedule a Callback or start a Chat: click (?)Help in the upper right > type and enter "Contact support" into the QB Assistant > click Contact Us > explain your situation > click Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook, Twitter, and Instagram.

If you have any other questions, feel free to reach out here. I've got your back.

Topics

Training

Community

Resources

How to delete or exclude a transaction from an old bank account that is no longer connected on Quickbooks online