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:
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:
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
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|