Skip to main content
February 5, 2024
Question

Excluding vs deleting unmatched bank feed transactions

  • February 5, 2024
  • 1 reply
  • 0 views

Greetings, hoping I can get some guidance about best practices for this project we need to take on.

 

We converted to QBO from Desktop last year, and never started using the bank feed to match transactions, so transactions for five months have accumulated and it's not feasible to tackle now.

 

We want to start fresh and decided to utilize the match feature as of January 1, and either exclude or delete all the bank feed transactions up until 12/31.

 

What I would appreciate knowing is:

  • If I deleted the unwanted bank feed items, will QBO continually try to re-download those transactions that I never categorized and matched?
  • Is it better to leave those transactions in excluded if that means QBO won't continually try to re-download these transactions that I'd like to get rid of?

 

Thank you!

SB

1 reply

February 6, 2024

Thanks for checking in with us, SurlyBird.

 

If you need to exclude and then delete the downloaded bank transactions, it will not go back to the Banking page where you can categorize or match them. On your next question, yes you can leave those transactions in the Excluded tab if you want to see those records. If not, then you can delete them after you exclude the transactions.

 

If the downloaded transaction is a personal expense, we recommend adding it to QuickBooks, rather than excluding it. Otherwise, your bank account in QuickBooks won’t match your bank statement when you reconcile it. To avoid recording the transaction as a business expense, many business owners add the transaction to an equity account they’ve created, called an owner’s draw.

 

As always, check with your accountant or bookkeeper if you’re not sure how to handle a personal expense or any other type of transaction. Here's how to exclude bank transactions: 

 

  1. Go to Transactions, then select Bank transactions (Take me there).
  2. Choose the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Press Exclude.

 

The transaction moves to the Excluded tab of the Banking page. If you accidentally exclude the wrong transaction, just go to the Excluded tab and select the checkbox for the transaction. Once done, select Undo and the transaction goes back to the For Review tab so you can decide what to do with it again. To learn more about this one, check out this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Moreover, I'm adding this article that tackles reconciliation to ensure your account is balanced and accurate: Reconcile an account in QuickBooks Online.

 

I've got your back if you have more questions about managing your banking transactions. Just leave a comment below and I'll be back. 

SurlyBirdAuthor
February 6, 2024

Thank you, RCV, for your thorough and helpful response! I think this is the assurance I needed.

 

Thanks again,

SB

February 6, 2024

Hello there.


We're glad to know that the issue has been resolved for you. If you require further assistance working on specific tasks in QuickBooks, the Community is willing to assist you at any time. Have a great day ahead!