Dug out my login detail and thought I would post a question here as this forum has been most helpful to me a few years ago.
Basically, I am helping another bookkeeper who has gotten in to a pickle with some accounts she took over.
she came to the year end on 31.12.14 with the bank reconciling to 5.01.15.
She then began to review the trial balance etc to check everything was in the right place. It wasn't.
So she deleted a few bits and reposted stuff, unfortunately Sage deleted some batches of transactions where she only meant to delete one post Etc. this happened on a couple of transactions too.
Any way. she made all of her corrections then went to reconcile the bank (I have to say at this point i reconcile after each amended transaction so it doesn't get muddled!) and now the bank balance in sage is 3k higher than the bank balance on jan 5th.
is there any way in sage of undoing bank reconciliations?! She has printed off the whole bank and ticked it off so it should be a matter of working out what is wrong. I don't know how well she has done this though.
Has anyone had a similar situation and can tell me how to help her correct it? We both work for the same accountancy practice and she is spending an awfully long time on this job which is making it not cost effective.....
Hi the simple answer on this one is to restore a previous back up and start from there, but I'm guessing that this might not be an option. I would always say, take backups before you do something on sage that you aren't sure about and check the impact of all the entries you make in these circumstances, not just the impact on the Bank. The Bank reconciling is just a sense check, but the other sides of the transactions eg debtor control, vat and debtors accounts etc need to be right.
If you have no back up to hand then I would suggest you try an audit trail (full) , nominal activity for the period and back rec going back to the prior period and then a manual tick back, unless someone else has a better idea. But before you do that just have someone look at the corrections option....it might be as simple as the corrections/entries now just have the wrong date posted on them.
__________________
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
"So she deleted a few bits and reposted stuff, unfortunately Sage deleted some batches of transactions where she only meant to delete one post Etc. this happened on a couple of transactions too."
Hmm. Not sure I've ever seen that happen - but I can imagine where it might; where a sales/purchase ledger payment is partly allocated, and partly a payment on account, for example, so it's split as two transactions. I expect deleting one will remove both.
(So if a payment of £10 against an invoice of £10 is accidentally entered as £12, for example, the resulting £2 POA might seem to be a separate transaction - but deleting it will probably also delete the £10 allocated payment. Probably. I think. At a guess.)
"is there any way in sage of undoing bank reconciliations?! She has printed off the whole bank and ticked it off so it should be a matter of working out what is wrong. I don't know how well she has done this though."
Sort of - but, depending on the volume of transactions, it can be a tedious process. It also might not be necessary.
The way to "undo" a bank reconciliation is to find the reconciled transactions in the maintenance screen, and edit them - unticking the "Bank rec on" option.
IF you know the dates each reconciliation(s) took place on, AND you know how far back you need to go, you can apply a search in the maintenance screen:
'Where' 'bank reconciled date' 'is equal to' '[the date of each reconciliation]'
Do that to list the transactions reconciled in each case, working back to however far back you need to go, and you can unreconcile the transactions on a per-reconciliation basis.
Alternatively, if you want to do it in one search, change 'is equal to' to 'is greater than or equal to' and make the date the date of the oldest reconciliation.
However, the flip side is that the search will also show up any deleted transactions. (I think the reconciled flag remains in place, so they show up).
You could therefore conceivably use these searches, alongside the PDFs that Sage saves for the bank recs, and work out where things have gone wrong without going to the effort of unreconciling things.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
"So she deleted a few bits and reposted stuff, unfortunately Sage deleted some batches of transactions where she only meant to delete one post Etc. this happened on a couple of transactions too."
Hmm. Not sure I've ever seen that happen - but I can imagine where it might; where a sales/purchase ledger payment is partly allocated, and partly a payment on account, for example, so it's split as two transactions. I expect deleting one will remove both.
(So if a payment of £10 against an invoice of £10 is accidentally entered as £12, for example, the resulting £2 POA might seem to be a separate transaction - but deleting it will probably also delete the £10 allocated payment. Probably. I think. At a guess.)
If you enter a batch of transactions with the same reference sage can delete them all when you delete one, 'tis a bit quirky like that.
The way to "undo" a bank reconciliation is to find the reconciled transactions in the maintenance screen, and edit them - unticking the "Bank rec on" option.
Oh Vince, good shout - why didnt I remember this one? Simples! (or maybe not in this case)
__________________
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
