Multi-location restaurant bookkeeping in Canada — a field guide
If you run 2+ restaurants, the bookkeeping problem isn't your accountant. It's the five spreadsheets you reconcile every month. Here's the workspace-and-tag pattern that ends Sunday spreadsheet hell, plus the T2125 / T2 lines specific to restaurant operations in Canada.
The actual problem
I run three restaurants in Toronto. The single most expensive monthly cost isn't payroll, food, or rent. It's reconciling receipts.
Five different people buy things for my businesses every day:
- Me — Costco runs, equipment from Restaurant Depot, supplier negotiations
- Two location managers — paper goods, weekly produce, condiments
- The prep cook — specialty ingredients spanning two locations
- The part-time supplier rep — wine, premium meat (vendor relationships)
By the end of any month, there are 600-1000 receipts spread across three locations and seven categories — food, paper goods, equipment, repairs, marketing, utilities, professional services. Each person had their own way of getting receipts to me: texts, emails, photos, paper at end of week.
Half my Sunday afternoon × four Sundays/month = 16 hours of my time. Plus four hours of bookkeeper time at $50/hour. About $10,000 a year of receipt reconciliation alone.
What didn't work
Each person keeps their own QuickBooks Online
Sounds clean, but in practice each manager refused to learn QBO at $28-39 CAD/month per workspace. Multiplied across locations, monthly QBO bills hit $100+. Worse, data didn't consolidate — I still ended up reconciling.
Manual shared Google Sheet with column headers
Cheap (free) and looks like the right answer. In practice: managers entered data inconsistently. Half the time the merchant was wrong, the date was off, or HST wasn't separated. Getting clean data took as much work as just doing it myself.
Dext for accountant-driven capture
Works for accountants, not for kitchen staff during dinner rush. UX assumes the user is a bookkeeper. $25-48 CAD/month per workspace got expensive across three locations. Killed the trial after a month.
Paper receipts in a Tim Hortons bag
How most multi-location restaurant owners actually do it. The accountant charges to sort. You pay them to type, not to advise.
The pattern that works: ONE workspace, tag by location
After a year of trying everything, the pattern that actually works:
- Create ONE workspace — call it "All Restaurants" or just your business name
- Invite each manager / staff buyer as a workspace member with upload-only role (they can submit receipts but can't see your books)
- Each receipt gets a Tag for the location — "King St", "Dundas", "Yorkville", "Catering" (3 taps on phone)
- All data lands in ONE Google Sheet that you own and your bookkeeper reads
- Owner filters by tag for per-location P&L; filter by category for total food cost; filter by vendor for supplier negotiations
The reason this works where the others didn't: permissions match human reality. Your kitchen staff can submit, but can't see books. Your bookkeeper sees everything but can't change permissions. You see and control everything. Each role gets exactly what they need, nothing more.
The T2125 / T2 lines specific to restaurants
Most multi-location operators are incorporated (T2 + Schedule 125), not sole proprietorships (T2125). The line numbering is similar but rolls up differently. Here are the categories that matter most for Canadian restaurants, with T2125 line numbers:
Cost of Goods Sold (food, beverages, paper)
Inventory purchases (raw food, alcohol, paper goods, packaging) are typically COGS, not operating expenses. Deducted as items are sold, not at purchase. This is the largest expense category for most restaurants — typically 28-35% of gross revenue.
Track separately from operating expenses by tagging receipts as "Food Cost" or "Beverage Cost" in your Sheet so your bookkeeper can apply COGS treatment correctly.
Line 9060 — Salaries, wages, benefits
Server tips reported on T4As, kitchen staff hourly, manager salaries. Not a receipt-capture issue (payroll runs separately) but key for monthly P&L.
Line 8910 — Rent
Per-location lease payments. Typically the second-largest expense after COGS + labour.
Line 9200 — Utilities (gas, hydro, water, internet)
Per location. Restaurants are utility-heavy — commercial kitchens consume 5-10× a typical retail space. Track each location's utility spend separately.
Line 8523 — Meals & Entertainment (50%)
Restaurants make staff meals available; the deductibility is 50% per CRA rules. R2Sheet's dashboard auto-applies this cap so your accountant doesn't have to. This is the most-missed line: most restaurant owners under-claim staff meals or claim at 100% accidentally.
Line 8521 — Advertising
Photography, social media ads (Instagram especially for restaurants), Google Ads, signage, food blogger / influencer comps, menu printing.
Line 8960 — Repairs & Maintenance
Kitchen equipment service (fridges, walk-ins, oven calibration), HVAC, plumbing, glassware breakage. Restaurants are R&M-heavy.
Line 8810 / 9270 — Operating supplies
Cleaning supplies, smallwares (knives, cutting boards, utensils under $500), uniforms. Small-tools rule applies: items over $500 each capitalize as CCA Class 8.
Line 8760 — Licenses, fees, dues
Liquor license, business license per municipality (Toronto, Vancouver, etc.), health permits, music licensing (SOCAN, Re:Sound), restaurant association dues.
Capital Cost Allowance (Class 8 — equipment)
Major kitchen equipment ($500+) capitalizes:
- Class 8 (general equipment): 20% declining balance
- Class 12 (small tools, kitchen utensils under specific threshold): 100% in year 1
- Class 13 (leasehold improvements — your restaurant build-out): straight-line over lease term
HST/GST/PST handling for multi-province operators
If you run restaurants in multiple provinces, taxation gets multi-flavored:
- Ontario, Nova Scotia, NB, PEI, NL: HST (combined federal + provincial) — 13-15%
- BC: GST 5% federal + PST 7% provincial (separate)
- Quebec: GST 5% federal + QST 9.975% provincial (separate, separately reported via Revenu Quebec)
- Saskatchewan, Manitoba: GST 5% + PST 6-7%
- Alberta: GST 5% only
Each receipt needs HST and PST split appropriately for ITC claims — and the PST is generally NOT claimable as ITC, only the GST/HST portion is. Most accountants spend hours separating these manually. R2Sheet does it per receipt automatically.
Quarterly HST filing across locations
For a 3-location Ontario restaurant chain, your quarterly HST is straightforward: aggregate HST collected on sales, subtract aggregated HST paid on supplier invoices, remit the net.
For a multi-province chain (Toronto + Vancouver), you have two separate filings: HST return for Ontario operations, plus GST + PST returns for BC operations. PST in BC is filed quarterly with BC's Ministry of Finance (separate from federal CRA).
Specific roles in the multi-location workflow
Owner (you)
Reviews the master Sheet weekly. Filters by location, by category, by vendor for negotiations. Catches anomalies (why did King St spend $3,000 on produce in one week?). Approves any receipts that landed in "Uncategorized".
Location managers
Snap receipts at the till during their shift. Tag location, tap submit. Done in 5 seconds. Don't see books, don't see other locations' data. Permission scope = upload only.
Kitchen / prep staff who buy ingredients
Same role as location managers. Each gets their own login, snaps from their phone.
Bookkeeper
Read access to the Sheet directly. Pulls totals into your accounting software (QBO, Sage 50, Xero) at month-end. Closes the books. Files HST quarterly.
External CPA / tax accountant
At year-end, gets the Sheet link. Uses the Dashboard tab to pull yearly totals per T2125 line / T2 Schedule 125 line. Files T1 / T2.
Real numbers from a 3-restaurant operation
From my own use over the last 12 months:
- Receipts captured: ~9,200 across 3 locations
- Hours saved (vs old workflow): ~16 hours/month × 12 months = 192 hours
- Bookkeeper hours saved: ~3 hours/month × 12 = 36 hours at $50/hour = $1,800
- Owner time value saved (at $80/hour): $15,360
- Total time savings annualized: ~$17,160
- R2Sheet cost: $4.99 CAD/month × 12 = ~$60
- ROI: 286×
The bigger win — and I genuinely mean this — is having Sundays back.
How to set this up (the actual workflow)
Day 1: Create the workspace
Sign up at r2sheet.ca/sign-up. Connect Google. Create workspace named after your business. Pick the Small Business template (or T2125 if sole prop).
Day 1: Set up Tags for each location
In Settings → Tags, add one tag per location: "King St", "Dundas", "Yorkville". Optionally add tags like "Catering" for side-business categorization.
Day 2: Invite staff as workspace members
Settings → Members → Invite. Each manager / staff buyer enters their email. They get an invite link, sign in with their own Google, can upload but not see books.
Day 2-3: Train staff (15 min per person)
Show each manager: open R2Sheet on phone → take photo of receipt → tap location tag → submit. That's it. Most kitchen staff get it on their first try.
Week 1: Run parallel
Keep your old workflow running for the first week. Have staff snap receipts AND give you the paper. Compare what R2Sheet captures vs what you'd have manually entered. Catch any AI extraction errors (rare but possible on faded receipts).
Week 2: Cut over
Stop the parallel run. From now on, R2Sheet is the canonical record.
End of month 1: Bookkeeper consults the Sheet
Share the Sheet read-only with your bookkeeper. They pull data into your accounting software. Closes books faster than ever.
This pattern works beyond restaurants
Same workspace + tag-by-location pattern applies to:
- Multi-store retail (clothing boutiques, salons, fitness studios)
- Service businesses with techs in different cities (cleaning, landscaping, HVAC)
- Multi-trades contractors with crews on different jobs
- Catering / food truck / mobile food service
Rule of thumb: if you have 2+ locations OR 3+ people buying things for the business, the workspace + tags pattern saves you Sundays.
Try it free
30 receipts/month free, $4.99 CAD/month for unlimited. No credit card to start.
r2sheet.ca/for-multi-location walks through the multi-location-specific setup.
r2sheet.ca/for-restaurants for the restaurant-specific page.
Try R2Sheet free
Snap a receipt → AI extracts merchant, HST, T2125 line → row appears in your Google Sheet. Free for 30 receipts/month, $4.99 CAD/month for unlimited.