Quick Method HST Calculation Excel - Free Template

1. Start on the HST_Calculator sheet and enter each invoice row with the date, invoice number, client name, province, supply type, and taxable sales.
2. Check the rate columns before you move on. If you are in Ontario, for example, a $1,000 taxable sale with a 13% HST rate and a 10% remittance rate gives you $130 collected and $100 remittable before ITCs.
3. Enter estimated ITCs where you know them. That keeps the net remittance realistic instead of overstating what you owe the CRA.
4. Review the Status column for any entries that need attention, such as missing client details or a rate that does not fit the province.
5. Open the Remittance_Summary sheet to see the totals roll up for the period. Use it as your working number before you file through CRA online services or your accountant’s process.
6. Use Reference_Quick_Method when you want to confirm the remittance rate and compare it with the GST/HST rate used on the sale.
7. Keep the file updated as you invoice. If you wait until the last week of the filing period and have 120 invoices to sort, the cleanup takes much longer than entering 5 to 10 rows at a time.

If you are a sole proprietor in Ontario, a bookkeeper at an incorporated contractor, or an office manager at a trades shop, this is the kind of spreadsheet you reach for before a GST/HST filing. It is most useful when you have steady invoice flow — for example, 40 invoices a month at $250 each, or an online store with 300 orders a month that need tax reviewed.

Where it fits in the month

Most people use it near the end of the filing period, then again when they reconcile the bank account. A contractor with 4 employees can use the HST_Calculator sheet to review taxable sales by invoice instead of waiting until the accountant asks for totals.

Who benefits most

If you are handling your own books, the spreadsheet keeps the tax math visible line by line. If you are supporting a non-profit treasurer or a small retail owner, it also gives you a simple check before you post the remittance journal entry or transfer money to the tax account.

The two practical numbers matter most: the collected tax and the estimated remittance. When you can see a $1,000 sale turning into $130 collected HST and a $100 remittance amount, you can plan the difference instead of guessing at month-end.

The CRA expects you to keep enough support to show how you calculated your remittance, and the usual record-retention period is six years. That matters because a quick method worksheet is not just a planning tool — it is part of the support for your GST/HST numbers.

Numbers that matter in 2026

The small-supplier threshold for mandatory GST/HST registration is $30,000 in taxable revenue over four consecutive quarters. Once you register, you also need a BN with an RT program account, and your filing frequency may be monthly, quarterly, or annual depending on your revenue and filing setup.

Quick method vs. regular method

For many small businesses below roughly $400,000 in taxable revenue, the quick method is simpler because you remit at a prescribed rate instead of tracking every input tax credit. If you have heavy expenses with a lot of recoverable tax, the regular method usually gives you more precise ITCs; if your overhead is light, the quick method often saves time and bookkeeping effort.

Example: if you collect $13,000 of HST on sales and your quick method remittance rate is 10%, you remit about $10,000 before ITCs. If you have $1,200 of estimated ITCs, your net remittance drops to about $8,800, which is the figure you want sitting in your tax account before the filing deadline.

The biggest mistake is mixing up the rate used on the invoice with the rate used for remittance. If you charge 13% HST in Ontario but calculate the remittance as if every sale were at the same provincial rate, you can be off by hundreds of dollars on a modest month of sales.

Bad rows create bad totals

A second problem is sloppy invoice detail. If 10 out of 100 rows are missing province codes, client names, or dates, you waste time tracing them back through email, bank deposits, and packing slips before you can trust the summary sheet.

Cash flow mistakes cost money

Another common error is spending the HST you collected. On $50,000 of taxable sales, even a small remittance mismatch can leave you short by $1,000 or more when the return is due, and that turns into a cash flow problem fast. It is much easier to set aside the net amount every week than to find it all at filing time.

The other costly mistake is forgetting estimated ITCs that should reduce the remittance. If you paid $600 of HST on software, supplies, and fuel during the period, leaving that out means you overpay the CRA and then spend extra time fixing the return later.

The spreadsheet works best when you tie it to a fixed habit. Most small businesses should update it on the same day as bank reconciliation, payroll, or the last Friday before the filing deadline, so the work happens before the pressure builds.

Simple habits that stick

• Copy last period’s sheet and clear the old rows so you are not rebuilding the file every time.
• Enter invoices weekly instead of waiting until the end of the quarter; 10 rows a week is easier than 120 rows at once.
• Use the status column to catch missing province codes or zero-value errors before they reach the summary.
• Set aside the remittance amount in a separate bank account so the collected tax does not disappear into operating cash.

When to move on

If you are handling hundreds of invoices, multiple sales channels, or a more complex GST/HST structure, a spreadsheet starts to feel stretched. At that point, you should move to accounting software with tax codes and stronger audit tracking instead of forcing a manual workbook to do everything.