cancel
Showing results for 
Search instead for 
Did you mean: 
LuckyLady2
Level 1

Bank statement beginning balance does not equal previous month's ending balance.

I just acquired a new account who has been in business since 2014.  Previous bookkeeper did not reconcile any bank statements for 2021.  I am working on this now.  My problem is that the Jan. 2021 beginning balance does not equal the checkbook register and all previous years have been reconciled.  How do I correct this or find out what the problem is??

Solved
Best answer January 17, 2022

Best Answers
Pete_Mc
Community Champion

Bank statement beginning balance does not equal previous month's ending balance.

That's a tough one to figure out.  Some of the big "gotchas" are:

- Previously Reconciled transaction was deleted

- Previously Reconciled transaction was changed

- Big possibility that in Dec. 2021 they made an entry into Jan 2021 when they meant 2022

- And amount was modified

- Are you over or under?  So are you looking for a Payment or Deposit?

 

You get the idea.  Maybe start with sorting the Register by Amount and see if you can find a transaction for the same amount.  Next, start a Reconciliation (doesn't matter the numbers are wrong) and just look to see if you find anything pending that's dated Jan 2021 or any other transaction out of wack.  Also just look through Dec and Jan to see if you see anything out of wack. 

 

Next, I'd take a chance that something changed in Dec. OR to confirm the Nov Reconciliation was correct, UnReconcile December and do it again.  Hopefully the ending number in Nov will match the beginning number for Dec.  If not, then you've got a bigger issue and the prior Bookkeeper may have just been checking things off vs. actually reconciling the accounts.

 

From there I'd check with the Accountant.  They may be okay with just an entry to fix it (pending the amount).  If not, it sounds like a fair amount of time will be involved to UnReconcile back to where you find there error and then move forward again.

 

Hope you'll find an obvious error.

View solution in original post

7 Comments 7
RCV
QuickBooks Team
QuickBooks Team

Bank statement beginning balance does not equal previous month's ending balance.

I've got some steps we can perform to get your bank balance fixed, LuckyLady2.

 

The Beginning Balance is incorrect due to one of the following reasons:

  • No balance or an incorrect balance was entered when the account was set up.
  • Previously cleared and reconciled transactions were voided, deleted, or modified.
  • The file was converted from a different version of QuickBooks.
  • Possible data damage.

 

To find the transactions causing the discrepancy, we can run the Reconcile Discrepancy report. Here's how: 

  1. Go to the Reports menu.
  2. Select Banking, then Reconciliation Discrepancy.
  3. Choose the appropriate Account, then select OK. You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue.
  4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

 

To correct the discrepancy, you may need to re-enter or edit the transactions. We can also undo a previous reconciliation and redo it. Let me show you how: 

  1. Back up the QuickBooks company file.
  2. In the Begin Reconciliation window, select Undo Last Reconciliation.
  3. When prompted, tap Continue then OK.
  4. Close and reopen the Begin Reconciliation window.

 

To provide you other troubleshooting solutions, you can check out this article: Fix beginning balance issues in QuickBooks Desktop

 

Feel free to browse this link here if you need help with other tasks with bank feeds and reconciling accounts. It'll route you to our general payroll topics with articles.

 

Please know that I'm just a post away if you have any other questions about handling your accounts in QuickBooks. It'll always be my pleasure to help. Have a great day ahead. 

Pete_Mc
Community Champion

Bank statement beginning balance does not equal previous month's ending balance.

That's a tough one to figure out.  Some of the big "gotchas" are:

- Previously Reconciled transaction was deleted

- Previously Reconciled transaction was changed

- Big possibility that in Dec. 2021 they made an entry into Jan 2021 when they meant 2022

- And amount was modified

- Are you over or under?  So are you looking for a Payment or Deposit?

 

You get the idea.  Maybe start with sorting the Register by Amount and see if you can find a transaction for the same amount.  Next, start a Reconciliation (doesn't matter the numbers are wrong) and just look to see if you find anything pending that's dated Jan 2021 or any other transaction out of wack.  Also just look through Dec and Jan to see if you see anything out of wack. 

 

Next, I'd take a chance that something changed in Dec. OR to confirm the Nov Reconciliation was correct, UnReconcile December and do it again.  Hopefully the ending number in Nov will match the beginning number for Dec.  If not, then you've got a bigger issue and the prior Bookkeeper may have just been checking things off vs. actually reconciling the accounts.

 

From there I'd check with the Accountant.  They may be okay with just an entry to fix it (pending the amount).  If not, it sounds like a fair amount of time will be involved to UnReconcile back to where you find there error and then move forward again.

 

Hope you'll find an obvious error.

LuckyLady2
Level 1

Bank statement beginning balance does not equal previous month's ending balance.

Check written in Jan was entered in Dec. and was showing as cleared. That was the difference.

 

Thx so much for your help!!

Pete_Mc
Community Champion

Bank statement beginning balance does not equal previous month's ending balance.

Glad it worked out.  Those kind of issues often are really obvious or they can be a royal pain to find.

GeoZero
Level 1

Bank statement beginning balance does not equal previous month's ending balance.

I deleted a transaction from 2020 somehow... it's in the discrepancy report.  How do I fix it so that the opening balance in QB actually matches the banks balance. 

LeizylM
QuickBooks Team

Bank statement beginning balance does not equal previous month's ending balance.

Let's work together and solve this,GeoZero

 

Deleted transactions that had the Reconciled status could mess up your balances. To fix this, you'll need to manually re-create the deleted transactions and reconcile them again.

 

We can visit the Audit Log to see the specific transaction that was deleted from 2020. Here's how:

 

  1. Go to the Reports Menu. 
  2. Click on Accountant and Taxes. 
  3. Select Audit Trail.
  4. Input the date you want to view the report.

 

Then, you can use the information displayed to recreate the transactions. Let's make sure to update the status of the transactions in the register to R for Reconciled.

 

If the opening balance is now correct, you can now start reconciling. If there are any discrepancies, you can check this article to help you fix them: Fix issues for accounts you have reconciled in the past in QuickBooks Online.

 

Keep your post coming if you need additional assistance while managing your reconciled transactions. I'm always here to help. Have a great day!

GeoZero
Level 1

Bank statement beginning balance does not equal previous month's ending balance.

I don't have a gear icon as I am in Desktop not online version. 

Anyway... I fixed it just added the transaction again and at the next reconcile it zeroed out. 

Need to get in touch?

Contact us