Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Handyman Bill Sample (No Tax). Double-click the downloaded file to extract all files.
  2. Open the template "handymannotax.xlsx" or "handymannotax-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.

Handyman Bill Sample (No Tax)

Handyman Bill Sample (No Tax) (c5054)

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

Handyman Bill Sample (No Tax) - freeware edition

Handyman Bill Sample (No Tax) - freeware edition

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

Handyman Bill Sample (No Tax) - Uniform Invoice Software V3 edition

Handyman Bill Sample (No Tax) - Uniform Invoice Software V3 edition

Download Handyman Bill Sample (No Tax) (c5054)

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.

313 KBDownload

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

2.79 MBDownload

Detail

Handyman Bill Sample (No Tax) is a sample based on c7006 Handyman bill format. Unlick the original template, where the invoicing items are charged with either one or two taxes (GST and PST), this handyman bill format charges no tax.

A sales tax version is also available here on InvoicingTemplate.com, at Handyman Bill Template (Sales Tax).

Handyman Bill Sample (No Tax) is provided in two editions - a freeware editions of Handyman Bill Sample (No Tax), and a Uniform Invoice Software (UIS) edition of Handyman Bill Sample (No Tax). Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

The freeware edition of Handyman Bill Sample (No Tax) provides exactly the same form layout and design in Microsoft Excel format as the UIS edition of Handyman Bill Sample (No Tax). The most noticeable difference, at the first glance, is that the UIS edition of Handyman Bill Sample (No Tax) contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by UIS. For example, if you click "Save To DB", UIS validates and checks the current document on Handyman Bill Sample (No Tax), generate a unique invoice number automatically (if necessary), and then save it to the backend database.

While the free version of Handyman Bill Sample (No Tax) is simple, the result created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service bill creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Handyman Bill Sample (No Tax) work for you.

In order to create this customized sample from the original version c7006, we at InvoicingTemplate.com first unprotect the Invoice worksheet, moved out the GST and PST columns from the printable invoicing form, move the Quantity column several columns right, and then expand the Description column to occupy the space left by moving out the GST and PST columns.

The protection of the "Invoice" worksheet in Handyman Bill Sample (No Tax) 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 Handyman Bill Sample (No Tax).

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.

The printable area, or print area, is the area with white background on the center of the Handyman Bill Sample (No Tax) 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 Handyman Bill Sample (No Tax), 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 Handyman Bill Sample (No Tax), 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.

Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Handyman Bill Sample (No Tax) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Handyman Bill Sample (No Tax) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Handyman Bill Sample (No Tax) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

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 Handyman Bill Sample (No Tax), 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.

To change the currency symbol of Handyman Bill Sample (No Tax), first make sure you've unprotected Handyman Bill Sample (No Tax) spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on Handyman Bill Sample (No Tax), you push CTRL key on keyboard and click each cell on Handyman Bill Sample (No Tax) one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

Like other form designs here on InvoicingTemplate.com, Handyman Billing Template (No Tax) 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#c5054
NameHandyman Bill Sample (No Tax)
CategoryService Invoice Template
Release DateMonday, June 2, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$P$43
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates