Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download VAT Invoicing Template with VAT Rate and Amount Column. Double-click the downloaded file to extract all files.
  2. Open the template "vatinvoicetemplatewithvatrateamount.xlsx" or "vatinvoicetemplatewithvatrateamount-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 Invoicing Template with VAT Rate and Amount Column

VAT Invoicing Template with VAT Rate and Amount Column (c6003)

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

VAT Invoicing Template with VAT Rate and Amount Column - freeware edition

VAT Invoicing Template with VAT Rate and Amount Column - freeware edition

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

VAT Invoicing Template with VAT Rate and Amount Column - Uniform Invoice Software V3 edition

VAT Invoicing Template with VAT Rate and Amount Column - Uniform Invoice Software V3 edition

Download VAT Invoicing Template with VAT Rate and Amount Column (c6003)

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.

300 KBDownload

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

2.72 MBDownload

Detail

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.

The previous example, VAT Invoicing Template with VAT Rate and Amount Column (c6002), demonstrated how to create a new Excel invoicing template from c5005, which complies with the UK HMRC requirements of showing "the rate of VAT that applies to what's being sold". This sample Excel template shows the VAT amount column too.

If you are interested in this free Excel invoicing template please go to the download page and choose the format you like. If you are interested in the implementation details then please read on.

If you are registered for VAT you must give any VAT-registered customers a VAT invoice for any standard-rated or reduced-rated goods or services you sell them. If you are a retailer, you do not need to issue a VAT invoice or receipt unless your customer asks for one. As a VAT-registered supplier, you may be liable to a fine if you do not issue a VAT invoice for a supply you have made when asked to do so by a VAT-registered customer.

This Excel template, just like the default template shipped with Uniform Invoice Software (UIS), has two taxes defined on the invoicing form.

VAT Invoicing Template with VAT Rate and Amount Column, like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.

According to UK HM Revenue & Customs VAT invoices, what they must show, it must show:

  • An invoice number which is unique and follows on from the number of the previous invoices - if you spoil or cancel a serially numbered invoices, you must keep it to show to a VAT officer at your next VAT inspection.
  • The seller's name or trading name, and address.
  • The seller's VAT registration number.
  • The invoicing date.
  • The time of supply (also known as tax point) if this is different from the invoicing date.
  • The customer's name or trading name, and address.
  • A description sufficient to identify the goods or services supplied to the customer.
  • The rate of any cash discount.
  • The total amount of VAT charged expressed in sterling.

For each different type of item listed on the form, 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.

In order to adhere to these rules and requirements, we added several custom fields to the default database shipped with UIS.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. VAT Invoicing Template with VAT Rate and Amount Column uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as VAT Invoicing Template with VAT Rate and Amount Column without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

When working with Uniform Invoice Software (UIS) version of VAT Invoicing Template with VAT Rate and Amount Column, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template VAT Invoicing Template with VAT Rate and Amount Column and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

If you installed UIS and start the Custom Field Manager, you'll easily find out what custom fields we've added to the database that runs with VAT Invoice Template with VAT Rate and Amount Column - To both the Customer and "InvHdr" tables, the new field "VAT ID" was added; to the Product table, "Tax Category" was added; To the "InvBdy" table, we added 4 custom fields to it, including "Applied Tax Rate", "Category", "Line Tax", "Tax Category". These custom fields added to the database tables are then mapped to Excel cells / columns according the rules described above.

Like other form designs here on InvoicingTemplate.com, VAT Billing Template with VAT Rate and Amount 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#c6003
NameVAT Invoicing Template with VAT Rate and Amount Column
CategorySales Invoice Template
Release DateMonday, May 12, 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