Trust account reconciliation for agencies: from same-day receipting to sign-off

Trust account reconciliation for a real estate agency means showing that three numbers agree: the bank statement balance (adjusted for deposits and payments not yet cleared), the trust cash book balance, and the total of every owner, tenant and other client ledger. If they agree to the cent, the money you hold matches the money you owe. If they do not, the difference is an exception someone must explain before anything else happens.

Most of the effort is not the reconciliation itself. It is the daily receipting that feeds it: working out which tenant a $560 transfer referenced “unit 4” belongs to. That matching is where an AI agent helps most, and it is the first item in our guide to AI for real estate agencies. This article is general information for NSW agencies, not legal or accounting advice.

The rules that frame the work in NSW

NSW Fair Trading's page on real estate trust accounts and audit requirements sets the boundaries for any automation:

• Licensees must hold clients' funds in a trust account, and those funds can only be used for that client and disbursed as the client directs.
• Only a licensee in charge can authorise trust account withdrawals, and they cannot delegate that authority — to staff or to software.
• Trust accounts are audited for the year ending 30 June, and audits must be submitted within three months of the end of the audit period and no later than 30 September.
• Trust money held for more than two years is treated as unclaimed.

The detailed requirements for receipts, records, ledger trial balances and reconciliation timing sit in the Property and Stock Agents Regulation 2022. We have deliberately not restated deadlines here: confirm them in the Regulation or with your trust account auditor, and build your calendar around their answer. Other states have different rules and regulators.

Same-day receipting: where the agent earns its keep

Tony Lorenzo, licensee at Elite Partners Real Estate in Abbotsford, NSW, describes the daily version:

Individual results vary. In practice the daily loop looks like this:

1. The agent reads the day's trust bank transactions from a statement export or feed.
2. For each deposit it proposes a tenant ledger using the reference, amount, payer name and the tenant's payment history, and gives a confidence level with a reason.
3. High-confidence matches are presented as a batch for a person to receipt in the trust accounting software. Low-confidence and unmatched deposits go on a separate list with the agent's best guess.
4. Anything odd — a payment much larger than the rent, a payer the system has never seen, a deposit for a property you no longer manage — is flagged, not guessed.
5. Once receipted, the morning arrears list is built from up-to-date ledgers, so nobody is chased for rent they paid yesterday.

Should the agent receipt directly into your trust software? For most small agencies, no. Proposed matches that a person confirms are fast to review and keep a clear line of responsibility. Write access to trust records is an access decision with real consequences, and the time saved by removing the confirmation click is small.

Month-end: preparing the trust account reconciliation pack

At month end the agent assembles what the licensee needs to review, in one place:

Exceptions worth flagging every month

• Overdrawn ledgers. A ledger in debit means one client's money is covering another's. Treat it as urgent.
• Old unpresented cheques or payments. These usually mean a payment never arrived where it should have.
• Unallocated receipts. Money sitting in a holding ledger is money you cannot yet show belongs to anyone.
• Balances held for a long time. Fair Trading treats money held more than two years as unclaimed; the agent can list long-held balances well before that.
• Disbursements that do not match the agency agreement. If fees taken differ from the signed agreement, raise it with the rent roll audit.

What the licensee must keep doing personally

AI preparation changes how long the review takes, not who is responsible. Keep these with the licensee in charge:

• Authorising every withdrawal and disbursement run. The agent can prepare the disbursement list and check it against ledgers; it cannot press the button.
• Reviewing and signing the reconciliation, and investigating every exception, not just reading the agent's explanation.
• Deciding how to correct errors, including journal adjustments, which should be documented with reasons.
• Dealing with the auditor. The agent can assemble the documents the auditor asks for; conversations and representations are the licensee's.

One rule we recommend writing down: the agent never describes a reconciliation as “balanced” unless all three figures agree to the cent with no unexplained items. “Balanced except for a $0.40 difference” is an exception, not a balance.

Access and audit trail

For receipting and reconciliation preparation the agent needs read access to trust bank statements and exports from your trust accounting software. It does not need write access to the bank, and it should never hold online banking credentials. Every proposal, approval and correction should be logged with who did what and when — which is also what an auditor wants to see. Our guide to AI agent audit trails explains what to log. If you also run the agency's own operating account through Xero or MYOB, the separate routine in Xero and MYOB in the agent loop applies there; keep trust and general accounts strictly apart.

When an agent is not worth it for trust work

If your bank feed already auto-matches nearly every rent payment because tenants use unique references, and your trust software produces a clean reconciliation with a click, the agent's marginal value is small. It earns its place where references are messy, receipting falls behind, a part-time bookkeeper does month end, or the licensee wants exceptions explained rather than just listed. To see how the agent, the records and the approvals fit together, start with the Fulcrum Cortex platform.