BoostExcel.com main content

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

518 KBDownload

Download this if you want this design to be set as the default template by the installer program.

6.09 MBDownload

Screenshots and Images

The printed version.

Five Price Percentage Levels (Sales)

Open the template in Excel.

Five Price Percentage Levels (Sales) (IMFE Edition)

Detail

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

Template#c4014
NameFive Price Percentage Levels (Sales)
CategorySales Invoice Template
Release DateWednesday, November 13, 2013
Format (XLS or XLSX).xlsx
Feature Gallery
Columns4
Lines30
Line Height (Points)13.50
Print Area$H$3:$O$57
Papaer Size / OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top73.70
Bottom73.70
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

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

Related

Thumbnail for Customer Value Based Pricing
Thumbnail for Five Price Levels (Sales, Amount)
Thumbnail for Five Price Levels (Service, Amount)
Thumbnail for Five Price Percentage Levels (Service)
Thumbnail for Five Price Levels (Sales, Amount, Custom Column)
Thumbnail for Five Price Levels (Service, Amount, Custom Column)
Thumbnail for Five Price Percentage Levels (Sales, Custom Column)