BoostExcel main content


invoice date

What is Invoice Date? According to, "(invoice date is) usually the date when goods are shipped. Payment dates are set relative to the invoice date."

According to, The date marked on a due bill or a purchase record which represents the date of purchase or services rendered. It is also the date from which the timeframes for shipment and payment are determined. "The date on which an invoice for a good is issued, which is usually the same day the good is sent to the buyer. Payment is due a certain number of days after the invoice date. "

Almost all templates here on has the "Invoice Date" cell put inside the printable area. The cell name (range name) is "oknInvoiceDate", which is cleared when you click the "Clear & New" button. If it is left blank when you click "Save To DB" or "Save Invoice", it is filled with current date automatically.

Here are our templates closely related to Invoice Date Definition.

Invoice with Date Column
Template with Date Column

Moving cell or cells, or even an entire column, is easy and quick as Excel provides handy tools for you. To do this, you simply unprotect the Invoice form, and then select all the cells you want to move, and then push your mouse key on the border of the selected area, and then without releasing the mouse key move it to the new location where you want to place the cells. Several of the templates here on have more detailed instructions included, such as this sample of proforma invoice template.

Simple Hourly Rate Service Invoice with Date Column
Simple Hourly Rate Service Bill with Date Column

Unlike other simple invoice templates, this design has a custom field "Date" column added to the detail section. Since "Date" is a reserved keyword for underlying database, we use the "ItemDate" as the database field name. This custom field is added to the "Invoice Body" database table -- this means that the cell values are not filled automatically when you pick saved products / items. To learn how to set up and use custom fields (also known as user-defined fields), visit custom fields. Visit hourly rate invoice template for more sample forms on hourly rate.

General Service Invoice
General Service Invoice

This template was originally published on as C5-012. The description of this template on is attached below. Note that we've made modifications to the form during upgrading it for publishing here on

Hong Kong Service Invoice Template
Hong Kong Service Invoice Template

On the form of the form, there is also a discount field. This is a discount amount, which is deducted from subtotal using the following Excel formula on calculating invoiced total, as shown in the formula assigned to the "oknDiscountedSubTotal":

Hotel Guest Folios with Satisfied Business Traveler
Hotel Bill Layout with Satisfied Business Traveler

On the bottom of the form, besides the usual "Subtotal", "Tax" and "Total" fields, it also adds space for "Cashier's Signature" (this is for printing purpose only - not a field saved to database), and "Guest's Signature", with a declaration like "I agree that my liability for this bill is not waived and agree to be held personally liable in the event that the indicated person, company or association fails to pay for any part or the full amount of the these charges".

Psychologist Invoice Template
Psychologist Billing Format

This free invoice template designed for psychological services features a "Bill To" section, a separate "Patient" section, and 6 columns - "Date", "Service", "Charges", "Payments", "Insurance Payments", "Current Balance".

Consulting Invoicing Form
Consulting Billing Template

Consulting Invoice Template is suitable for those who provide consulting service. It details invoice #, invoice date, client information, service provided. Two tax types are supported but customization is possible.

Lightweight Proforma Invoice Format
Lightweight Proforma Invoice Form

As detailed on our proforma invoice template category page, a proforma invoice should include certain fields that are not included in the standard invoice template shipped with the installer program of Invoice Manager for Excel. Since this invoice template is created directly based on c7013, the two template could share the same underlying Access database file.

Sales Invoice with Profit Calculation
Sales Invoice with Profit Calculation

If you are interested in the implementation details regarding this invoicing template, read on. You may find that it could be a good sample on adding profit and taxable column to your own invoice template. The following description assumes the circumstances that we are creating this template based on the default sales invoice template. You job may differ, but as said before, you can see this as a sample on adding the profit calculation feature.

Simple Consulting Invoice Template
Simple Consulting Invoice Template

As a consultant you need a beautiful invoicing template to bill your clients, yet the template should be simple and easy to use. Simple Consulting Invoice Template might be your choice for creating invoices.

does not include the shipping address section on the printable invoicing form. If you need the shipping address fields, try
Invoicing Template to Email
Invoicing Template to Email

Many templates here on has the "Email" field on the "Bill To" or "Client Info." section. By adding this to the billing form, new customer accounts created by clicking the "Save As New Customer" button (or the "Save New Customer" button on the task pane) could have the email address saved too. Otherwise, you have to go to the "Customer Edit" or "New Customer" window to set the email address for customers.

Auto Repair Invoicing Sample (2)
Blank Vehicle Repair Invoice (2)

To UIS version users: The form is protected to prevent accident modifications to layout and formulas. If you unprotect the sheet and try to close it, UIS prompts a warning message about the protection status of the template. If you want to be able to change the list when creating invoices, you should unlock the range starting from Q16.

Advanced Sample - Invoiced Total in English Words
Advanced Sample - Invoiced Total in English Words

Most templates here on are ".xlsx" files. ".xlsx" workbooks are Microsoft Excel Open XML Format Spreadsheet files. It's an XML-based spreadsheet file created by Microsoft Excel version 2007 and later. One limitation of ".xlsx" format is that it cannot store macros (i.e. VBA codes). To save the macro function code with the Excel invoicing template, you have to firstly convert your template into ".xlsm" format, which is called "Excel macro-enabled Workbook". See c5101 - Advanced Invoice Sample - Macro-Enabled Invoicing Template for more information on this topic.

First, to convert an ".xlsx" invoice template into ".xlsm" format, follow steps below.

Music Store Invoicing Sample (Wholesale)
Music Store Invoicing Sample (Wholesale)

You should also modify the formula of the "Total" cell to use the discounted amount instead of the original subtotal amount:

Simple Sales Invoicing Sample
Simple Sales Invoicing Format

Simple Sales Invoicing Sample is the template designed by that helps you create beautiful and professional sales invoices in an easy and quick way.

Standard Invoicing Template with EAN
Standard Invoicing Format with EAN

An EAN-13 barcode (originally European Article Number, but now renamed International Article Number even though the abbreviation EAN has been retained) is a 13 digit (12 data and 1 check) barcoding standard which is a superset of the original 12-digit Universal Product Code (UPC) system developed in 1970 by George J. Laurer. The EAN-13 barcode is defined by the standards organization GS1. See Wikipedia.