Skip to main content
InvoicingTemplate.com main content
sharing is caring! we do appreciate your time to let others know us!

Summary

invoice date

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

According to BusinessDictionary.com, 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.

TheFreeDictionary.com: "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 InvoicingTemplate.com 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.

Invoice Date Definition is a sub-topic of Download Free Excel Invoicing Templates . Here are our templates closely related to Invoice Date Definition.

Invoice with Date Column

c4004
Template with Date Column

Of course you have to do some formatting work too to make the new Date column has the same style like the other columns. You can use Excel's format painter, which allows you to copy the formatting, to quickly duplicate the formatting (background color, border style etc) of an entire column. Next, format the Date column with appropriate date format - to do this, first select all the date cells, right-click one of the selected cell and choose Format Cells. On the Format Cells dialog box, go to the Number tab, and then choose Date from the Category list. On the right-hand of the tab, you can find various date formats that you can choose. Pick the one you like and click OK to close the Format Cells dialog box.

General Service Invoice

c5012
General Service Invoice

The "Date" column links to the "DateCompleted" field in the back end database. This database filed is not included in the default database packaged with Uniform Invoice Software setup program, so it is a custom field (or user-defined field). The custom field feature, combined with Microsoft Excel formulas, allows as to create many complex invoicing forms without breaking the support from Uniform Invoice Software. With Excel Invoice Manager, adding and updating custom fields should be done with a separate program called Custom Field Manager. With Uniform Invoice Software, it is now a built-in feature of the main program.

Hong Kong Service Invoice Template

c5114
Hong Kong Service Invoice Template

By default this template shows no tax. If you pay tax, you can use the "Settings" dialog box to modify the template layout and design. Simply click the "Settings" button on the "Invoice" ribbon tab, then activate the "Tax" tab. Set tax type to "One tax", fill in tax name and rate properly. Visit Tax Rates on Hong Kong Inland Revenue Department for more information.

Hotel Guest Folios with Satisfied Business Traveler

c5091
Hotel Bill Layout with Satisfied Business Traveler

If you search for a bill template with the keyword "Hotel", you may find we've already published several implementations for hotel / motel invoicing here on InvoicingTemplate.com. For example, Hotel Receipt Template (c7005) and Hotel Receipt Format with Blue Gradient Design (c7027). The form designers at InvoicingTemplate.com are committed to offer you more choices with professional templates. So here comes the new design - Hotel Guest Folios with Satisfied Business Traveler.

Psychologist Invoice Template

c6024
Psychologist Invoice Template

Except the "Current Balance" column, which is in fact the "Line total" column in the default invoice template shipped with Uniform Invoice Software, all the other columns are manually fillable when you create an invoice. The calculation of "Current Balance" is done by "Charge - Payments - Insurance Payments" using Excel formulas. As you can see, we completely redefined the calculation method of the "Current Balance" or "Line total" cells, without breaking or modifying Uniform Invoice Software, which is our invoicing software that processes tasks like saving invoices, auto-generation of invoice numbers, tracking customers etc. Even in complex accounting / invoicing systems on the market, this level of flexibility could hardly be found. Uniform Invoice Software archived this easily because it uses Excel spreadsheets as its front end.

Consulting Invoicing Form

c4008
Consulting Billing Template

On the top of the invoice, there are fields for you to detail your company or business information, such as your name / company name, address, phone, fax, email, web, and you can also add your US Federal Tax Payer ID (Business Number in Canada) if applicable.

Subscription Invoice Template (Sales)

c7007
Subscription Invoice Form (Sales)

Subscription Invoice Template (Sales) adds two new columns, Start Month and End Month to the invoice body. It is suitable for products that are subscription or rental based for which a date range should be detailed.

Transport Invoice with GST

cm021
Transport Invoicing Form with GST

On the top of the form is a section for your own business, including your company logo (to replace the default "InvoicingTemplate.com" logo placeholder), transportation business name, PO Box and city, state (province), ABN#, telephone number etc.

Sales Invoice with Profit Calculation

c5060
Sales Invoicing Template with Profit Calculation

In order to calculate the profit, you'll need the cost figure which is either set the Product Edit form, or entered manually according to the agreement or contracts on the invoicing form when you are creating an invoice. The cost is the amount you pay the vendor for each item you purchased, equal to the "price" listed on the orders you send to your vendors. On the other hand, the price is the amount your clients or customers pay you. On the invoices that you'll send to your customers, whether they are printed hard-copy, or as electronic bill in PDF / Excel / HTML format, the cost figures will not be shown to your customers, since this column is placed outside the printable area. It is designed for your own accounting or book keeping purpose only.

Simple Consulting Invoice Template

c4034
Simple Consulting Billing Format

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

c3017
Invoicing Template to Email

In this sample, we take c3001 Basic Sales Invoice Template (Light Blue) as the basic template, replace the "Country" field with the "Email" field.

Auto Repair Invoicing Sample (2)

c5049
Blank Vehicle Repair Invoice (2)

So how do we at InvoicingTemplate.com design this customized auto repair billing form based on the previous layout? It is in fact easy if you know Excel a little. Our procedures are as follows: unprotect the Invoice worksheet in the Excel spreadsheet and switch to design mode; select the area where you want to put your car / vehicle model list - in this sample, we choose to place the model list to the right side the printable area, starting from Q16, so that you can easily add new entries to it whenever needed. Once the car models are setup, you can then easily go to the Data ribbon tab, execute the Data Validation command to create the drop-down list.

Advanced Sample - Invoiced Total in English Words

c5102
Advanced Sample - Invoiced Total in English Words

Most templates here on InvoicingTemplate.com 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.

Simple Sales Invoicing Sample

c4032
Simple Sales Invoicing Sample

This template has 4 columns on the invoice detail section - Description, Quantity, Unit Price and Amount. Basically this invoicing templates offers the same number of fields / cells on the invoice form as the default template shipped with Uniform Invoice Software. However this template has very different look and feel. This is archived by moving the fields, setting fonts and colors - all tools are provided by Microsoft Excel. Simple Sales Invoicing Template, or Simple Sales Invoicing Form, helps you create professional invoices for your business by simply filling in a blank form. You can also use this simple sales invoicing template as a basic and starting point, customize the layout, look and feel of your invoices to add professionalism to your business. Don't waste time creating manual invoices for goods and services when you can easily use a pre-designed template.

Standard Invoicing Template with EAN

c6025
Standard Invoicing Format with EAN

The additional EAN field is a custom field. Since this field is a property of an invoiced item (i.e. it should be saved along with the other product details such as description, price etc.), so it must be added to the "Product" database table; The EAN must also be saved along with each invoice, so this field must be added to the "Invoice Body" (i.e. "InvBdy") database table too. Note the field definitions in both tables must be exactly the same. In this sample template, it is "text (13)" - meaning the field is able to store up to 13 characters.