Australian Real Estate Trust Account Three-Way Reconciliation

Walk the Australian real estate trust account three-way reconciliation: bank, cashbook, and aggregated ledger, with NSW, VIC and QLD timing and audit rules.

Published
Updated
Reading Time
17 min
Topics:
Tax & ComplianceAustraliaReal Estatetrust account reconciliationProperty and Stock Agents ActLicensee in Chargeannual auditor's report

An Australian real estate trust account three-way reconciliation matches three balances at month-end and resolves any difference before the Licensee in Charge signs it off. The three balances are the bank statement balance for the agency's designated trust account, the cashbook balance, and the aggregated trust ledger total — the sum of every individual ledger, one per landlord, one per pending sales deposit, one per pending rental bond, and one per body corporate or other matter the agency runs through trust money. All three figures must equal each other. Where they do not, the difference must be investigated and resolved; the recon is not signed off until they reconcile.

The headline compliance facts shape everything that follows. The recon is signed monthly by the Licensee in Charge (LIC). The trust account is externally audited every year by a CA or CPA. The governing legislation is set by each state, not federally — the Property and Stock Agents Act 2002 in NSW, the Estate Agents Act 1980 in Victoria, and the Agents Financial Administration Act 2014 in Queensland, with separate acts in WA, SA, Tasmania, ACT, and NT. Queensland requires the monthly reconciliation within five business days of month-end, the most aggressive cadence in the country. NSW lodges its annual auditor's report by 30 September for the year ending 30 June.

Trust money is the money the agency holds on someone else's behalf — landlord rental receipts awaiting disbursement, deposits on pending sales, bond money awaiting lodgement, body corporate funds. It is not the agency's money and never enters the agency's general (operating) account. The whole regulatory architecture rests on that distinction.

Searchers landing here from a non-AU jurisdiction should head to the equivalent walkthrough for their regime: the US broker trust account three-way reconciliation walkthrough for state-by-state US broker rules, or UK letting agent client account reconciliation under the CMP regime for UK letting agents. The Australian rules are different on every dimension that matters — act, regulator, timing, lodgement portal — so the AU article does not substitute for the home-jurisdiction one or the reverse.

State-by-state regulatory framework: NSW, Victoria, Queensland and the rest

Real estate trust account regulation is a state matter in Australia. Each jurisdiction sets its own act, names its own Fair Trading regulator, prescribes its own monthly reconciliation cadence, and operates its own annual audit lodgement path. A multi-state agency runs eight regimes side-by-side. The table below sets the eight out in one view; the prose paragraphs that follow walk NSW, Victoria, and Queensland in operational depth, since they account for most agencies and carry the regime-specific quirks readers most often look up.

State / territoryGoverning legislationRegulatorMonthly reconciliation timingAnnual audit lodgement
NSWProperty and Stock Agents Act 2002 and Property and Stock Agents Regulation 2022NSW Fair TradingMonthly recon signed by preparer and Licensee in ChargeAuditor's Report Online portal by 30 September, for year ending 30 June
VictoriaEstate Agents Act 1980 and Estate Agents (General, Accounts and Audit) Regulations 2018Consumer Affairs VictoriaMonthly reconLodged via myCAV; trust money holding statement by 31 March
QueenslandProperty Occupations Act 2014 and Agents Financial Administration Act 2014Office of Fair TradingWithin five business days of month-endAnnual audit report to Office of Fair Trading
Western AustraliaReal Estate and Business Agents Act 1978DMIRSMonthly reconAnnual audit
South AustraliaLand Agents Act 1994Consumer and Business ServicesMonthly reconAnnual audit
TasmaniaProperty Agents and Land Transactions Act 2016Property Agents BoardMonthly reconAnnual audit
ACTAgents Act 2003Access CanberraMonthly reconAnnual audit
NTAgents Licensing Act 1979NT Consumer AffairsMonthly reconAnnual audit

NSW. A licensee opening a trust account in NSW first obtains a unique identifier (UID) from NSW Fair Trading and provides it to the bank, which uses it to register the account on the regulator's records as a designated trust account under the Property and Stock Agents Act 2002. The monthly reconciliation must carry two signatures: the staff member who prepared it, and the Licensee in Charge who reviewed it. According to NSW Government's real estate trust account and audit requirements, the trust account audit period is the year ending on 30 June and the licensee's auditor's report must be submitted by 30 September. Submission is through the Auditor's Report Online portal; the auditor lodges directly using their own credentials.

