BoostExcel main content

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.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

607 KB Download

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

6.29 MB Download

Screenshots and Images

The printed version.

Sales Invoice Template with Discount Amount Column

Open the template in Excel.

Sales Invoice Template with Discount Amount Column (IMFE Edition)

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 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

Template# c6010
Name Sales Invoice Template with Discount Amount Column
Category Sales Invoice Template
Release Date Monday, December 23, 2013
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 6
Lines 20
Line Height (Points) 15.75
Print Area $F$3:$O$51
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 22.68
Right 22.68
Top 45.35
Bottom 45.35
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Update History

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