Download
| Description | Size | Download |
|---|---|---|
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:
| 908 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
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 | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 6 |
| Lines | 18 |
| Line Height (Points) | 15.75 |
| Print Area | $G$1:$Q$139 |
| Papaer Size / Orientation | Portrait |
| Default Margins (Points) | |
| Left | 19.44 |
| Right | 23.04 |
| Top | 68.03 |
| Bottom | 57.60 |
| Price | Free (0.00USD) |
Related
