Firstly thank you for looking at my question, so here goes I hope I explain it correctly.
Using Sage 50(latest version)
I use Linnworks and pull my customer information into Sage via Tradebox, as I have a charity shop selling on multi channels. I have a few customers showing a credit balance which is not right, when I dd the VAT return it said there were duplicate transactions where it had pulled them across twice so when I delete them it has left a credit balance on the customer account. How do I clear them down so they show a zero balance.
Hi
I am sorry Steve but this is a forum for professional bookkeepers and Accountants, rather than business owners so we are unable to answer your specific questions. A couple of things I can say though is that you should avoid using the delete button on sage as it can really mess things up especially where VAT is concerned. So would normally suggest adjustments rather than deletions. In addition there is not really enough information to go on here without being able to interrogate the data - you mention deleting trans, but we cant see what and dont know how you enter the details in the first place., so we could be trying to help and actually making matters worse.
First thing I would suggest it that you get audit trail/nominal activity report covering the period of the so called duplicated transactions, check whether or not they were actually duplicated (sometimes the software states they are, and they quite clearly arent to the inputter, with knowledge of the transactions) and then see if the other half of the transaction also needs correcting, which now you have completed and reconciled your VAT cannot be via the deletion option. So - I would have a word with your Accountant who, once they have looked at your reports and comments, or even better the sage backup or access it via the portal, can then suggest the appropriate action.....most will do this for no extra charge as its just some in year assistance. Failing that - Sage helpdesk can probably assist you
__________________
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 Steve
Ive just got the PM you sent me confirming you are indeed the Scout man.
Here is the link to another post which will show your other profile - you will need to delete one of them. http://forum.bookkeepers.network/t61735718/tradebox-and-sage-50-mis-posting-vat/
As a Scout Treasurer myself, despite what I have said above, Im happy to help a fellow scout, BUT, you will see that the last time you posted I did ask a few questions, which I never got the answer to, so Im loathe to waste my time by starting the same process again as some of the questions will be the same, plus one or two more to ascertain what you do now and why so I can suggest how you can correct it. Plus you have already indicated that you have an Accountant on board so this should be your first port of call, unless that said Accountant has no clue as to how sage works.
So given the passage of time since you asked this - have you sorted it? If not, let me have the answers to the previous post, I will then pose a couple more and we can take it from there and see if I can help. Or perhaps someone else on here will.
__________________
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