BoostExcel main content



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

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


Bill Format for Lamp and Lighting Business


This form is designed for specialists in lamps, bulbs, and tubes for many hi-tech and specialized applications.

This template is designed with a UK business in mind, so the layout meets the requirements of a UK VAT invoice. For example, below your business detail section, a "VAT Registration #" label was added.

This template is designed for A4 paper in landscape orientation.

The "Due Date" field has an Excel formula assigned:

=IF(oknPaymentTerm="Net 30", DATE(YEAR (oknInvoiceDate), MONTH (oknInvoiceDate) +2,0), oknInvoiceDate )

This formula means that if "oknPaymentTerm" equals "Net 30", the "Due Date" will be the end date of the next month to the invoice date; giving any other value to "oknPaymentTerm" causes the "Due Date" to be the invoice date. The "oknPaymentTerm" cell in the above formula is placed outside the printable area.

This sample uses a number of custom fields, such as "Order Received Date", "Weight", "Packages", and a custom column on the detail section "SC" (Support Code).

Format and Specification

Belongs to


Format (XLS or XLSX).xlsx
Line Height (Points)15.00
Print Area$F$3:$P$37
Papaer Size / OrientationLandscape
Default Margins (Points)
PriceFree (0.00USD)


Lightweight Service Invoice Template
Basic Sales Invoice Template (Light Blue)
Simple Lightweight Service Invoice
Lightweight Sales Invoice Template
Lightweight Proforma Invoice Format