I need some help with the bank reconciliation in Sage 50.
In November 2014 I reconciled the statement. There was an invoice already entered in sage for £3269 and but at a wrong date. So I cancelled the entry with a credit for the same date and then re-entered the invoice at the right date. The Nov statement was reconciled, however the entry I did at the wrong date appears now on the top window of the Dec reconciliation. I don't know how to adjust that amount and re-reconcile the Dec statement. can someone please help me out on this.
If you mess with invoices that have already been paid and reconciled, sometimes the payment becomes un-reconciled. If you now enter the balance on your reconciliation for the end of December and reconcile the statement for December you should be left with a difference of £3269 in the bottom right hand corner, all you do then is match that line in your top pane and you should be left with a zero difference. What I would have done is just corrected the date in corrections and re-matched the payment in the bank :)
-- Edited by Rhianrach on Tuesday 20th of January 2015 02:03:31 PM
-- Edited by Rhianrach on Tuesday 20th of January 2015 02:05:34 PM
Ive just had something similar (ish) although without the invoices, but got this figure popping up on my reconciliation which was throwing matters out. Unfortunately I had only half read your thread before leaving this morning, was at a clients and couldnt get on the internet to sort it! Was going to bring it home but fortunately I had backed up before starting the Bank rec so I was able to sort it. Thanks for the tip though Steve.
Glad you got it sorted Tazzy
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
