Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

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

Five Price Levels (Sales, Amount) (c4012)

c4012 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open five-price-levels-sales-amount-uis.xlsx.

Five Price Levels (Sales, Amount) (UIS Edition)

Five Price Levels (Sales, Amount) - UIS edition

Download Five Price Levels (Sales, Amount) (c4012)

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.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

316 KBDownload

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

2.82 MBDownload

Detail

Built specially for Uniform Invoice Software users, it supports 5 levels of prices or discounts - that is, you can define 5 prices for each invoicing item, and then assign level number from 1 to 5 for each customer.

It's common business practice to give certain customers, such as returning customers or VIP customers, a discount. You may even expect the ability from an invoicing system that makes it possible to give different levels of discount depending on the types of a customer. for example, in the cosmetic business it is common to define several levels of discounts. The default invoice template shipped with Uniform Invoice Software does not support this. However just like many other features that are not directly supported by the default invoice template - because every business is different, thus it is not possible to create one invoice template to make it suitable for every business type - customizing the template to create such a feature is possible and easy with Uniform Invoice Software. This is not a magic. The secret behind this is that Uniform Invoice Software combines the powerful of a backend database and a front end Excel spreadsheet, leveraging the power of the two mature platforms.

With this customization applied, the "invoice form with 5 price levels (sales)" invoice template here on InvoicingTemplate.com allows you to define 5 prices for each product. When creating an invoice, Uniform Invoice Software shows both base and discounted price per item on invoice form whenever you choose a product. For each customer, you can assign it a discount level, ranging from 1 to 5. When you pick up a customer, Uniform Invoice Software will apply the correct price based on the discount level of the customer.

The discount level number of a customer and the discounted prices of the selected invoicing items, although appear on the invoice form when you create an invoice, they will not be included in the printed hard copy of an invoice or the extracted invoice that you sent to your customer. This happens because all these fields are placed outside the printable area, which is the area that will get printed when you issue the "Print" command in Excel.

This invoice template has shipping fields included so it is more suitable for creating sales invoices. If you are looking for a service version, see Form with Five Price Levels (Service, Amount).

The prices in this template are defined as amount value. For the editions that support discount percentage, see Form with Five Price Percentage Levels (Sales) and Form with Five Price Percentage Levels (Service).

As we are working on these invoice templates that support multiple-level of prices to be published on InvoicingTemplate.com, an accountant working for a cosmetic company states that while it is true that a cosmetic company needs several levels of prices, an additional column "Color" on the invoice body is also highly recommended. To fulfill this requirement, and to provide more samples for InvoicingTemplate.com users and Uniform Invoice Software users, we created the cosmetic-version of these invoice templates that support 5 price levels, including: Form with Five Price Levels (Sales, Amount, Custom Column), the cosmetic-version of 5 prices invoice template that includes shipping fields and prices and discounts are in amount; Form with Five Price Levels (Service, Amount, Custom Column), the cosmetic-version of 5 prices invoice template that has no shipping fields and prices and discounts are in amount; Form with Five Price Percentage Levels (Sales, Custom Column), the cosmetic-version of 5 prices invoice template that includes shipping fields and prices and discounts are in percentage; Form with Five Price Percentage Levels (Service, Custom Column), the cosmetic-version of 5 prices invoice template that has no shipping fields and prices and discounts are in percentage.

Like other form designs here on InvoicingTemplate.com, 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 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4012
NameFive Price Levels (Sales, Amount)
CategorySales Invoice Template
Release DateMonday, November 11, 2013
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns4
Lines30
Line Height (Points)15.00
Print Area$H$3:$O$57
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left18.00
Right18.00
Top73.70
Bottom73.70

Update History

January 2, 2017

  • Clean up "Taxable" boxes, assuming all items on the invoicing templates are taxable.
  • Change Excel workbook file format from ".xls" to ".xlsx".
  • Use Excel themed colors.

Sample Templates