Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
I
itzel1
February 28, 2019
Question

excluding transations

  • February 28, 2019
  • 2 replies
  • 0 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?

2 replies

C
Charies_M
Level 9
February 28, 2019

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.

P
PACMAN1
November 18, 2020

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?

J
JamesDuanTQuickBooks Team
QuickBooks Team
November 18, 2020

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.

A
Anonymous
April 19, 2019

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!

    U
    utopiansara
    April 23, 2019

    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
    April 23, 2019

    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 @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. 

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement