Moving Expenses Deduction Tracker (CRA Form T1-M)
Check the 40 km rule, track every moving cost by CRA category, and see what you can deduct on line 21900 this year and carry forward.
MTC_Moving_Expenses_Deduction_Tracker_Canada_2026.xlsx· 13 KB
Opens in Excel, Apple Numbers and Google Sheets (File, then Import).
- One-click download
- Free, no subscription
- Mac, PC & Mobile
- 100% Private & Offline
Canadian-Specific
Key Features & Capabilities
Designed specifically around Canadian payroll, tax forms, and account structures:
- 40 km eligibility check: old home vs new home distance to your new work or school
- Expense log with the CRA's categories, from movers to land transfer tax on the new home
- Employer reimbursements subtracted automatically
- Deduction limited to income earned at the new location, with the carry-forward worked out
- Notes on temporary living (15 days) and the simplified method
Complete Toolkit
What's Inside (4 Components)
Everything you receive immediately upon download:
- How to use guide
- Eligibility check
- Expenses (60 rows)
- Deduction (line 21900 and carry-forward)
Detailed Walkthrough
Moved for work? Deduct the cost
If you moved at least 40 km closer to a new job, business or full-time school, many moving costs are deductible on line 21900. This free tracker checks the rule, keeps your receipts organized and works out the deduction.
What you can usually deduct
- Movers, transportation and storage
- Travel costs: vehicle, meals and lodging on the way
- Temporary living near either home, up to 15 days
- Cancelling your old lease, or selling your old home (commissions, legal fees)
- Legal fees and land transfer tax on the new home, if you sold your old one
The income limit
You can only deduct up to the employment or self-employment income you earned at the new location this year. Anything left over carries forward to next year, and the tracker calculates both.
Target Audience
Who This Template Is For
Frequently asked questions
What is the 40 km rule for moving expenses?
Your new home must be at least 40 km closer (by the shortest normal route) to your new work or school than your old home was.
Can I deduct moving expenses if I moved late in the year?
Yes. If your deduction is more than the income you earned at the new location this year, the rest carries forward to next year.
Does it work in Google Sheets and on a Mac?
Yes. It is an Excel workbook (.xlsx) that opens in Excel for Windows and Mac, Apple Numbers, and Google Sheets (upload it to Drive, then open with Google Sheets). Formulas recalculate as you type.
You Might Also Like
Other curated spreadsheets for Canadian finances
Free
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.
Self-Employed
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.
Free
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.
