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.


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

438 KBDownload

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

6.07 MBDownload

Screenshots and Images

The printed version.

Service Invoice with Discount Amount

Open the template in Excel.

Service Invoice with Discount Amount (IMFE Edition)


Service Invoice with Discount Amount (c4024) is a customization sample and variant of Service Invoice with Discount Percentage (c4005). The modifications to the original Excel service invoice template is that the discount percentage field is now redefined as an amount field.

When the discount field is a percentage, the total is calculated with an Excel formula like " =ROUND(IF(oknInvDiscount=0,oknSubTotal,oknInvDiscount*oknSubTotal),2)". In this Service Billing Form with Discount Amount, since the discount is an amount, the total is now calculated with an Excel formula like " =ROUND(oknSubTotal-oknInvDiscount,2)".

As we can see from this example, Invoice Manager for Excel allows you to add new fields to all the main database tables (as well as the Excel invoicing forms), since the templates are in Microsoft Excel spreadsheet format, it is also possible to create or define the relationship between new fields and existing fields. The use of discount field is just a simple example. More complex features that are not found in the existing Excel invoice templates can also be added, such as Free Five Price Percentage Levels, and Mixed Tax Rates in an Invoice. You can find more samples by browsing our categories and search pages here on

This free invoice template is a service invoice template, meaning that there is no fields defined for shipping address information.

If you are using Excel Invoice Manager, i.e. the previous version of Invoice Manager for Excel, you might be already familiar with the concept of custom fields. However, custom fields in Invoice Manager for Excel are much easier to work with. For example, with Invoice Manager for Excel now the Custom Field Manager can be opened directly from all the main data list windows.

Format and Specification

NameService Invoice with Discount Amount
CategoryService Invoice Template
Release DateSunday, May 18, 2014
Format (XLS or XLSX).xlsx
Line Height (Points)19.50
Print Area$G$1:$P$44
Papaer Size / OrientationPortrait
Default Margins (Points)
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

August 27, 2018

  • This template was updated to be compatible with UIS 6.

November 24, 2018

  • Changed the field type of "InvDiscount" from decimal(6,3) to decimal(12,3).