The company I am working with had not reconcilled the bank statements since 2005. So I reconciled every thing from 2005 until December 2017 to get a correct starting balance for the January 2018 bank statement. I have now reconciled upto February 2019. I found that I accidently put some 2019 deposits on the 2005 to 2017 reconcilliation. How can I remove those and add the correct ones without redoing all of 2018 and 2019 up to Feburary?
It always a waste of time to undo a reconciliation due to minor errors. Just fix the prior posting errors, then fix the prior reconciliation to match.
Fixing the prior postings is up to you - just make them right. While doing this you will get warnings not to change reconciled items - do it anyway (this assumes you know what your doing and will finish the next step !!!).
Now fix the reconcilation - you cant edit so do a new reconciliation using the same closing balance and date that was used the first time you did it. Once you 'hide items after the statement date' then only things left will be your new (or changed) entries, plus the prior uncleared items. Now reconcile the changes.
Are you saying that I should just go to my register and uncheck the deposits that should not be reconciled then go check the deposits that should be reconciled?
I am confused about fix the prior postings. Can you list the steps that I should take?
Hello there, @Joycee.
Let me walk you through the steps to fix the prior posting that @MikeinBC advised.
This method uses a date other than the most recent reconciliation and does not require that you know the ending balance from the previous reconciliation. Here's how:
Here's an article for more detailed steps and information: Reconcile Previously Deleted and Re-entered Checking or Credit Card Transactions.
If you need assistance on how to make these corrections, you can consult your accountant.
Please get back to me if you need further assistance with QuickBooks. You got me here to figure things out for you.