Canada · Free chart of accounts template

Alberta Chart of Accounts for QuickBooks Online with GST Codes (Free)

Free Alberta chart of accounts for QuickBooks Online: GST, Z, E and Out of scope mapped to every account, plus a ready-to-import CSV.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV pairing each account with its default QuickBooks code and the exceptions worth knowing.

Download chart of accounts (CSV)

A one-tax province deserves a chart that keeps its one tax effortless and its edge cases obvious. This Alberta chart of accounts for QuickBooks Online codes the routine at GST 5%, hands the zero-tax cases to Z, E, and Out of scope deliberately, and annotates the places where other provinces’ taxes legitimately enter an Alberta ledger.

The Alberta working set

Four codes cover in-province life. GST (5%) on taxable sales and purchases, fully creditable for commercial activity. Z for the zero-rated: basic groceries, exports, international transportation, where the 0% preserves your input tax credits. E for the exempt: financial services, insurance premiums, residential rent, where no credits attach. Out of scope for the non-supplies: payroll, source deductions, dividends and drawings, municipal permit fees, inter-account transfers.

The chart wires those defaults into account structure so the daily question is only “does this line match the account’s normal case,” with the readable CSV listing the legitimate exceptions per account.

Border traffic is the real coding work

Alberta’s simplicity ends at the provincial boundary, in both directions. Sales out: the buyer’s province writes the rate, so the sales and services accounts flag HST ON for Ontario deliveries and clients, the BC and Quebec sets where those apply, and Z for exports. Purchases in: goods delivered to Alberta should carry 5% regardless of the vendor’s home province, and the purchasing accounts warn about the classic error, an out-of-province supplier charging their own rate. QuickBooks’ built-in provincial code list makes the correct code a one-time enable under Taxes.

The third border is international and digital: foreign platforms under Canada’s simplified GST framework charge tax that is not claimable as an ITC. The software and advertising accounts carry the standing fix, which is registering your GST number with the vendor.

Federal rules that do not care how simple Alberta is

  • Meals and entertainment: 5% on the receipt, half of it claimable for most businesses; the account note tracks the adjustment.
  • Club memberships: no ITC on dining, recreation, or sporting clubs whatsoever, hence their quarantine account.
  • Rent: commercial space carries creditable GST; residential is exempt.
  • Vehicles: passenger-vehicle ITCs cap at the capital cost limit, and personal use is apportioned out.

Putting it to work

  1. Enable sales tax first; the codes must exist before anything can reference them.
  2. Import the account file under Settings, Import data, Chart of accounts, mapping its four columns.
  3. Adopt the readable CSV as the coding sheet for everyone entering bills or expenses.
  4. Skim out-of-province activity monthly; both directions of the border error are cheap to catch early and annoying late.

Two closing disciplines make the whole setup durable. First, retention: the CRA expects records kept for six years from the end of the year they relate to, so the receipt behind every coded line needs a home your future self can find, not a shoebox. Second, review: pick one week a quarter and re-read every line coded to E or Out of scope; those two codes are where wrong assumptions hide, because nothing about a zero-tax line looks broken at entry time.

Coding load in a small business is mostly small documents, and Alberta’s easy tax makes complacency the risk. Dext holds recurring suppliers to rules. ExpenseFlow reads every receipt and bill, applies GST, Z, E, or Out of scope for the actual supply, flags wrong-province tax before it books, and posts coded entries into QuickBooks against this chart. Hubdoc files the documents behind each line.

Numbering runs in gapped conventional ranges from 1000s assets to 6000s expenses, so the chart grows without renumbering. On Xero instead? See the Alberta chart of accounts for Xero; codes are explained in the Alberta QuickBooks sales tax reference.

Questions, answered

Common questions

Which sales tax codes does QuickBooks give an Alberta company?

Turning on sales tax provisions the flat GST code at 5% plus the country-wide trio: Z for zero-rated, E for exempt, and Out of scope. That is the entire working set for in-province activity; other provinces' codes come from the built-in list when a transaction needs them.

When would an Alberta business use an HST code?

Whenever the place of supply is an HST province. Deliver goods to Toronto or serve an Ontario client and the invoice carries HST ON at 13%, not GST at 5%. The same logic applies in reverse to purchases: something delivered to you in Alberta should carry 5% even if the vendor is in Halifax.

Is there any provincial tax to track on insurance here?

No. Premiums are exempt from GST, and Alberta, unlike Ontario or Quebec, adds no retail tax line on insurance. The premium books as a clean exempt cost.

Why do the import file and the readable file differ?

QuickBooks' chart import accepts only number, name, type, and detail type; tax codes attach to transaction lines, not to imported accounts. So the import creates the structure and the readable CSV carries the coding standard: default code, alternatives, and the reasoning per account.

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