BoostExcel main content

Gift Invoice

Template#: c5111

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
334 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Gift Invoice

Detail

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

To create this gift invoice template, we first move the entire "Line total" column out of the printable area.

Tip: Use Excel's "Format Painter" to quickly restore the original formats for the moved section.

Next, assign formulas to the original "Line total" column inside the printable area. For example, the first "Line total" cell inside the printable area has a formula 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, it shows the calculated amount.

Format and Specification

Template#c5111
Belongs to
Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$K$46
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60
PriceFree

Related

Magazine Subscription Invoice Thumbnail
Subscription Invoice Template (Sales) Thumbnail
Subscription Invoice Template (Service) Thumbnail
Web-hosting Invoicing Template Thumbnail
Welding Invoice Template Thumbnail
Welding and Fabrication Service Invoice Template Thumbnail