The printed version.
Five Price Percentage Levels (Sales) (c4014)
c4014 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Five Price Percentage Levels (Sales) - IMFE edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you want this design to be set as the default template by the installer program.
Without database file. How to download and use
Download this if you have already installed IMFE, but are looking for additional customized templates.
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.
Like other form designs here on InvoicingTemplate.com, Form with 5 Price Levels is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Five Price Percentage Levels (Sales)|
|Category||Sales Invoice Template|
|Release Date||Wednesday, November 13, 2013|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||13.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
January 2, 2018
December 12, 2018