BoostExcel main content

Service Invoice Form with Discount Percentage

Template#: c5031

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

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

Screenshot

The screen shot for Service Invoice Form with Discount Percentage

Detail

This is a variant of the Service Invoice Form with Discount Amount (c5011). The template redefined several Excel formulas so the Discount field became a percentage value.

In this form, we modified the formula of the "discounted subtotal" cell as follows:

= Subtotal * (1 - Discount Percentage)

This way, the discount value becomes a discount percentage value.

Besides modifying the formula, the format of the discount cell should also be updated to show percentage values. To do this, first switch to design mode, and then right-click the Discount cell and choose Format Cells. On the Number tab of the Format Cells dialog box, you can set the format of the discount cell to be a percentage value.

Format and Specification

Template#c5031
Belongs to
Format (XLS or XLSX).xlsx
Columns5
Lines8
Line Height (Points)37.50
Print Area$F$3:$N$45
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree

Related

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