TOOLS CLUB TEMPLATE

GST/HST/PST Tracker (Canada)

Canadian sales tax isn’t just about what you collect — it’s a net calculation between tax collected on sales and input tax credits on eligible purchases. This tracker logs both sides and calculates your net remittance automatically.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

GST/HST or PST registered Canadian businesses
Businesses tracking input tax credits alongside sales tax collected
Anyone who has miscalculated a net remittance before
Bookkeepers managing sales tax compliance for a Canadian business client

What's included

GST/HST or PST collected on sales, logged by period
Input tax credits (ITCs) on eligible business purchases
Automatic net remittance or refund calculation
Built-in AI prompt to flag upcoming filing deadlines

Why use a template instead of starting from scratch?

Tracking only what you collected and ignoring input tax credits significantly overstates what you actually owe — GST/HST/PST is a net calculation, and missing eligible ITCs means overpaying. This tracker keeps both sides visible together.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Log GST/HST or PST collected on sales

Track this by filing period, consistent with your registration.

Log input tax credits on eligible business purchases

This is tax you paid on business purchases that can be credited against what you owe.

Review the automatic net remittance calculation

This nets collected tax against your eligible input tax credits.

Run the built-in AI prompt as your filing deadline approaches

Attach the saved file to ChatGPT or Claude and ask if your period’s numbers look reasonable and complete.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your GST/HST/PST period numbers look reasonable and complete before filing, based on collected tax and input tax credits logged, no accounting background required.

Common Mistakes to Avoid

Not tracking input tax credits, only tax collected

This significantly overstates your remittance — ITCs on eligible business purchases directly reduce what you owe.

Claiming an ITC on an ineligible purchase

Not every business purchase qualifies for a full input tax credit — verify eligibility rather than assuming all business spending qualifies.

Missing your specific filing frequency

GST/HST/PST filing frequency depends on your registration and revenue — verify your specific required schedule rather than assuming a default.

Not registering when required

Small supplier thresholds determine when GST/HST registration becomes mandatory — verify your current status against your revenue.

Frequently Asked Questions

What’s the difference between GST, HST, and PST?

GST is the federal goods and services tax; HST is a harmonized combination of GST and a provincial component in certain provinces; PST is a separate provincial sales tax in provinces that haven’t harmonized. Which applies depends on where you operate and sell.

What is an input tax credit (ITC)?

It’s the GST/HST you paid on eligible business purchases, which can be credited against the GST/HST you collected from customers — reducing your net remittance.

Do I need to register for GST/HST?

Generally required once your revenue exceeds the small supplier threshold — verify the current threshold and your specific registration status.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Invoice Template for the underlying sales this tracker is built from.

How often do I need to file GST/HST/PST returns?

This depends on your registration and revenue level — could be monthly, quarterly, or annually. Check your specific assigned filing frequency.

What happens if I don’t claim all my eligible ITCs?

You end up remitting more than actually owed — tracking purchases consistently is what ensures you capture every eligible credit.

Should this tracker replace working with an accountant or bookkeeper?

No — GST/HST/PST compliance has real financial consequences if handled incorrectly. This tracker supports visibility and organization; professional guidance is valuable, especially for more complex situations.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club