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?
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:
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:
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?
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
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!
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:
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.
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.
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.