BoostExcel main content

Gift Invoice

Template#: c5111



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.


The screen shot for Gift Invoice


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:


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

Belongs to
Format (XLS or XLSX).xlsx
Line Height (Points)18.00
Print Area$D$3:$K$46
Papaer OrientationPortrait
Default Margins (Points)


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