InvoicingTemplate.com main content

Screenshots and Images

The printed version.

Service Invoice with Discount Amount

Open the template in Excel.

Service Invoice with Discount Amount (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.

463 KBDownload

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

5.80 MBDownload

Detail

Service Invoice with Discount Amount (c4024) is a customization sample and variant of Service Invoice with Discount Percentage (c4005). The modifications to the original Excel service invoice template is that the discount percentage field is now redefined as an amount field.

When the discount field is a percentage, the total is calculated with an Excel formula like " =ROUND(IF(oknInvDiscount=0,oknSubTotal,oknInvDiscount*oknSubTotal),2)". In this Service Billing Form with Discount Amount, since the discount is an amount, the total is now calculated with an Excel formula like " =ROUND(oknSubTotal-oknInvDiscount,2)".

As we can see from this example, Invoice Manager for Excel allows you to add new fields to all the main database tables (as well as the Excel invoicing forms), since the templates are in Microsoft Excel spreadsheet format, it is also possible to create or define the relationship between new fields and existing fields. The use of discount field is just a simple example. More complex features that are not found in the existing Excel invoice templates can also be added, such as Free Five Price Percentage Levels, and Mixed Tax Rates in an Invoice. You can find more samples by browsing our categories and search pages here on InvoicingTemplate.com.

This free invoice template is a service invoice template, meaning that there is no fields defined for shipping address information.

If you are using Excel Invoice Manager, i.e. the previous version of Invoice Manager for Excel, you might be already familiar with the concept of custom fields. However, custom fields in Invoice Manager for Excel are much easier to work with. For example, with Invoice Manager for Excel now the Custom Field Manager can be opened directly from all the main data list windows.

Format and Specification

Template#c4024
NameService Invoice with Discount Amount
CategoryService Invoice Template
Release DateSunday, May 18, 2014
Format (XLS or XLSX).xlsx
Columns4
Lines12
Line Height (Points)19.50
Print Area$G$1:$P$44
Papaer Size / OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

August 27, 2018

  • This template was updated to be compatible with UIS 6.

November 24, 2018

  • Changed the field type of "InvDiscount" from decimal(6,3) to decimal(12,3).

Samples

Screenshot for Service Bill with Discount Percentage

Service Bill with Discount Percentage

Screenshot for Plumbing Service Invoice Template (Landscape)

Plumbing Service (Landscape)

Screenshot for Plumbing Service Invoicing Sample (Sales Tax)

Plumbing Service (Sales Tax)

Screenshot for Plumbing Contractor Invoice Template (Landscape)

Plumbing Contractor (Landscape)

Screenshot for Plumbing Contractor Invoice Template

Plumbing Contractor

Screenshot for Netherlands Service Bill Sample

Netherland (Service)

Screenshot for Netherlands Service Invoice Template 2

Netherland (Service) 2

Screenshot for Engineering Service Billing Sample

Engineering Service Billing Sample

Screenshot for VAT Service Invoice Template - Price Including Tax

VAT Service - Price Including Tax

Screenshot for VAT Service Invoice Template - Price Excluding Tax

VAT Service - Price Excluding Tax

Screenshot for Auto Repair Invoicing Sample (2)

Auto Repair (2)

Screenshot for Print Shop Bill Sample

Print Shop

Screenshot for Medical Invoice Template (2)

Medical (2)