UniformSoftware main content

Sales Invoice Template with Discount Amount Column

Template#: c6010

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
444 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Sales Invoice Template with Discount Amount Column

Detail

This sample adds a discount amount column to the default template shipped with our app.

It's common practice for many types of businesses to offer discounts. The easiest way, however, and also a flexible way, is to add the discount as a product or service item in the detail section but with a negative price or line total.

There are also special ways that are not commonly used but do work for some businesses. For example, one of our customers found a new way to use the tax cells and formulas on the default template: by naming a tax "Discount" and assigning it a negative tax rate, one of the tax fields on the bottom of the form efficiency becomes a discount field. Since Invoice Manager allows you to change the tax rate (in this example, it becomes the discount rate) on a per-invoice basis, the customer has never encountered a problem 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 separately. This requires an additional column in the item section. So, in this customized format, we have six columns within the printable range: Product ID, Description, Quantity, Unit Price, Discount, and Line Total. The "Discount" here is an amount.

Format and Specification

Template#c6010
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns6
Lines20
Line Height (Points)15.75
Print Area$F$3:$O$51
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree