- Document for Excel Invoice Manager
This version of the document, "VAT Invoice Templates", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.
VAT (value added tax) in theory avoids the cascade effect of sales tax by taxing only the value added at each stage of production. For this reason, throughout the world, VAT has been gaining favor over traditional sales taxes. For example, VAT is a tax that's charged on most business transactions in the UK. Businesses add VAT to the price they charge when they provide goods and services. Here we offer two types of VAT invoice template that work with, i.e. VAT invoice - price excluding tax, and VAT Invoice - price including tax.
Note that InvoicingTemplate.com has revised both templates, VAT Invoice Template (Price Including Tax) and VAT Invoice Template (Price Excluding Tax). The sales invoice template (meaning that the template includes a shipping address section) of "VAT Invoice Template (Price Including Tax)" is available at VAT Sales Invoice Template - Price Including Tax, the service invoice template (meaning that the shipping address section is changed to a "Service Location" section) is available at VAT Service Invoice Template - Price Including Tax. If you are interested in the "price excluding tax" version of our VAT invoice templates, InvoicingTemplate.com has the versions too. See VAT Sales Invoice Template - Price Excluding Tax and VAT Service Invoicing Template - Price Excluding Tax to download the free VAT invoice templates.
Excel Invoice Software provides custom builds that replace the default invoice template in Uniform Invoice Software with the customized invoice templates published on InvoicingTemplate.com. The custom builds on Excel Invoice Software install Uniform Invoice Software as usual, but set a customized invoice template as the default invoice template of this Uniform Invoice Software installation. The VAT invoice templates available on InvoicingTemplate.com have corresponding custom build on Excel Invoice Software too. For VAT Sales Invoice Template - Price Including Tax, see VAT Sales Invoice Template - Price Including Tax for Excel Invoice Software. For VAT Service Invoice Template - Price Including Tax, see VAT Service Invoice Template - Price Including Tax for Excel Invoice Software. For VAT Sales Invoice Template - Price Excluding Tax, see VAT Sales Invoice Template - Price Excluding Tax for Excel Invoice Software. For VAT Service Invoicing Template - Price Excluding Tax, see VAT Service Invoicing Template - Price Excluding Tax.
Tip: Download the customized VAT invoice templates free of charge from the bottom of this page.
The layout of the VAT invoice templates provided here is similar to the layout of the default invoice template provided by. It contains:
The invoice body section contains 6 columns that will display on the printed invoices, including description, price, quantity, total (net), VAT, total (VAT); there are also 3 columns to the left of the visible invoice body, which are visible only when you are creating invoices, and will not be visible on the printed invoices - "product#" column, "taxable" checkbox column and "product selection" icon buttons column.
As described in the preceding section, here we offer two types of VAT invoice template. The most important difference between the two VAT invoice templates is that with the first one, price excludes VAT, and with another, price already includes VAT.
And finally, at the end of the VAT invoice forms there are calculated cells (fields), including Net Total, VAT, Total, Paid, Total due, and a manually editable cell Delivery Charge.
If price includes tax, the following formulas are created to calculate "Total (VAT)", "VAT" and "Total (Net)".
|Total (VAT)||oknLinetotal_?||=oknPrice_? * oknQuantity_?|
|VAT||oknVAT_?||=oknLineTotal_? - oknTotalNet_?|
The "?" symbols in the names and formulas are line numbers of the current row. For example, for the first row on the invoice body, the "Total (VAT)" cell is actually named "", and the formula to calculate its value is actually " ".
If the price excludes tax, the following formulas are created to calculate "Total (VAT)", "VAT" and "Total (Net)".
There are also other VAT invoice templates available on this site, for example.
This VAT invoice template supports two vat taxes. Unlike the default invoice template included in the setup program of, where the two taxes are both applied to each product or item, in this invoice template only one of the two VAT taxes is applied to a product or item, and each product or item in this VAT invoice template has a property with which you can specify which VAT tax is suitable for the product item. However if the customer provide its VAT ID then it is Vat free.
If your products have different VAT rates, say some of the products have 6% VAT rate and the others have 19% VAT rate, this template might be suitable for you.
This VAT invoice template is a variant of C5-005 VAT Invoice Template. It differs from the original VAT invoice template in that thecolumn is moved into the . This makes the column visible on printed invoices.
This VAT invoice template is a variant of (C5-005) VAT Invoice Template. It differs from the original VAT invoice template in that theand columns are moved into the . This makes the and columns visible on printed invoices.
This service vat invoice template does not usefields, but added several new fields on invoice header, such as , , . It also added two new columns, and . For each product or service item, you can set a VAT percentage rate, which is loaded when you pick up a product or service item by clicking one of the icon buttons. For a product where there is no VAT payable there simply will be no figure in the VAT section, therefore, where VAT is zero the price and the total will read the same. The currency symbol of this VAT invoice template is set for UK (United Kingdom) format.