cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
LGKC1
Level 1

Bank Reconciliation for Desktop

How can I fix what appears to be a QB's issue.  My bank statement was reconciled through 5-31-24 and when I went to reconcile June's statement the date listed in the reconciliation window was 3-31-24.  I looked at the prior reconciliation reports and both April 2024 and May 2024 showed as reconciled.  Also, there were years of checks and deposits that were showing up as unreconciled back twelve years.  I called Qb's support and they couldn't help me. When I opened up the bank recon window again it now shows the date last reconciled as 5-31-24 but it has the starting and ending balances from the 3-31-24 statement.

2 Comments 2
LouiseG
QuickBooks Team

Bank Reconciliation for Desktop

I appreciate you for the detailed information, @LGKC1.

 

Let's use the verify and rebuild tools in QuickBooks Desktop to fix a data issue with your company file, causing the behavior where your reconciliation date and balance changed. 

 

The verify tool identifies the most common issues in a company file, and the rebuild tool fixes them. Follow the steps below.

 

  1. Go to Window, then select Close All.
  2. Go to File, then choose Utilities.
  3. Select Verify Data. If you see:
  • QuickBooks detected no problems with your data — your data is secure, so you don't need to do anything else.
  • If you see an error message – you can search on our QBDT support site to learn how to fix it.
  • If your data has lost integrity – damage to your data was found in the file and we have to rebuild your data.

 

Then, here's how to rebuild the data in your company file:

 

  1. Go to File, then select Utilities.
  2. Click on Rebuild Data.
  3. Follow the on-screen instructions, then press OK.
  4. Select the place where you want your backup file to be saved, then tap OK.
  5. Enter a new name in the File name. Click Save.

 

For more details, check out this article: Verify and Rebuild Data in QuickBooks Desktop.

 

Furthermore, I'll include this article for future reference. It discusses common causes of ending balance issues and guides you to identify and fix the discrepancies: Fix issues when you're reconciling in QuickBooks Desktop

 

You're welcome to drop by if you have additional questions about bank reconciliation. Let me know and I'll lend a hand again.

BigRedConsulting
Community Champion

Bank Reconciliation for Desktop

Assuming all of the transactions in the account remain intact, and no new ones were added, and none deleted,

Then if you put in the ending date of the current statement and mark everything up to that point as cleared, then the reconciliation ending balance should match the current statement ending balance, which is all that really matters.

 

What happens if you try that?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us