Canada · Free chart of accounts template

Ontario Real Estate Chart of Accounts for QuickBooks Online (Free)

Free QBO chart of accounts for Ontario real estate agents: commission HST coding, vehicle split, desk fees and marketing, import CSV included.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV: realtor accounts with default QuickBooks codes and notes on the vehicle, commission and meals rules.

Download chart of accounts (CSV)

QuickBooks Online suits a real estate practice: light on inventory, heavy on services, and full of recurring supplier relationships. What a stock chart misses is Ontario’s specific mix, where the agent’s commission is taxable at 13% even on exempt homes, the car splits into two tax treatments, and the brokerage statement is a monthly bundle of creditable fees. This chart closes those gaps in QuickBooks’ own code language.

Commission first

Commission income codes HST ON. It is the point most new agents get wrong in their first year: the home may change hands exempt, but the service of selling it is fully taxable, so 13% HST belongs on every commission invoice once the agent is registered, and registration comes quickly at commission volumes. Getting this right is also what entitles the practice to input tax credits on everything below.

Two vehicle accounts, on purpose

Motor vehicle expenses holds actual costs: fuel and repairs at HST ON, insurance exempt with Ontario’s 8% RST as part of the premium cost. Its note keeps the two federal caveats in view, the ITC cap on passenger vehicles and the personal-use apportionment. Vehicle allowance claims codes Out of scope, because a reasonable per-kilometre allowance is compensation for a personal car rather than a supply to the business. Keeping the streams separate is what makes both the GST/HST return and the year-end vehicle claim defensible.

The production accounts

  • Listing and portal fees at HST ON: MLS access, board dues, franchise portals, all creditable.
  • Photography, staging and floor plans at HST ON, tracked per listing for cost-per-listing visibility.
  • Signage and lockboxes at HST ON.
  • Brokerage desk fees at HST ON with full ITCs; contractual and material, so they get their own line rather than sharing professional fees.
  • Meals and entertainment for client dinners keeps the 50% credit note; the receipt shows 13%, the return claims half for most businesses.

From import to routine

QuickBooks’ chart import carries structure only (number, name, type, detail type), so run it under Settings, Import data, Chart of accounts, and put the readable CSV to work as the coding sheet, where each account’s default code and exceptions are spelled out. Ontario’s codes (HST ON, Z, E, Out of scope) exist as soon as sales tax is enabled.

  1. Post each brokerage statement in its parts: splits to income, desk fees to their account.
  2. Keep a live kilometre log; the allowance entries depend on it.
  3. Attach listing addresses to staging and photography bills for per-listing costing.
  4. Check the vehicle and meals accounts before each filing; they are where realtor returns typically leak.
  5. Archive closed-deal paperwork with its entries so commission questions die quickly.

Commission income is lumpy, and the tax on it arrives with the lumps, so borrow a habit from seasoned agents: move the HST portion of every commission deposit to a separate savings account the day it lands. The filing then never competes with the quiet months, and the books in this chart tell you the exact amount to park, because the tax sits on its own line from the moment the invoice was coded.

An agent’s receipts are earned car-door to car-door, which is why they go missing. Dext applies supplier rules to the regular vendors. ExpenseFlow reads receipts and bills as they are captured, applies the Ontario treatments in this chart (taxable desk fees, out-of-scope allowances, half-credit meals), and posts coded entries into QuickBooks, so the spring rush does not turn into a summer cleanup. Hubdoc keeps documents matched to entries.

Prefer Xero? The mirrored chart is Ontario real estate chart of accounts for Xero; code semantics live in the Ontario QuickBooks sales tax codes reference.

Questions, answered

Common questions

What code goes on commission income in QuickBooks?

HST ON at 13%. The exempt status of a resale home belongs to the property transaction, not to the agent's service; commissions are taxable supplies of services in Ontario whatever the property's own treatment. That taxable status is also what keeps an agent's input tax credits flowing.

How do I keep the vehicle from becoming a bookkeeping mess?

Use both vehicle accounts as designed. Fuel, maintenance, and other actual running costs go to motor vehicle expenses with HST ON where charged, remembering the passenger-vehicle credit caps and a personal-use split. Per-kilometre allowances go to the allowance account coded Out of scope, because an allowance is compensation, not a purchase.

Are staging and photography costs worth separate tracking?

Yes, and not for tax reasons alone; both carry HST ON with full credits. Per-listing marketing cost is the number that tells an agent whether a listing strategy works, and it only exists if photography, staging, and portal spend do not dissolve into general marketing.

Do REALTOR board dues carry tax I can claim?

Board and association dues generally carry 13% HST that a registered agent claims back, and they sit in the listing and portal fees account. The trap account is different: recreational club memberships allow no input tax credit at all, even with HST on the receipt.

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