Bank Reconcilation

Hi Bsroi....   Not sure I'm following.

Is the "0" you are seeing in the Reconcile window in the lower right?  If it is, then that is a good thing because you have balanced/reconciled.

The 0 is telling you that when QBs compares your Beginning Balance, the new Ending Balance and all the payments and deposits you checked off, you balance.

If you UNcheck one of your Deposits (e.g. 1,000.00) you'll see the 0 change by the amount you unchecked.  So if you had  really gone through the process and saw a -1,000, then that would mean you made a $1,000 deposit in your records, but the bank doesn't show it.  (Or often that you checked something by mistake that did or didn't really clear.)

And if you did not notice it, there is a little check box at the top of the window where you mark off the transactions called Hide transactions after the statement's end date.  So if you're a week or two into February and Reconciling January, checking that box will hide all the Feb. entries.

Hello there, Bsroi.

I want your issue about bank reconciliation gets taken care of.

Let's try to check if there are any missing or modified transactions that is causing this reconciliation discrepancy. 

To help us identify the discrepancies, we can run the Reconciliation Discrepancy Report. This report shows transactions sorted by statement date that were changed since the last reconciliation.

1. Go to the Reports menu.
2. Select Banking.
3. Click Reconciliation Discrepancy.
4. Choose the appropriate account, then select OK.
5. Review the report to identify any discrepancies.

If you see duplicate transactions, you can delete or void it. For missing transactions, you can manually enter it in QuickBooks.

To learn more about the different ways of fixing Reconciliation discrepancies, you can check out this article: Fix Reconciliation Discrepancies.

And just in case you need help from a live support, feel free to get in touch with our Desktop Care Support Team. Here's how to get their contact information: 

1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
2. Choose your QuickBooks Product.
3. Select your QuickBooks Version.
4. On the Contact Us page, click a topic.
5. Click on the Get Phone Number button to see the support number.

I'm still here if you have additional questions and you're more than welcome to leave a reply for anything you need.

Thanks for the prompt response, @Bsroi.

I’d like to ask more details such as screenshots on the reconciliation screen where you can find the big difference on your ending and cleared balance. 

The report suggested by my colleague should be able to find any discrepancies on the account you’re trying to reconcile. 

In the meantime, we’ll also try performing the Verify and Rebuild Utility Tool to make sure there are no data damages to your company file. Here’s how:

Rebuild Data:
1.    Go to the File menu.
2.    Choose Utilities, then select Rebuild Data.
3.    Select OK on the QuickBooks Information window.
4.    Follow the prompt to save a backup.
5.    When you see Rebuild has completed, click OK.

Verify Data:
1.    Go to the File menu.
2.    Choose Utilities, then select Verify Data.
3.    If you see QuickBooks detected no problem with your data, click OK. You can continue using the company file.
4.    If Verify finds an issue with your data, you’ll be prompted to Rebuild Now or View Errors.
5.    Select Close.

For more information about resolving data damage, take a look at this article: https://quickbooks.intuit.com/community/Reports-and-accounting/Resolve-data-damage-on-your-company-file/m-p/201602.

Give this a try and let me know what the results are. Please leave a reply below with the screenshot and we’ll take it from there. Thanks for reaching out. I’ll be on a look out for your response. Take care!