GST/HST Return Worksheet & Input Tax Credit Tracker
Track GST/HST charged on sales and paid on expenses, and read off lines 101, 103, 106 and 109 for every quarter.
MTC_GST_HST_Return_Worksheet_Canada_2026.xlsx· 23 KB
Opens in Excel, Apple Numbers and Google Sheets (File, then Import).
- One-click download
- Free, no subscription
- Mac, PC & Mobile
- 100% Private & Offline
Canadian-Specific
Key Features & Capabilities
Designed specifically around Canadian payroll, tax forms, and account structures:
- Pick your province: the right GST/HST rate fills in automatically (all 13 provinces and territories)
- Sales log calculates the GST/HST you charged on each invoice
- Expense log works out input tax credits, including business-use %
- Return summary for lines 101, 103, 106 and 109, by quarter and for the year
- Notes on the $30,000 small supplier limit and ITC receipt rules
Complete Toolkit
What's Inside (5 Components)
Everything you receive immediately upon download:
- How to use guide
- Settings (province and rate table)
- Sales (120 rows)
- Purchases and ITCs (150 rows)
- Return Summary (GST34 lines)
Detailed Walkthrough
Your GST/HST return, already added up
Filing GST/HST is simple once your numbers are in one place: the tax you collected, minus the tax you paid on business expenses. This free worksheet keeps both logs and gives you the numbers for each line of the return.
What you'll fill in on the return
- Line 101: sales and other revenue
- Line 103: GST/HST collected or collectible
- Line 106: input tax credits (ITCs)
- Line 109: net tax: positive means you owe, negative means a refund
Good to know
You must register once your taxable sales pass $30,000 in four consecutive calendar quarters. To claim ITCs, keep receipts that show the supplier's GST/HST number for purchases of $100 or more. In Quebec, the QST is filed separately with Revenu Québec, so the worksheet uses the 5% GST there.
Target Audience
Who This Template Is For
Frequently asked questions
Do I have to charge GST/HST?
Once your taxable sales are over $30,000 in four consecutive calendar quarters, you must register and charge GST/HST. Below that you are a small supplier and registration is optional.
What are input tax credits?
The GST/HST you pay on business purchases. You subtract them from the GST/HST you collected, so you only send the difference to the CRA.
Does it work in Google Sheets and on a Mac?
Yes. It is an Excel workbook (.xlsx) that opens in Excel for Windows and Mac, Apple Numbers, and Google Sheets (upload it to Drive, then open with Google Sheets). Formulas recalculate as you type.
You Might Also Like
Other curated spreadsheets for Canadian finances
Free
Excel · Google Sheets
Self-Employed
Self-Employed Tax & Expense Tracker for Canada (T2125)
Track business income, CRA T2125 write-offs, GST/HST remittances, and vehicle mileage in one complete Excel workbook.
Free
Excel · Google Sheets
Self-Employed
Invoice Template for Canada (with GST/HST)
A clean, printable invoice that adds the right GST/HST for your client's province, plus a log that flags overdue invoices.
Free
Excel · Google Sheets
Budgeting & Debt
Canadian Personal Budget & Net Worth Dashboard (50/30/20)
Master your monthly cash flow, crush debt with snowball/avalanche, and track your growing net worth in Canadian dollars.