Tax and GST

Tax-deductible expenses summary: tracking mixed personal and business use

A Canadian-dollar summary template for expenses used partly for work and partly at home, with a business-use percentage column and the formulas to total it.

Editorial illustration for Tax-deductible expenses summary: tracking mixed personal and business use

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?

ColumnHeaderExample
ADate2026-04-01
BItemHome internet
CCategoryUtilities
DAmount100.00
EWork use %40%
FWork portion=D2*E2
GBasis for the percentageAbout 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?

ItemAmount for the yearWork useWork portion
Home internetC$1,20040%C$480
Mobile planC$96050%C$480
Software subscriptionsC$600100%C$600
TotalC$2,760n/aC$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?

  1. The transaction list with the work-use column filled in.
  2. The category summary with both totals and the personal remainder.
  3. A note listing every percentage and its basis.
  4. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports