Download

DescriptionSizeDownload

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.
441 KBDownload

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

Screenshot

screenshot for VAT Invoicing Template with VAT Rate and Amount Column

Detail

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

Template#c6003
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns6
Lines12
Line Height (Points)19.50
Print Area$F$2:$O$42
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree