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:
| 444 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Detail
This sample adds a discount amount column to the default template shipped with our app.
It's common practice for many types of businesses to offer discounts. The easiest way, however, and also a flexible way, is to add the discount as a product or service item in the detail section but with a negative price or line total.
There are also special ways that are not commonly used but do work for some businesses. For example, one of our customers found a new way to use the tax cells and formulas on the default template: by naming a tax "Discount" and assigning it a negative tax rate, one of the tax fields on the bottom of the form efficiency becomes a discount field. Since Invoice Manager allows you to change the tax rate (in this example, it becomes the discount rate) on a per-invoice basis, the customer has never encountered a problem applying discounts in this way.
What if you need to show discounts in a more detailed manner? For example, show discounts applied to each item separately. This requires an additional column in the item section. So, in this customized format, we have six columns within the printable range: Product ID, Description, Quantity, Unit Price, Discount, and Line Total. The "Discount" here is an amount.
Format and Specification
Template# | c6010 |
Belongs to | |
Format (XLS or XLSX) | .xlsx |
Columns | 6 |
Lines | 20 |
Line Height (Points) | 15.75 |
Print Area | $F$3:$O$51 |
Papaer Orientation | Portrait |
Default Margins (Points) | |
Left | 22.68 |
Right | 22.68 |
Top | 45.35 |
Bottom | 45.35 |
Price | Free |