Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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.
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.
Hi, There is not a unreconciled option at the bottom only resume reconciling
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here