Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Job Invoice Sample (Taxable Column). Double-click the downloaded file to extract all files.
  2. Open the template "jobinvoicesampletaxable.xlsx" or "jobinvoicesampletaxable-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 Invoice Sample (Taxable Column)

Job Invoice Sample (Taxable Column) (c5057)

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

Job Invoice Sample (Taxable Column) - freeware edition

Job Invoice Sample (Taxable Column) - freeware edition

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

Job Invoice Sample (Taxable Column) - Uniform Invoice Software V3 edition

Job Invoice Sample (Taxable Column) - Uniform Invoice Software V3 edition

Download Job Invoice Sample (Taxable Column) (c5057)

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.

328 KBDownload

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

2.78 MBDownload

Detail

Job Invoice Sample (Taxable Column) is the second sample on customizing the original Job Invoice Sample. With this sample template, we moved the Taxable checkbox column into the printable invoice form.

The printable area, or print area, is the area with white background on the center of the Job Invoice Sample (Taxable Column) spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Job Invoice Sample (Taxable Column), only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Job Invoice Sample (Taxable Column), select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

If you are not interested in the implementation details regarding how this invoice template was created from the original version, you can download the template for free from the download page. Otherwise, read on to learn how we at InvoicingTemplate.com created the template. Or, visit Job Invoice Template designed by InvoicingTemplate.com.

To design this invoice form layout based on its original version, we first unprotect the Invoice spreadsheet, display grid lines and row headings and column headings, switch to design mode. And then, we unmerge the "Part No." column (which comprises 4 Excel raw columns), move all the "Taxable" checkboxes to Excel column L. On each item line, merge the first 3 cells on column I, J and K to create the new "Part No." cell. Finally, replace the original label "Part No." with the new text "# / Taxable" to indicate the purpose of the taxable checkboxes. The following section describe the process in detail.

The protection of the "Invoice" worksheet in Job Invoice Sample (Taxable Column) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Job Invoice Sample (Taxable Column).

To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

The gridlines and row/column headings could help a lot when design the layout of the form.

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Job Invoice Sample (Taxable Column). Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Once you have finished your design work for Job Invoice Sample (Taxable Column), click the Design Mode button again to exit design mode.

Merge and Center works by merging the selected cells into one and then centering the data in the new combined cell. While design a template layout like Job Invoice Sample (Taxable Column), Merge and Center could be a handy tool if used properly. One thing to note, however, since Uniform Invoice Software (UIS) relies on cell names (or field names) to create the relationship between the Excel form cells and the database fields, you should make sure the cell that contains a field name is the first one in the group of cells that are to be merged. This way, UIS will work with the merged cell by reading from or writing to the named cell.

Once Job Invoice Sample (Taxable Column) is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the printable form, then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

Once you moved in the taxable boxes, you may also like to include them on the printed or extracted invoice copy. To do this, name all the checkboxes with "oknWidget_" prefix.

Naming a control or an image is easy in Microsoft Excel. First make sure your template Job Invoice Sample (Taxable Column) is in design mode. Right-click the control or image you want to assign it a name, choose Properties. On the Properties box, enter the name into the "name" field and press enter. Note that if you have several controls that you want to assign different names, you can do so by entering the name and then clicking to choose another control without closing the Properties window.

Now you get the idea about how to create this Job Invoice Sample (Taxable Column) from the original Job Invoice Sample. If you need to charge two taxes on the invoicing items, you can either use the Setup dialog box in Uniform Invoice Software, or download the pre-configured one at Job Invoice Sample (2 Taxes). In case you need to show tax amount for each item, we have another variant created and ready for you to download for free, at Job Invoice Sample (Tax Column).

Like other form designs here on InvoicingTemplate.com, Job Billing Sample (Taxable 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#c5057
NameJob Invoice Sample (Taxable 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
Columns5
Lines12
Line Height (Points)15.00
Print Area$E$1:$AI$55
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left0.00
Right0.00
Top53.86
Bottom0.00

Sample Templates