Victoria. The Estate Agents Act 1980 and the Estate Agents (General, Accounts and Audit) Regulations 2018 govern Victorian agency trust accounting, with Consumer Affairs Victoria as the regulator. The annual audit is lodged through myCAV, CAV's online portal, by the auditor on the licensee's behalf. Separate from the audit, every estate agent must lodge an annual statement of trust money holding by 31 March each year through the same myCAV portal — this is a holding statement of trust money at a point in time, not the audit. The two are commonly confused; they are different obligations on different deadlines.

Queensland. Queensland sits under both the Property Occupations Act 2014 and the Agents Financial Administration Act 2014, with the Office of Fair Trading as the regulator. The defining cadence rule is the five business day window: the monthly reconciliation must be completed within five business days of month-end. That timing is the strictest in the country and is the one Queensland agencies most often miss when month-end falls awkwardly across a public holiday or a software issue. The annual audit report is lodged with the Office of Fair Trading.

WA, SA, Tasmania, ACT, and NT each follow the same operational shape — a designated trust account, a monthly reconciliation, and an annual external audit by a CA or CPA — with the operative differentiator being the legislative reference and the regulator named in the table above. Where state-specific quirks apply (for example WA's interaction with DMIRS for trust account audits, or the Tasmanian Property Agents Board's audit lodgement process), the regulator's own guidance is the authoritative source for the year's submission rules and any portal changes.

Documents on the recon and the role of property management software

Each of the three balances comes from a defined document set. The bank statement balance is the trust account's month-end balance per the bank — pulled from the statement itself or from a bank file export run on the closing business day. The cashbook balance is built by the agency from two journals: a receipts journal capturing rent receipts, sales deposits, bond money received, and body corporate or owners' corporation funds collected, and a payments journal capturing landlord disbursements, supplier invoices paid on the landlord's behalf, bond lodgements, refunds, and reversals. The aggregated trust ledger total is the sum of every individual ledger across the agency — one per landlord property, one per pending sale deposit, one per pending bond, one per body corporate matter — produced as a per-ledger balance report from the agency's trust accounting system.

Several supporting documents substantiate the entries that build each balance. Deposit slips and EFT receipt confirmations evidence receipt timing — most state regimes require trust money to be banked the next banking day after receipt. Payment authorisations evidence the agency's right to disburse from a ledger; for property management work this is the landlord direction or the written authority embedded in the management agreement, and for sales work it is the authority drawn from the contract of sale or sales authority. Bond lodgement evidence is jurisdiction-specific: RTBA in Victoria, RBO in WA, NSW Rental Bonds Online in NSW, with state equivalents elsewhere. Reversal entries — for a dishonoured deposit, a misallocated receipt, or a corrected payment — must reference the original transaction so the auditor can trace back to the entry being corrected.

Supplier invoices the agency pays on the landlord's behalf are a substantial portion of the volume. Maintenance trades, council rates, water charges, insurance premiums, and body corporate levies all sit on the trust ledger for the relevant landlord and must be substantiated by both the supplier invoice and the landlord's authority to pay it. For agencies that handle body corporate funds or pay strata levies on landlords' behalf, extracting NSW strata levy notices into a working spreadsheet is the same kind of document-extraction task that produces the audit-ready evidence for those entries. The same broader practice of tracking vendor invoices and payments inside a property management workflow is what feeds the payments journal — the cleaner that workflow is during the month, the less work the recon takes at month-end.

Most Australian agencies do not run the recon by hand. Console, PropertyMe, PropertyTree, Rockend Rest, Inspect Real Estate, Re-Leased, and MRI Property Management each automate ledger entries from rent receipts, supplier payments, and disbursements, and each generate a three-way reconciliation report at month-end. The recon then becomes a software-output exercise: the bank file imports, the system attempts an automatic match against the cashbook, and the unmatched items are the practical work. The three balances appear at the top of the report, and the system either shows them in agreement or shows the gap.

