Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Job Invoicing Template. Double-click the downloaded file to extract all files.
  2. Open the template "jobinvoicetemplate.xls" or "jobinvoicetemplate-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Job Invoicing Template

Job Invoicing Template (c5018)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Job Invoicing Template - freeware edition

Job Invoicing Template - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Job Invoicing Template - Uniform Invoice Software V3 edition

Job Invoicing Template - Uniform Invoice Software V3 edition

Download Job Invoicing Template (c5018)

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

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

340 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.81 MBDownload

Detail

Job Invoicing Sample is a service invoicing template that does not include the shipping fields in the printable spreadsheet form. The template added several job related fields to the form, including job start and finish date, work or job address etc.

To be compatible with the old, but still widely used Excel 2003 format, the job invoicing template is downloadable as an Excel 2003 "xls" format.

Although it is easy to create the layout and format of Job Invoicing Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Job Invoicing Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Job Invoicing Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

This free template, just like all the other free invoice templates available here on InvoicingTemplate.com, is created from the default sales invoicing template shipped with Uniform Invoice Software (UIS). The free job work invoice added several new fields that are not found in the default template, i.e. Start Date, Finish Date and Job Address. If you use the UIS version of this free Template, these are custom fields defined both on the database and the template level.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Job Invoicing Template uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Job Invoicing Template without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

When working with Uniform Invoice Software (UIS) version of Job Invoicing Template, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Job Invoicing Template and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

The job invoicing sample free download here on InvoicingTemplate.com offers both the freeware edition and the UIS edition of this invoicing template.

Like other form designs here on InvoicingTemplate.com, Job Invoice Format is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5018
NameJob Invoicing Template
CategoryService Invoice Template
Release DateSaturday, January 11, 2014
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines16
Line Height (Points)19.50
Print Area$F$2:$N$44
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates