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.

531 KBDownload

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

6.01 MBDownload

Screenshots and Images

The printed version.

Five Price Percentage Levels (Sales, Custom Column)

Open the template in Excel.

Five Price Percentage Levels (Sales, Custom Column) (IMFE Edition)

Detail

As the name of this invoice template implies, it is a sales invoice template that has shipping information inside the printable range on the invoice form, and the prices or discounts are in percentage.

The meaning and usage of percentage values are detailed in Form with 5 Price Percentage Levels (Sales), where you can also find samples on how to use the percentage discount fields. The keyword "Color" in the template name means there is an additional column "Color" on the invoice body, which is a custom field defined in both the Product and Invoice Body database table.

Custom Field is a concept introduced by Invoice Manager for Excel, which refers to the fields that are not defined in the default database structure of Invoice Manager for Excel. For example, for an invoice selling clothes you may like a "Size" column on the invoice body to indicate the size of the invoicing item, but the "Size" field does not exist in the default database definition. In this case, you can add it as a custom field in both the Product and Invoice Body database table, so that when you pick up a product on creating an invoice, the size field filled in automatically along with the description, price and product #, and when you save an invoice, the size field is saved too.

If you prefer a service version of this invoice template, click here.

Format and Specification

Template#c5029
NameFive Price Percentage Levels (Sales, Custom Column)
CategorySales Invoice Template
Release DateSunday, November 17, 2013
Format (XLS or XLSX).xlsx
Feature Gallery
Columns5
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

  • In the "Bill To" section, replaced "oknWhoCountry" cell with "oknWhoEmail" cell.
  • Added bottom lines to cells inside both the "Bill to" and "Ship To" sections.

May 14, 2019

  • Assigned a slightly deep color to headings of the 5 price columns outside of the printable area.
  • Removed all the ActiveX labels from "Bill To" and "Ship To" sections; Replaced them with Excel text.