Reading the software-generated three-way report is mostly about chasing the unmatched items. The common categories: timing differences from end-of-month EFTs that have left the cashbook but have not yet cleared the bank — these resolve once the bank presents them; presented versus banked deposits where a deposit was banked late on the last business day and shows on the next month's statement; reversals that were entered in the cashbook but not yet replayed against the original ledger entry; supplier payments queued in the system but not yet authorised by the LIC, which sit in a pending state rather than a posted state; and bond money received and recorded but not yet lodged with the relevant bond authority, which sits as a temporary ledger balance until lodgement clears. Each of these is normal at month-end and resolves within a few business days. What is not normal is an unexplained difference left unreconciled — that is the difference the auditor will ask about, and the difference the regulator treats as a deficiency if it sits across the year-end.

The audit findings Fair Trading raises most often

External auditors and Fair Trading inspectors see the same patterns repeat across agencies, year after year. Most are preventable by a tightly run month-end and a Licensee in Charge who treats the recon as a control rather than a formality. The findings below are the ones that turn up consistently in published audit summaries and on REINSW, REIV and REIQ practitioner guidance, named with the specific operational behaviour that produces each.

  • Opening transfer without authority. Funds moved out of a landlord's ledger before the agency holds the written authority to do so — usually a signed management agreement, a landlord direction for a one-off payment, or the sales authority drawn from a contract of sale. The transfer is the breach; correcting the ledger after the auditor flags it does not undo the finding.
  • Mid-month withdrawal without supporting documentation. A disbursement made without a substantiating supplier invoice, bond lodgement reference, or written instruction sitting in the file. The trust account does not pay on a verbal request; every entry needs documentation that the auditor can trace.
  • Trust ledger overdrawn. Any individual ledger going below zero is a regulatory breach in every Australian jurisdiction. The aggregate position being positive does not save the agency; one landlord's ledger being negative because their account was used to cover another landlord's payment is precisely the breach the legislation is structured to prevent.
  • Receipts not banked promptly. Most state regimes require trust money to be banked the next banking day after receipt. The breach is the timing, not the eventual outcome — cash held overnight in the office safe, in transit, or sitting unprocessed produces the same finding whether or not the money ultimately reaches the account intact.
  • Bank account not designated as a trust account. The account at the bank must carry the formal trust designation. Holding trust money in an account the bank treats as an operating account, even briefly, is itself the breach, and this shows up most often when an agency opens a second business account for convenience and routes some receipts through it.
  • Cashbook not reconciled within the regulator's timeframe. Queensland's five business day window is the most commonly missed; NSW, Victoria, and the other states each have their own timing rule that the auditor will check against the dated sign-off. Late month-end reconciliation is a finding even where the numbers ultimately agree.
  • Missing Licensee in Charge sign-off. A monthly recon prepared but not signed off by the LIC is treated as not done. NSW expressly requires both a preparer's signature and the LIC's review signature; an unsigned reconciliation reads the same as a missing one, and a back-dated signature reads worse.
  • Mixing trust funds with operating funds. Trust money deposited to the agency's general account — even temporarily, even by mistake, even pending a transfer to the trust account the next day — is a serious finding. The reverse, paying agency expenses out of the trust, is more serious still and is one of the findings that most reliably escalates to a regulator review.
  • Deficiency on reconciliation not reported. Where the recon does not balance and the difference is a deficiency — the bank holds less than the ledger says it should — most state regimes require the licensee to notify the regulator immediately, in writing, regardless of the cause and regardless of whether the agency intends to make up the shortfall from its own funds. Failing to report, or reporting late after the auditor finds it, escalates the consequence considerably.

None of these findings are trivial. Each can convert into a qualified audit opinion in the annual external audit, and a qualified audit triggers regulator review.

Annual external audit pack assembly

The annual audit is a year-end attestation built from twelve months of monthly evidence. The auditor's scope is anchored on the twelve signed reconciliations and the supporting bank statements, cashbooks, and trust ledger reports for each, with sample-tested transactions across the year substantiated by their underlying authorities. There is no shortcut to a year-end pack assembled in a fortnight from an unreconciled twelve months — the structure of the audit reflects the structure of the obligation, which is monthly.

