Free Excel Invoice Template Canada with GST/HST

Set up taxes in your Excel invoice template

The workbook starts with a $1,000 example using 5% GST and 9.975% QST. Replace the sample service, invoice number and dates. Check both tax columns on every used line: rates are not selected automatically by province. Enter 0% when a tax does not apply. Add your tax registration numbers and Interac e-transfer instructions.

For a taxable $1,000 Quebec sale, GST is $50 and QST is $99.75, for a total of $1,149.75. Both taxes apply to the pre-tax price. The workbook rounds each line and each tax to cents, then adds the cents. A $200 payment already received leaves a $949.75 balance.

For an Ontario supply subject to HST, enter 13% in the first column and 0% in the second. Nova Scotia HST has been 14% since April 1, 2025. Place of supply, registration and the product or service determine which taxes to collect. Check provincial PST/RST rules before entering them; this template does not handle compounded taxes or special tax bases.

Sources: CRA — rates and invoicing and Revenu Québec — calculating taxes.

Create a PDF invoice ready to print

1. Excel: select the Invoice sheet. In File > Print, choose the active sheet, Letter paper, portrait and fit to one page. Export or print to PDF after checking the preview.
2. Google Sheets: upload the .xlsx to Google Drive, open it with Google Sheets and save as Google Sheets. Check the sample total after conversion. In File > Print, choose the current sheet and fit to page, then save as PDF.
3. Word: replace bracketed fields and calculate the amounts, taxes and balance. Choose File > Save As or Export, then PDF. The document does not calculate taxes automatically.
4. Google Docs: upload the .docx to Google Drive and open it with Google Docs. Keep Pages mode and Letter paper. Check amounts manually, then choose File > Download > PDF Document.

The Google options are files to import, not shared-document links. After conversion or adding long descriptions, check page breaks. Keep an editable copy and send only the invoice PDF to your client, without the Guide sheet.

Google help: importing Office files · Microsoft help: exporting to PDF

What must be included on a Canadian invoice

• Your business name and contact information
• Your client's name and contact information
• A unique invoice number
• Invoice date
• Description of services or products
• Total amount before tax
• Applicable taxes (GST, HST, or provincial taxes)
• Total amount payable

If you are registered for GST/HST, you must also include your GST/HST registration number.

GST, HST, and provincial taxes explained

In Canada, taxes vary depending on your province.

GST (Goods and Services Tax)

A federal tax of 5% that applies in all provinces.

Learn more: canada.ca

HST (Harmonized Sales Tax)

Some provinces combine federal and provincial tax into one single HST rate.

• Ontario: 13%
• Nova Scotia: 14%

Provincial taxes (like QST in Quebec)

In Quebec, you may need to charge both:

• GST (5%)
• QST (9.975%)

Learn more: revenuquebec.ca

This template explains invoice structure. To determine when to charge Quebec taxes, read the GST/QST invoice guide. To verify an amount before sending, use the GST/QST calculator.

Important: You must register before charging taxes

You cannot legally collect GST, HST, or QST unless you are registered.

• Register for a GST/HST number with the CRA
• Register for QST if you operate in Quebec
• Once registered, you must collect taxes, remit them to the government, and file returns on your reporting schedule.

Canadian invoice template

Frequently asked questions