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.

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?

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. 

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. 

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?

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.