Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI had to manually reconciled a checking account from the paper statement that has closed, since the bank took down the account on us, so I can't upload the information. I reconciled it, QB's shows zero register balance, but shows a bank balance as the last amount from the last upload. How can I clear that?
Good Evening, @peggy64.
I strive to give the best possible support. I can help with understanding why your "In Quickbooks" balance is different from your "Bank Balance".
These accounts wouldn't be the same amount unless nothing were Added, Matched, or Transferred in the For Review tab. When you select them into the right account, these transactions then reduce the "In Quickbooks" amount and sends them to the Reviewed sections and are then sent to the Bank Register.
Also, I noticed an exclamation mark (!) in the screenshot you sent beside the "In QuickBooks" balance, and that means your bank needs updated, or there's an error that needs fixing. If you could provide me with some information about what the error says when you click on that exclamation mark, I'll be able to give you some additional insight and help fix that for you.
I'm going to attach a link below with some more information about QuickBooks balances as well:
I'll be waiting for your Reply here. Speak to you soon!
Good Morning,
Thank you very much for replying. The error message states that QB's can't find this bank account at your bank. Please reconnect to the bank.
And that is the problem, we can't reconnect to the bank as that account has been closed.
Please let me know if you need any additional information to help me. I appreciate any help.
Thank you again.
And I forgot to mention, the bank paper statement does show a zero balance. And when I reconciled the account, I put the ending balance as zero. and I reconciled to the zero balance account. But the QB Bank balance still shows.
I thank you for the complete details you've provided, @peggy64.
Let's perform the following troubleshooting steps to resolve the prompt you've received.
1. Log in to your bank’s website outside QuickBooks.
2. Review your posted transactions and check for any connectivity error notifications.
3. Once completed, log in to your QuickBooks Online account.
4. Let’s perform a manual update on your connected bank account.
a. Go to the Banking menu.
b. Choose the Banking tab.
c. Select your bank account.
d. Click Update.
e. If prompted, enter your Multi-Factor Authentication (MFA) credentials.
f. Click the Continue update button.
On the other hand, we can perform a single reconcile using the ending balance of your last reconciled bank statement to fix your bank balance. Make sure not to enter any interests or fees before saving the data.
You can check this article for more detailed instructions: Why doesn't my QuickBooks Online beginning balance match my statement?
To learn more about how to review your opening balance in QuickBooks, you can browse these articles:
Keep me posted if you have other questions about the reconciliation workflow in QuickBooks.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.