Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Sales Invoice Template with Discount Amount Column. Double-click the downloaded file to extract all files.
  2. Open the template "salesdiscountamount.xls" or "salesdiscountamount-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.

Sales Invoice Template with Discount Amount Column

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

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

Sales Invoice Template with Discount Amount Column - Uniform Invoice Software V3 edition

Download Sales Invoice Template with Discount Amount Column (c6010)

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.

352 KBDownload

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

2.82 MBDownload

Detail

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.

Format and Specification

Template#c6010
NameSales Invoice Template with Discount Amount Column
CategorySales Invoice Template
Release DateMonday, December 23, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns6
Lines20
Line Height (Points)15.75
Print Area$F$2:$O$51
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates