You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
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 Invoice Manager for Excel.
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 Invoice Manager for Excel 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 Invoice Manager for Excel. 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 Invoice Manager for Excel. 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.
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 Invoice Manager for Excel. A PDF version of this Sales Invoice Template with Discount Amount Column is also available for free.
Format and Specification
|Name||Sales Invoice Template with Discount Amount Column|
|Category||Sales Invoice Template|
|Release Date||Monday, December 23, 2013|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
February 8, 2018
- Added several lines of sample data to the detail section to show how the discount amount formulas work.
- Added bottom lines to all the fields in both the "Bill To" and "Ship To" section.
- Replaced all ActiveX checkboxes with Excel form controls. Each taxable checkbox is linked to a hidden cell.
- Changed the default tax names to "State Tax" and "Local Tax".
May 24, 2019
- Updated reports