Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download VAT Invoice Template with VAT Rate Column. Double-click the downloaded file to extract all files.
  2. Open the template "vatinvoicetemplatewithvatratecolumn.xlsx" or "vatinvoicetemplatewithvatratecolumn-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

VAT Invoice Template with VAT Rate Column

VAT Invoice Template with VAT Rate Column (c6002)

This is how the template looks like when you open the freeware template in Microsoft Excel.

VAT Invoice Template with VAT Rate Column - freeware edition

VAT Invoice Template with VAT Rate Column - freeware edition

The following template was designed for Uniform Invoice Software version 3.

VAT Invoice Template with VAT Rate Column - Uniform Invoice Software V3 edition

VAT Invoice Template with VAT Rate Column - Uniform Invoice Software V3 edition

Download VAT Invoice Template with VAT Rate Column (c6002)

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 UIS, but are looking for additional customized templates.

303 KBDownload

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

2.72 MBDownload

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.

The printable area, or print area, is the area with white background on the center of the VAT Invoice Template with VAT Rate Column spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for VAT Invoice Template with VAT Rate Column, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the VAT Invoice Template with VAT Rate Column, select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

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.

The protection of the "Invoice" worksheet in VAT Invoice Template with VAT Rate Column prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in VAT Invoice Template with VAT Rate Column.

To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

The gridlines and row/column headings could help a lot when design the layout of the form.

To adjust the existing columns to leave space for new column or columns that will be added to the printable form for VAT Invoice Template with VAT Rate Column, we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening VAT Invoice Template with VAT Rate Column as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this VAT Invoice Template with 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.

Like other form designs here on InvoicingTemplate.com, VAT Billing Template with VAT Rate Column is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

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
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns6
Lines12
Line Height (Points)19.50
Print Area$F$2:$O$42
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates