Expense categories

Expense categories with tax and business-use flags (Canada)

Create categories for a freelancer or small business that track tax paid and the business share of mixed costs, with a CA$273 worked example.

Editorial illustration for Expense categories with tax and business-use flags (Canada)

For a Canadian reader asking about GST rate and input tax credit flags, the practical version is a category list with three attributes: the tax amount on the receipt, a business-use share, and a confirm flag. Fill them in once per category and your month-end totals nearly build themselves.

Which costs are really mixed?

The hardest purchases are not equipment but the ones used for work and home life: internet, a phone plan, a spare room, a car. Each needs a business-use percentage that you can explain and repeat.

How do the business shares add up?

These numbers are invented. A home internet bill is CA$95 and you use 40 percent for work; a phone plan is CA$70 at 50 percent; a coworking pass is CA$200, all business.

CategoryMonthly costBusiness shareBusiness amount
InternetCA$9540 percentCA$38
Phone planCA$7050 percentCA$35
Coworking passCA$200100 percentCA$200
TotalCA$365n/aCA$273

95 times 0.40 is 38; 70 times 0.50 is 35; and 38 + 35 + 200 equals 273. The personal part is 365 minus 273, which is CA$92.

How do you choose a fair percentage?

  • Base it on something you can describe, such as hours of work use against total use.
  • Keep the same figure from month to month unless your pattern changes.
  • Write the reasoning in the category note.
  • Ask your accountant whether the share is acceptable for that type of cost.

Where does the tax amount go?

Put it in its own column. If a receipt shows CA$11.50 of tax on a CA$100 item, the total is CA$111.50 and the tax field holds 11.50. Do not apply the business share to the item and forget the tax; apply it to both and keep both visible.

What is a sensible month-end routine?

  1. Check that every receipt has an amount and a tax figure or a missing-tax flag.
  2. Total business amounts by category.
  3. Total the tax column for the same rows.
  4. List items marked confirm for your accountant.

What about a home office?

A home office usually mixes several costs: part of rent or utilities, internet, furniture. Do not try to solve it all at once. Create a Home office category with a note describing how you measured the space or hours, and record each cost at its full amount. Your accountant can then apply whatever share is right, and the full figures stay in your records.

Write the date you last reviewed the share. A figure that has not been looked at for two years is probably out of date.

A final point on shares: write the percentage as a number in its own cell, such as 40, rather than burying it in the notes. Then a formula like =C2*D2/100 gives the business amount, where C holds the cost and D holds the share. Changing the share in one place updates every row that depends on it.

If you split a bill across two categories instead, make sure the two parts add up to the original total, otherwise your category totals will not match the bank statement.

When a spreadsheet gets heavy

If you track in rupees, SpendixAI categories can carry a GST rate, an ITC-eligible setting and a tax-deductible setting, and its figures are estimates to check with a CA. It is built around India and INR and is not described here as available for Canadian dollars.

SPENDIXAI JOURNAL

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

Explore your reports