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:
| 449 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Detail
This is the third sample based on the Job Invoice Sample (c5006). It adds a new column to the detail section, i.e., the tax amount column, which shows how much tax was collected on each item.
For each item, a formula calculates the tax, which looks like this:
=ROUND(oknLineTotal_? * oknTax1Rate * oknTaxable_?,2)
In the above formula, "_?" is the line number. "oknTaxable_?" is the value of the "Taxable" checkbox for each item.
Format and Specification
Template# | c6015 |
Belongs to | |
Format (XLS or XLSX) | .xlsx |
Columns | 6 |
Lines | 12 |
Line Height (Points) | 15.00 |
Print Area | $E$1:$AI$55 |
Papaer Orientation | Portrait |
Default Margins (Points) | |
Left | 0.00 |
Right | 0.00 |
Top | 53.86 |
Bottom | 0.00 |
Price | Free |