Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Gift Invoice. Double-click the downloaded file to extract all files.
  2. Open the template "gift-invoice.xlsx" or "gift-invoice-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.

Gift Invoice

Gift Invoice (c5111)

c5111 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open gift-invoice-uis.xlsx.

Gift Invoice (UIS Edition)

Gift Invoice - UIS edition

Download Gift Invoice (c5111)

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.

350 KBDownload

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

2.80 MBDownload

Detail

If you give gifts to customers to express your gratitude for their business, you may like to show this fact on your bills and invoices too. This template addresses that by modifying the Excel formulas used for the line total cells.

This template design is based on the default template shipped with Uniform Invoice Software version 5. So it is a sales invoice template with 5 columns on the printable form and PDF gif invoices generated. For more business invoice template designs visit business invoice template here on InvoicingTemplate.com.

To create this gift invoice template, we first move out the entire "Line total" column from the printable area. This clears the format (cell font settings, colors, borders etc.). Here is the tip to quickly restore the original format settings for the moved section: drag your mouse to select entire section that you've just moved out, click the "Format Painter" button on Microsoft Excel "Home" ribbon tab; and then click the column heading cell ($K$21 in this sample). Excel copies back the format settings so that the invoice form looks exactly like the version before the "Line total" column was moved.

The next step is to assign formulas to the "Line total" column inside the printable section (Remember the "Line total" column inside the printable form is now for displaying purpose only, the actual line total values saved to database are identified by a serial of "oknLineTotal_?" names that were moved out of the printable section). For example, for the first "Line total" cell, the formula assigned looks like this:

=IF(oknProductName_1="","",
IF(oknLineTotal_1=0,"GIFT",oknLineTotal_1))

This Excel formula means that, if the "oknProductName_1" cell (i.e. the "Description" cell) is empty, the "Line total" shows empty too; otherwise, if the calculated line total is zero, it shows "GIFT"; otherwise the actual calculated amount.

Is your business giving gifts to customers when they purchase your goods? If so, you may like to show the gift on your bills. The technique described in this sample template could be applied to other templates too. If you are familiar with Microsoft Excel, this could be done within several minutes.

Like other form designs here on InvoicingTemplate.com, Gift Invoice Template 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#c5111
NameGift Invoice
CategorySales Invoice Template
Release DateFriday, March 31, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$K$46
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60

Sample Templates