reconcile
hi
this week i have a accidently deleted 2 cleared cheques form dec last year and jan this year that had been reconciled .this has thrown my latest beginning balances out. when i tried to reconcile . i have tried to re do the cheques with the original date but i cant get them to show up in the month they were in . how do i get it to go back to how it was. my accountant is doing my end of financial year and the balances on 30 of june dont balance with bank because of this stupid mistake. any thoughts
thanks steve
Answers
-
Just reenter the cheques exactly as they should be, go to the reconcile window, ignore the fact that the opening balance is incorrect and enter the balance as at the last reconciled date, then all you should have to do is tick the 2 cheques and the reconciliation will balance
1 -
Don't do what Kris says. What you want is to reconcile the transactions back to the original date. Call me any time 0407744914
0 -
I have done this many times, takes 2 secs,
As long as you use the correct date that the cheques came through on statement everything will balance. I’m guessing that this is the difference your opening balance is. So when you enter the closing balance as at the last date you reconciled you will just have to tick those 2 transactions
0 -
Yeah except your reconciliation reports will change, no matter how many times you have done it before. Trust me Kris. You want the previous reports to be the same, not just the most recent one. It takes four seconds. Time well spent imho
0 -
The balance as at 30/6 will be exactly as it was before the transactions were deleted. I too have been doing bank recs for over 50 years, and realise the consequence of changing things and do not suggest things unless I’m 100% certain it will work. If he still has his printed recs they will still apply, and this method is the simplest, or rather my simplest. You are entitled to your methods as well
0 -
The cash book will be the same. The reconciled balance won't be. When I run the reconciliation report I want it to be the same every time. The simplest method isn't always the best. It's not a matter of being entitled. I just want the reconciliation report to be correct. Unless you reconcile them back at the original date, The bank rec at June 30 will not be correct. That's the way it is.
0 -
Personally, I prefer to reconcile back to the applicable date so my Bank Rec’s opening & closing balances remain correct. If the transactions have been reconciled previously & accurately maintained (eg no old transactions are still sitting there) the recs can quickly be re-done by just ticking the checkbox for current period & selecting “check all” 😬
0 -
Personally Sharon you are spot on. I've only been using Reckon since 1999 but this approach has served me very well. I also do the same thing with the "m" program. It make it a million times less complicated if the bank ever gets out of balance and you need to find where. Thanks for your feedback
0 -
You have an end of financial year involved, I would re enter the transactions and reconcile back to the date of the transactions. All will be correct then
0
