Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Sample Format for Job Invoicing (Tax Column)

Sample Format for Job Invoicing (Tax Column) (c6015)

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

Sample Format for Job Invoicing (Tax Column) - freeware edition

Sample Format for Job Invoicing (Tax Column) - freeware edition

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

Sample Format for Job Invoicing (Tax Column) - Uniform Invoice Software V3 edition

Sample Format for Job Invoicing (Tax Column) - Uniform Invoice Software V3 edition

Download - Sample Format for Job Invoicing (Tax Column)

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

Without database file. How to download and use

55 KBDownload

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

338 KBDownload

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

2.79 MBDownload

Detail

Job Billing Sample (Tax Column) is the third sample on customizing Job Billing Sample. With this sample we added a new column to the detail section, i.e. the tax amount column which shows how much tax charged on each item that is being invoiced.

The finished template, including both the freeware edition and the UIS edition, as well as the PDF Job Billing Sample Template, could be downloaded here for free. If you are interested in the design details regarding this template, read on.

In order to create such format, we split the existing "Part No." and "Description" columns, narrow these two columns to leave space for the new tax column, move the "List" (i.e. Unit Price) column so that we can place the new tax column to the right-side of the "List" column. However, before begin, we need to first unprotect the spreadsheet and display grid lines and row headings and column headings.

Once the spreadsheet is unprotected and switched to design mode, we can now start to adjust the columns.

The last major step on creating this template is to add formulas to calculate taxes. To do this, we add the following formula to each tax cell on the detail section:

=ROUND(oknLineTotal_? * oknTax1Rate * oknTaxable_?,2)

In the above formula, "_?" is the line number of each line on the detail section. "oknTaxable_?" is the value of the "Taxable" checkbox of each item that is being invoiced.

This serial of Job Invoicing Sample templates, including Job billing Sample, Job Billing Sample (2 Taxes), Job Invoicing Sample (Taxable Column) and Job Invoicing Sample (Tax Column), use custom fields to implement the feature required. The fields that are not included in the default sales invoicomg template that is included in the Uniform Invoicing Software installer program are called custom fields, which are user defined fields added to both the template and database.

If you don't need the added custom fields and prefer to a simpler job billing template, try Job Invoicing Template.

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

Format and Specification

Template#c6015
NameSample Format for Job Invoicing (Tax Column)
CategoryService Invoice Template
Release DateWednesday, June 4, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns6
Lines12
Line Height (Points)15.00
Print Area$E$1:$AI$55
Printable with Papaer Size / OrientationSample Format for Job Invoicing (Tax Column) - Portrait
Default Margins (Points)
Left0.00
Right0.00
Top53.86
Bottom0.00