cancel
Showing results for 
Search instead for 
Did you mean: 
info-themiamigro
Level 1

I uploaded a qbo file to the wrong bank account, categorized some before I realized it was the wrong A/C, then excluded/deleted the rest. How do I fix the bank balance?

 
3 Comments 3
AileneA
QuickBooks Team

I uploaded a qbo file to the wrong bank account, categorized some before I realized it was the wrong A/C, then excluded/deleted the rest. How do I fix the bank balance?

Hello, info-themiamigro. 

 

Thank you for reaching out to the Community. You'll want to undo the transactions and delete them to fix the balance. Also, you can undo the transactions by batch to deleting everything. I'll share with you the steps:

  1. Click Banking, then go to the Banking tab.
  2. Select the bank account.
  3. Go to the Reviewed tab.
  4. Tap the transactions you want to undo, then click Undo.

These transactions will go back to the For Review tab. Just follow the steps on how to exclude and delete them.  

 

Here's how:

  1. Go to the Banking page.
  2. Under the For Review tab, select all transactions.
  3. Click on Batch actions.
  4. Select Exclude Selected.
  5. Go to the Excluded tab.
  6. Select all transactions and click on Batch actions.
  7. Tap Delete.

 

Once done, you can import these transactions using the WebConnect or Excel CSV files to the correct bank account.  

 

Get back to this thread if you have more questions. We're here to fill you in. Stay safe!

info-themiamigro
Level 1

I uploaded a qbo file to the wrong bank account, categorized some before I realized it was the wrong A/C, then excluded/deleted the rest. How do I fix the bank balance?

I had already done those steps, and the Bank Balance is wrong. The Quickbook balance for both the old closed account shows $0, which is correct, and the current Bank Account balance shows the correct QB balance also, but both accounts show the wrong Bank Account balance on the Banking Dashboard. Both bank accounts are reconciled and they match. There must be some transactions that are "hanging" in the background that are still affecting the bank balance totals.

 

This was supposed to be escalated to the next tier of support, but I have not received an update.

 

Please advise.

DivinaMercy_N
Moderator

I uploaded a qbo file to the wrong bank account, categorized some before I realized it was the wrong A/C, then excluded/deleted the rest. How do I fix the bank balance?

Thanks for getting back here, @info-themiamigro. I'd be happy to share additional steps in fixing your bank balance issue in QuickBooks. 

 

Below are several reasons why bank balances in QuickBooks don't match. You may need to check the transactions to fix the balance:

 

  • There are outstanding transactions.
  • New transactions for a connected account.
  • Duplicate transactions.
  • Edited or deleted transactions.
  • Credit card (liability) account.

 

For more information on fixing the bank balance in QuickBooks Online (QBO), please visit this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online

 

You may also want to reach out to our Customer Care team to further help you check what caused the wrong bank balance. They use specific tools to safely look into your account and guide you on the actions you can take. 

 

Just in case you'll want QBO to automatically categorize transactions for you, you can set up bank rules. This will speed up this review process and can even scan the entries and add details.

 

Feel free to get back here if there's anything else you need in fixing your bank balance in QBO. I'm always around to help. Have a good one. 

Need to get in touch?

Contact us