Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download GST and PST Invoice Template. Double-click the downloaded file to extract all files.
  2. Open the template "gst-pst-invoice-template.xlsx" or "gst-pst-invoice-template-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.

GST and PST Invoice Template

GST and PST Invoice Template (c7031)

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

GST and PST Invoice Template (UIS Edition)

GST and PST Invoice Template - UIS edition

Download GST and PST Invoice Template (c7031)

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.

355 KBDownload

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

2.82 MBDownload

Detail

This free Canadian invoice template charges both GST (Goods and Services Tax) and PST (Provincial Sales Tax). If the item being invoiced is a service, GST is charged; if the item is a material, then both GST and PST is charged. This billing format is suitable for business who sells products or provides service in Canada.

This template was originally published on office-kit.com as C7-006. Here on InvoicingTemplate.com there are several customized version for this format: c7006 Handyman Invoice Template, c5055 Handyman Invoice Template (Sales Tax), and Handyman Bill Sample (No Tax). If you charge HST (Harmonized Sales Tax), visit our sample invoice template in Excel format at Canadian Invoice Template with HST. All of our templates come with a PDF sample invoice which you can download for free too.

There are online GST and PST invoice template for Canada / Ontario in Microsoft Word too, which you can download for free or a small fee. However Microsoft Excel is better on doing calculations. As you can see from this sample GST and PST invoice template, all you need to do is to enter the basic values, all calculable values are shown automatically when the basic values are entered. If you install Uniform Invoice Software, this template can be a complete and easy to use GST and PST invoicing software.

The following description was originally published on office-kit.com for C7-006 "Tax Invoice Template That Charges One Tax (GST) on Services and Two Taxes' (GST & PST) on Materials". We republish it here on InvoicingTemplate.com to provide with you additional information about this template.

The default template and database shipped with Uniform Invoice Software already have an "Is Service" field defined for products/items, which can be set by checking the "Is Service" box on the Product Edit window. If we load this "Is Service" on to the invoice form along with the other product/item data, it is then simple to use Excel formulas to choose and calculate GST/PST taxes based on the "Is Service" value - If the current product/item is a service, we calculate only GST; if the current product/item is not a service, we calculate both GST and PST.

Custom fields added to the tax invoice template

In order to display GST, PST on the invoice detail section, we need to add two custom fields to the "InvBdy" database table. To make sure we can restore a saved invoice completely after it is saved, we also need to add the "Is Service" field to the "InvBdy" database table. The following table shows all the custom fields added to implement the GST / PST template as required.

Table nameField nameField type
InvBdyGSTdecimal (15,4)
InvBdyPSTdecimal (15,4)
InvBdyIsServiceInteger

Unlike Excel Invoice Manager, which uses a separate program "Database Sesigner" to create and modify custom fields; Uniform Invoice Software has a "Custom Field Manager" built in. Visit Simple Sample - Discount Amount Field for a detailed tutorial on using custom fields.

Load "Is Service" values along with the other product/item data

The "Is Service" field appears as a checkbox on the Product Edit window, and its underlying value stored in the backend database is an integer - For a service whose box is checked on the Product Edit window, its underlying value is 1; otherwise it is 0.

To load the "Is Service" value into the invoice form when a product/item is selected, all you need to do is to name a column of cells on the invoice form, in the format oknIsService_1, oknIsService_2, ..., oknIsService_12, where "okn" is the prefix for all the cell/range names used by Uniform Invoice Software; and "IsService" is the field name in both the Product and InvBdy database tables - it is this name created the link between the invoice form and backend database, i.e. Uniform Invoice Software depends on this field name to find out where to display a value loaded from database; and the last part, "_1", "_2", ..., "_12", is the line number.

The following are the brief steps to implement the Is Service column on the invoice sheet.

  1. Backup the template.
  2. Open it as usual.
  3. Switch to design mode by pressing the "Design Mode" button on the ribbon tab.
  4. Drag your mouse to select a column of cells at the right side of the invoice body and out of the print area.
  5. Right-click one of the selected cells, choose Format Cells. On the Patterns tab, set a background color for the cells; on the Protection tab, clear the Locked box - If you don't clear the Locked box, Uniform Invoice Software will not write data to the cells once the invoice template is protected, as detailed at Locking/Unlocking Cells.
  6. Name the cells oknIsService_1, oknIsService_2... oknIsService_12.

Show GST, PST taxes on the invoice body

This tax invoice template also has GST and PST tax columns on the invoice body, so that the tax charged on each product/item line is clearly listed. To implement this, you need to add two columns to the invoice body section.

  1. Add two columns to the invoice body. In this implementation, the GST and PST tax columns are added to the left of the Line total column.
  2. Name the cells. The first column will store GST tax, so the cells are named oknGST_1, oknGST_2...oknGST_12; the second column will store PST tax, so the cells are named oknPST_1, oknPST_2...oknPST_12.
  3. Fine tune the invoice form, such as settings colors, adjusting the sizes of cells, etc., to make the newly added column looks natural to the other part of the invoice form.
  4. Now create formulas for the two tax columns. For the GST tax cells, the tax is charged both on services and materials, so the formula should be:
    =IF(oknTaxable_?,ROUND(oknTax1Rate*oknPrice_?*
    oknQuantity_?,2),0)

    And, PST tax is charged on materials only, so the formula should be:

    =IF(oknTaxable_?,IF(oknIsService_?=1,0,
    ROUND(oknPrice_? * oknQuantity_?* oknTax2Rate,2)),0)

    In above formulas, "_?" is the line number of the current item/product.

  5. The formulas of the two tax cells on the bottom of the invoice form should also be modified. First, for the GST tax cell, it sums all the GST taxes calculated on the invoice body, so the formula should be:
    =SUM(oknGST_1:oknGST_12)

    Similarly, the formula for the PST tax cell should be:

    =SUM(oknPST_1:oknPST_12)

Like other form designs here on InvoicingTemplate.com, GST and PST Billing Form 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#c7031
NameGST and PST Invoice Template
CategorySales Invoice Template
Release DateMonday, March 20, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns7
Lines12
Line Height (Points)19.50
Print Area$F$3:$O$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