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

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

Screenshot

screenshot for VAT Sales Invoice Template: Price Including Tax

Detail

This template includes six columns in the printable section: Description, Price (Including Tax), Quantity, Total (Net), VAT Amount, and Total VAT.

As the name implies, the price on this template includes tax, so the total, which is calculated by "Price * Quantity", includes the VAT amount. The VAT amount column inside the printable form is calculated with a formula like this:

=oknLineTotal_1 - oknTotalNet_1

The "Total (Net)" is calculated with a formula like this:

=ROUND(IF(oknTaxable_1,oknLineTotal_1/(1+oknTax1Rate),oknLineTotal_1),2)

Please also see VAT Sales Invoice Template: Price Excluding Tax (c6008), where the price does not include VAT. You can choose any template that suits your needs.

Format and Specification

Template#c6007
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns6
Lines18
Line Height (Points)15.75
Print Area$G$1:$Q$139
Papaer OrientationPortrait
Default Margins (Points)
Left19.44
Right23.04
Top68.03
Bottom57.60
PriceFree