Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Service Bill with Discount Percentage

Service Bill with Discount Percentage (c4005)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Service Bill with Discount Percentage - freeware edition

Service Bill with Discount Percentage - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Service Bill with Discount Percentage - Uniform Invoice Software V3 edition

Service Bill with Discount Percentage - Uniform Invoice Software V3 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

Without database file. How to download and use

36 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

291 KBDownload

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

2.79 MBDownload

Detail

Service Bill with Discount Percentage is a sample invoicing template that demonstrates how to use custom fields to add new features to the default Excel invoice template shipped with Uniform Invoice Software. There are 3 custom fields added to this template - Company Name, Fax# and Discount Percentage.

Note: Feel free refer to c4105 Service Invoice with Horizontal Logo, which has a similar layout, a horizontal logo image, and detailed customization steps.

The Company Name and Fax# are custom fields that are added to both the Customer and "InvHdr" database tables. Discount Percentage is a custom field that is added to only the "InvHdr" database table.

By adding the Company Name custom field to both the Customer and "InvHdr" database tables, Service Bill with Discount Percentage makes the newly added field work like the other standard fields, such as the customer billing address.

The Discount Percentage field of Service Bill with Discount Percentage is added to the "InvHdr" database tables only. This means that, unlike the Company Name field which is added to the Customer database table too, a discount value will not be filled in automatically when you pick up a customer on creating an invoice. If you want to be able to define a default discount percentage value for each customer and have the discount percentage reloaded each time you pick up a customer, you can easily implement this feature by adding the discount percentage field to the Customer database table.

Note that after adding a custom field to the proper place on the invoicing form, you should unlock the cell to make it editable when the billing template is protected.

Service Bill with Discount Percentage defines no taxes on the billing form, but the tax cells and fields found in the default sales invoice template shipped with UIS are still there.

For a variant of this Excel spreadsheet template where the discount field is defined as an amount value, see Service Bill with Discount Amount.

Like other form designs here on InvoicingTemplate.com, Service Billing Form with Discount Percentage is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4005
NameService Bill with Discount Percentage
CategoryService Invoice Template
Release DateSaturday, May 17, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
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