Category: Small Business Resources | Reading Time: 5 Minutes
Running a business in Ontario is hard work; tracking your expenses shouldn’t be.
At TaxMint, we often see clients scramble at year-end, digging through shoeboxes of receipts or trying to download twelve months of bank statements at once. This isn’t just stressful—it’s how you miss out on legitimate tax deductions.
To help you stay organized, we have created the TaxMint Business Expense Template. It’s a simple, CRA-friendly Excel sheet designed to match the T2125 (Statement of Business Activities) form we file for you.
[Download the Free Excel Template Here]
Why Use This Template?
The Canada Revenue Agency (CRA) has specific rules about what you can claim. Dumping a pile of receipts on a desk isn’t enough. Our template helps you:
- Separate HST: Essential if you want to claim your Input Tax Credits (ITCs).
- Categorize Correctly: We use the exact categories the CRA looks for (Advertising, Office Expenses, Travel, etc.).
- Audit-Proof Your Books: By logging details now, you save hours of headache if the CRA ever asks for proof later.
Step-by-Step Instructions
Tab 1: The Expense Log
This is your “Daily Diary.” Every time you buy something for the business, enter it here.
- Date: The date on the receipt (not the date it posted to your credit card).
- Category: Use the dropdown menu to select the type of expense.
- Vendor: Who did you pay? (e.g., “Staples,” “Shell,” “Zoom”).
- Subtotal vs. HST:
- If you are HST Registered, break out the tax in the “HST” column.
- If you are Small Supplier (Not Registered), combine the total into the “Subtotal” column (since you can’t claim the HST back).
💡 TaxMint Tip: A credit card statement is not a receipt. The CRA requires the detailed receipt showing what was bought. Snap a photo of every receipt and save it to a folder on your phone or computer.
Tab 2: Categories (The Dropdown)
We have pre-filled this with standard CRA categories.
- Meals & Entertainment: Only 50% of these are deductible, but please track the full 100% in the sheet. We will apply the 50% rule for you when we file your taxes.
- Vehicle Expenses: Only track fuel/repairs here if the vehicle is owned by the business. If you use your personal car, see the “Mileage” section below.
Tab 3: The Dashboard
You don’t need to touch this! This sheet automatically calculates your totals. When you send this file to us at tax time, we look at this summary to prepare your return instantly.
The 3 Golden Rules of Expense Tracking
1. The “Business Purpose” Test
If you buy a laptop, is it for the business? If you use it 50% for business and 50% for personal gaming, you can only claim 50% of the cost. Be honest with your percentages—CRA auditors look for this.
2. Personal Vehicle Mileage (The 2025 Rules) *
If you drive your personal car for work (e.g., visiting clients, picking up supplies), you must keep a Mileage Logbook.
- What to track: Date, Destination, Purpose of Trip, and Kilometers driven.
- The 2025 Rate: The CRA allows a tax-free allowance of 72¢ per km for the first 5,000 km, and 66¢ per km after that.
- Note: Driving from your home to your main office is considered “commuting” and is NOT deductible.
- *2026 Rates are not yet disclosed by CRA, as soon as it has been revealed we will be updating on here.
3. Beware of “Red Flag” Categories
- Clothing: You generally cannot deduct business suits. You can deduct uniforms or safety gear (like steel-toe boots).
- Golf Dues: Green fees and membership dues are strictly non-deductible in Canada.
- Late Penalties: You cannot deduct penalties or interest paid to the CRA.
Ready to get started?
Download the template and save it to your desktop. Update it once a week—it takes 5 minutes and saves you hours in April.
Got questions about a specific expense? Don’t guess. [Book a 15-Minute Consultation] with TaxMint, and let’s clarify your books before year-end.
Disclaimer: This guide provides general information and does not constitute professional legal or tax advice. Please consult with TaxMint for advice specific to your business situation.
Leave a Reply