Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
This sample consulting invoice template has only one column, consisting of 16 lines of the "Description" fields. The total invoiced amount cell is manually editable. It also includes the "SpellNumber" VBA procedure to show the invoiced amount in English words.
This template is created based c1001 Construction Proposal Template.
To make the invoice form, we moved the Invoice# cell back into the printable area, put it near the "Invoice Date" cell.
The 3 lines of "Job Location" fields are now defined as custom fields. The fields are added to the "Invoice Header" database table. See How to use custom field to learn more.
This form uses only the "Description" field on the detail section, which is the "ProductName" field in the "Product" and "Invoice Body" table. In this case, the "Price", "Quantity" and "Line Total" fields are all set to zero. The "Item#" column was added back to the left side of the form. This allows you to save common description to database and retrieve them on creating invoices, avoiding type the text again and again.
The "=SpellNumber" formula is an user defined formula, detailed in the sample template c5102 Advanced Sample - Invoiced Total in English Words. For example, if the invoice total is 1234.56, then the "Total Amount in English Words" shows "Twelve Thousand Three Hundred Forty Five Dollars and Sixty Seven Cents".
Most templates here on InvoicingTemplate.com don't have VBA macros attached, but you can add your own to further customize our invoicing software program. With the "Enterprise" edition of our billing software, you can even call button commands on the Excel sheets from your own VBA macro code, as shown at c5103 Advanced Sample - Email Is Required Before Saving Invoice. If you are familiar with VBA programming, you can easily turn a generic / simple consulting invoicing form into a powerful invoicing software program.
Format and Specification
|Name||One Column Consulting Invoice Sample|
|Category||Consulting Invoice Template|
|Release Date||Thursday, November 1, 2018|
|Format (XLS or XLSX)||.xlsm|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|