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.


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

1630 KBDownload

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

6.33 MBDownload

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

NameBusiness Invoice with Customer-Specific Discounting
CategorySales Invoice Template
Release DateSaturday, March 25, 2017
Format (XLS or XLSX).xlsx
Line Height (Points)37.50
Print Area$F$4:$N$46
Papaer Size / OrientationPortrait
Default Margins (Points)
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.


Thumbnail for Service Invoice Form with Discount Amount
Thumbnail for Service Invoice Form with Discount Percentage
Thumbnail for Sales Invoice Form with Discount Amount
Thumbnail for Sales Invoice Form with Discount Percentage
Thumbnail for Customer Value Based Pricing
Thumbnail for Business Invoice Template
Thumbnail for Billing Invoice Template