Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Sales Invoice with Profit Calculation. Double-click the downloaded file to extract all files.
  2. Open the template "salesinvoiceprofit.xlsx" or "salesinvoiceprofit-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Sales Invoice with Profit Calculation

Sales Invoice with Profit Calculation (c5060)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Sales Invoice with Profit Calculation - freeware edition

Sales Invoice with Profit Calculation - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Sales Invoice with Profit Calculation - Uniform Invoice Software V3 edition

Sales Invoice with Profit Calculation - Uniform Invoice Software V3 edition

Download Sales Invoice with Profit Calculation (c5060)

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 UIS, but are looking for additional customized templates.

324 KBDownload

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

2.80 MBDownload


This sales invoice template produces exactly the same printed invoices as the default sales invoice template that is included in the Uniform Invoice Software 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 Uniform Invoice Software 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 Uniform Invoice Software - Uniform Invoice Software Standard, Uniform Invoice Software Net and Uniform Invoice Software Enterprise, which is called custom fields.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Sales Invoice with Profit Calculation uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Sales Invoice with Profit Calculation without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on, that are one freeware edition, and another edition that works only with our invoicing software installed.

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 Uniform Invoice Software, 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 Uniform Invoice Software, 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

Like other form designs here on, Sales Invoicing Template with Profit Calculation is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

NameSales Invoice with Profit Calculation
CategorySales Invoice Template
Release DateSaturday, September 20, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)19.50
Print Area$F$2:$N$44
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)

Sample Templates