Canada · Free chart of accounts template

Alberta Restaurant + Hospitality Chart of Accounts for Xero (Free)

Free Xero chart of accounts for Alberta restaurants: zero-rated ingredients vs 5% menu, AGLC licences, alcohol stock, with import CSV.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV of hospitality accounts with Xero GST defaults and the ingredient-level exceptions.

Download chart of accounts (CSV)

Feeding people in Alberta means running the one genuinely tricky consumer-goods tax boundary in a province that otherwise has almost none: groceries in at zero, meals out at 5%, with snack food and pop switching sides depending on what they are. This Xero chart of accounts keeps that boundary at the account level, where it can be coded at delivery-slip speed.

Stock accounts with opinions

Food stock and ingredients defaults to the custom Zero Rated rate, because basic groceries are taxable at 0% across Canada, and lists AB - GST on Purchases for the exceptions the distributor mixes into every order: confectionery, carbonated drinks, prepared items. Alcohol stock stands alone at 5% with its note debunking the usual worry: resale inventory earns a full input tax credit, and the AGLC markup is baked into wholesale pricing rather than appearing as a codable tax line. Kitchen and bar equipment holds the capital purchases whose GST claims and capital cost allowance both want a clean history.

Revenue mirrors it: food and beverage sales carries AB - GST on Sales, because everything prepared and sold in Alberta, dine-in or takeout, is a 5% supply.

The operating layer

  • Liquor and business licences code Out of Scope; AGLC and municipal fees are regulatory charges with no credit inside.
  • Cleaning and laundry and smallwares and consumables run at 5%, claimable, and constant.
  • Staff events and welfare plus meals and entertainment carry the 50% ITC warning; consumption is not resale.
  • Insurance is exempt, and in Alberta the premium arrives with no provincial tax rider at all.

Before the accounts, three rates

Xero’s Canadian edition seeds only the provincial pairs, so the zero-rated ingredient default cannot exist until you create it: add Zero Rated, Exempt, and Out of Scope as custom 0% rates under the Tax menu, Tax settings, Tax rates, then import via Accounting, Chart of accounts, Import. Xero resolves each line’s tax by contact, then inventory item, then account default, which means distributor-level defaults you add later can sharpen, not fight, this chart.

Tips and gift cards, the two revenue impostors

Two flows move through a till without being sales. Tips belong to staff: they pass through as a liability, never touch the revenue account, and carry no GST. Gift cards are deferred revenue: selling one creates a liability with no tax event, and the GST arrives when the card buys an actual meal, at the 5% the meal carries. Post both through their own liability accounts and the daily summary stays a clean statement of what the kitchen actually sold. Mixing either into food and beverage sales inflates revenue, miscounts tax, and makes the POS reconciliation quietly impossible.

Service rhythm

  1. Post daily sales as one POS summary per day, taxable total plus GST, and reconcile monthly to the POS tax report.
  2. Code broadline invoices line by line; a single delivery mixing zero-rated and 5% lines is Tuesday, not an exception.
  3. Keep bar purchases in alcohol stock even when they ride a general supplier statement.
  4. Calendar the licence renewals; out-of-scope is also out-of-credit, so nothing needs hunting there.

The back-of-house paper flow decides whether the books stay true, and it never slows down. Dext holds distributor coding steady with supplier rules. ExpenseFlow reads every invoice line, splits zero-rated stock from taxable items on the same document, keeps licences out of scope, and posts coded entries into Xero against this chart. Hubdoc archives the paperwork the health of the file depends on.

Running the kitchen on QuickBooks? The mirrored build is at Alberta hospitality chart of accounts for QuickBooks; rate mechanics are in the Alberta Xero tax rates reference.

Questions, answered

Common questions

What changes between buying food and selling food in Alberta?

The rate flips. Raw ingredients bought as basic groceries are zero-rated; the prepared meal sold across the counter carries 5% GST. Alberta keeps it simpler than the HST provinces because the flip is only between 0% and 5%, but the flip still exists on every ingredient that becomes a menu item.

How does AGLC liquor pricing show up in the books?

As cost, not as a tax line. Alberta's liquor markup is embedded in wholesale prices before your invoice is printed, so there is nothing to code for it; the GST on the invoice is the only tax line, and it is fully creditable on resale stock.

Are staff meals and comps a tax problem?

They are a category problem. Meals consumed rather than sold fall under the 50% ITC limitation like any business meal, which is why staff events and the meals account carry warnings while the stock accounts, being resale inventory, claim in full.

What setup does the import expect?

The seeded AB - GST pair plus three custom 0% rates you add first under Tax settings: Zero Rated, Exempt, and Out of Scope. Ingredient stock leans on Zero Rated, licences on Out of Scope, and the rest of the chart on the AB pair.

Keep exploring

Stop filling in spreadsheets by hand

A template is a starting point. ExpenseFlow captures receipts, reads the tax automatically, and posts the cleaned record to Xero or QuickBooks Online, so the log keeps itself.

Start free trial