Skip to main content
G
GraceH
May 5, 2021
Solved

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

  • May 5, 2021
  • 1 reply
  • 0 views

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. 

Best answer by LauraAB

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.

  1. In the Accounting section, click the small gear icon above the Action column.
  2. Check off Include inactive.
  3. Find the inactive account in the list of accounts.
  4. 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!

1 reply

L
LauraAB
May 5, 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.

  1. Click Accounting from the left menu.
  2. Select Account history for the chart of accounts entry that was connected to the banking feed.
  3. Click one of the transactions you'd like to delete.
  4. Select Delete.
  5. Click Yes on the warning message that comes up.
  6. 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.

G
GraceHAuthor
May 5, 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?

L
LauraABAnswer
May 5, 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.

  1. In the Accounting section, click the small gear icon above the Action column.
  2. Check off Include inactive.
  3. Find the inactive account in the list of accounts.
  4. 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!

    Terms & ConditionsAccessibility statement