Hi, Just wondered if anyone could help. We use Sage Instant Accounts for our book keeping. I've gone to run the latest VAT return Nov '16 - Jan '17 and the purchases figure is triple what it normally is. I think it may have something to do with the year end as I recently did the tax return on Sage to submit to HMRC. Has anyone got any experience of running a VAT return and the purchases being a lot higher after completing a year end? The previous VAT return showed a figure of £10056.94 in box 7 and this VAT return is showing a figure of £34054.40 in box 7!!!!! I've manually added the purchase invoices myself and the figure is just over £13k. Any advice would be much appreciated. Thank you.
Question the first: You are presumably the bookkeeper for this company - so it might help forum members if you offer some insight into your background and abilities. E.g. are you solely employed by this company, or are you self employed and they're a client (I'm guessing an employee judging by your phrasing), and so on.
Question the second: What version of Sage Instant? This is a very important question, because different people use different versions, which have different facilities - so when someone answers/offers help, they might suggest things that your version doesn't allow you to do.
Those aside, as I've just said to someone else: Start by having a nice, relaxing cup of tea and - most importantly - don't panic.
Now a new set of questions:
Have you told Sage to "reconcile" or "flag" the transactions on that VAT return yet, or is it still live? (i.e. does it stored in the list of VAT returns, or do you have to run it and enter the dates) ? If you are still at the stage where you have to run it and enter the dates, that means you still have time to fix it if there is definitely a problem.
If you *have* 'reconciled' the return, do you have a backup from immediately before doing so (and related, have you input many transactions since)? (This determines whether it is practical to go back to that point, or whether that would be too much work).
Start with these questions, and someone else will hopefully pick the thread up later (I'm not at a Windows computer today, so any comments I make will be from memory rather than looking at a real version of Sage)
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Just to add a couple of questions to Vince's. Is it just the purchases out or are sales out as well? My immediate thought was is whether the previous VAT return was reconciled, and it's picking up the previous return as well.
Have you looked at the detailed transaction list? This should give you an indication of what'a amiss maybe.
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
I was half thinking that, and half thinking about Emma's comment about the year end being done, and the possibility of one or more journals being posted with the wrong T-code.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Thanks for your quick replies! It's my husband's business and I do the accounts for him (I'm not a qualified accountant!). Hence, my lack of knowledge and the panic that I've done something wrong and unsure how to correct it. I'm at work at the moment so can't confirm the version of Instant Accounts - but I'll log on later and confirm.
The previous VAT returns have been reconciled so it's definitely not adding those into it. To me, it seems strange that since running the year end this problem has occured and that's why I think it could be something to do with the YE and something I've missed??
The sales invoices are correct, it's just the purchase invoices that are triple what they normally are.
If it was a T-code problem on the year end journals (an incorrect setting*), I'd expect it to be consistent across the debits and credits - so it would affect the inputs as well as the outputs.
* There was a version of Sage which did have an incorrect setting along these lines, straight out of the box - but it was a VERY long time ago, so I'd be surprised if it's the same problem now (plus, it would affect all of the figures, as I said). I saw it at a small number of different places, some of which I'd been called in to investigate a problem along these lines.
Another possibility: The payment after the last VAT return - double check that it wasn't incorrectly input as T0 instead of T9 (assuming the usual defaults). This used to be a common mistake I saw when called to look at problem figures. (I think it largely stopped when Sage added the ability to enter the payment from the tasks button on the return itself).
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
"Have you told Sage to "reconcile" or "flag" the transactions on that VAT return yet, or is it still live? (i.e. does it stored in the list of VAT returns, or do you have to run it and enter the dates) ? If you are still at the stage where you have to run it and enter the dates, that means you still have time to fix it if there is definitely a problem.
If you *have* 'reconciled' the return, do you have a backup from immediately before doing so (and related, have you input many transactions since)? (This determines whether it is practical to go back to that point, or whether that would be too much work)."
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Do you have an Accountant? Might be more appropriate and quicker for them to take a quick look at it as they will probably spot it a mile off in a couple of minutes.
What do you mean - did the tax return on sage? The CT return? (adjustments issue?)
The year end shouldnt have affected anything. But it depends what you did. Can you explain what process you followed. Maybe share a screen shot of the trans (stripping out the company name for obvious reasons!)
Did you put the correct dates in when calculating the return? Have to ask!
You say you are not a trained Accountant - are you a trained bookkeeper and if so what training etc?
The other questions Vince has asked are critical.
Can you see any obvious duplications on the vat detailed report for the period you are doing?
Have you changed the year end of the business from one period to another in sage?
When was your last backup and how many entries have you done since then?
__________________
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