Canada · Free chart of accounts template

Alberta Construction Chart of Accounts for Xero (Free)

Free Xero chart of accounts for Alberta contractors: lien-act holdbacks, sub registration checks and GST-only coding, with import CSV.

By ExpenseFlow team
· 6 July 2026

Free download · no email required

CSV of construction accounts with Xero GST defaults, holdback structure included. Import file below.

Download chart of accounts (CSV)

Construction bookkeeping runs on the same three complications in every province: retained money, a mixed subcontractor base, and job costs that must stay separable. Alberta adds its own flavour, a flat 5% GST with no provincial layer, and jobs that regularly cross into provinces where that stops being true. This Xero chart encodes the whole picture for an Alberta contractor.

Retention has its own geography in the ledger

Holdbacks receivable and holdbacks payable stand apart from ordinary AR and AP, coded to the custom Out of Scope rate. Alberta’s prompt payment and lien rules make retention part of every progress billing cycle, and the held-back slice is money in limbo: not collectible yet, not payable yet, with GST generally crystallizing at release. Fold holdbacks into regular receivables and both your cash forecast and your tax timing go blind.

The cost engine

  • Subcontractor labour defaults to AB - GST on Purchases with Out of Scope listed for the unregistered small supplier. The account note makes registration checks a habit, because a denied ITC after the fact is pure loss.
  • Materials carries the delivery-point rule in its note: Alberta-delivered means 5%, and out-of-province job sites take that province’s taxes.
  • Equipment and tool rentals keeps plant costs out of materials, matching how estimates get built.
  • Safety gear and PPE is claimable 5%; permits and inspection fees code Out of Scope because municipal and safety-code charges are not supplies.

Around the trade-specific pieces, the standard Alberta texture holds: crew meals at the 50% ITC limit, insurance exempt with no provincial premium tax line, payroll and source deductions out of scope, commercial yard rent taxable at 5%.

Setup in Xero

Create the three custom 0% rates once (Tax menu, Tax settings, Tax rates: Zero Rated, Exempt, Out of Scope), then import through Accounting, Chart of accounts, Import. Xero fills line tax by contact, then item, then account, so supplier defaults you set later will override these account defaults where you want them to.

For job profitability, put Xero’s tracking categories to work rather than cloning accounts per project: one Job category across these accounts gives per-project labour, materials, and plant without bloating the chart. The readable CSV doubles as the brief for whoever runs the office; its notes column was written to survive being read at speed.

Own the iron or rent it, but code it accordingly

Equipment decisions echo in the chart. A purchased skid steer is a fixed asset: its 5% GST claims once at purchase, its cost recovers over years through capital cost allowance, and its repairs run through repairs and maintenance. A rented one is a period cost in equipment and tool rentals, claimed as it is billed. Crews blur this constantly by putting rental invoices wherever the last one went, and the estimate-versus-actual comparison dies a little each time. Fuel cards deserve the same discipline: they are vehicle or equipment cost at 5%, not miscellaneous site spend, and the card statement’s line detail is the document that supports the credits.

Field habits that keep it clean

  1. Reconcile both holdback accounts to contract terms monthly; releases move tax and revenue together.
  2. Confirm GST registration when onboarding any sub, and recheck when a small supplier’s volume obviously grows.
  3. Route fuel, lumber yard, and rental invoices through their accounts rather than a generic site-costs bucket.
  4. For out-of-province jobs, decide the tax treatment when the contract is signed, not when the first invoice lands.

Construction paper arrives muddy, crumpled, and daily. Hubdoc gets it captured and filed. ExpenseFlow reads each bill and receipt, applies the 5% or no-tax treatment the supply actually calls for, distinguishes registered subs from small suppliers, and posts into Xero against these accounts. Dext keeps the regular merchants consistent with supplier rules.

The QuickBooks mirror lives at Alberta construction chart of accounts for QuickBooks, and the rate mechanics at the Alberta Xero tax rates reference.

Questions, answered

Common questions

Do Alberta builders deal with holdbacks like Ontario's?

Yes. Alberta's prompt payment and lien legislation has owners and contractors retaining a statutory holdback from progress billings until lien periods run out. The chart tracks holdbacks receivable and payable in their own accounts, coded out of scope, because the retained slice is neither collected revenue nor paid cost yet, and the GST timing generally follows the release.

How do I code a sub who bills without GST?

On the same subcontractor labour account, with the Out of Scope alternative instead of the 5% default. Small suppliers under the $30,000 threshold are allowed to bill without registering, and their invoices simply carry no credit. The risk runs the other way: 5% paid to someone who turns out not to be registered is a credit the CRA can deny, so verify registration on new subs.

What about materials bought from BC or Ontario suppliers?

Delivery point decides. Materials delivered to an Alberta site should carry 5% GST regardless of the supplier's province; a supplier charging you their home rate on Alberta-bound goods should be asked for a corrected invoice. Working a job outside Alberta flips it: that province's taxes govern the supplies for that site.

Which Xero rates does the import need to exist?

AB - GST on Purchases and AB - GST on Sales are seeded automatically. Create the three custom 0% rates first (Zero Rated, Exempt, Out of Scope) under Tax settings; holdbacks, permits, wages, and the bank accounts reference them.

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