QST GST Return Excel - Free Template

1. Open the Transactions sheet and enter each sale or expense on its own row. Include the date, invoice or receipt number, client or vendor, province, and taxable amount.
2. Choose the correct GST and QST rates for the transaction. The sheet calculates the tax amounts and the total invoice or bill value for you.
3. Review the QST_GST_Return sheet at the end of the filing period. Check the totals for tax collected, tax paid, and the net amount.
4. Use the Dashboard sheet to confirm that the totals look reasonable before you file. If a number looks off, go back to Transactions and fix the source entry.
5. Keep the Instructions sheet open the first time you use the file. It shows the intended workflow so you can stay consistent month after month.
6. Save a copy for each filing period if you want a clean archive. That makes it easier to compare one return against the next one later in the year.

This workbook is for you if you file Quebec sales tax regularly and want one place to see taxable sales, tax paid, and the net remittance. A sole proprietor with 18 invoices in a month, a small incorporated shop with 240 receipts, or a bookkeeper handling several clients can all use it without changing systems.

When this helps most

The pressure point is usually filing time. If you collect $1,250.00 in GST and $1,875.00 in QST on monthly sales, you do not want to rebuild those numbers by hand from a stack of invoices the night before the deadline.

What the sheet is doing

The Transactions sheet records each row once, then the QST_GST_Return sheet adds up the period totals. That is much faster than retyping the same invoice data into a separate spreadsheet for filing, especially if you have sales, refunds, and mixed vendor bills in the same period.

A practical example

Say you run a small service business with 40 taxable invoices at $150.00 each in a month. That is $6,000.00 in taxable sales before tax, and the workbook lets you carry the GST and QST amounts through to the return without manual addition every time.

Those taxable sales still need to tie back to the source records, and the revenue reconciliation sheet is the next step for matching the totals to what gets filed.

For Quebec filing, you need records that support the tax you charged and the input tax you claimed. The CRA requires business records to be kept for six years, and in practice that means your workbook should line up with source documents, not guesses.

Tax numbers you need to handle correctly

GST is 5%. QST is 9.975%, and in Quebec the QST calculation is not just a simple add-on when the tax is taxable on the GST-inclusive base. If you sell a $100.00 item, the combined tax is $14.98 in most standard cases, which is why separate fields for GST and QST matter.

Registration and filing basics

If your worldwide taxable revenue is over $30,000.00 over four consecutive calendar quarters, GST/HST registration becomes mandatory. Once you are registered, your filings may be monthly, quarterly, or annual depending on your assigned cycle, and your workbook should match that period exactly.

Why the return sheet matters

The QST_GST_Return sheet gives you a filing-ready summary for the period, which is what you need when you compare your collected tax against your deductible tax credits. If you are using the regular method, the detail in Transactions supports those numbers line by line.

The most common problem is a transaction entered with the wrong tax rate or the wrong province. A $2,400.00 invoice marked as Ontario instead of Quebec can distort both GST and QST calculations, and the error usually shows up only when you are already trying to file.

Missing receipts and unsupported claims

If you claim tax paid on a vendor bill without the invoice number, date, or vendor name, you will spend time fixing the backup later. On audit, weak support can mean denied input tax credits and a return that has to be adjusted.

Rounding and mixed amounts

Another issue is mixing tax-inclusive and tax-exclusive entries in the same sheet. If 12 receipts are entered as tax-inclusive and 8 are entered as tax-exclusive without a clear method, the return summary can be off by dollars, not cents.

Why a spreadsheet beats memory

People often trust a bank balance and forget that sales tax is not their money. If you collected $3,000.00 in tax during the quarter and spent $1,200.00 of it before setting it aside, the filing becomes a cash flow problem instead of a bookkeeping task.

That is exactly the point where a quick HST worksheet keeps the quarter’s tax separate from operating cash.

The easiest way to make this spreadsheet stick is to use it on the same day every week or every month. Many small businesses update it after the payroll run, after bank reconciliation, or on the last business day before the GST/QST deadline.

Simple habits that keep it alive

• Enter transactions in one batch, such as every Friday afternoon, so you are not chasing receipts all month.
• Copy the prior filing period and clear the old rows if you want a repeatable monthly or quarterly routine.
• Use the Dashboard as your check step so totals do not drift unnoticed.

When to move beyond the spreadsheet

If you are processing 300 orders a month, have several tax codes, or need detailed audit trails for multiple staff, you may outgrow a manual workbook. At that point, an accounting system with sales tax modules and bank feeds will usually save more time than a spreadsheet can.

The practical cutoff

For a small service business with under 100 entries per filing period, this template is often the fastest way to stay organized. Once the volume is high enough that you spend more time correcting entries than filing the return, it is time to automate.