Question

excluding transations

7 replies
52 views

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?

QuickBooks Online

C

Charies_M

Level 9

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:

Go to Banking menu on the left panel.
Choose Banking tab.
Check the box for beside the transactions you want to exclude.
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:

Sign in to your QuickBooks Online company.
Click the Help icon in the upper right of the screen.
Select Contact US on the pop-up.
Enter what you're needing assistance with in the How can we help? field and choose Continue.
Click Get a callback.
Enter your contact information.
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.

U

utopiansara

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?

A

Anonymous

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

Click the Banking menu from the navigation panel.
Go to the Banking tab, click the account you want to use.
Tap the For Review tab.
Mark the checkbox of the transactions you want to exclude.
From the Batch actions drop-down, choose Exclude Selected.
The items will be moved to the Excluded section.
From the Excluded tab, put a check in the box for the transaction you'd like to permanently delete.
Choose Batch actions, then Delete.
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!

U

utopiansara

Thank you for the reply @196027 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.

J

JanyRoseB

Level 5

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:

Go to Accounting tab on the left panel.
Under Your Company, select Chart of Accounts.
Choose the account you’re working on, and click on View Register.
Select the transactions you want to unreconcile.
Keep on clicking the R status until it shows blank or cleared (C).
Click on Save.
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 @196027.

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO