A Canadian side hustle with mixed products, such as a baker who sells bread, pastries and gift boxes, benefits most from tagging every item in the sales log. Record the price, the tax added and a tag for the type of item, because tax treatment can differ between products. Which items are taxed and at what rate is for official guidance or an accountant to confirm; the log just keeps the facts.
Why mixed products complicate things
A till that rings up one total per customer hides which item was which. If a customer buys a loaf, a box of cookies and a coffee mug, and different items may be treated differently, you want a line per item type. You do not need to know the treatment yet. You need the evidence to apply it later.
Set up item tags before the season starts
- List your products once, with a short code such as BRD for bread, PAS for pastry, GFT for gift box.
- Add a column for the code on every sales line.
- Record price before tax, tax charged, and total.
- Record where it sold: market stall, online order, wholesale to a cafe.
- Note any discount given, as its own negative line.
One market day, calculated
Imagine a Saturday with the following sales, using a made-up 5 percent tax on the taxed items only.
| Code | Units | Price each | Tax | Line total |
|---|---|---|---|---|
| BRD | 40 | C$6 | C$0.00 | C$240.00 |
| PAS | 30 | C$4 | C$6.00 | C$126.00 |
| GFT | 10 | C$25 | C$12.50 | C$262.50 |
| Day | 80 units | C$610 net | C$18.50 | C$628.50 |
Check: 40 times 6 is 240; 30 times 4 is 120, and 5 percent of 120 is 6, giving 126; 10 times 25 is 250, and 5 percent is 12.50, giving 262.50. Net is 240 plus 120 plus 250, or C$610; tax is 6 plus 12.50, or C$18.50; the day is C$628.50. The point is the BRD line has no tax and the others do, which the tags make visible.
What about ingredients and supplies?
Keep a purchases log with the same columns: supplier, item, price before tax, tax charged, total. Flour in 20 kg bags, boxes, ribbon and the stall fee each get a row, and photographed receipts go in a folder per month. If a receipt does not show the tax separately, note that rather than guessing.
How do I handle cash and e-transfers?
Add them to the log at the end of each market day, from the cash tin count and the transfer notifications. A weekly total that matches the deposits into your account is the check that tells you nothing was missed.
Wholesale orders to a cafe deserve a sheet of their own, because they often come with an invoice, a delivery date and payment terms. Treat each as you would a customer invoice: a number, the lines, the total, and the date the cafe pays.
What happens to unsold or damaged stock?
Write it off in the log with a line of its own: 6 cookie boxes dropped, nil sale, cost of ingredients about C$14. It will not change your tax collected, but it explains why your ingredient spend looks heavy against sales that month. Over a season those lines also show which products are wasteful to make.
End-of-month checklist
- Total sales by tag.
- Total tax collected.
- Reconcile with deposits.
- File supplier receipts.
- Note any unsold stock thrown away or given out.
SpendixAI includes GST rate and ITC-eligible settings on categories, but it is designed for India and INR and is not intended for Canadian sales tax.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
