Google Sheets Expense Tracking Template for T2125: Free Download + Auto-Import
If you file CRA Form T2125 as a Canadian self-employed individual, using a properly structured Google Sheets template saves hours at tax time. This guide covers what your T2125 tracker should include, how to structure it for CRA compliance, and how to skip the manual data entry entirely with R2Sheet.
Why Use Google Sheets for T2125 Expense Tracking?
Before spending $37/month on Dext or QuickBooks, most Canadian freelancers can get everything they need from a well-built Google Sheet:
- Free: Google Sheets is free. A $37/month subscription isn't necessary for basic T2125 filing.
- Shareable: Send a link to your accountant — they can view, filter, and export without any special software.
- Customizable: Structure your categories exactly to T2125 lines. Add columns for HST, project codes, or payment methods.
- CRA-accepted: Google Sheets is digital recordkeeping the CRA accepts. A printed copy or exported CSV is sufficient for audits.
- Mobile-friendly: Access from any device — phone, tablet, laptop. No app to install.
What Your T2125 Google Sheets Template Must Include
A compliant T2125 expense tracker needs, at minimum, these columns:
| Column | Purpose | Required by CRA? |
|---|---|---|
| Date | Date of purchase | Yes |
| Merchant / Vendor | Who you paid | Yes |
| Description | What was purchased | Yes |
| Amount (pre-tax) | Business expense amount | Yes |
| HST / GST paid | For ITC claims | If HST registered |
| T2125 Category | Which line on the form | Yes |
| Currency | CAD vs USD, etc. | If foreign |
| Receipt link | Google Drive link to image | Recommended |
| Project / Client | For multi-client businesses | No (but helpful) |
T2125 Category Mapping: Line Numbers to Use
The most important part of your template is mapping expenses to the correct T2125 lines. Here are the key categories for Part 4 of T2125:
Google Ads, Facebook Ads, flyers
Business credit card interest
Business liability insurance
Client lunches — CRA only allows 50%
Supplies, postage, paper
Phone plan, internet (business %)
Flights, hotels for business trips
Gas, maintenance, insurance (business %)
Accountant, lawyer
Renting a workspace outside home
Pro-rata rent/mortgage interest, utilities
Adobe, Figma, Notion — business use
Adding an HST / ITC Tracking Tab
If you're registered for HST/GST, your Google Sheet should also track input tax credits (ITCs) to recover the HST you paid on business expenses. Add a second tab with:
- HST paid per receipt (extracted from the receipt)
- Business-use percentage (e.g., 80% for a phone used 80% for work)
- Claimable ITC amount (HST × business %)
- Quarterly totals (Q1–Q4)
- 50% reduction for meals (CRA rule: only half of meal HST is claimable)
Skip Manual Entry: Auto-Import Receipts with R2Sheet
Building the template is the easy part. The hard part is actually filling it in — manually entering 200+ receipts per year. That's where most people give up.
R2Sheet generates a Google Sheet structured exactly for T2125 and auto-populates it when you upload receipts. AI extracts the date, merchant, amount, and HST, picks the correct T2125 category, and logs the row — in seconds.
What R2Sheet generates automatically:
- ✓Expenses tab — all receipts logged with T2125 category
- ✓Dashboard tab — monthly totals, category breakdown, quarterly HST summary
- ✓Drive links — each row links back to the receipt image in your Google Drive
- ✓50% meals auto-reduction applied
- ✓HST extracted and ITC calculated per receipt
Limitations of a Manual Google Sheets Template
A DIY Google Sheets template works well if you're consistent. But there are real limitations:
- ✗Manual entry is tedious — most people fall behind and do it all at year-end
- ✗Easy to miscategorize expenses (wrong T2125 line = incorrect return)
- ✗No receipt image linking — you need a separate folder system in Drive
- ✗HST calculation must be done manually per receipt
- ✗No reminder when receipts are missing or ambiguous
These limitations are why tools like R2Sheet exist — not to replace your Google Sheet, but to eliminate the manual data entry that makes the system break down in practice.
Frequently Asked Questions
Is there a free Google Sheets T2125 template I can download?
Yes. R2Sheet generates a pre-structured T2125 Google Sheet automatically when you sign up. It includes an Expenses tab with T2125 categories and a Dashboard tab for summaries. Free plan available.
Can I use a Google Sheet as my official business records for CRA?
Yes. The CRA accepts digital records including Google Sheets, as long as they are a true representation of your transactions and you have supporting receipts. You don't need to print anything — but you must be able to produce the records on request.
What's the difference between T2125 categories and regular bookkeeping categories?
T2125 categories map directly to line numbers on the official CRA form. Regular bookkeeping categories (like "cost of goods sold" or "operating expenses") are more general. Using T2125-specific categories makes it easier to transfer numbers directly to your tax return.
Can I track mileage for T2125 in Google Sheets?
Yes. Add a Mileage tab with columns for date, destination, purpose, and kilometers. At year-end, total your business kilometers, divide by total kilometers driven, and apply that percentage to vehicle expenses. Use the CRA's prescribed rate for simplified mileage deductions.
Get Your T2125 Google Sheet — Automatically
Sign up free. R2Sheet creates your T2125-structured Google Sheet instantly, then auto-populates it every time you upload a receipt.
Start Free →No credit card required · Free plan: 30 receipts/month