Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Simple Sample - Adding Discount Column. Double-click the downloaded file to extract all files.
  2. Open the template "simple-sample-discount-column.xlsx" or "simple-sample-discount-column-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Simple Sample - Adding Discount Column

Simple Sample - Adding Discount Column (c4061)

c4061 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-sample-discount-column-uis.xlsx.

Simple Sample - Adding Discount Column (UIS Edition)

Simple Sample - Adding Discount Column - UIS edition

Download Simple Sample - Adding Discount Column (c4061)

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 UIS, but are looking for additional customized templates.

302 KBDownload

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

2.78 MBDownload

Detail

To give customers detailed discount information for each sales / service item on their bills and invoices, you need a "Discount" column on the invoice layout. This template demonstrates how to add the column to an existing invoice format.

By adding the "Discount" column, we meant not only re-design the Excel spreadsheet form so that it has an additional column, by also make the newly added column work with Uniform Invoice Software -- i.e. when you click the "Save Invoice" button, the content on the "Discount" column should also be saved along with each invoicing item; if "Clear & New" command is clicked, the "Discount" column should get cleared too. This is implemented by using custom fields (user-defined fields) in Uniform Invoice Software.

We've already released several templates here on InvoicingTemplate.com that are focused on discounting. For example, this tutorial is based on the result template built in Simple Invoice Template - Discount Amount Field that demonstrates how to add a discount amount field to the bottom of the billing form. And, there are also bill / receipt designs that offer discount column, such as Sales Invoice Template with Discount Amount Column and Sales Invoice Template with Discount Percentage Column. There are also samples on uniformsoft.com, at Template with Discount Amount Column, and on office-kit.com, at Invoice Template with Discount Column. All these templates works with Uniform Invoice Software well.

This tutorial differs from others in that it focus on the steps that we followed to add the "Discount" column. The basic template that we used as the origin and starting point of this tutorial already has a "Discount" field added, which is a manually fillable custom field. After adding the "Discount" column, we'll also use Excel formula for automated calculation of discount amount.

Let's see how to add the new column, step by step.

  1. First, back up the Excel invoice template and database file. In this sample, we'll need to modify the database, so creating a backup of the database is necessary.
  2. Open the template.
  3. Push down the "Design Mode" button on the "Invoice" ribbon tab.
  4. This is not a required step - but you may like to try it. Go to Excel "Page Layout" tab. In the "Themes" group, click to open the "Colors" list, choose "Blue".

    As you can see, the whole invoice form now has a new color theme now. Like the themes feature in Microsoft Word, this is the quick and best (easy) way to change the look & feel of the form.

  5. Drag your mouse to select all cells on the "Description" column, including the heading, ranging from $D$21 to $D$33. Click the "Merge and Center" button on Excel "Home" ribbon tab. This unmerges all the cells on the "Description" column.
  6. Drag your mouse to select all the cells on the "Quantity" column, including the heading, ranging from $I$21 to $I$33. Push the mouse key on the border of the selected area. Without releasing the mouse key, move the entire selected area on column left (Destination: $H$21:$H$33).
  7. Now select the entire "Unit Price" column, including the heading. Drag the select area one column left. The new location of the "Unit Price" column is now $I$21:$I$33.
  8. With the new "Unit Price" column still selected, click the "Format Painter" button on Excel "Home" ribbon tab.
  9. Click the first empty cell left by moving out the "Unit Price" column, i.e. $J$21. This applies the format of the "Unit Price" column to the empty column.
  10. Drag your mouse to select all the cells on the empty column, except the heading cell, ranging from $J$22 to $J$33. Right-click one of the selected cell, choose "Format Cells" from the shortcut menu. On the "Format Cells" dialog box, go to the "Protection" tab, make sure the "Locked" property is cleared. Click OK to close the dialog box. This makes sure that the "Discount" column is manually fillable when the sheet is protected.
  11. Click to select heading cell of the empty column, i.e. $J$21. Enter the column heading text "Discount".
  12. Name the following empty cells. The names should be "oknItemDiscount_1" ($J$22), "oknItemDiscount_2" ($J$23), "oknItemDiscount_3" ($J$24) ... "oknItemDiscount_12" ($J$33).
  13. Drag your mouse to select all the cells on the "Description" heading, ranging from $D$21 to $G$21. Click "Merge and Center" on Excel "Home" ribbon tab.
  14. Repeat the above step for each line of the "Description" field. For example, select $D$22:$G$22, click "Merge and Center"; select "$D$23:$G$23", click "Merge and Center", and so on. If you are very familiar with Microsoft Excel, you can also use "Format Painter" to speed up the processing of merging.
  15. Select all the "Description" cells, ranging from $D$22 to $G$33. Click "Align Left" icon button in the "Alignment" group on Excel "Home" ribbon.

    Click to select the "Discount (Amount)" cell, $K$35. Enter a formula for this cell, "=sum (J22:J33)". Right-click the same cell $K$35 again, and choose "Format Cells" from the dialog box. Go to the "Protection" tab, checked the "Locked" property. This makes sure that the cell is not manually fillable once the sheet is protected.

  16. Now we need to create the definition of the custom field "ItemDiscount" in the database. To do this, we need to use the "Custom Field Manager" provided by Uniform Invoice Software. In order to use this tool, we have to first exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon.
  17. Click "Invoices" on the ribbon.
  18. Click "Custom Fields".
  19. From the "Database table" list, choose "Invoice Body".
  20. Click "Add Field".
  21. Enter the field definition as follows - Name: ItemDiscount; Type: Decimal; Precision: 10; Scale: 2.

    The map between an Excel cell and a database field is established by using names. For the invoice body section, all "oknItemDiscount_*" fields are mapped to the "ItemDiscount" field defined in the "Invoice Body" database table. That is, a cell should be named with "okn + Database Field Name", where we call "okn" is a prefix of the cell name.

  22. Save the template by clicking the "Save" button on Excel quick access toolbar.
  23. Now you can test the template to see if it works in the way met our plan.

Giving discounts to customers / clients is a common practices in many businesses, for example It is common for attorney / legal, medical, catering, restaurant, law firms (whether small or big), health insurance billing or statement / timesheet, car / vehicle sales, graphic designs, freelance, plumbing, marketing, business plans, accounting, house rent (yearly or monthly), or even home businesses for monthly bill.

This sample does not change the tax settings implemented with the base template. It still has GST and PST taxes set on the bottom of the form. So this is a GST-compliant tax invoice template. If you need to change the tax settings, click the "Settings" button on the "Invoice" ribbon tab, and then go to the "Taxes" tab where you can find the overview of all tax settings.

Like other form designs here on InvoicingTemplate.com, Simple Invoicing Sample - Discount Column 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#c4061
NameSimple Sample - Adding Discount Column
CategorySales Invoice Template
Release DateSunday, February 7, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$47
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left29.52
Right29.52
Top52.20
Bottom52.20

Sample Templates