BoostExcel main content

Excel Retail Invoice Template

Template#: c5155



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.
436 KBDownload

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


The screen shot for Excel Retail Invoice Template


This Excel retail invoice template features all the fields required by a general sales invoice. In addition to that, it also has a "Discount Rate" field and a "Tax Exempt" checkbox.

The "Tax Exempt" checkbox is linked to a hidden Excel cell "oknTaxExempt". If this box is checked, the result of the tax formula should be zero. To do this, the following formula is applied:

=IF(oknTaxExempt,0,ROUND(IF(oknSubtotal=0,0,IF(oknTaxType=0,0, oknTax1Rate*(oknSubtotal+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost)))),2))

This template is designed for a lighting shopkeeper. A stringent statement of return policy is added as a footprint. Be sure to modify it according to your requirements.

Related templates:

Format and Specification

Belongs to
Format (XLS or XLSX).xlsx
Line Height (Points)16.50
Print Area$F$3:$N$42
Papaer OrientationPortrait
Default Margins (Points)


Sales Invoice Template with Discount Amount Column Thumbnail
1/2 Page Invoice Template Thumbnail
Sample Sales Invoice Template: Using Line Number Instead of Item# Thumbnail
Sales Invoice Template with Discount Percentage Column Thumbnail
Book Store Invoice Template Thumbnail
5.5 Inch X 8.5 Inch: 2 Invoices On One Template Thumbnail