Budget planners
Grocery Budget Tracker (Canada)
Grocery budget tracker spreadsheet for Canadian households who do one big shop every week or two. Log each trip on its own tab, and the workbook adds up the subtotal, sales tax and trip total, then keeps a running total for the year on the Dashboard.
C$7CAD
Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.
- Instant download, nothing shipped
- Excel 2016+ and Google Sheets
- Filled-in sample file included
- Damaged or not as described? Fixed or refunded within 60 days
Prefer Etsy? Buy this template in our Etsy shop.
What it does
- 50 trip tabs, each with about 70 common grocery and household items in 10 groups: produce, meat and seafood, dairy and eggs, bread and baking, pantry, spices, frozen, snacks, beverages, health and household
- Type the quantity and unit price for what you bought; subtotal, tax and total fill in for you
- 6 blank rows on every trip for anything not on the list, and you can rename any item
- Pick your province once and household (Non-Food) items are taxed at its combined GST/HST and PST/QST rate. Food rows stay untaxed. Change any line's tax type to match your receipt
- Dashboard: total spent, trips logged, average trip, highest trip, a running total, and a spend-per-trip chart
- Click a trip name on the Dashboard to jump to that tab
- Sales tax table for all 13 provinces and territories, with rates you can edit if one changes
What you get
- XLSXBulk-Grocery-Trip-Tracker.xlsx. Trip 01 and Trip 02 hold invented sample purchases so you can see it working; clear them before you start. Trips 03 to 50 are empty
- PDFQuick-start guide (PDF)
Please note
Made for Canadian provinces and territories. Tax is simplified: Food rows are untaxed and Non-Food rows are taxed at your province's combined rate. Many basic groceries are zero-rated, but some foods (snacks, soft drinks, prepared food) can be taxable, so match the tax type to your receipt. The rates in the file are inputs: check them against current government rates. A tracking tool, not tax advice. For personal use; please don't resell or share the file.
Disclaimer
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor, lawyer or certified tradesperson). Check the results before you rely on them.
How it was made
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release.
Questions
Email varsdigitals@gmail.com and we'll help you get set up.
