Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
The printed version.
Sales Invoice Template with Discount Amount Column (c6010)
This is how the template looks like when you open the freeware template in Microsoft Excel.
Sales Invoice Template with Discount Amount Column - freeware edition
The following template was designed for Uniform Invoice Software version 3.
Sales Invoice Template with Discount Amount Column - Uniform Invoice Software V3 edition
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.
Download this if you want this design to be set as the default template by the installer program.
Sales Invoice Template with Discount Amount Column is a sample invoice template that adds a discount amount column to the default sales invoice template shipped with Uniform Invoice Software.
It's common practice to show discounts on invoices in many types of businesses. The easiest way, however, and also a flexible way, is to add the discount as a product or service item on the invoice body but with negative price or line total.
There are also special ways that are not commonly appliance but do work for some business. For example, one of our customers found a new way to use the tax cells and formulas on the default sales invoice template - by naming a tax "Discount" and assigning it a negative tax rate, one of the tax field on the bottom of invoice form efficiency becomes a discount field. Since Uniform Invoice Software allows to change the tax rate (in this example it becomes discount rate) on a per-invoice basis right on the bottom of the invoice form, the customer had never encountered a problem in applying discounts in this way.
What if you need to show discounts in a more detailed manner? For example, show discounts applied to each item on invoice body separately? This requires an additional column on the invoice body, as compared to the 5 columns on the default sales invoice template that shipped with the setup program of Uniform Invoice Software. So in this customized sample invoice template - Sales Invoice Template with Discount Amount Column, we have 6 columns on the invoice body within the printable invoice body: Product ID, Description, Quantity, Unit Price, Discount, and Line Total. The "Discount" here is an amount value. We'll publish the percentage version of this sample invoice template here on InvoicingTemplate.com in the near future.
Like all the other sample invoice templates here on Invoicing Templates, Sales Invoice Template with Discount Amount Column is also created from the default sales invoice template shipped with Uniform Invoice Software. In order to create this 6-column invoice layout, we need to adjust the existing 5-column invoice layout to leave space for the additional column.
To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Sales Invoice Template with Discount Amount Column, we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening Sales Invoice Template with Discount Amount Column as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this Sales Invoice Template with Discount Amount Column.
Please download the Sales Invoice Template with Discount Amount Column for free to see how it differs from the default sales invoice template shipping with Uniform Invoice Software. A PDF version of this Sales Invoice Template with Discount Amount Column is also available for free.
Like other form designs here on InvoicingTemplate.com, Sales Template with Discount Amount Column 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.
|Name||Sales Invoice Template with Discount Amount Column|
|Category||Sales Invoice Template|
|Release Date||Monday, December 23, 2013|
|Format (XLS or XLSX)||.xls|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||15.75|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
Simple Sales Invoice Template without Item Description is a variant of Simple Service Invoice Template without Item Description. It differs from the original invoice format by including shipping fields inside the printable invoice form.
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.
Basic Sales Invoice Template (Light Blue) is a slightly modified version of the standard Excel sales template shipped with Uniform Invoice Software installer program. The main features include a "Bill To" section, a "Shipping To" section, 3 columns on invoice body, no sales tax.