I've inherited a Sage bank rec that is out of line with the manual rec. I want to use Sage to do the bank, but I need to effectively reset it to start from now and forget the past. How can I overwrite the system generated opening balance, which it's carrying forward from the last rec. I am talking to Sage about this, but strugling a bit, so perhaps somebody has already had this problem and cracked it.
Thanks.
John Gillespie
Replies (3)
Please login or register to join the discussion.
How is it out of balance?
I guess you are saying that the balance on the bank control does not agree with the manual bank rec. If this is the case you need to put a bank transaction into the system to balance it up.
If you mean that the transactions that are marked as cleared in the system are wrong, I don't think you can undo this so you just have to wait till they work themselves out.
Or have I missed something?
Bank Reconciliation - simplified
From what I understand, your reconciled balance on Sage is different to your reconciled balance on Manual Reci. However, the balance per Nominal Ledger is the same - so Sage bank rec,at present, does not balance. OK. Match the unreconciled transactions against manual reconciliation, which will enable you to identify either the missing unreconciled transactions on Sage screen or surplus unreconciled transaction. If it is the latter, just click on it - and if it is the former, do a search on amount or date using Maintenance, recall it and take the tick off against Bank Rec (see split screen). This will then show it on the Bank Rec screen as unreconciled - your problem solved.
Good luck.
Vijay