Im using Sage 50, the 2013 version. I rec'd funds from a client and used customer receipt to allocate it as a payment to account, as we had received no remittance advice.
Now trying to adjust it to link to an invoice but realised I placed it to the wrong customer account. When I tried to change the customer account in maintenance it came up with a message ''trans cannot be carried out automatically since this trans has been reconciled for VAT'' (Its also been Bank reconciled)
How do I correct the entry please?
__________________
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
Hi Joanne
Is the client on cash accounting? Thats usually why you cannot amend entries that have been reconciled for Vat, you may be able to go into corrections and take out the Vat reconciled date and amend it then put the date back in but Sage is very temperamental when it comes to cash accounting.
I find the easiest option is to do a reverse entry for each item with the same vat code etc then re enter the correct details thus making a net entry for Vat (does that make sense)
Hi
Yes the client is on cash accounting (my first and only client on this!). I will try the first option (with backups of course), but if that doesnt work then will have to try your second suggestion although (as my head is truly mashed for the day), Im not sure what you mean/how I would go about this - if you could explain further please I would be very grateful.
Thanks Sharon
__________________
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
Hi Joanne, if the correction doesn't work taking the vat reconciled date out I would raise a credit note to the customer that has had the wrong posting therefore creating a credit balance on his account (raise with a T9 and then do a refund to client which will again be a T9) this will put the incorrect customer back to zero balance, then you can process the payment again under the correct customer.
When you do the bank reconciliation you will have 3 entries, the two incorrect ones and the correct one.
Others may have an easier solution but that's usually what I have had to do if it happens to me- I hate cash accounting and the inability to do corrections on Sage!!!
Thank you Sharon - this is when I hate Sage too!! Im normally really careful about which customer I post to, exactly to avoid sorting such things out, although now I will be even more careful. Not helped by forgetting to ask which VAT Scheme they were on when I had my 1st discussion with them - had I known I would probably have run a mile - Im too much for an easy life, although sorting out their books is proving a challenge Im mostly quite enjoying (except yesterday and today!!)
Thanks for your guide - I will have a go tomorrow when Im in a better mood (hopefully!!)
__________________
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
When I tried to change the customer account in maintenance it came up with a message ''trans cannot be carried out automatically since this trans has been reconciled for VAT'' (Its also been Bank reconciled)
