I've just gone to do a Bank Rec in Sage. On the bank record it shows the last rec as being 29/01/2016, with the same balance as the bank statement of £10000 (for the purpose of this post). However when I go to the Reconciliation, it shows the opening balance/last reconciliation as £12000. How is this different - surely the opening balance will be the same as the last reconciled balance?
Stabbing in the dark a bit - have you done ANY keying in sage since that last rec? Sounds like something has been keyed to the bank that you maybe shouldve keyed to cash/other bank account. Or perhaps have you gon into the Bank to then link a supplier/customer payment on account to an invoice and the boxes didnt nil out. Perhaps the last Bank rec wasnt saved properly. You will need to do some digging - start with the above, then check if there are any lurking entries you thought you had cleared in the unreconciled part of the rec screen/tick off the Bank manually to the last rec with the benefit of the rec PDF or use the activity screen/check the audit trail. Can you restore a Bank up, post last Bank rec and check that is ok.
__________________
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
It's not the opening balance on the bank that's wrong it the reconciliation opening balance on the reconciliation window, which would normally be the same as the last reconciled balance. Hope that makes sense. I can't screen shot it to show what I mean as I do this work on remote access via two different computers.
Depending on your version of sage, keying a deletion of a previous reconciled entry can just skew the opening rec balance now showing. So you may have deleted something, then re-keyed it, so your Bank balance is correct on your main Bank screen but the rec will clearly be wrong.
You can still do a screen shot even if you are working remotely, or take a piccie on your phone if it has a camera. But I know where you mean so dont need to see it. You need to do the digging I suggested, Im afraid.
Deletions are the biggest cause of problems in sage!
__________________
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
Thanks I will have a look at all the deleted transactions and see if I can find it. Normally the only things that get deleted are invoices, as this particular client has a habit of creating dummy invoices which then have to be reversed when we get the actual invoices, but not the actual payments themselves.
OMG - I would be forcefully putting a stop to that, especially if they are VAT registered. (quote appropriate accounting standards and scare them into stopping if you have to!) You mention deleting invoices and also reversing invoices, not sure which but I wouldnt be deleting them. Use the delete option VERY sparingly and absolutely not if any VAT and Bank recs have been done. If any of them have payments attached that can throw out your rec potentially.
Quick check I thought of - with your opening balance in the rec screen being incorrect, are there any transactions lurking now waiting to be reconciled that were not there before? Bringing those back to being reconciled might sort the issue.
Sounds like you have some right odd clients! lol
-- Edited by Cheshire on Friday 24th of June 2016 11:25:52 AM
__________________
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