InvoicingTemplate.com main content

Screenshots and Images

The printed version.

Service Invoice Form with Discount Percentage

Open the template in Excel.

Service Invoice Form with Discount Percentage (IMFE Edition)

Download

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

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

679 KBDownload

Download this if you want this design to be set as the default template by the installer program.

5.81 MBDownload

Detail

This service invoice template is a variant of Service Invoice Form with Discount Amount. The template redefined several Excel formulas so the Discount field becomes a percentage value.

In the original implementation that could be found at Service Invoice Form with Discount Amount, the discount field is an amount value, which is deducted from the subtotal of an invoice by using Excel formula. With this customized invoice template, we modified the formula of the "discounted subtotal" cell to be "Subtotal * (1 - Discount Percentage)". This way, the discount value saved along with other customer information becomes a discount percentage value.

Besides modifying the formula, you'll also need to set the format of the discount cell to show as a percentage. To do this, first unprotect the Invoice worksheet by clicking the Unprotect Sheet command on the Review ribbon tab, and then right-click the Discount cell on the bottom of the invoice form 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. Feel free to browse the other options available on the Format Cells dialog box, you may find it helps you a lot when you try to customized the invoice template to create your own style and layout.

The freeware version of Service Invoice Form with Discount Percentage invoice template does help you create professional and beautiful invoices with its intuitive form layout, and printing a hardcopy of an invoice is also as easy as issuing the Print command in Excel. However a pure Excel invoice template is a simple invoice creator or invoice generator, because it lacks the ability to manage customers, products, invoices and payments. To fulfill these types of business requirements, upgrade the pure-Excel invoice template to Invoice Manager for Excel version, which allows Invoice Manager for Excel creates the connection between Excel formatted invoice template and backend database.

Format and Specification

Template#c5031
NameService Invoice Form with Discount Percentage
CategoryService Invoice Template
Release DateWednesday, November 20, 2013
Format (XLS or XLSX).xlsx
Feature Gallery
Columns5
Lines8
Line Height (Points)37.50
Print Area$F$3:$N$45
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

March 31, 2017

  • "Century Gothic" font style.
  • Support for Uniform Invoice Software version 5.

May 14, 2019

  • Added simple usage instruction to the items section.

Samples

Screenshot for Service Invoice Form with Discount Amount

Discount Amount

Screenshot for Sales Invoice Form with Discount Amount

Discount Amount (Sales)

Screenshot for Sales Invoice Form with Discount Percentage

Discount Percentage (Sales)

Screenshot for Business Invoice with Customer-Specific Discounting

Per-Customer Discounting

Screenshot for Customer Value Based Pricing

Customer Value Based Pricing

Screenshot for Five Price Percentage Levels (Service, Custom Column)

Five Price Percentage Levels (Service, Custom Column)

Screenshot for Sample Service Invoice Template: Fixed Items

Fixed Items (Service)

Screenshot for Five Price Levels (Service, Amount, Custom Column)

Multiple Price Levels

Screenshot for Service Credit Note Template

Service Credit Note Template

Screenshot for Five Price Percentage Levels (Service)

Five Price Percentage Levels (Service)

Screenshot for Five Price Levels (Service, Amount)

Five Price Levels (Service, Amount)

Screenshot for Simple Service Invoice Template without Item Description

Simple Service Sample without Item Description