VAT Software

VAT Paperwork, or TAX returns?

I can recommend Business Accountz (PC/Mac) for TAX returns and general accounting tasks, but as for VAT.. excel or simular spreadsheet is probably a better option.
 
I though a spreadsheet would do the job could someone possibley create me a template to do the VAT as I am useless at spreadsheet.

Cheers
 
VAT = (Original Price x 0.175)

For example, a £10 item would be worked out like this;

10 x 0.175 = 1.75 (of VAT on top of item.)

1.75+10 (original price) = £11.75 (final value).


Now, if you have a price that's already inclusive of VAT then it's more complex..

For example, you have an item that's £211.50 after VAT.

To find the VAT that was added on you;

(211.50 x 7) / 47 = 31.5 (VAT added)

(final price) 211.50 - 31.5 = £180 (price before VAT)
 
Last edited by a moderator:
EVH said:
VAT = (Original Price x 0.175)

For example, a £10 item would be worked out like this;

10 x 0.175 = 7.5 (of VAT on top of item.)

7.5+10 (original price) = £17.5 (final value).


Now, if you have a price that's already inclusive of VAT then it's more complex..

For example, you have an item that's £211.50 after VAT.

To find the VAT that was added on you;

(211.50 x 7) / 47 = 31.5 (VAT added)

(final price) 211.50 - 31.5 = £180 (price before VAT)
Click to expand...

slight error in your VAT calc. 10*0.175 = 1.75 not 7.5... I was about to scream down the government for extortion!
 
What i am saying is I cant even program a spreadsheet to do the calculation. I am so thick at spreadsheets but if someone can creat a template i can noramlly do the rest.

Cheers
 
Your time spent posting this could be spent learning how to work a spreadsheet, and then you'll always know. It's better for you in the long run if you learn how to type =(A2*1.175) yourself.
 
You must log in or register to reply here.
Back
Top Bottom