BoostExcel main content

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

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

Sales

Format (XLS or XLSX).xlsx
Columns6
Lines20
Line Height (Points)15.00
Print Area$F$3:$O$52
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00USD)

Related

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