VAT template for Excel?

[pete12345]

Does anyone know of a free (or cheap) Ms Excel template which I can use for VAT invoices?

Thanks in advance!

 

[E Storey]

Ms office seem to have a lot here.
http://office.microsoft.com/en-us/templates/CT010117255.aspx

I would like to use some for one of my clients but her invoicing is usually very detailed and can run for a number of pages. I am most worried about how excel would handle this.

Perhaps we could both try a few out and report back?

 

[MyAccountantOnline]

Does anyone know of a free (or cheap) Ms Excel template which I can use for VAT invoices?

Thanks in advance!

Just a thought but have you considered using an accounting package which includes invoicing?

If you dont want to use a full accounting package this might be of interest - http://shop.sage.co.uk/free.aspx

 

[tony84]

Im not sure if this is what your after but i tend to just use a calculation.

Going off memeory it would be something like:
=sum(Your selling price)/100*17.5+(your selling price)

That would then give you the price of your item + vat (presuming vat stays at 17.5%)

 

[MyAccountantOnline]

Im not sure if this is what your after but i tend to just use a calculation.

Going off memeory it would be something like:
=sum(Your selling price)/100*17.5+(your selling price)

That would then give you the price of your item + vat (presuming vat stays at 17.5%)

I think the OP wanted an invoice template rather than help with a formula to calculate VAT.

 

[ch4580]

Hi, I'm just working on a template now...

let me know if you want me to send it to you when I'm done. (ch4580 at mac.com)

what fields would be helpful, just incase I'm unaware of some...

if you need some formulas to get you by....

VAT from subtotal
=SUM(<cellnumber>*17.5)

Total from subtotal
=SUM(<cell number>*17.5+<cell number>)

Before VAT total, from Total...
=SUM(<cell number>/117.5*100)

VAT total from Total...
=SUM(<cell number>/117.5*17.5)

 

[Tom McClelland]

Hi, I'm just working on a template now...

let me know if you want me to send it to you when I'm done. (ch4580 at mac.com)

what fields would be helpful, just incase I'm unaware of some...

if you need some formulas to get you by....

VAT from subtotal
=SUM(<cellnumber>*17.5)

Total from subtotal
=SUM(<cell number>*17.5+<cell number>)

Before VAT total, from Total...
=SUM(<cell number>/117.5*100)

VAT total from Total...
=SUM(<cell number>/117.5*17.5)

None of those formulae are likely to round to the correct penny.

 

[ch4580]

None of those formulae are likely to round to the correct penny.

Hi Tom,
Gonna be a 'problem man' or a 'solutions man' ????
????

try this...

if you use e.g this formula, you'll get your results...
=ROUNDUP(SUM((B70/117.5)*17.5), 2)

ROUND will apply normal rounding rules.... (e.g 1.005 = 1.01, 1.00499999 = 1.00)

ROUNDUP obviously up to the next whole decimal (if you use ",2" at the end)
ROUNDDOWN obviously to the previous whole decimal...

Best bet would be to weigh the rounding in favour of HMRC...
e.g ROUNDDOWN for the VAT you get back from them, ROUNDUP for the VAT you owe them...

Ultimately though, best thing would be to use the BEFORE VAT figure from your receipts and invoices, so that the figures are done the way they would be done 'at the til'.... and Rounded up!!

(maybe I'll do two versions of my template)...

if you're talking about figures that would actually have a large affect on your earnings, (rounding pennies would affect you by 1 or 2 pence per invoice)... then you probably want to pay an accountant to do this stuff...

 

[ch4580]

And, sorry Pete, I've realised you were asking about an Invoice template, not a RETURN template (I've got these things on my mind just now)...

I always use Word/Pages... Excel can print out a bit funny, and certainly not look as good as it might in Word...

I think you can import Excel Cells into word, so you could still use the formulas

 

[E Storey]

And, sorry Pete, I've realised you were asking about an Invoice template, not a RETURN template (I've got these things on my mind just now)...

I always use Word/Pages... Excel can print out a bit funny, and certainly not look as good as it might in Word...

I think you can import Excel Cells into word, so you could still use the formulas

Nah it doesn't auto calculate after it's been imported....

 

[Tom McClelland]

Hi Tom,
Gonna be a 'problem man' or a 'solutions man' ????
????

Anyone who doesn't know how to do stuff like that without assistance probably shouldn't be trying to do it.

Incidentally, VAT should always be rounded down (except on the individual lines of multi-line invoices, where it can be rounded to the nearest tenth of a penny, and then the total of those tenths is rounded down)

 

[ch4580]

Menu -> Insert -> Object -> Microsoft excel worksheet

though i'm not totally sure how it'd work...

i'm thinking a worksheet that you enter quantity, description, price, and calculate subtotal on,
and at the bottom, a cell with a sum of the subtotals, and the VAT figure

 

[evosolution]

Hi, I'm just working on a template now...

let me know if you want me to send it to you when I'm done. (ch4580 at mac.com)

what fields would be helpful, just incase I'm unaware of some...

if you need some formulas to get you by....

VAT from subtotal
=SUM(<cellnumber>*17.5)

Total from subtotal
=SUM(<cell number>*17.5+<cell number>)

Before VAT total, from Total...
=SUM(<cell number>/117.5*100)

VAT total from Total...
=SUM(<cell number>/117.5*17.5)

Have could I have that template please ?

 

[STDFR33]

Have could I have that template please ?

Google VT Cashbook. It can be downloaded from the VT website for free.