Invoices for Zero and Standard Vat rates

[BusinessChump]

Hi I'm guessing that this might sound simple to many out there - well hopefully anyway.

The invoices I use to give to my clients involve me manually adding in any VAT when there are products on it that are zero rated and standard rated.

For example

Sports T-Shirt - Small Boys Size - Zero rated - £10
Sports Jumper - Large Mens Size - Standard Rated - £20

Vat of £3.50 would have to be paid on the mens jumper only and I would either have to do two seperate invoices or manually add the Vat otherwise my template would also Vat the childs product.

What I'm looking for is a template where I can add zero rated or standard rated to a column alongside the product and it will automatically work it out for itself.

Can anybody help????? I've Googled without success!!!

[DuaneJackson]

What are you using to create your invoices? I'm assuming you're not using any software otherwise it'd cater for this easily enough.

So I'm guessing it's word or Excel, in which case isn't it just a matter of inserting another column?

[sanjiv]

Have a look at bambooinvoice. That allows you to do it. I use it for invoicing.

[BusinessChump]

Yes we use Excel Duane. I've tried to add another column but it all ended up a bit messy. Looking for something a bit more professional now but without having to go out and buy a specific package that we dont yet need.

[Faevilangel]

As sanjiv said, Bamboo invoice will do that, you set the vat status for each invoice you create. The settings allow you to edit the vat rate also.

[kpdorset]

In Excel, do you have a column with your product price in then column for VAT?
So 20.00 3.50
10.00 0.00

Total 30.00 3.50 33.50

If so, then you need to add a narrow column next to the product price entitled VAT Rate. Then this column needs to say 17.5 or 0 or similar against each product price. Then your VAT column itself (In my example Column D) could have the following calculation =SUM(IF(C1=17.5,B1/100*17.5,0)) - Column C says 17.5 Column B has your product price. This is basically saying if cell C1 says 17.5 then this cell (D1) is B1/100*17.5, if it doesn't say 17.5 then this cell (D1) should be nothing.

You can use letters as your VAT rate if you prefer. I use S and Z. The calculation has to have the letter in inverted commas: - =SUM(IF(C1="S",B1/100*17.5,0)

If you have any reduced rate (5%) items, then the calculation will get more difficult but this will cover the two sorts of VAT.