Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
The printed version.
Service Invoice Form with Discount Percentage (c5031)
c5031 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open service-invoice-form-discount-percentage-uis.xlsx.
Service Invoice Form with Discount Percentage - UIS edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
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 Uniform Invoice Software version, which allows Uniform Invoice Software creates the connection between Excel formatted invoice template and backend database.
Like other form designs here on InvoicingTemplate.com, Service Invoice Template - 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.
|Name||Service Invoice Form with Discount Percentage|
|Category||Service Invoice Template|
|Release Date||Wednesday, November 20, 2013|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||37.50|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
March 31, 2017
With this business invoice template you can assign each customer a specific discounting rate. This rate is saved with other customer information such as street address and email. On creating invoices if you choose a customer, its discount level / rate is retrieved and applied too.
This is the eighth sample of the multiple-price serial invoice templates. The template uses percentage discounts, and has no shipping fields.
This seventh sample in the multiple-price or multiple-discount serial has no shipping fields in the printable section, and the prices are set in amount (instead of percentage).
Simple Sales Invoice Template without Item Description introduces a specially invoice format layout that excludes the Description columns from the invoice form. Items on this simple invoice template are identified by product# (or item#, serial#) only.