- Document for Excel Invoice Manager
This version of the document, "Job Invoice Template (C5-018)", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.
Job Invoice Template was revised and published on our new site InvoicingTemplate.com, at Job Invoice Template, as both a free invoice template and a template that works with Uniform Invoice Software. Please visit our new site Invoicing Templates for the updated documents and download links of this template "Job Invoice Template".
With this job invoice template you can enter both materials and labor costs. Compared to the default invoice template shipped with, this job invoice template does not include the " " section, but added several new fields to let you enter job-related information, including "Start Date", "Finish Date", "Job Address", "Client Name".
Tip: Please download the customized job invoice template for free from the bottom of this page.
To create this job invoice template from the default invoice template shipped with, you should firstly move those unneeded cells out of the , including the entire " " section.
Since all the cells/fields and controls are identified by names, you can easily redesign the layout by moving cells/fields/controls. For example, if you don´t want to show the, cells/fields on your printed invoice, you can move them out of the Print_Area:
To move a control:
New fields not defined by the default invoice template can be added by using custom fields. With this job invoice template we added 4 new fields, including "Start Date", "Finish Date", "Job Address", "Client name".
|Table name||Field name||Field type|
|Invoice Header (InvHdr)||StartDate||Date|
|Invoice Header (InvHdr)||FinishDate||Date|
|Invoice Header (InvHdr)||JobAddress||Text (100)|
|Invoice Header (InvHdr)||Client Name||Text (50)|
To add the preceding custom fields to the job invoice template and the backend database, here are the steps to follow.
The link or map between Excel cells and database table fields is created by names. For example, a cell namedwill be linked to the field named in the backend database. So, to display the newly added custom fields to the form, simply name 4 cells , , and , respectively.