Canada · Free chart of accounts template

Quebec Real Estate Chart of Accounts for Xero (Realtors, Free)

Free Xero chart of accounts for Quebec realtors: GST+QST commissions, OACIQ dues, split vehicle accounts and Centris fees, import CSV.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV of realtor accounts with Quebec-correct Xero defaults and the commission and vehicle notes.

Download chart of accounts (CSV)

A Quebec real estate practice bills the country’s highest combined tax on its commissions and recovers nearly all of what it spends, a fair trade once the books are structured for it. This Xero chart of accounts encodes that structure: dual-tax commissions, a fully-recoverable production stack, the regulator’s out-of-scope fees, and the vehicle discipline no province excuses.

Commissions, both taxes, both numbers

Commission income defaults to QC - GST/QST on Sales: the exempt resale home still produces a taxable brokerage service, so 14.975% rides on every commission with both registration numbers on the invoice. Referral fees between registered practices are taxable services on their own visible line. The cash habit follows the bigger tax: move the combined tax share of each commission deposit to savings on arrival, and the Revenu Quebec filing stops competing with slow months.

The production stack, recoverable end to end

  • Listing and portal fees: Centris, board dues, franchise portals, the pair with full recovery.
  • Photography, staging and floor plans: the pair, recoverable, tracked per listing so cost-per-listing stays a number rather than a feeling.
  • Signage and lockboxes: the pair; unlike the PST provinces, nothing lodges permanently in the goods.
  • Brokerage desk fees and OACIQ dues: the pair on brokerage services, Out of Scope on the regulator’s licence fees, split per line as the note directs.
  • Meals and entertainment: the stereo half-recovery on client dinners, flagged.

The car, twice-disciplined

Motor vehicle expenses takes actual costs at the pair, fuel and repairs recoverable within the passenger-vehicle caps and after personal-use apportionment, insurance exempt with the premium tax as cost. Vehicle allowance claims takes per-kilometre amounts at Out of Scope, compensation rather than purchases. The kilometre log carries both accounts through any review, federal or provincial, and Quebec runs both through one office.

Open-house consumables and closing gifts are ordinary purchases at the pair with recoveries intact, kept in a modest client-gifts line inside marketing so the spend stays budgeted and visible rather than scattered.

Setup and season

  1. Create the four custom rates (Tax menu, Tax settings, Tax rates: GST on Purchases at 5%, plus the three zeros), then import via Accounting, Chart of accounts, Import, confirming the preview pairs rates and accounts as expected.
  2. Put both registration numbers in the invoice template before the first commission bills.
  3. Post brokerage statements in components: gross commission to income, splits reducing it, fees to their accounts at their treatments.
  4. Tag marketing bills with listing addresses; the cost-per-listing report disciplines the next pitch.
  5. Reconcile the combined liability to the single Revenu Quebec return each period, sweeping the meals line for stereo overclaims first.

Incorporation keeps the same grammar: a broker’s corporation inherits this chart wholesale, adding shareholder-loan and dividend accounts, with the dual-tax logic untouched.

Client deposits never belong in these books at all: purchase deposits sit in the brokerage’s trust account under OACIQ rules, they are not the broker’s money, and no tax event touches them until they become someone’s consideration at closing. The only deposit-adjacent entry a broker’s own file should ever see is the commission that eventually flows from the completed deal, taxed as commissions always are.

The receipts of the trade are earned between showings and lost by Friday. Hubdoc captures them from a phone first. ExpenseFlow reads each receipt and bill, applies the pair-with-recovery defaults, the out-of-scope allowance and regulator lines, and the half-recovery meals rule, and posts coded entries into Xero while the market moves. Dext keeps Centris and the boards consistent through supplier rules.

The QuickBooks rendering is at Quebec real estate chart of accounts for QuickBooks; the rates are documented in the Quebec Xero tax rates reference.

Questions, answered

Common questions

Resale homes are exempt. Is a Quebec broker's commission exempt too?

No. The property's exemption never transfers to the service of selling it: commissions carry GST + QST, invoiced with both registration numbers, on every deal including exempt resale homes. Commission volume also carries new brokers past the registration thresholds quickly.

Which practice costs recover in full?

Nearly all of them: Centris and board fees, brokerage desk charges, photography and staging, signage, all carry the pair with both components recoverable. The exceptions are the stereo classics: half recovery on client meals, none on recreational club dues, and Quebec's premium tax on insurance as cost.

How does the vehicle split work?

Actual running costs sit in motor vehicle expenses at the pair, subject to the passenger-vehicle recovery caps and a personal-use split under both taxes. Per-kilometre allowances are compensation, not supplies, and code Out of Scope in their own account, backed by a contemporaneous kilometre log.

Where do OACIQ fees go?

The dues account, with the note splitting them: regulator licence fees are out of scope, while board, Centris and franchise services carry the recoverable pair. One account, two treatments, decided per line.

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