InvoicingTemplate.com main content

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

497 KBDownload

Download this if you want this design to be set as the default template by the installer program.

5.79 MBDownload

Screenshots and Images

The printed version.

VAT Invoice Template with VAT Rate Column

Open the template in Excel.

VAT Invoice Template with VAT Rate Column (IMFE Edition)

Detail

This is a variant of C5005 VAT Invoice Template with 2 Separate Rates. It differs from the original Excel VAT invoice template in that this variant moves in the VAT Rate into the printable Excel invoice form.

According to UK (United Kingdom) HM Revenue & Customs "VAT invoices: what they must show", for each different type of item listed on the VAT invoice, you must show:

  • the unit price or rate, excluding VAT
  • the quantity of goods or the extent of the services
  • the rate of VAT that applies to what's being sold
  • the total amount payable, excluding VAT

The original design found on VAT Invoice Template with 2 Separate Rates does not include the VAT Rate column inside the printable invoice form - i.e. the VAT Rate column is put outside the range defined by the Print_Area name.

So to create this VAT Invoice Template with VAT Rate Column template, all we have to do is to firstly unprotect the Invoice worksheet, and then adjust the existing columns to leave space for the newly moved in (VAT Rate) column.

VAT Invoice Template with VAT Rate Column includes the Shipping Address section, so it is categorized as Sales Invoice Template here on InvoicingTemplate.com. The Excel template will work great for sole traders and limited companies alike.

Format and Specification

Template#c6002
NameVAT Invoice Template with VAT Rate Column
CategorySales Invoice Template
Release DateWednesday, April 30, 2014
Format (XLS or XLSX).xlsx
Feature Gallery
Columns6
Lines12
Line Height (Points)18.00
Print Area$F$3:$O$43
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

December 24, 2017

  • Fine turn the line heights of the top rows.

September 24, 2018

  • Updated the Sales Report for vatinvoicetemplatewithvatratecolumn.xlsx.

Samples

Thumbnail for VAT Service Invoice Template - Price Including Tax
Thumbnail for Service VAT Invoice Template
Thumbnail for VAT Service Invoice Template - Price Excluding Tax
Thumbnail for VAT Invoicing Sample with 2 Separate Rates
Thumbnail for VAT Invoicing Template with VAT Rate and Amount Column
Thumbnail for VAT Sales Invoice Template - Price Including Tax
Thumbnail for VAT Sales Invoicing Sample - Price Excluding Tax