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.
MarkR s post is good info but may not apply here. No - do not manually add or delete the 'cleared checkmark' - allow the reconcile function to do that. What I thought you meant was the usual problem people run into - they successfully complete a reconciliation but later find an error in one of the reconciled postings that needs fixed. Changing a reconciled entry causes it to become 'uncleared' and throws out an existing reconciliation. It is almost impossible to have 'cleared' too many items, but still end up with the correct closing balance - unless the 'excess' items were exactly offsetting If you used the wrong closing balance that also should have been (nearly) impossible to reconcile. So if you 'cleared' items that were after the statement date - yet somehow still made it reconcile - then there must be other errors in that reconciliation If you 'plugged' the prior reconcilation to force an apparent balance and now want to fix it then delete the plug and then redo the reconcile as i described.