Canada · Free chart of accounts template

Ontario Chart of Accounts for Xero with HST Codes (Free)

A free Ontario chart of accounts for Xero: every account carries its default HST treatment, as a readable CSV plus a ready-to-import CSV.

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 tax-rate list below.

Download chart of accounts (CSV)

This is a chart of accounts built for an Ontario business running on Xero, with the HST treatment carried on every account using Xero’s real Canadian rate names. Ontario is the simplest of the big provinces to code: one harmonized 13% line covers both the federal and provincial parts, it appears as a single tax on invoices, and the whole amount is generally recoverable as an input tax credit when the purchase is for commercial activity.

What you get

  • A readable CSV listing each account with its class, its default Xero tax code, the other codes that legitimately show up on that account, and a one-line reason.
  • A Xero import CSV in the chart-of-accounts import format, with ON - HST on Purchases, ON - HST on Sales, and the 0% rates already sitting in the Tax Code column.

Do this first: add three 0% rates

Xero’s Canadian edition ships with the provincial purchase and sale pairs only. For Ontario that means ON - HST on Purchases and ON - HST on Sales exist on day one, but nothing for the zero-rated, exempt, or outside-scope cases. Before importing, go to the Tax menu, open Tax settings, then Tax rates, and add three custom rates at 0%: Zero Rated, Exempt, and Out of Scope. A custom rate can apply to both sales and purchases, so three rates cover both sides. Skip this step and Xero will reject the rows that reference them.

The distinction is worth the two minutes. Zero-rated and exempt both mean no tax on the line, but they are different answers to the input-tax-credit question: zero-rated supplies keep your ITCs intact, exempt ones do not, and the CRA cares which story your return tells.

The Ontario defaults this chart encodes

  • 13% HST both ways: sales income defaults to ON - HST on Sales, and most cost accounts default to ON - HST on Purchases with a full ITC.
  • Meals and entertainment default to 13% but the account note flags the rule that surprises people: only half the HST is claimable for most businesses.
  • Bank fees are exempt financial services, and insurance is exempt from HST but usually carries Ontario’s separate 8% RST, which is a cost, not a credit.
  • Commercial rent is taxable at 13% while residential rent is exempt, so the rent account defaults to the taxable side with exempt as the listed alternative.
  • Wages, drawings, depreciation and other non-supplies sit on Out of Scope.

Place of supply keeps the other provinces relevant

The 13% default is an Ontario assumption, not a rule. GST/HST follows the buyer’s province for sales and the delivery province for goods, so an Ontario company invoicing a Calgary client charges 5% GST, and Xero’s seeded AB - GST on Sales rate is the right pick for that line. The readable CSV’s “other codes” column exists exactly for this: the default covers the common case, the alternatives remind whoever codes the books which exceptions are legitimate on that account.

How to use it

  1. Create the three custom 0% rates described above.
  2. Adjust account names and numbers to the business; keep the tax defaults.
  3. Import via Accounting, then Chart of accounts, then Import, ideally into a demo org first.
  4. Hand the readable CSV to whoever codes transactions as the house coding sheet.

The chart imports correctly once; keeping every transaction on the right code afterwards is the ongoing work. Hubdoc remembers how you coded a recurring supplier. ExpenseFlow reads each receipt or bill, applies the correct Canadian treatment for the supply, including the exempt and zero-rated cases and the buyer’s-province rate, then posts it to Xero against the right account. Dext applies per-supplier rules so repeat purchases land consistently.

Numbering is range-based: assets in the 1000s, liabilities 2000s, equity 3000s, revenue 4000s, cost of sales 5000s, and operating costs 6000s, with gaps left so new accounts slot in without renumbering.

On QuickBooks instead? Use the Ontario chart of accounts for QuickBooks. For the rate list itself, see the Ontario Xero tax rates reference.

Questions, answered

Common questions

Why do I need to create tax rates before importing?

Xero's Canadian edition seeds only the provincial pairs, such as ON - HST on Purchases and ON - HST on Sales. It has no default zero-rated, exempt, or out-of-scope rate. This chart references three custom 0% rates named Zero Rated, Exempt, and Out of Scope; create them under Tax settings before importing so every Tax Code in the file matches a rate that exists.

Is HST 13% the only rate an Ontario business uses?

No. It is the default because most Ontario purchases and Ontario sales carry 13% HST, but the rate follows the place of supply. Sell to an Alberta customer and you charge 5% GST; buy something delivered in BC and the invoice shows BC taxes. Xero seeds every province's purchase and sale rates, so the right code always exists.

Can I change the tax code on a single transaction?

Always. The account's tax code is the lowest-priority default: Xero first looks at the contact's default rate, then the inventory item's, then the account's, and you can override the line manually. The account setting just prefills the common case.

Which accounts stay out of the import file?

Accounts receivable, accounts payable, the GST/HST account, and retained earnings. Xero creates those system accounts on its own, and importing duplicates causes errors. The readable CSV lists them anyway, marked as system accounts, so the chart is complete on paper.

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