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.
One-time purchase · Instant digital download · Lifetime access
Available soon
Leave your email and we'll send you an instant note the day this template is released.
Your download includes
- MTC_Self_Employed_Tax_Tracker_Canada_2026.xlsx18 KB
- Google Sheets Cloud Copy Setup LinkInstant copy
- Instant file access
- No monthly subscription
- Mac, PC & Mobile
- 100% Private & Offline
Canadian-Specific
Key Features & Capabilities
Designed specifically around Canadian payroll, tax forms, and account structures:
- Pre-built categories mapped directly to CRA Form T2125 tax lines (Advertising, Meals, Office, Subcontracts, etc.)
- Automatic GST/HST collected vs paid tracker calculating exact Input Tax Credits (ITCs) and net remittance
- CRA-compliant Motor Vehicle Mileage Logbook with auto-calculating business-use percentage
- Home Office Workspace Deduction calculator factoring in rent, mortgage interest, heat, hydro, and internet
- Real-time Tax Reserve Estimator calculating your federal, provincial, and CPP self-employed obligations
- Export-ready T2125 Tax Summary table ready to copy straight into TurboTax, Wealthsimple Tax, or hand to your CPA
Complete Toolkit
What's Inside (9 Components)
Everything you receive immediately upon download:
- 1 × Professional Self-Employed Tax & Expense Workbook (.xlsx)
- 1 × Google Sheets Cloud Copy Access (Instructions Included)
- Interactive Financial Dashboard with live KPI revenue and profit cards
- Sales & Invoice Income Tracker with provincial GST/HST breakdown
- Categorized Expense Log with Input Tax Credit (ITC) tracking
- CRA Motor Vehicle Mileage Log with business-use deduction formula
- Home Office Workspace Deduction Calculator
- CRA Form T2125 Statement of Business Activities summary sheet
- Quick-start instruction manual and Canadian tax deduction cheatsheet
Detailed Walkthrough
Tame Canadian Tax Season Without Expensive Bookkeeping Software
If you're a freelancer, sole proprietor, gig worker, or small business owner in Canada, tax time usually brings one major headache: hunting down months of disorganized receipts, guessing vehicle mileage, and struggling to figure out which line on CRA Form T2125 (Statement of Business Activities) each expense belongs to.
The MTC Self-Employed Tax & Expense Tracker is built from the ground up for Canadian tax rules, eliminating the confusion and saving you hours of frantic calculations every spring.
📊 Comprehensive All-in-One Dashboard
Get an instant, visual snapshot of your business health in Canadian dollars ($ CAD):
- Gross Revenue & Net Profit: Real-time calculations show exactly how much your business earned after all allowable deductions.
- Estimated Income Tax & CPP Reserve: Automatically suggests how much cash to set aside for federal and provincial taxes plus the 11.9% combined self-employed CPP contribution.
- Net GST/HST Remittance: Subtotals tax collected versus Input Tax Credits (ITCs) paid, so you know your exact CRA remittance before your filing deadline.
🧾 Pre-Built CRA Form T2125 Expense Categories
Stop guessing how to categorize your expenses. Every dropdown matches official CRA categories:
- Line 8521 (Advertising): Digital ads, social media campaigns, print, and website hosting.
- Line 8523 (Meals & Entertainment): Automatically applies the CRA 50% allowable deduction rule.
- Line 8810 & Line 8811: Office expenses, stationery, software subscriptions, and materials.
- Line 8862: Legal, accounting, and professional consulting fees.
- Line 9220: Business mobile phone plans and internet service.
- Line 8964: Subcontractors, virtual assistants, and hired freelancers.
🚗 CRA-Compliant Motor Vehicle Mileage Log
If you drive for business (client meetings, job sites, rideshare, or delivery), the CRA strictly requires a logbook to justify your auto expenses. This sheet tracks starting and ending odometer readings, automatically computes your annual Business-Use Percentage, and applies it to your total vehicle operating costs (gas, insurance, maintenance).
🏡 Home Office Deduction Calculator
Deducting your home workspace is one of Canada's biggest tax write-offs. Enter your dedicated workspace square footage and total home area. The template calculates your deductible percentage and applies it to rent, mortgage interest, electricity, heating, water, and home internet.
💼 Ready to File or Hand to Your Accountant
When tax season arrives, open the T2125 Tax Summary tab. Every total is compiled into the exact line numbers requested by TurboTax Canada, Wealthsimple Tax, UFile, or your accountant. Filing takes minutes instead of an entire weekend.
Target Audience
Who This Template Is For
Frequently asked questions
Does this template match official CRA Form T2125 lines?
Yes. Every expense category in the tracker maps directly to CRA Form T2125 lines, including Line 8521 (Advertising), Line 8523 (Meals & Entertainment with the 50% rule automatically applied), Line 8810 (Office expenses), Line 9281 (Motor vehicle), and Line 9945 (Business-use-of-home).
How does the GST/HST calculation work?
The income sheet tracks GST/HST collected based on your client's province, while the expense sheet tracks GST/HST you paid to vendors. The dashboard automatically subtracts your Input Tax Credits (ITCs) from tax collected so you know exactly what you owe the CRA on your next remittance.
Does it work with Google Sheets, Excel for Mac, and Windows?
Yes. The workbook is formatted using standard OpenXML (.xlsx) and works natively in Microsoft Excel (Windows, Mac, iOS, Android) as well as Google Sheets and Apple Numbers.
Can I use this for multiple business years?
Yes! You can duplicate the template at the start of every tax year or create separate copies for multiple business ventures.
You Might Also Like
Other curated spreadsheets for Canadian finances
Save 69%
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.
Save 70%
Excel · Google Sheets
RRSP, TFSA & Investing
Canadian Registered Accounts Tracker (TFSA, RRSP & FHSA)
Consolidate your TFSA, RRSP, and FHSA contribution room, track investments across institutions, and rebalance your portfolio.
Save 69%
Excel · Google Sheets
Home Buying
First-Time Home Buyer & Mortgage Closing Cost Planner
Model down payments, CMHC insurance, Land Transfer Tax rebates, and every closing cost before making an offer.