Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Five Price Percentage Levels (Sales). Double-click the downloaded file to extract all files.
  2. Open the template "five-price-levels-sales-percentage.xls" or "five-price-levels-sales-percentage-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.

Five Price Percentage Levels (Sales)

Five Price Percentage Levels (Sales) (c4014)

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

Five Price Percentage Levels (Sales) - freeware edition

Five Price Percentage Levels (Sales) - freeware edition

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

Five Price Percentage Levels (Sales) - Uniform Invoice Software V3 edition

Five Price Percentage Levels (Sales) - Uniform Invoice Software V3 edition

Download Five Price Percentage Levels (Sales) (c4014)

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.

360 KBDownload

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

2.83 MBDownload


This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original template in that it uses percentage values in the price fields.

This template uses the same database structure and field definition as the original version, but changes the meaning of the fields. The 5 prices field in the original database definition are decimal (15,6) which is enough for storing a percentage value. In this implementation offered by, the first price custom field (Discount Price A) is used as the base price, and the other 4 prices (from Discount Price B to Discount Price E) are used to store discount percentage values. For example, in the sample database attached with this template, product "ABC-01" has 5 custom fields defined for prices, named from "Discount Price A" to "Discount Price E", and the values are 19.00, 0.11, 0.21, 0.31 and 0.41. If the discount level of a customer is 1 and he purchases the product "AB-01", the base price (19.00) will be applied; If the customer's discount level is 3, the discount will be 0.21 (i.e. 21%), the applied price will be 19 * (1-0.21) = 15.01.

Like all the other invoice templates in this "5 price levels" serial, the invoice body part includes only one taxable checkbox. If you check this box, all the items on the invoice form will be taxable, and if uncheck this box, the tax amount of this invoice template will be zero. If you tested the default sales invoice template shipped with Uniform Invoice Software, where each item on the invoice body has its own taxable checkbox so that you can control whether each item is taxable or not on this invoice, the calculation of taxes in this customized invoice template has been greatly simplified, as the template even ignores the "taxable" option set on each Product Edit window. This is a sample on how you can bypass the default tax calculation methods implemented by the default template and create your very own tax rules.

Like other form designs here on, Form with 5 Price Levels is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

NameFive Price Percentage Levels (Sales)
CategorySales Invoice Template
Release DateWednesday, November 13, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Line Height (Points)15.00
Print Area$H$2:$O$56
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)

Sample Templates