Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Canadian Invoice Template with HST. Double-click the downloaded file to extract all files.
  2. Open the template "canadianhst.xlsx" or "canadianhst-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.

Canadian Invoice Template with HST

Canadian Invoice Template with HST (c6020)

c6020 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open canadianhst-uis.xlsx.

Canadian Invoice Template with HST (UIS Edition)

Canadian Invoice Template with HST - UIS edition

Download Canadian Invoice Template with HST (c6020)

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.

274 KBDownload

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

2.78 MBDownload

Detail

Canadian Invoice Template with HST, or Canadian Billing Form with HST, is an invoicing form that implements one tax (HST - Harmonized Sales Tax) . It also includes the "Taxable" checkbox column on the invoice detail section to support for

The goods and services tax (GST) is a tax that you pay on most goods and services sold or provided in Canada. In Alberta, Saskatchewan, Yukon, British Columbia, Manitoba, New Brunswick, Northwest Territories, Newfoundland and Labrador, Nova Scotia, Nunavut, Ontario, Quebec and Prince Edward Island, the GST has been blended with the provincial sales tax and is called the harmonized sales tax (HST). Note that this free invoice sample designed by InvoicingTemplate.com is set up for a business in Ontario where the HST rate is 13% (as of April 1, 2013). You should change the HST rate according to the rate applicable in your province. For example, in B.C., the HST rate is 5% (as of April 1, 2013), in Nova Scotia, the HST rate is 15%, and in New Brunswick and Newfoundland/Labrador the HST rate is 13%. See GST/HST rates on Canada Revenue Agency to find out the rate that is suitable for your province. If you have Uniform Invoice Software installed, changing the tax rate is as easy and simple - firstly, you click the Settings button on the Excel ribbon tab, and then go to the Taxes tab, fill in the tax rate percentage number into the first tax rate box, and then click "Apply". Click the Close button to close the Settings dialog box. Note that in order to make the change permanently, you'll need to click Excel menu File / Save to save the invoice template file - you have to do only once. This is because the default tax rate is saved into a hidden cell on the invoicing form.

Like the default sales invoice template shipped with Uniform Invoice Software setup program, the price on this template excludes tax. Unlike the default invoice template, this template details the tax amount for each invoicing item. This is done by using Excel formulas.

As you can see from Canadian Invoice Template with HST, one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

The Item# (product#) column, which is seen on the default invoice template, is also moved out of the print area of the invoicing form.

The printable area, or print area, is the area with white background on the center of the Canadian Invoice Template with HST 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 Canadian Invoice Template with HST, 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 Canadian Invoice Template with HST, 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 Canadian Invoice Template with HST 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 Canadian Invoice Template with HST 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 Canadian Invoice Template with HST 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.

Like other form designs here on InvoicingTemplate.com, Canadian Billing Form with HST 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#c6020
NameCanadian Invoice Template with HST
CategorySales Invoice Template
Release DateWednesday, August 5, 2015
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns6
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$46
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates