Property Management Trust Account Reconciliation Explained

Trust account reconciliation is the process of proving that the actual bank balance of a trust account matches the sum of everything the agency's records say it should contain. It sounds like basic bookkeeping. In practice it's the single most closely audited process in property management, because a mismatch — even a small one — is exactly how missing or misused client money first gets noticed.

The three numbers that have to agree

A proper reconciliation checks three figures against each other:

1. The bank statement balance — what the bank says is actually in the trust account.
2. The trust ledger total — the sum of every individual client ledger (each property, each bond, each deposit) the agency is tracking.
3. The cash book / receipts and payments record — the agency's own running record of money in and out.

If all three agree, the trust account is reconciled. If any one of them is out — even by a few dollars — something needs to be found and explained before the period can be closed off.

Why it has to happen on a fixed schedule

Every state requires reconciliation at least monthly; some require more frequent checks depending on transaction volume. The schedule isn't bureaucratic box-ticking — it's about limiting how much time can pass before an error compounds. A $12 discrepancy found the same week it happens is a five-minute fix. The same discrepancy found eleven months later, after dozens more transactions have layered on top of it, can take days to trace back to its source — assuming it's traceable at all by then.

What actually causes a mismatch

The individual causes are usually mundane, which is exactly why they need a systematic check rather than relying on someone noticing:

• A payment recorded against the wrong property's ledger.
• A disbursement that went out for the wrong amount.
• A bank fee or interest payment that hit the trust account but was never recorded in the ledger.
• Timing differences — a payment that's cleared in the bank but not yet entered in the ledger, or vice versa.

None of these are necessarily fraud or negligence. They're the kind of small, human errors that happen in any system with enough transaction volume — which is exactly why reconciliation exists as a structural safeguard rather than a matter of trust.

What a real reconciliation process looks like

1. Pull the trust account's bank statement for the period.
2. Generate the ledger total from the agency's own records for the same period.
3. Compare the two. If they match, the reconciliation is complete and gets signed off (often requiring a second person's review — separation of duties matters here).
4. If they don't match, investigate transaction by transaction until the discrepancy is found, corrected, and documented.
5. Retain the reconciliation report — auditors will ask to see a history of them, not just the current month's.

Why software matters more here than almost anywhere else

A spreadsheet-based reconciliation can be edited after the fact with no trace of the original numbers. A trust ledger built into proper property management software should make every entry permanent once recorded, timestamp every change, and be able to reproduce exactly what the ledger looked like on any given day — because that's what an auditor is actually going to ask to see. The goal isn't just passing this month's reconciliation; it's being able to answer, for any transaction from any point in the agency's history, exactly what happened and why.