Canada · Free chart of accounts template

Ontario Chart of Accounts for QuickBooks Online with HST Codes (Free)

Free Ontario chart of accounts for QuickBooks Online: HST ON, Z, E and Out of scope mapped per account, with a ready-to-import CSV.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV with the default and other valid QuickBooks sales tax codes per account. Import file and code list below.

Download chart of accounts (CSV)

This chart of accounts gives an Ontario company a clean QuickBooks Online setup where every account is mapped to the sales tax code its transactions should normally carry: HST ON for the taxable 13% lines, Z where the zero rate applies, E for exempt costs, and Out of scope for the money that never touches the GST/HST system.

Two files with two different jobs

QuickBooks imports accounts without tax settings, so the pair of downloads splits the work. The import CSV carries number, name, type, and detail type in the exact column layout QuickBooks expects, and creates the account list in one pass. The readable CSV is the coding sheet: default code per account, the legitimate alternatives, and a note explaining the treatment. Print it, pin it, or paste it into your client onboarding doc.

Ontario coding in QuickBooks terms

QuickBooks Online Canada provisions Ontario’s codes automatically once sales tax is on, so nothing here needs to be built by hand:

  • HST ON (13%) is the workhorse on both sides: sales to Ontario buyers and most business purchases, where the full HST comes back as an input tax credit.
  • Z (zero-rated) covers basic groceries, exports, and international transportation. Zero tax on the line, ITCs preserved.
  • E (exempt) is for bank charges and interest, insurance premiums, and residential rent. No tax charged, and no credit on related costs. Note that insurance in Ontario usually shows the province’s separate 8% RST on the premium; that amount is simply part of the cost.
  • Out of scope takes wages, source deductions, owner drawings, government permit fees, and transfers between your own accounts.

Two Ontario-flavoured account notes deserve a call-out. The meals and entertainment account keeps HST ON as its code, but only half of that HST is claimable for most businesses, so the readable file flags the 50% adjustment. And the club memberships account exists precisely because dining, recreation, and sporting club dues give you no credit at all even though the invoice shows HST.

Interprovincial lines are normal, not edge cases

GST/HST is charged by the place of supply. Ship goods to Vancouver and the sale is not an HST ON line; consult for a Montreal client and it is not one either. QuickBooks keeps a built-in list of every province’s codes; you enable, say, GST for an Alberta sale the first time it comes up, and it stays available. The chart’s “other codes” column tells whoever does the books which accounts see this regularly (sales, travel, and inventory purchases most of all).

Setting it up

  1. Turn on sales tax in QuickBooks (Taxes, then Sales tax) so the Ontario codes exist.
  2. Import the CSV through Settings, then Import data, then Chart of accounts, and match the four columns.
  3. Work from the readable file when coding: default code first, alternatives when the transaction genuinely differs.
  4. Review a month of coded lines before the first GST/HST filing to confirm the pattern stuck.

The steady-state problem is that every bill and receipt needs the right code on the right account, every time. Dext learns supplier-level rules so repeat vendors stay consistent. ExpenseFlow reads the document itself, works out the correct Canadian treatment including zero-rated, exempt, and buyer’s-province cases, and posts the coded transaction into QuickBooks for you. Hubdoc files the paperwork and remembers prior coding.

Account numbers follow the familiar ranges (1000s assets through 6000s expenses) with room between neighbours, so adding an account never means renumbering.

Running Xero instead? Take the Ontario chart of accounts for Xero. The code list behind this page lives in the Ontario QuickBooks sales tax codes reference.

Questions, answered

Common questions

Why does the QuickBooks import file have no tax column?

QuickBooks Online's chart-of-accounts import accepts account number, name, type, and detail type only. Sales tax is chosen on each transaction line from codes QuickBooks already knows. That is why this template ships two files: the import creates the accounts, and the readable CSV tells your team which code belongs on each account's transactions.

Do I have to create the HST codes myself?

No. QuickBooks Online Canada sets up the common codes for your province automatically when sales tax is turned on. An Ontario company gets HST ON at 13% plus Z, E, and Out of scope. Codes for other provinces can be added from the built-in list under Taxes when you first need them.

What is the difference between Z, E, and Out of scope?

All three put zero tax on the line but they report differently. Z is zero-rated: taxable at 0%, and your input tax credits on related costs survive. E is exempt: no tax, and no ITC recovery on costs tied to making exempt supplies. Out of scope is for things that are not supplies at all, like wages or donations.

Which code do I use when I sell outside Ontario?

The buyer's province decides. An invoice to a Toronto customer carries HST ON at 13%, one to an Edmonton customer carries GST at 5%, and an export is Z. Add the other province's code from QuickBooks' built-in list the first time you need it.

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