If you're a Canadian freelancer searching for an expense tracker, you've probably noticed the problem: most templates are built for Americans. Wrong tax categories, no HST column, no T2125 alignment. You end up adapting something that doesn't quite fit.
This guide covers what to look for in a Google Sheets expense tracker built for Canada — and why the T2125 line structure matters more than you think.
300-row expense log, 15 T2125 categories, automatic HST calculation, monthly + annual summaries. Built for Canadian freelancers.
Get the Expense Tracker — $19The CRA's T2125 form (Statement of Business or Professional Activities) has specific line numbers for each expense category. When you file your taxes, every dollar needs to map to the right line. If your tracker uses generic categories like "Other" or American categories like "1099 expenses," you're doing double work at tax time — re-categorizing everything manually.
A proper Canadian expense tracker should use T2125 categories from day one:
Pro Tip: Meals and entertainment automatically get 50% applied at tax time under CRA rules. Your tracker should handle this math, not you.
If you're registered for HST/GST, your expenses need an extra column: the HST you paid (your Input Tax Credits, or ITCs). This reduces the HST you owe CRA.
Most generic expense trackers have no ITC column. That means at tax time you're going back through every receipt trying to calculate what HST you paid — on top of categorizing everything. It's exhausting.
A smart Canadian expense tracker calculates HST automatically from the total paid, using your province's rate from Settings. In Ontario, that's 13%. You just enter the total amount you paid, and the HST column fills in.
| Feature | Why It Matters |
|---|---|
| T2125 categories (dropdown) | Maps directly to your tax return — no re-categorizing at year-end |
| Auto HST calculation | Tracks ITCs automatically — saves hours at filing time |
| Monthly summary | Spot unusual months, see cash flow patterns |
| Annual summary by category | One-click view of total per T2125 line |
| Receipt tracking column | CRA requires receipts — know what's missing before audit season |
| Meals 50% auto-applied | CRA rule applied automatically — correct deduction amount |
FreshBooks, Wave, and QuickBooks are the common recommendations. But for most freelancers with straightforward income and expenses, they're overkill — and expensive.
Google Sheets advantages:
When to use accounting software instead:
For the average Canadian freelancer doing $30K-$200K in self-employment income with straightforward expenses? A well-built Google Sheets tracker is faster, cheaper, and less confusing.
Vehicle expenses are the #1 missed deduction for Canadian freelancers. CRA requires you to track:
Your deductible vehicle expenses = total vehicle costs × business-use percentage. Most people either forget to track this or don't know how to calculate it. A vehicle calculator tab built into your expense tracker makes this automatic.
When tax season comes, your accountant (or you, if you're filing yourself) needs total expenses by T2125 category. If your tracker is organized correctly all year, year-end is a 10-minute exercise. If it's not, it's a weekend of sorting through receipts.
The annual summary tab in a good tracker should show:
Our Canadian Expense Tracker has 300 rows, 15 T2125 categories, automatic HST, monthly + annual summaries, and receipt tracking. Built once, use every year.
Get the Expense Tracker — $19Yes. CRA requires original receipts for all business expenses. Your spreadsheet is a summary — not a replacement for receipts. Keep digital scans organized by year.
You can still deduct business expenses paid from a personal account. Just track them the same way. CRA doesn't require a separate business account (though it's recommended).
CRA requires you to keep records for 6 years from the end of the tax year they relate to.
Yes, as long as your home office is your principal place of business, or you use it exclusively and regularly to meet clients. The detailed method (based on square footage) is required for 2023+.