cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Explorer *

Bank Reconciliation Nightmare

Last month my ending balance/cleared transactions matched the bank statement perfectly, which in turn SHOULD have been my new beginning balance for this month's bank rec..  When I started my bank rec. today, the beg balance was off by thousands.  I have not deleted, edited, etc. anything that affects the bank recs.  This happened 2 months ago and I had to undo 3 months of bank recs. to resolve it.  Anyone know why this might be happening?  Is there a way to begin this months bank rec without having to undo months worth of statements?  Thank you!

Solved
Best answer 05-10-2019

Accepted Solutions
QuickBooks Team

Re: Bank Reconciliation Nightmare

Hello there, mermaidgurl. 

 

I can see that after performing the troubleshooting steps and recreated the deleted check, you still get the same thing. I would suggest reaching out to our Customer Support Team so they can walk you through how to fix this. They can also screen share with you so they can further investigate. 

 

Here's how: 

  1. From the Help menu, select QuickBooks Desktop Help
  2. Click Contact us at the bottom. 
  3. Enter a brief description about reconciliation discrepancy. 
  4. Then, Continue
  5. You have two ways to connect with us, it could be through Chat or Call

 The Community team is always around if you need further help!

3 Comments
QuickBooks Team

Re: Bank Reconciliation Nightmare

Welcome to the Intuit Community, mermaidgurl.


I appreciate the in-depth information you shared in your post. This will help us narrow things down.


Let's perform the basic data troubleshooting steps to resolve the reconciliation issue.


To start off, run the rebuild tool after creating a backup of the company file to resolve data integrity issues. Here's how:

 

  1. In your company file, go to the File menu at the top menu bar.
  2. Choose Utilities, then select Rebuild Data.
  3. In the QuickBooks Desktop Information pop-up, click on OK.
  4. Create a backup copy of the company file.
  5. Click on OK when the rebuild has completed.

The next thing to do is run the verify data utility. This process identifies the most common occurring data issues.


To run the tool:

 

  1. Go back to the File menu, then choose the Utilities option.
  2. Select Verify Data.
  3. If you see this message “QuickBooks detected no problem with your data”, click on OK.
  4. If the tool finds an issue with the data, you’ll see the following prompts: Rebuild Now or View Errors.
  5. Choose Close.

Then, continue with performing the steps in this article and proceed directly to the Review Last Verify/Rebuild section.


Once done, go back to the Reconciliation page and check the information. If you get the same result, I recommend following the resolution steps in the Zero or incorrect Beginning Balance in the Begin Reconciliation Window article.


This should fix the reconciliation issue. Keep me posted on the results after following the steps. I want to ensure this is taken care of. 

Super Explorer *

Re: Bank Reconciliation Nightmare

Thank you! I figured out what it was. It was a check that was deleted.  I tried to re-enter it for the day it was originally written and check it for reconciliation but it didn't fix my beginning balance.  What am i doing wrong?

QuickBooks Team

Re: Bank Reconciliation Nightmare

Hello there, mermaidgurl. 

 

I can see that after performing the troubleshooting steps and recreated the deleted check, you still get the same thing. I would suggest reaching out to our Customer Support Team so they can walk you through how to fix this. They can also screen share with you so they can further investigate. 

 

Here's how: 

  1. From the Help menu, select QuickBooks Desktop Help
  2. Click Contact us at the bottom. 
  3. Enter a brief description about reconciliation discrepancy. 
  4. Then, Continue
  5. You have two ways to connect with us, it could be through Chat or Call

 The Community team is always around if you need further help!