Skip to main content
InvoicingTemplate.com main content
sharing is caring! we do appreciate your time to let others know us!

VAT Invoicing Template with VAT Rate and Amount Column

c6003
VAT Billing Template with VAT Rate and Amount Column

This sample template for VAT invoicing with VAT rate and amount column is the second sample of customizing VAT Invoice Template with 2 Separate Rates. It differs from the original Excel templates in that this one has both the VAT rate and the VAT amount column moved into the printable spreadsheet form.

For each different type of item listed on the form, you must show:

VAT Sales Invoice Template - Price Including Tax

c6007
VAT Sales Invoicing Template - Price Including Tax

As the name implies, the price on this template including tax, so that the total, which is calculated by "Price * Quantity", includes the VAT amount. The VAT amount column inside the printable invoicing form is calculated with the formula "Total (VAT) - Total (Net), where the "Total (Net)" is calculated with a formula like "Total including VAT / (1 + VAT Rate)" if the item that is being invoiced is taxable; or the "Total (Net)" equals to "Total (VAT)" if the current item is not taxable.

VAT Service Invoice Template - Price Excluding Tax

c6014
VAT Service Invoice Template - Price Excluding Tax

If you offer different product types that have different tax rates, it is better to details this fact on your invoices. InvoicingTemplate.com has designed such a template for you too, which is available at VAT Invoice Template with VAT Rate Column and VAT Invoice Template with 2 Separate Rates. If you need to show both the VAT rate and VAT amount for each invoicing item, visit VAT Invoice Template with VAT Rate and Amount Column.

VAT Service Invoice Template - Price Including Tax

c6013
VAT Service Invoicing Template - Price Including Tax

If you don't need the "Service Location" at all, as we did with many other service billing forms here on InvoicingTemplate.com, you can move the section completely out of the printable invoice form - i.e. the area named "Print_Area", you can easily do this by unprotecting the sheet and then dragging and dropping.

4-Column without Tax

c4002
4-Column Invoice Template

If you have Invoice Manager for Excel (namely Uniform Invoice Software) installed, setting tax types is as easy as clicking several buttons. For example, if you find a template here on InvoicingTemplate.com interesting but don't need tax fields, you can set it to non-tax by firstly clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab of the Settings dialog box. The Taxes tab offers 3 options, non-tax, one-tax and two-tax. Tax names and rates can also be set on the "Taxes" page of the Settings window.

ABN Tax Invoice

c7028
ABN Tax Invoice

If all your items are taxable or not taxable, you may not want to include the "Taxable" controls on the form. Don't worry. You can easily move ActiveX controls or Excel / Office form controls by following the steps below.

FET Tax Invoice for Truck Tire Business

c7040
FET Tax Invoice for Truck Tire Business

As detailed on Information on Federal Excise Tax, "You will need to pay Federal Excise Tax (FET), which amounts to 12% of the price and must be collected and paid by the seller …" In this sample template, the FET column is an amount value entered manually. See Federal Excise Tax (FET) info for more information on FET. See our tax invoice template collection for templates categorized by countries and regions.

Jamaica Tax Invoice Template

c5072
Jamaica Tax Billing Format
  • Words "Tax Invoice" (shown prominently)
  • Date of the taxable supply
  • Serialized number of the tax invoice
  • Name, address and GCT registration number of the Registered Taxpayer issuing the invoice
  • Name and address of the Registered Taxpayer to whom the taxable supply is made
  • Quantity and description of the taxable supply
  • Amount of the consideration payable on the taxable amount
  • Rate of tax and the amount of tax payable
  • Total amount of the consideration and the GCT.

UK Tax Invoice Template

c6005
UK Tax Billing Form

In certain trades (UK Construction, for example) it is customary for a list price to be given (on some, but not all products) and then a percentage discount to be applied. I.e. Quantity 1, List price of £81.57, discount of 65%, giving a line total of £28.55.

Recipient Created Tax Invoices Form

c4077
Recipient Created Tax Invoices Form

At InvoicingTemplate.com we've already published a serial of Excel invoice templates according to Australian Taxation Office requirements, including ABN Tax Invoice Template, Australian GST Invoice Template and Australian GST Invoice Template (2). Unlike the samples provided by Australian Taxation Office, our invoice templates are provided in both Excel and PDF formats. And of course, the Excel versions works with Invoice Manager for Excel (namely Uniform Invoice Software), which is our Excel-based invoicing software app that combines the power of Microsoft Excel with the back end databases in either Access or SQL Server format, providing features that could hardly be found or implemented with pure Excel templates. Invoice Manager for Excel (namely Uniform Invoice Software) was originally named Excel Invoice Manager, and the first version was released on August 1, 2005. Our continuous improvements based on the requirements from our users make Invoice Manager for Excel (namely Uniform Invoice Software) an easy to use, powerful and unique invoicing tool.

Blank Sales Invoice Layout (Two-tax)

c2020
Blank Sales Invoice Sample (Two-tax)

This two taxes invoice sample was created based on c2019 Blank Sales Invoice Format (One-tax). This customized template has similar layout as the original version, but differs from the original in that it has two taxes.

Mixed Tax Rates (5 Columns)

c5034
Mixed Tax Rates in an Invoicing Form (5 Columns)

This design, Mixed Tax Rates in an Invoice, has the "Product Type" and "Applied Tax Rate" placed outside of the printable area. What if you want to show these two columns on the printable invoicing form? It is easy actual to do - as mentioned above, all you need to do is to first adjust the existing columns to leave space for the two newly added columns, and then move in the two new columns.

General Service Invoice

c5012
General Service Bill

This general service invoice template / bill form features a logo image, invoice# and date on top of the form. Next to it is the "Bill To" section. This Excel billing format features 5 columns - Date, Description, Quantity, Unit Price and Amount.

Simple Sample - Adding Discount Column

c4061
Simple Invoicing Sample - Discount Column

By adding the "Discount" column, we meant not only re-design the Excel spreadsheet form so that it has an additional column, by also make the newly added column work with Invoice Manager for Excel (namely Uniform Invoice Software) -- i.e. when you click the "Save Invoice" button, the content on the "Discount" column should also be saved along with each invoicing item; if "Clear & New" command is clicked, the "Discount" column should get cleared too. This is implemented by using custom fields (user-defined fields) in Invoice Manager for Excel (namely Uniform Invoice Software).