Three-Way Reconciliation for Property Managers: What a Trust Account Audit Looks For

Three-way reconciliation for property managers is the audit-grade check that compares the bank statement, the trust ledger, and each owner's sub-ledger until every dollar ties out. It sits at the center of trust accounting for any Property Management operation handling client funds, and it's the first thing an auditor pulls.

By REA Team, Property Management Experts

A three-way reconciliation checks all three records that should always agree: the bank statement from the financial institution, the trust account balance in your accounting software, and the sum of every individual owner or tenant sub-ledger. When those three numbers match, the trust account is clean. When they don't, someone owes an explanation before a regulator or a client asks for one.

For a real estate accounting operation handling client deposits, this isn't optional bookkeeping hygiene. State real estate commissions treat a trust account like it belongs to the owners and tenants, not the company holding it, and a bank account that runs a few dollars off can look identical to commingled funds during an audit, even when the cause is a simple timing error.

Start with the bank statement balance as of the closing date, then adjust it for anything the bank hasn't processed yet: deposits in transit and outstanding checks. That produces the adjusted bank balance.

Next, pull the trust account balance from your accounting software's general ledger for the same date. This number should reflect every recorded deposit, disbursement, and transfer tied to the trust account, not the operating account.

Finally, total every individual owner and tenant sub-ledger and compare that sum to both the adjusted bank balance and the trust ledger. If all three numbers match, the reconciliation is complete. If they don't, the gap almost always traces back to a posting error, a missed deposit, or a check that cleared under the wrong owner's ledger. A property manager who works through these three steps monthly rarely finds a surprise at audit time.

An auditor doesn't take the reconciliation report at face value. They ask for the source records behind it: monthly bank statements, deposit slips, canceled checks or ACH confirmations, the general ledger detail, and every individual owner or tenant sub-ledger for the period under review.

Auditors never skip the main content of a bank statement review, they read every deposit and withdrawal line by line and trace it back to a lease, a work order, or an owner disbursement. They'll also want lease agreements, management contracts, and any written trust account policies your firm follows, since those establish what the money was supposed to do in the first place.

Most state real estate commissions require monthly trust account reconciliation at minimum, and many property management firms reconcile weekly or even after every batch of rent deposits. Monthly is the floor, not the target.

Reconciling on a tighter cycle keeps small errors small. A timing difference that would be invisible in a single day's activity becomes obvious within a week, before it compounds across dozens of owner ledgers. That discipline also pays off heading into year-end trust reconciliation, when every ledger needs to already tie out before a CPA or auditor starts asking questions.

A handful of errors show up again and again. Rent deposits posted to the wrong owner's sub-ledger. Security deposits recorded in the operating account instead of the trust account. Bank fees or interest that never got booked. Voided checks that were reversed on the bank statement but not in the software. And, most commonly, a bank account balance that simply hasn't been reconciled in months, so small unexplained differences have stacked on top of each other.

Any one of these can push the adjusted bank balance out of line with the trust ledger, and auditors flag the pattern, not just the dollar amount. A five-dollar gap that's existed unexplained for six months reads as worse than a five-hundred-dollar gap traced to a single dated error.

An unreconciled trust account rarely resolves itself. The first step is isolating the discrepancy to a specific transaction or date range rather than re-running the whole reconciliation from scratch. Pull the bank statement, the ledger, and the sub-ledger totals side by side and work backward from the date they last matched.

If the gap can't be explained, most state regulators require it to be reported, and some require the shortage to be covered from company funds until the source is found. Left alone, a small discrepancy tends to grow, and it becomes the kind of finding that turns a routine review into a formal investigation.

Most property management accounting platforms, including AppFolio, now support bank feed imports that match deposits and disbursements against the ledger automatically, which cuts down the manual matching that used to eat a full day each month. The right platform turns three-way reconciliation for property managers from a manual, end-of-month scramble into a running check that flags mismatches as they happen instead of thirty days later.

Not every platform handles trust accounting the same way. The gap shows up most in how cleanly each system separates sub-ledgers by owner, and those trust accounting feature differences are often the deciding factor between two of the most common platforms.

What's the difference between two-way and three-way reconciliation? Two-way reconciliation only compares the bank statement to the trust ledger balance. Three-way reconciliation for property managers adds a third check: the sum of every individual owner and tenant sub-ledger. That third comparison catches errors two-way reconciliation misses entirely, like a deposit posted to the wrong owner while the total ledger balance still looks correct.

Is three-way reconciliation legally required for property managers? Requirements vary by state, but most real estate commissions that regulate property management trust accounts require some form of regular reconciliation, and several specify the three-way method by name. Even where it isn't explicitly mandated, it's the standard auditors and courts expect, so treating it as required is the safer practice regardless of the exact statute.

How long does a trust account audit typically take? It depends on the number of properties, owners, and transactions in the trust account, along with how current the reconciliations already are. A firm with clean monthly records might clear a routine audit in a few days, while unresolved discrepancies or missing documentation can stretch the process to several weeks.

Can a property manager lose their license over reconciliation errors? Yes, in cases involving commingled funds, repeated unexplained shortages, or failure to correct a known discrepancy, state licensing boards can suspend or revoke a property manager's license. Isolated, promptly corrected errors are usually treated very differently than a pattern of neglect, which is why documenting every correction matters as much as making it.

What's the difference between a trust account audit and a routine reconciliation? A routine reconciliation is an internal check, usually done monthly, comparing the bank statement, ledger, and sub-ledgers. A trust account audit is an external or formal internal review that verifies those reconciliations were actually performed correctly and examines the underlying documents, not just the reported totals.

Clean three-way reconciliations don't happen by accident, they come from a system built for real estate trust accounting from the start. Lets Connect with REA's property management accounting team to see what that looks like for your books.