What the auditor will request, in roughly the order they request it:

  • Twelve months of signed monthly reconciliations, each showing the three balances in agreement and carrying the LIC sign-off.
  • Twelve months of bank statements for the designated trust account.
  • Twelve months of cashbooks, with the receipts journal and payments journal for each month.
  • A sample of ledger transactions selected by the auditor across the year, with the supporting authority for each — the landlord direction or management agreement clause for a property management disbursement, the contract of sale or sales authority for a sales-side payment.
  • Evidence of receipt timing, drawn from deposit slips and EFT confirmations dated against the banking-next-day rule.
  • Evidence of LIC oversight, both on the monthly recon sign-off and on disbursements above any agency-internal authorisation threshold.
  • The agency's documented cash-handling policies — written procedures for receipts, banking, disbursements, and exception handling.
  • A sample of landlord trust authorities — the agreements that authorise the agency to handle the landlord's money in the first place.
  • Evidence of bond lodgements with the relevant bond authority for each pending and completed bond across the year.
  • Evidence that any overdrawn ledger or unreconciled difference during the year was investigated, resolved, and documented at the time, not retrofitted at audit prep.

The auditor's request is for structured evidence, not raw documents. The agency's working file needs the bank statements, deposit slips, supplier invoices paid on landlords' behalf, and payment authorisations turned into per-ledger and per-month evidence the auditor can sample-test efficiently. This is where the volume problem lives. A property management agency of any scale carries thousands of supplier invoices and payment authorisations across a year — maintenance trades, council rates, water charges, insurance, body corporate levies — and converting those into structured per-ledger working data is the part of audit prep that consumes the most time. Tools that turn financial documents into spreadsheets, such as our AI document extraction for trust account audit packs, are built for that volume problem: a year of bank statements, deposit slips, supplier invoices, and payment authorisations becomes structured per-ledger rows the auditor can sample-test directly, with the same prompt producing the same layout across every document so the working file is consistent end-to-end.

External auditors of Australian real estate trust accounts work to ASAE 3100 and GS 011 — the AUASB guidance on compliance audits and on auditing trust accounts under the relevant state acts. The working file the agency produces needs to support that level of evidence: every sample-tested transaction traceable from the trust ledger back through the cashbook to the bank, supported by an invoice, authority, or other source document.

The qualified audit opinion and the path to a licence consequence

A qualified audit opinion is an external audit report in which the auditor cannot give a clean (unqualified) opinion that the trust account complied with the relevant act for the audit year. The qualification can be on a specific scope limitation — reconciliations that could not be verified, supporting documentation that was missing for sample-tested transactions, an overdrawn ledger that was not investigated at the time, or evidence the agency could not produce in the form the auditor required — or, less commonly, on a non-compliance the auditor has identified. Either way, the auditor has stopped short of stating that the trust account met its obligations across the year, and the report says so on its face.

State Fair Trading regulators receive every annual audit report — NSW Fair Trading via the Auditor's Report Online portal, Consumer Affairs Victoria via myCAV, the Queensland Office of Fair Trading via its lodgement process, and the equivalent regulators in WA, SA, Tasmania, ACT, and NT. A clean audit is filed and largely sits there. A qualified audit is reviewed. Depending on the nature of the qualification and the regulator's discretion, the review can lead to a regulator-initiated inspection of the agency's trust accounting records, an enforceable undertaking that commits the licensee to specified remedial steps, suspension of the licensee's licence for a defined period, or — in serious cases or for repeat findings — cancellation of the licence.

Be honest about what that means operationally. A licensee whose licence is suspended cannot lawfully run the agency's trust account or hold trust money during the suspension period. For a property management agency, that is a continuity-of-business problem: rent receipts cannot be collected through the trust account, supplier invoices cannot be paid on landlords' behalf, and ongoing landlord relationships are exposed. For a sales agency, a suspension is a transaction-stopping problem: deposits cannot be held in trust pending settlement, which means new contracts cannot be exchanged through the agency. The auditor's qualified opinion is therefore not a paperwork issue; it is a licence-risk event with direct revenue and continuity consequences.

A clean annual audit is built from twelve clean monthly reconciliations, each signed by the Licensee in Charge, each supported by the documentation the auditor will sample-test, each with overdrawn ledgers investigated and any deficiency reported in the timeframe the act requires. The state-by-state framework, the document set, the audit findings agencies most often face, and the audit pack the auditor will request — all of it exists so that the year-end attestation is a confirmation of work already done, not a forensic exercise.

Extract invoice data to Excel with natural language prompts

Upload your invoices, describe what you need in plain language, and download clean, structured spreadsheets. No templates, no complex configuration.

Exceptional accuracy on financial documents
1–8 seconds per page with parallel processing
50 free pages every month — no subscription
Any document layout, language, or scan quality
Native Excel types — numbers, dates, currencies
Files encrypted and auto-deleted within 24 hours
Continue Reading