First VAT return using ANNA template

[ITUK]

I'm working on my first VAT return using the free template from ANNA but stuck with what to choose when putting in sales and purchases in the OPTIONS box

For the sales the OPTIONS are:
Miscellaneous
Goods supplied from Northern Ireland to EU state member
Goods supplied from Great Britain to EU state member before 01.01.2021

For the purchases the OPTIONS are:
Miscellaneous
Acquisition of goods made in Northern Ireland from EU state member
Purchase of services from outside the UK on or after 01.01.2021
Purchase of services from EU state member before 01.01.2021

My sales are the use of health equipment at my place of business, the purchases I am claiming for are health machines/equipment. Which one do I choose for sales and purchase? I have seen other templates that have an option to write what the invoice is for but with this template the only options are what I wrote above

Can someone also please explain the final VAT return with the green boxes, while I have not yet input all sales it I am confused as Box 4 (VAT reclaimed on purchases and other inputs (including acquisitions from the EU) has this for it's value ######

I am also confused with Box 5 (Net VAT to be paid or reclaimed (difference between boxes 3 and 4) as it's not clear if the amount is for me to reclaim or pay

I have screenshots but there is no option to attach

 

[ITUK]

I have just noticed everything is ok until I input the 14th expense, this is when the #### appears but if I only have 13 expense inouts everything is as it should be ang gives the correct amount of VAT to be returned to me

 

[Daybooks]

Free templates are free for a reason. Either ask ANNA or better still refer to the HMRC guidance:

How to fill in and submit your VAT Return (VAT Notice 700/12)

Find out how to fill in your VAT return, about using VAT accounting schemes and how to submit your return electronically.

www.gov.uk

It is all explained there. Given that most businesses are mandated into "Making Tax Digital" for VAT it is probable that your understanding of the template might prove to be the least of your problems:

Making Tax Digital for Income Tax

Find out how to use Making Tax Digital for Income Tax, including step by step guidance for sole traders, landlords, and their agents.

www.gov.uk

 

[ITUK]

I just realised it works ok until the VAT I am owed goes above 10k, this is when box 4 and 5 show #####

Anything below 10k it works fine

 

[Daybooks]

I just realised it works ok until the VAT I am owed goes above 10k, this is when box 4 and 5 show #####

Anything below 10k it works fine

Have a word with your IT expert as to why your <Excel> template might be displaying ##### when the numbers become large. For the VAT Return please consider engaging the services of a professional accountant as soon as practicable.

 

[DWS]

If it’s the same as an excel spreadsheet then it should just be the case of widening the column to allow for the larger figure.

 

[ITUK]

If it’s the same as an excel spreadsheet then it should just be the case of widening the column to allow for the larger figure.

Oh dear, red faced. You were right

Thank you

 

[WaveJumper]

You must be spending to much it won't fit in the wee little boxes

 

[Karimbo]

i beleive someone from anna may have come here a year or so back fielding opinions on what we think about integrating bookkeeping and banking together. I thoughgt it was a silly idea and they are trying to do too much and probably wont do a good job of either.

I have revolut, mettle and tide each for the one perk, revolut for cheap transfers to china, mettle for freeagent access for £0. tide just temporarily for a £200 cashback. all 3 of them do my head in about classifying transactions when i spend money. the bank want to know what expense this is. it's annoying as heck and pointless using it because i have a full accounting package.

IMHO i think OP should get a good accounting software and learn it and use it, the vat forms will be auto populated from doing the books.

Using the bank accounts internal bookkeeping is a sneaky tactic to get the business owner to do all the banking through that bank account and you may not be getting the best deal.

the book keeping features in the bank account are not fully featured accounting packages, the revolut one for example does not have a classification for stock purchases, they only allow the common p&l expenses to be classified.

for free accounts ANNA charges 29p per transfer (in our out), 1.5% fee on atm (minimum charge £1), money for pots. those fees are waived if you get a monthly fee account at £17.88pcm where they will give you some more fee free allowances for those.

honestly, just get a business bank account with the co-op, and use a mettle expense account for light expenses to get access to freeagent. the co-op business bank account interface is as basic as basic can be and i love it. they dont even have an app. it's on desktop only.

these online banks give you dumbed down bookeeping features and charge you for things everyone else gives for free.

 

[Newchodge]

I just realised it works ok until the VAT I am owed goes above 10k, this is when box 4 and 5 show #####

Anything below 10k it works fine

That would probably be because the excel cell is only 9999.99 wide.