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

I haven't reconciled one of my bank accounts since my December 2019 statement. I went in today to reconcil and all of my reconcile dates are now 2 years in advance and the ending balances are incorrect. What can I do to correct this.

I haven't reconciled one of my bank accounts since my December 2019 statement. I went in today to reconcile and all of my reconcile dates are screwy.  The last correct one (I believe) is December 2014.  From then on they are random dates and the last ones are now 2 years in advance (2021) and the ending balances are incorrect. What can I do to correct this.

4 Comments 4
MaryLurleenM
Moderator

I haven't reconciled one of my bank accounts since my December 2019 statement. I went in today to reconcil and all of my reconcile dates are now 2 years in advance and the ending balances are incorrect. What can I do to correct this.

Hello there, Darla680,

 

You'll want to make sure to select the correct dates before starting the reconciliation. Select the date on your Statement Date.

 

Furthermore, it's ideal to reconcile your account every month.

 

Check out these articles about bank reconciliation:

I'll be right here if you have more questions.

Pete_Mc
Community Champion

I haven't reconciled one of my bank accounts since my December 2019 statement. I went in today to reconcil and all of my reconcile dates are now 2 years in advance and the ending balances are incorrect. What can I do to correct this.

Is it possible that you accidentally entered something with a date back in 2014 or 2015?  The first thing you can check is to select Cleared Status in the drop-down menu in the lower left corner of the Acct Register window. 

 

If you find something that's has the wrong date, hopefully correcting it will put everything back.

 

I see two other options to hopefully fix the imbalance.  If you didn't make a lot of other entries in QBs other than reconciling, restore from a backup.

 

If you can't do that.  Then UN-Reconcile what you just did.  First, MAKE A BACKUP.  Then Go to Banking and Reconcile for this Acct.  Then, in the bottom of the window, click on Undo Last Reconciliation.  Repeat as many times as needed to get back to where you were. 

 

When you restart the process, make sure the Reconciliation date does indeed match what the statement says (sometimes they're not the last day of the month). 

 

If something doesn't match, STOP on that month and fix it then.  When you get totally done and you're still off, you're just going to have to make an Adjustment entry.  Check with your accountant on what Acct they want to apply that Adj. to.  (Stick anything in there for now, but don't wait until the end of the year or you'll drive your accountant crazy trying to figure out what that entry is.)

 

Good luck. 

MV550
Level 1

I haven't reconciled one of my bank accounts since my December 2019 statement. I went in today to reconcil and all of my reconcile dates are now 2 years in advance and the ending balances are incorrect. What can I do to correct this.

Hi, There is not a unreconciled option at the bottom only resume reconciling 

Kurt_M
QuickBooks Team

I haven't reconciled one of my bank accounts since my December 2019 statement. I went in today to reconcil and all of my reconcile dates are now 2 years in advance and the ending balances are incorrect. What can I do to correct this.

Thanks for joining the thread, @MV550. I'll share an insight as to why you don't have the option in your company file.

 

It looks like you're using QuickBooks Online (QBO). Please be aware that the Undo Last Reconciliation option is available in QuickBooks Desktop (QBDT). That's the reason you're only seeing the Resume Reconciling button below.

 

In QBO, if you want to undo an entire reconciliation, you'll want to contact your accountant since they're the only ones who can access this tool. However, if you don't have a financial advisor on board, you can still get through this by manually unreconciling each transaction inside the account. 

 

If you wish to continue with this method, I'll gladly input the process below. To get you started, these are the steps:

 

  1. Access your QuickBooks Online company.
  2. Go to Accounting tab on the left panel.
  3. Under Your Company, select Chart of Accounts.
  4. Choose the account you’re working on, and click on View Register.
  5. Select the transactions you want to unreconcile.
  6. Keep on clicking the R status until it shows blank or cleared (C).
  7. Click on Save.
  8. Choose Yes in the confirmation window.

 

To learn more about the process, please see this page: Undo or remove transactions from reconciliations in QuickBooks Online.

 

Additionally, here's an article to help you fix issues within your reconciliation: Fix issues at the end of a reconciliation in QuickBooks Online.

 

@MV550, I'll be happy to help you if you need further assistance sorting this out. Please don't hesitate to leave a comment down below. Take care, and have a nice day!

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

Need to get in touch?

Contact us