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:
| 360 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
How is it possible to tax things differently? With this template, you can provide a tax group (i.e., tax type) for each item. Then, various tax rates are imposed in accordance with the tax classification of each item.
Related templates:
Note: Because this template's formulas are extensively modified, the options on the "Taxes" tab of the "Settings" window may not work. If you want to further customize this template, you have to do that manually without relying on the options on the "Taxes" tab of the " "Settings" window.
You specify the tax type of a product using the "Product Edit" window. The defined types are: TAX0, TAX1, and TAX2.
When creating an invoice, you pick up a product. The sheet uses the following formula to calculate the first tax:
=ROUND(SUMIF(oknProductType_1:oknProductType_12,"=TAX1", oknLineTotal_1:oknLineTotal_12)*oknTax1Rate+ SUMIF(oknProductType_1:oknProductType_12,"=TAX2", oknLineTotal_1:oknLineTotal_12)*oknTax1Rate,2)
The formula tests the product type, and if it is "TAX1" or "TAX2", the corresponding line total is added. Then, the sum is multiplied by the first rate to get the amount of the first tax.
The second tax formula works in a similar way.
=ROUND(SUMIF(oknProductType_1:oknProductType_12,"=TAX2", oknLineTotal_1:oknLineTotal_12)*oknTax2Rate,2)
The formula tests the product type, and if it is "TAX2", the corresponding line total is added. Then, the sum is multiplied by the second rate to get the amount of the second tax.
Format and Specification
| Template# | c5016 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 5 |
| Lines | 12 |
| Line Height (Points) | 19.50 |
| Print Area | $F$3:$M$41 |
| Papaer Size / Orientation | Portrait |
| Default Margins (Points) | |
| Left | 22.68 |
| Right | 22.68 |
| Top | 45.35 |
| Bottom | 45.35 |
| Price | Free (0.00USD) |
Related
