BoostExcel main content



The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
366 KBDownload

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


VAT Invoicing Template with VAT Rate and Amount Column


This is the second example of customizing Two Separate VAT Rates (c5005). It differs from the original version in that this one has both the VAT rate and amount columns moved into the printable section.

The previous example, VAT Invoicing Template with VAT Rate and Amount Column (c6002), demonstrated how to create a form based on c5005, which complies with the UK HMRC requirements of showing "the rate of VAT.

In order to adhere to these rules and requirements, we added several custom fields. For example, to the "InvBdy" table, we added 4 custom fields: "Applied Tax Rate", "Category", "Line Tax", and "Tax Category". These custom fields added to the database tables are mapped to Excel form cells.

Format and Specification

Belongs to


Format (XLS or XLSX).xlsx
Line Height (Points)19.50
Print Area$F$2:$O$42
Papaer Size / OrientationPortrait
Default Margins (Points)
PriceFree (0.00USD)


VAT Service Invoice Template: Price Including Tax
Service VAT Invoice Template
VAT Service Invoice Template: Price Excluding Tax
VAT Invoicing Sample with Two Separate Rates
VAT Invoice Template with VAT Rate Column