Skip to main content main content

Show Word 'Free' for Gifts

 Share This Page

Show Word 'Free' for Gifts In Detail

If you are giving something to your customers for free for the goods or services purchased from you, it might be wise to list the free items on the invoices and state the fact clearly by displaying the word 'Free' or 'Gift' on the free items. This sample invoice template implement this by moving the actual price and line total columns outside the print area, and then on the invoice body use Excel formulas to check whether the current price and line total is zero - if it is, the formula shows the word 'Free'; if it isn't, the price and line total are shown as usual.

The sample invoice template demonstrates the advantage of using Excel-template based invoicing. For example, Excel formula allow you to do calculations based on the value shown on the invoice template; and, by creating the range name for the print area, you can easily define what to print on the invoices. All these features combined together, makes it possible to customize the sample invoice template to create your very own invoice creator to meet your special business needs - sometimes this could be very difficult even with those complicated invoicing solutions or accounting systems.


Show Word 'Free' for Gifts - Screenshots

Tip: Enlarge an image by clicking on it.

Show Word 'Free' for Gifts - printed document

Show Word 'Free' for Gifts

This is how show word 'free' for gifts will look like when you open it with Microsoft Excel.

Show Word 'Free' for Gifts - freeware edition

Show Word 'Free' for Gifts freeware version

The following Uniform Invoice Software version of Show Word 'Free' for Gifts should be used with Uniform Invoice Software installed.

Show Word 'Free' for Gifts - Uniform Invoice Software edition

Show Word 'Free' for Gifts for Uniform Invoice Software

Download Show Word 'Free' for Gifts


Download show word 'free' for gifts

Choose the format you like and download Show Word 'Free' for Gifts for free.

Uniform Invoice Software

Upgrade show word 'free' for gifts

Make Show Word 'Free' for Gifts a powerful invocing program.

Show Word 'Free' for Gifts PDF document

PDF Show Word 'Free' for Gifts

Show Word 'Free' for Gifts in PDF format.

Use Show Word 'Free' for Gifts with Uniform Invoice Software

Integrate Show Word 'Free' for Gifts with Uniform Invoice Software

Find out how to use Show Word 'Free' for Gifts with Uniform Invoice Software

Show Word 'Free' for Gifts Related Templates

Excel icon

Commercial Invoice Template

Commercial Invoice Template offers a blank commercial invoice form that helps you create commercial invoice, bill of sale or receipt in an intuitive way. The commercial invoice template contains required information for a Customs and Border Protection (CBP) Officer to determine if the goods being imported are admissible, and if so, what the correct Harmonized Tariff Schedule (HTS) classification and rate of duty should be.

Excel icon

Template with Line Number on Invoice Body

The sample invoice template here differs from the other invoice templates available here on in that it does not use 'Product ID' or 'Item #'. Instead, if you fill in an item description on a line, it shows the line number of the current line; but if the description is not filled in, it shows nothing in the field. All this is implemented by using a simple Excel formula.

Excel icon

Template with Discount Percentage Column

The discount column on the invoice body are titled with '%Discount'. As you can see, the discounts you entered here are formatted and seen as percentags. For example, if quanity is 10, unit price is 20, '%Discount' is 5, then the line total is 190. All the calculations within the free invoice template are done with Excel formulas. You may also like to see: Template with Discount Amount Column and Template with Discount Column without Client.

Excel icon

VAT Invoice (Price Excluding Tax)

This vat invoicing template has 7 columns, "Description", "Price (excluding VAT)", "Quantity", "Total (Net)", "VAT", "Total (VAT)". The invoicing template is designed for the situation where prices include VAT tax. You specify VAT rate on the bottom of the invoice form. The amount of VAT of each invoicing item is calculated automatically and listed on the invoice body too.

Excel icon

Holland Clothing Invoice Template

The most interesting part of this invoice template is that how the template translate address the Holland format - the template allows you to enter the client address information (both the 'Bill To' and 'Ship To' addresses) in 'City (State) ZIP' format, and then transform it into 'ZIP CODE space City' format, for example '567 AA Amsterdam'. The transformation is done automatically with Excel formula. Another point to notice about this invoice template is that the invoice body has 6 columns - since this invoice template is designed for clothing-related business, a 'Size' (Maat) column is necessary - and usually important enough to list it as a dedicated column.

Excel icon

Cosmetic Clinic Invoice Format

This invoice format is designed for small cosmetic clinics that offers non-surgical cosmetic service, and offers a variety of anti-aging skin rejuvenation treatments in safe experienced medical hands. The invoice template includes fields that are designed specially for this business type. For example, on the top of the invoice form you could find the fields such as 'Patient', 'Shade', 'Booked In', etc.