Skip to main content
InvoicingTemplate.com main content

Five Price Percentage Levels (Sales) - 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

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

Without database file. How to download and use

95 KBDownload

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

366 KBDownload

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

2.84 MBDownload

Detail

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 InvoicingTemplate.com, 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 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 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4014
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
Columns4
Lines30
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)
Left18.00
Right18.00
Top73.70
Bottom73.70