BoostExcel main content

Sales Invoice Template with Discount Percentage Column

Template#: c6011

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.
353 KBDownload

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

Screenshot

The screen shot for Sales Invoice Template with Discount Percentage Column

Detail

This is a variant of the Discount Amount Column (c6010). It differs from the original one by changing the discount amount field to a percentage field.

In the original version, the line total formula looked like this:

=Unit Price * Quantity - Discount

To apply a percentage discount, the formula is changed to this:

=Unit Price * Quantity * (1- Discount Percentage)

Format and Specification

Template#c6011
Belongs to
Format (XLS or XLSX).xlsx
Columns6
Lines20
Line Height (Points)15.00
Print Area$F$3:$O$52
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree

Related

Sales Invoice Template with Discount Amount Column Thumbnail
Simple Sample: Discount Amount Field Thumbnail
Business Invoice with Customer-Specific Discounting Thumbnail
Service Bill with Discount Percentage Thumbnail
Service Invoice with Discount Amount Thumbnail