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.
| Category | Monthly cost | Business share | Business amount |
|---|---|---|---|
| Internet | CA$95 | 40 percent | CA$38 |
| Phone plan | CA$70 | 50 percent | CA$35 |
| Coworking pass | CA$200 | 100 percent | CA$200 |
| Total | CA$365 | n/a | CA$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?
- Check that every receipt has an amount and a tax figure or a missing-tax flag.
- Total business amounts by category.
- Total the tax column for the same rows.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

