How to Use
Assuming you have downloaded and installed Uniform Invoice Software:
- Download Five Price Percentage Levels (Service, Custom Column). Double-click the downloaded file to extract all files.
- Open the template "five-price-levels-service-percentage-custom.xls" or "five-price-levels-service-percentage-custom-uis.xlsx" with Microsoft Excel.
- Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
- Enter your business information and replace the default logo image to make it your own. (How?)
- Click "Design Mode" again to exit design mode.
- 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 (Service, Custom Column) (c5030)
This is how the template looks like when you open the freeware template in Microsoft Excel.
Five Price Percentage Levels (Service, Custom Column) - freeware edition
The following template was designed for Uniform Invoice Software version 3.
Five Price Percentage Levels (Service, Custom Column) - Uniform Invoice Software V3 edition
Download Five Price Percentage Levels (Service, Custom Column) (c5030)
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 UIS, but are looking for additional customized templates. | 366 KB | Download |
Download this if you want this design to be set as the default template by the installer program. | 2.83 MB | Download |
Detail
This is the eighth sample of the multiple-price serial invoice templates. The template uses percentage discounts, and has no shipping fields.
Just like the other service invoice templates available here on InvoicingTemplate.com, this invoice form with 5 price percentage levels (service, cosmetic) was created from the sales invoice template by moving all the shipping fields out of the printable area. The printable area is the white area on the center of the "Invoice" worksheet, which is section that is printed when you execute the "Print" command in Excel. It is also the section that is extracted when you execute the "Extract" command in Uniform Invoice Software.
Moving the location of a cell or field is easy in Excel. To do this, you first unprotect the sheet (if the sheet is protected), and then select all the cells or fields you want to move, and then drag the border of the selected area to move it to the new location. If you need to move an Active X control, such as the "select a shipping address" icon button, you first need to switch to design mode, and then click and drag the icon button to the new location - in this case, outside the printable area.
After moving out the "Shipping Date" field, you may like to expand the size of the neighboring fields to make the layout organized. This is done by expanding the Terms label and field. Expanding the "Terms" label is done by first selecting the original terms cell and the empty cells left by moving out the "Shipping Date" field, and then execute the "Merge and Center" command on Excel ribbon tab. To do this for the Terms field, you first need to move the original Terms cell to the first (left-most) cell of the empty space, and then select all the cells you want to merge, and then execute the "Merge" command.
This invoice template has the "Color" column on the invoice body, which is defined as a custom field. For more information on the purpose and usage of custom fields, please refer to the documents included Uniform Invoice Software, which you can download for free and within the trial period it is fully functional.
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# | c5030 |
| Name | Five Price Percentage Levels (Service, Custom Column) |
| Category | Service Invoice Template |
| Release Date | Monday, November 18, 2013 |
| Format (XLS or XLSX) | .xls |
| Excel Version | Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 |
| Feature Gallery | |
| Columns | 5 |
| Lines | 30 |
| Line Height (Points) | 15.00 |
| Print Area | $H$2:$O$56 |
| Printable with Papaer Size / Orientation | A4 (210 mm x 297 mm) - Portrait |
| Default Margins (Points) | |
| Left | 18.00 |
| Right | 18.00 |
| Top | 73.70 |
| Bottom | 73.70 |
Sample Templates
This sample Excel invoice template demonstrates how to do special customer pricing based on customer values / types. By default this form design classifies clients as Distributor, Wholesale, Retail, individual and Special categories.
Five Price Levels (Sales, Amount)
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.
Five Price Levels (Service, Amount)
This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original one in that it is service-oriented, i.e. it has no shipping fields.
Five Price Percentage Levels (Sales)
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.
Five Price Percentage Levels (Service)
This is a variant of 5 Price Levels (Sales, Amount). It is suitable for service business as it moves out all the shipping-related fields.
Five Price Levels (Sales, Amount, Custom Column)
This sample of customizing invoice templates is named with the keyword "cosmetic". A new column "Color" was added to meet the requirements of the cosmetic business.
Five Price Levels (Service, Amount, Custom Column)
This seventh sample in the multiple-price or multiple-discount serial has no shipping fields in the printable section, and the prices are set in amount (instead of percentage).
Five Price Percentage Levels (Sales, Custom Column)
As the name of this invoice template implies, it is a sales invoice template that has shipping information inside the printable range on the invoice form, and the prices or discounts are in percentage.
Drop-down List for Multiple Price Levels
The template c5009 offers a sample for creating a sales invoice template that supports multiple price levels. This invoice template c5113 is an updated version of c5009. Here we implement a drop-down list for you to choose a price level on creating invoices.
Service Invoice Form with Discount Amount
This template includes a Discount field in the bottom of the form, allowing you to specify the discount in amount. The service invoice template includes no shipping field.
Service Invoice Form with Discount Percentage
This service invoice template is a variant of Service Invoice Form with Discount Amount. The template redefined several Excel formulas so the Discount field becomes a percentage value.
Sample Service Invoice Template: Fixed Items
Sample Service Invoice Template: Fixed Items is a variant of Sample Sales Invoice Template: Fixed Items. It is the service edition of the original one.
Service Credit Note Template is a variant of Credit Note Template. It differs from the original one by moving all shipping fields out of the printable credit note form, making the template more suitable for service business.
Invoice with Previous Balance (Service)
This is a service invoice version of Invoice with Previous Balance (Sales). It differs from the original version by moving all shipping-related fields out of the printable invoice.