Skip to content
The title slide and first slides of the GST/HST Tracker template

GST/HST Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Small business owners who register for GST/HST use this tracker to prepare each return. The Sales tab records invoices with a supply type and rate and adds up the tax collected. The Purchases tab does the same for bills and credits only the business share. The Periods tab compares the two for each filing period and tracks its due date and status. Net owing and a period chart appear on the Dashboard.

Give each row its period when you enter it, so the Periods tab fills itself. Type the rate that fits the sale, since provinces and supply types differ, and use zero for zero-rated or exempt sales. Mark a period as Filed once the return is in and Paid once the payment has left your account. A tax professional can help with quick method, instalments and corrections.

Useful for

  • Prepare each GST/HST return from one list
  • Claim credits only on the business share
  • Watch due dates and unpaid periods

What's included

  • 5 tabs: Dashboard, Sales, Purchases, Periods, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sales: a table
  • Purchases: a table
  • Periods: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sales tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is an input tax credit?

It is the GST/HST you paid on business costs, which you can usually claim back against the tax you collected. The Credit claimable column applies your business-use share. Check the CRA rules for what qualifies.

Which rate should I enter?

Use the rate the CRA lists for the province and type of sale. This sheet keeps rates as inputs on every row because they vary and can change, so there is no default to trust.

Can this replace accounting software?

It is a tracker for the return, not a ledger. It suits a small business with a modest number of invoices. Larger shops usually keep the books in software and use a sheet like this only as a check.

  • #tax-tracker
  • #gst-hst-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…