cancel
Showing results for 
Search instead for 
Did you mean: 
itzel1
Level 1

excluding transations

I want to exclude a transaction from the downloaded transaction bank accounts. i've read that you can choose the exclude button for this but i only have the add option. how can i include the exclude transaction option?

7 Comments 7
Charies_M
Moderator

excluding transations

Hello there, itzel1.

 

Thanks for reaching out to us. I'd be glad to help you locate the exclude button in QuickBooks Online (QBO).

 

The Exclude Selected option can be found under Batch actions from you Banking tab. Let me share the steps on how to do it below:

  1. Go to Banking menu on the left panel.
  2. Choose Banking tab.
  3. Check the box for beside the transactions you want to exclude.
  4. Click the Batch actions drop-down and choose Exclude Selected.

 

You may want to visit this video tutorial to learn more about excluding transactions in QBO: https://www.youtube.com/watch?v=xiiaz0qLEBo

 

Just in case you want additional help from our live support, here's how you can reach them:

  1. Sign in to your QuickBooks Online company.
  2. Click the Help icon in the upper right of the screen.
  3. Select Contact US on the pop-up. 
  4. Enter what you're needing assistance with in the How can we help? field and choose Continue
  5. Click Get a callback.
  6. Enter your contact information.
  7. Select Call me.

There you have it. Drop me a reply if you have any follow-up questions about excluding transactions. I'm always happy to help.

utopiansara
Level 1

excluding transations

I've excluded some transactions but they are still showing on my profit and loss report. I was under the impression that excluded transactions were in fact excluded and thus would not show on any reports. Is this not the case?

Anonymous
Not applicable

excluding transations

It's nice to see you here, @utopiansara,

 

Thanks for visiting our forum and joining the discussion. I can add additional information about excluding transactions in QuickBooks,


You're already on the right track with excluding the transactions, you only need a few more steps to entirely remove them to your books. Here are the steps to get these items permanently remove

  1. Click the Banking menu from the navigation panel.
  2. Go to the Banking tab, click the account you want to use.
  3. Tap the For Review tab.
  4. Mark the checkbox of the transactions you want to exclude.
  5. From the Batch actions drop-down, choose Exclude Selected.
  6. The items will be moved to the Excluded section.
  7. From the Excluded tab, put a check in the box for the transaction you'd like to permanently delete.
  8. Choose Batch actions, then Delete.
  9. You'll be asked if you're sure. Click Yes to confirm.

Once done, these items are no longer reported as part of your business finances and will not appear in any associated account registers or reports.

 

I've got a great article for you that provides additional details on excluding transactions. You can view it by clicking this link: How to exclude expenses from downloaded bank transactions?

 

That should get your work done in QuickBooks, @utopiansara. Please let me know if you have anymore questions with your online banking transactions in QuickBooks. I'm just post away if you need a helping hand. All the best!

utopiansara
Level 1

excluding transations

Thank you for the reply @Anonymous  I wasn't expecting to hear back from anyone. I followed the steps you provided but it is still not adjusting on my P&L report. A few items to notes on these transactions to maybe see if I'm doing something wrong an also to prevent myself from making it worse:

1. These transactions I'm trying to remove have all been reconciled so I know it will be throwing off my balance when I go to reconcile next.

2. I'm trying to correct a huge mess from when I linked the Square app for reporting. It began duplicating the transaction because the bank and also Square were both reporting the transactions-albeit Square was breaking out the fees into their own expense category which was great. I'm trying to remove the duplicate reported transactions from the bank.  

3. The correct amount for my total Square net is showing up in the "not specified" category. I eventually want to go and categorize these to the right Class once I am able to remove the duplicate ones. 

 

This is a mess. I called and talked to the QB help line but they were not helpful and said I'd have to call Square. So I am trying this work around with excluding/deleting the transactions. But then it will impact my reconciliations. I appreciate any assistance on this complicated (to me) issue. 

JanyRoseB
QuickBooks Team

excluding transations

Thanks for getting back to the QuickBooks Community, utopiansara.

 

Allow me to step in and help provide some additional information about excluding bank transactions in QuickBooks Online (QBO). 

 

I appreciate you for following the steps provided by my colleague which excluding the transactions to remove them to your books. Since the transactions are already reconciled, you have an option to manually unreconciled each transaction to undo the reconciliation. 

 

Let me walk you through the steps: 

  1. Go to Accounting tab on the left panel.
  2. Under Your Company, select Chart of Accounts.
  3. Choose the account you’re working on, and click on View Register.
  4. Select the transactions you want to unreconcile.
  5. Keep on clicking the R status until it shows blank or cleared (C).
  6. Click on Save.
  7. Choose Yes in the confirmation window.

For additional reference, you can check this article to learn more about unreconciling transactions. I also recommend consulting with your accountant before performing any of the steps to ensure your books are accurate. 

 

Once done, you can now exclude the transactions again to ensure it will remove entirely from your books by following the steps provided by @Anonymous.

 

With regards to the duplicate transactions and the categorization of your account from the Square, since this is a third-party application, I encourage you to contact the Square App Support Team. They have the tools to pull up your account and assists you further. 

 

This will get you on the right track. Please know that you're always welcome to post if you have any other questions about the bank transactions. Wishing you and your business continued success. 

PACMAN1
Level 1

excluding transations

Good day,

 

If you exclude the items they will not make the books match in quickbooks and I will be off and not zeroed out. I was told to not to exclude or delete items in QB other wise my books will be a mess. Is this true?

JamesDuanT
Moderator

excluding transations

That is not entirely true, PACMAN1.

 

When QuickBooks Online downloads your bank transactions, we don't have a control of what are being downloaded. There are times that the system can download duplicate or personal transactions associated to the account.

 

We exclude transactions that are duplicates or unnecessary to avoid them from being added to your QuickBooks register. They might cause the balances to be incorrect. You can use this link to know more about the Exclude option in QuickBooks Online: Exclude a bank transaction from your expenses in QuickBooks Online.

 

If you have accidentally excluded transactions that are part of your bank statement, you can still go back and undo it.

  1. From the Banking page, go to the Excluded section.
  2. Select the transactions you want to undo.
  3. Select Undo.

The transactions will go back to the For Review section. From there, you can already categorize the bank transactions.

 

After that, you can start reconciling the account. You can use this link for reference: Reconcile an account in QuickBooks Online.

 

Note: Just refresh the page if you're unable to view the articles associated to my response.

 

Let us know how this goes so we can help you review your transactions and make sure everything is fine.

Need to get in touch?

Contact us