You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original template in that it uses percentage values in the price fields.
This template uses the same database structure and field definition as the original version, but changes the meaning of the fields. The 5 prices field in the original database definition are decimal (15,6) which is enough for storing a percentage value. In this implementation offered by InvoicingTemplate.com, the first price custom field (Discount Price A) is used as the base price, and the other 4 prices (from Discount Price B to Discount Price E) are used to store discount percentage values. For example, in the sample database attached with this template, product "ABC-01" has 5 custom fields defined for prices, named from "Discount Price A" to "Discount Price E", and the values are 19.00, 0.11, 0.21, 0.31 and 0.41. If the discount level of a customer is 1 and he purchases the product "AB-01", the base price (19.00) will be applied; If the customer's discount level is 3, the discount will be 0.21 (i.e. 21%), the applied price will be 19 * (1-0.21) = 15.01. You can find more examples at standard invoice templates and blank invoice templates.
Like all the other invoice templates in this "5 price levels" serial, the invoice body part includes only one taxable checkbox. If you check this box, all the items on the invoice form will be taxable, and if uncheck this box, the tax amount of this invoice template will be zero. If you tested the default sales invoice template shipped with Invoice Manager for Excel, where each item on the invoice body has its own taxable checkbox so that you can control whether each item is taxable or not on this invoice, the calculation of taxes in this customized invoice template has been greatly simplified, as the template even ignores the "taxable" option set on each Product Edit window. This is a sample on how you can bypass the default tax calculation methods implemented by the default template and create your very own tax rules.
Format and Specification
|Name||Five Price Percentage Levels (Sales)|
|Category||Sales Invoice Template|
|Release Date||Wednesday, November 13, 2013|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||13.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
January 2, 2018
- Upgraded to ".xlsx" format from ".xls" format.
- Increased the line heights of top rows from "Your business name" to "Phone#" in the "Bill To" section.
- Applied steel blue color scheme.
- Removed unnecessary text labels such as "template# c4014" from the form. The template# is now identified by the database file name.
December 12, 2018
- Replaced all the report worksheets with those shipped with the latest standard invoice templates.