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.

516 KB Download

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

6.30 MB Download

Screenshots and Images

The printed version.

Sales Invoice with Profit Calculation

Open the template in Excel.

Sales Invoice with Profit Calculation (IMFE Edition)


This sales invoice template produces exactly the same printed invoices as the default sales invoice template that is included in the Invoice Manager for Excel installer program. The main difference is that this template support the calculation of profit.

When running a business you may prefer to know the cost and profit, whether you are selling goods or providing services. The default sales invoice template included in the Invoice Manager for Excel installer program does not support this by default (at least at the time when we are preparing this invoice template), which brings many inconvenience for example such as when you are doing marketing plans. This is true even when you are providing service, such as plumbing. The good news is that, adding the support for profit calculation is easy.

You can download the finished billing template, Sales Invoice with Profit Calculation, from the download page, or download the PDF version by clicking the corresponding link at the right-hand of this page. The service version of this template, Service Invoice with Profit Calculation, which does not include the shipping address section, is also provided. We've also created a variant for each of these templates, Sales Invoice with Profit and Taxable Column, which is a sales invoice template includes the profit calculation, and also adds the "Taxable" column to the printable invoice form; and Service Invoice with Profit and Taxable Column, which is the service edition that includes both profit calculation (outside the printable invoicing form), and the taxable column (inside the printable area). All these designs and forms are providing you for free by

If you are interested in the implementation details regarding this invoicing template, read on. You may find that it could be a good sample on adding profit and taxable column to your own invoice template. The following description assumes the circumstances that we are creating this template based on the default sales invoice template. You job may differ, but as said before, you can see this as a sample on adding the profit calculation feature.

The magic of adding profit calculation depends on a powerful feature supported by all editions of Invoice Manager for Excel - Invoice Manager for Excel Standard, Invoice Manager for Excel Net and Invoice Manager for Excel Enterprise, which is called custom fields.

In order to calculate the profit, you'll need the cost figure which is either set the Product Edit form, or entered manually according to the agreement or contracts on the invoicing form when you are creating an invoice. The cost is the amount you pay the vendor for each item you purchased, equal to the "price" listed on the orders you send to your vendors. On the other hand, the price is the amount your clients or customers pay you. On the invoices that you'll send to your customers, whether they are printed hard-copy, or as electronic bill in PDF / Excel / HTML format, the cost figures will not be shown to your customers, since this column is placed outside the printable area. It is designed for your own accounting or book keeping purpose only.

Like the sales invoice template shipped with Invoice Manager for Excel, this Sales Invoice with Profit Calculation contains 5 columns on the invoice body, that are Item#, Description, Price, Quantity and Line Total. If you use Invoice Manager for Excel, the inventory of an item will be subtracted automatically when an invoice is saved - and in the meantime, an invoice# is generated automatically according to the rules you set on the Settings window. The auto-generated invoice# is titled with the label "INVOICE#" on the header of the invoice form, near the name and details of your business or company, but you can changed it to anything like "receipt#" (for creating receipts). You don't have to be a technician in order to make such modifications - simply unprotect the sheet, and then enter the label you like to replace the default text labels. However, if you are planning to create estimates or quotes, note that our invoicing software will subtract the inventory once the document is saved. There are ideas that let you easily overcome this, which will be detailed in other documents here on

Format and Specification

Template# c5060
Name Sales Invoice with Profit Calculation
Category Sales Invoice Template
Release Date Saturday, September 20, 2014
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 5
Lines 12
Line Height (Points) 19.50
Print Area $F$2:$N$44
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.

Update History

August 27, 2018

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

October 2, 2018

  • Updated the template for Invoice Manager v7.11.