BoostExcel main content


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.

Description Size Download

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

1614 KB Download

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

6.81 MB Download

Screenshots and Images

The printed version.

Business Invoice with Customer-Specific Discounting

Open the template in Excel.

Business Invoice with Customer-Specific Discounting (IMFE Edition)


With this business invoice template you can assign each customer a specific discounting rate. This rate is saved with other customer information such as street address and email. On creating invoices if you choose a customer, its discount level / rate is retrieved and applied too.

No matter what business you are in, returning customers are always valuable. To encourage those customers and express your gratitude, a discount shown on invoice is a great way to do that. This business invoice template implements that by using a custom field created in both the "Customer" and "InvHdr" database tables.

This form design is a revisited version of c5033 Sales Invoice Form with Discount Percentage. Like the invoice template names imply, the discounts here are specified as percentage. If you prefer discount amount value, visit c5032 Sales Invoice Form with Discount Amount. Here on we also have the form designs for service business, at c5031 Service Invoice Form with Discount Percentage and c5011 Service Invoice Form with Discount Amount.

Every business is different, the pricing model could also be very different. If you prefer to offer prices based on customer values or levels, visit c6006 Customer Value Based Pricing.

This template was originally published on as C5-011 "Applying Discounts to Certain Customers". The following description from provides useful information to help you understand this template.

Some customers are very important so you need to allocate discounts to them whenever you invoice them. This template implements this by adding a custom field, Discount, to both the Customer and InvHdr (Invoice Header) database tables. For each customer, you can set a default discount, either 0 or a non-zero value. Whenever you create invoice for the customer, the discount is applied automatically.

Also in this invoice template the whole PO#, sales rep, ship date and ship via strip, as well as the Shipping and Handling at the bottom, are moved out of the Print_Area (the white area on the center of the form), leaving space for you to type in more information about your company or business.

Format and Specification

Template# c5108
Name Business Invoice with Customer-Specific Discounting
Category Sales Invoice Template
Release Date Saturday, March 25, 2017
Format (XLS or XLSX) .xlsx
Columns 5
Lines 8
Line Height (Points) 37.50
Print Area $F$4:$N$46
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 22.68
Right 22.68
Top 45.35
Bottom 45.35
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.