Sales Invoice Template with Discount Amount Column

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.