This free VAT invoice template has two VAT rates that can be set on the bottom of the invoice form. When creating an invoice, you choose the tax category from a dropdown list for each invoicing item; the invoice template calculates tax using the tax rate determined by the tax category. If the client has a 'VAT #' (or VAT registration number), then it is VAT-exempt. For each line of the invoicing item, there is also a 'Taxable' checkbox located near the left side of the print area. If an invoicing item is not taxable, uncheck this box to instruct the invoice template not to calculate tax for this invoicing item.
The 'Taxable' checkbox column, 'Tax Category' dropdown list column and tax amount column are all located outside the print area. This makes sure that the invoice template will not print these columns. This form design leaves more space for you to enter product/item description on the invoice body. The print area, which is identified by Excel range name 'Print_Area', defines what to print when you print in Excel
If you need to have any or all of the non-print columns, 'Taxable', 'Tax Category' and 'Tax', to appear on the printed invoices, you can simply move them into the print area. There are also ready-to-use variants of this free invoice template with the non-print column moved into the print area. Click the 'home page' link on the invoice form to visit us at UniformSoft.com to find the free invoice template with the VAT rate column, and the one with both the VAT rate and VAT Amount.
The invoice template is designed to be printable with A4 paper. To adjust the print options in Excel 2003, click Excel menu File / Page Setup; or if you are using Excel 2007/2010, go to the Page Layout ribbon tab.
Our free invoice templates are pure Excel templates without macros and password-protection. So if the template you like does not meet your business requirements exactly, you can use it as a starting point for your own customizations.
Microsoft Excel/Office 2000/XP/2003/2007/2010