Excel invoice template alternative
We don't offer an Excel file. The free invoice generator does the same job without formulas to maintain: fill in your details, the tax is worked out from your client's province, and you download a PDF.
How to use this template
- Open it. Press Use this template. The free invoice generator opens with the sample lines from this page already filled in.
- Make it yours. Add your business name, address and GST/HST number, your logo if you have one, and your client's details. Replace the sample lines with your own work.
- Check the tax. Choose your client's province. Each tax appears on its own line; tick PST Exempt or Tax Exempt if they apply to you.
- Download the PDF. Press Download PDF and choose "Save as PDF". Nothing you typed leaves your browser.
Why a spreadsheet invoice goes wrong
- Tax rates live in formulas. Each province uses a different mix of GST, HST, PST, RST and QST. A spreadsheet only knows the rate you typed in, and an old copy keeps using it.
- Formulas break quietly. One overwritten cell, or a new row outside the SUM range, and the total is wrong with no warning.
- Numbering drifts. Copying last month's file is the usual way invoice numbers get repeated.
- Rounding differs. A spreadsheet may round each line or only the total, so a client's own calculation can be a cent off yours.
What the generator does instead
You choose your client's province and the generator applies that province's taxes, each on its own line with its rate. Lines are rounded to the cent and added up the same way every time. When you're done, Download PDF gives you a file to email or print. Nothing you type leaves your browser.
If you want to keep invoices, number them automatically, email them and see who has paid, a free iBill account does all of that.
What every Canadian invoice needs
Whatever tool you use, include your business name and contact details, your GST/HST number if you're registered, your client's name, a unique invoice number, the issue and due dates, a description of the work with quantity and rate, each tax on its own line and the total. Our guide to CRA invoice requirements explains which details your clients need, depending on the amount.
Sales tax by province
For most services, sales tax follows your client's province: HST in Ontario and the Atlantic provinces, GST only in Alberta and the territories, GST and QST in Quebec, and GST plus PST or RST in British Columbia, Saskatchewan and Manitoba when you're registered there and the sale is taxable. If your sales stay under $30,000 over four consecutive calendar quarters, you're a small supplier and don't have to register for GST/HST; if you aren't registered, don't charge it.
Need something else? See all invoice templates or open the free invoice generator.
Common questions
Is there an Excel invoice template to download?
Can I still use my own spreadsheet?
Does the generator save my invoices?
Is the invoice generator free?
Keep every invoice in one place
Save invoices, email them to clients, send reminders and see who has paid, with a free iBill account.
Start freeJoin 1,200+ Canadian Businesses