The Book-keepers Forum (BKF)

Post Info TOPIC: Vat return in sage


Member

Status: Offline
Posts: 22
Date:
Vat return in sage
Permalink Closed


hi everyone,

Iv just prepared my first VAT return on sage and im not sure that i have done it correctly.

My box 6 figure was not totaling my Sales figure so i printed off the detailed vat report and looking through it had picked up figures journal credits that i had posted to capital introduced - i have then gone into correct the vat code to T9 on the half of the journal that was being posted to the capital account. Now my box 6 figure is totaling my sales (relief).

Again, on my box 7 figure it has picked up journals into drawing (code 3300) do i need to do the same with this?

Does anyone have a step to step that i can following at my quarter end to ensure i have done all the reconciling i need to do as im feeling a little worried that i may do this wrong.

Any help would be great. Thanks

__________________


Senior Member

Status: Offline
Posts: 200
Date:
Permalink Closed

Yes, drawings should be posted to code T9, also things like wages, Vat payments to HMRC etc. T9 is for anything that should not be included on the VAT return. Hope helps

__________________


Member

Status: Offline
Posts: 22
Date:
Permalink Closed

so just to get things straight if i posted a journal would the following be correct?

Stationary DR 100 Tax 1
Vat DR 17.50 Tax 1
Capital Introduced CR 117.50 T9



__________________


Senior Member

Status: Offline
Posts: 158
Date:
Permalink Closed

Ok SD, I don't know for sure but I'll have a stab for fun. Plenty of gurus to put me straight if I'm wrong.

Assuming business owner is a sole trader, bought something for use in his business, takes no cash out, just adds to capital introduced.

Owner bought the goods and paid VAT but they aren't VAT reg'd so can't claim VAT back and can't invoice on with VAT added. So from business's perspective, transaction is non-VATable.
Journal should just be Dr Stationery gross amount and cr capital, both code T9.

ohmygod.gif Fire away guys......

__________________


Senior Member

Status: Offline
Posts: 158
Date:
Permalink Closed

Re VAT return checklist, this one is from the Sage 50 Accounts Stage 2 workbook I have:
- ensure VAT settings and preferences set up
- post VAT Scale Charges if applicable (co car private fuel use)
- use verify system to check for VAT anomalies
- calc VAT return in Sage
- calc EC Sales List if applicable
- calc Reverse Charge Sales List is applicable
- check VAT return
- manually adjust as required
- print VAT return reports
- back up data
- reconcile and archive VAT transactions
- clear VAT control accs
- submit VAT return to HMRC
- view HMRC receipts if applicable
- pay HMRC if applicable

Lots of detailed instructions over many pages in the workbook that are copyrighted so I can't provide I'm afraid. I would hope, however, you can access this same info by registering online with Ask Sage, using your registered Sage software to gain access.

Hope this helps a bit anyway.

Phil

__________________


Senior Member

Status: Offline
Posts: 200
Date:
Permalink Closed

PhilMcTankup

Yes that is correct. If a company is not VAT registered put everything to T9.

Just use the gross amount eg Stationery £100 plus 17.50 VAT = £117.50. You would put the whole £117.50 in amount and use T9 code.



__________________


Senior Member

Status: Offline
Posts: 158
Date:
Permalink Closed

Thanks SD, nice to know some good comes of all the studying!  w00t.gif

Phil


__________________


Senior Member

Status: Offline
Posts: 426
Date:
Permalink Closed

Sorry I got confused if company was VAT registered or not so a brief outline on Sage VAT.
T9 does not enter the VAT return at all therefore used for Wages, Drawings, Dividends VAT payments & Receipts, PAYE payments etc.
T1 = VAT at standard rate
T2 = Exempt VAT items - ie postage stamps, insurance, some books
T3 = used for "old" rate VAT (this will be used in January 2011 when VAT changes)
T5 = Lower Rate (usually set as 5%) gas/electric etc.
T0 = Zero rated VAT
T4, T7 & T8 = all refer to EC

A full listing can be found in Tools/configurations/tax codes.

Once you have printed & reconciled dont forget the VAT wizard (modules/wizards in older versions) as this will transfer to the VAT liability account.

Hope helps

__________________

 

Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900

Payroll & bookkeeping solutions - info@completebookkeeping.co.uk

www.completebookkeeping.co.uk

IAB Training centre - Ringwood

 

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