The Book-keepers Forum (BKF)

Post Info TOPIC: Vat return error


Newbie

Status: Offline
Posts: 3
Date:
Vat return error
Permalink Closed


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.



__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

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...)



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Hi Emma

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.



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

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...)



Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

Hi,

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.

Thanks again.
Emma

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

That's particularly odd.

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...)



Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

It's instant account 2012 that we have . Thanks

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Okay - so what about the other 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)."




__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

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

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About