Many expenses are partly personal and partly for work: a phone plan, home internet, a car. To summarise them honestly, add a business-use percentage column and multiply it by the amount, so the sheet shows the portion you believe relates to work. The percentage is your own estimate, and what portion is acceptable depends on your situation, so ask your accountant before relying on it.
Why does mixed use need its own column?
A single Yes or No flag hides the very thing that matters. A C$100 internet bill used for work 40 per cent of the time is not C$100 of work expense, and it is not zero either. A percentage column records your estimate and lets anyone reviewing it see the assumption.
What does the template look like?
| Column | Header | Example |
|---|---|---|
| A | Date | 2026-04-01 |
| B | Item | Home internet |
| C | Category | Utilities |
| D | Amount | 100.00 |
| E | Work use % | 40% |
| F | Work portion | =D2*E2 |
| G | Basis for the percentage | About 3 of 8 waking hours online for work |
Column F multiplies the amount by the percentage. If D2 is 100 and E2 is 40 per cent, F2 shows 40. Format E as percentage so that 40% is stored as 0.4. Column G matters most: write why you picked the number.
How do you total the work portion by category?
- =SUMIFS($F$2:$F$500, $C$2:$C$500, "Utilities") gives the work portion for one category
- =SUMPRODUCT($D$2:$D$500, $E$2:$E$500) gives the total work portion across all rows
- =SUM($D$2:$D$500)-SUMPRODUCT($D$2:$D$500, $E$2:$E$500) gives the personal remainder
SUMPRODUCT multiplies matching cells and adds the results, so no helper column is needed. Both functions exist in Excel and Google Sheets.
What does a worked summary look like?
| Item | Amount for the year | Work use | Work portion |
|---|---|---|---|
| Home internet | C$1,200 | 40% | C$480 |
| Mobile plan | C$960 | 50% | C$480 |
| Software subscriptions | C$600 | 100% | C$600 |
| Total | C$2,760 | n/a | C$1,560 |
Check: 1,200 x 0.4 is 480, 960 x 0.5 is 480, and 480 + 480 + 600 equals 1,560. These percentages are examples only, not suggestions for what you should use.
How often should the percentages change?
Review them when your situation does: a new job, a move, a change in working days. Keep a dated note when you change a percentage so the sheet shows its history. Never adjust old rows quietly to match a new estimate.
What about items that are not shared at all?
Items used entirely for work get 100 per cent, and items used entirely for yourself get 0. It is tempting to skip the second group, but keeping them in the list with a zero makes the total of the sheet match your statements, which helps when you reconcile at year end. A single-purpose purchase, such as software you only use for client work, is easy to defend. A shared one needs the written basis. The fewer percentages that sit between 1 and 99, the less you have to explain.
When your accountant asks how you arrived at a figure, you can open the basis column, read the sentence you wrote on the day, and talk through it. That conversation is short when the reasoning is already on the page, and long when you are reconstructing it from memory.
What goes in the handover?
- The transaction list with the work-use column filled in.
- The category summary with both totals and the personal remainder.
- A note listing every percentage and its basis.
- Receipts or statements for each line over an amount you and your accountant agree.
One last point: SpendixAI is built around India and rupees, so it is not offered for Canadian-dollar records. Its categories hold tax-deductible and ITC-eligible settings, but it does not replace a conversation with your accountant.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
