Your year-end deductible total is the sum of the spending your accountant confirms as business-related, after you remove any personal share and keep a receipt for each item. You cannot read it off a bank statement, because the statement mixes everything. You build it in four moves: export a full year of transactions, tag each one, apply a business percentage where use is mixed, and add up by category.
This article covers the method and the records only. Which costs qualify, and by how much, is for your accountant or the official tax authority to say, and that can change from year to year.
What does "total deductible expenses" actually mean on a worksheet?
Think of it as a working figure, not a filing figure. It is the number you and your accountant start from. Each row in your list ends up in one of three buckets: clearly business, mixed use, or personal. Only the first two feed the total, and the second only in part.
- Clearly business: a software subscription used only for work, a course for your trade, a client's courier bill.
- Mixed use: home internet, a phone plan, a car used for both work and family. These need a business share.
- Personal: groceries, a family holiday, your own gym. These stay out, even if they were paid from the same account.
- Unsure: put these in a separate list with a question for your accountant. Do not guess them into the total.
How do I build the total, step by step?
- Download twelve months of statements for every account and card you used for work, as CSV or Excel where your bank offers it.
- Paste them into one sheet with columns: A Date, B Description, C Category, D Amount in C$, E Business share, F Working amount, G Receipt held (Yes or No), H Confirmed by accountant (Yes or No).
- Fill Category and Business share row by row. Use 1 for fully business and 0 for personal, and a decimal such as 0.4 for mixed use.
- In F2 enter =D2*E2 and fill down to the last row.
- Add up one category with =SUMIFS($F$2:$F$800,$C$2:$C$800,"Software"). Add up everything your accountant has signed off with =SUMIFS($F$2:$F$800,$H$2:$H$800,"Yes").
What does a worked example look like?
Say you are a self-employed designer. These are hypothetical figures for one year.
| Category | Spent in the year | Business share | Working amount |
|---|---|---|---|
| Home internet (C$95 x 12) | C$1,140 | 40% | C$456 |
| Software subscriptions (C$38.50 x 12) | C$462 | 100% | C$462 |
| Phone plan (C$70 x 12) | C$840 | 50% | C$420 |
| Online course | C$600 | 100% | C$600 |
| Total of the four lines | C$3,042 | - | C$1,938 |
Check the arithmetic: 1,140 x 0.40 = 456 and 840 x 0.50 = 420, so the working total is 456 + 462 + 420 + 600 = C$1,938. Client lunches of C$1,000 for the year sit in the "unsure" list, not in the total, until your accountant says how to treat them.
What if I am missing receipts or the statement is unclear?
Write the gap down instead of hiding it. Set column G to No for that row, and note what the payment was for while you still remember. Your statement proves money left the account; a receipt or invoice proves what it bought. Ask the supplier to re-send a receipt, or look for the confirmation email. Rows with no paper behind them are the first ones your accountant will question, so it helps to see them listed together.
Can my expense tracker produce this total for me?
A spreadsheet is enough for one person with a few hundred rows. Any tool that lets you set a category, split mixed use, attach a receipt and filter by a deductible flag will do the same job with less typing. SpendixAI is built around India and INR, so we do not offer it here as a Canadian product; the method above is what carries over.
A pre-meeting checklist
- All twelve months present for every account, with no gaps between statements.
- Every row has a category and a business share, even if the share is 0.
- Every business row has a receipt marked Yes or an explanation.
- The unsure list is written as questions, not guesses.
- Total at the bottom, plus a per-category subtotal.
Send the worksheet as one file rather than a chain of emails. Accountants can work with a clean list in minutes; a loose pile of screenshots takes much longer.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


