Canada · Free chart of accounts template

Alberta Chart of Accounts for Xero with GST Codes (Free)

A free Alberta chart of accounts for Xero: GST-only defaults on every account, a readable CSV plus a ready-to-import CSV with codes set.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV with the default and other valid Xero tax codes per account. Import file and rate list below.

Download chart of accounts (CSV)

Alberta gives bookkeepers the gentlest sales tax setup in Canada: a single 5% GST, no provincial layer, and no harmonization arithmetic. That very simplicity produces its own error pattern, because the ledger’s hard cases all arrive from outside the province. This Xero chart of accounts sets the GST default on every account using Xero’s Alberta rate names and marks exactly where the out-of-province exceptions belong.

The two-file package

The readable CSV is the working reference: account, class, default Xero tax code, other codes seen on that account, and a note saying why. The import CSV matches Xero’s chart-of-accounts import format with AB - GST on Purchases, AB - GST on Sales, and the custom 0% rates already in the Tax Code column, so accounts arrive coded instead of blank.

Three rates you add once

A Canadian Xero organisation starts with the provincial pairs only. Alberta work needs three more, all at 0%, created under Tax settings before you import: Zero Rated (groceries, exports, international fares), Exempt (bank fees, insurance, residential rent), and Out of Scope (wages, permits, drawings, transfers). They compute identical zeros but tell different stories to the CRA, and the exempt-versus-zero-rated distinction decides whether input tax credits on related costs survive.

Where an Alberta ledger actually goes wrong

Not on the 5%. The failure modes are imported:

  • Suppliers charging their province’s tax. An Ontario vendor’s 13% on goods delivered to Calgary is a place-of-supply error, not a bigger ITC. The purchasing accounts carry this warning because paying it quietly costs real money.
  • Sales into taxed provinces at 5%. Deliveries and clients in Ontario take 13%; BC and Quebec take their own systems. Xero seeds every province’s pair, so the correct rate always exists; the sales accounts list them as routine alternatives.
  • Foreign platforms under the simplified regime. SaaS and ad platforms that charge GST without being full registrants give you tax you cannot claim. Register your GST number with them instead. The software and advertising accounts flag it.

The federal quirks still apply at 5%: meals and entertainment carry a 50% ITC limit, recreational club dues yield no credit at all, and commercial rent is taxable while residential rent is exempt.

Import and daily rhythm

  1. Add the three custom rates in Xero (two minutes, once).
  2. Import via Accounting, then Chart of accounts, then Import; dry-run in a demo org if it is your first time.
  3. Remember Xero’s line-tax priority: contact default, then item, then account. These defaults are the floor, not a cage.
  4. Circulate the readable CSV; its notes are the induction doc for anyone touching the books.

Companies arriving in Alberta from an HST province should treat this chart as a remap, not a rename. The account list can carry over, but every default that used to say 13% now needs the AB pair, the exempt insurance note loses its provincial-tax rider, and the sales accounts’ alternatives flip from “occasionally another province” to “every non-Alberta client.” Running the import into a Xero demo organisation first shows the whole remapped picture in ten minutes and costs nothing.

Keeping thousands of small documents on the right side of those defaults is the recurring work. Dext pins recurring suppliers to rules. ExpenseFlow reads each receipt and bill, catches the wrong-province and simplified-regime cases before they post, and lands coded transactions in Xero against these accounts. Hubdoc captures and archives the documents behind the numbers.

Account numbering is conventional and gapped: 1000s assets, 2000s liabilities, 3000s equity, 4000s revenue, 5000s cost of sales, 6000s overheads, so growth never forces a renumber.

Working in QuickBooks? Use the Alberta chart of accounts for QuickBooks. The rates themselves are documented in the Alberta Xero tax rates reference.

Questions, answered

Common questions

Alberta has no sales tax of its own. Why do I need tax codes at all?

Because the federal 5% GST applies in Alberta on most business sales and purchases, and the zero-rated, exempt, and out-of-scope categories still exist. The chart's job is keeping the 5% lines and the no-tax lines correctly separated, which is what protects your input tax credits.

A supplier from Ontario billed me 13% HST. Do I just claim it?

Check the delivery first. Goods delivered in Alberta and most services supplied to an Alberta business should carry 5% GST, not the supplier's home rate. If the 13% was charged in error, the clean fix is a corrected invoice; the notes on the purchasing accounts flag this because it is the most common tax error on an Alberta ledger.

What do I create in Xero before importing?

Three custom 0% rates: Zero Rated, Exempt, and Out of Scope, added under the Tax menu, Tax settings, Tax rates. Xero's Canadian edition seeds only the provincial pairs like AB - GST on Purchases, and the import references the custom rates on accounts such as bank fees, insurance, and wages.

Can one account accept more than one tax code?

Yes, and the chart is designed around it. The account's rate is only a default that prefills lines (after the contact's and item's defaults). The readable CSV pairs each default with the other codes that legitimately appear on that account, like zero-rated groceries inside cost of goods sold.

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