A trust account holds money that is not yours. Security deposits, prepaid rent, and owner funds sit in it, and the obligation is straightforward to state and easy to break: at any moment, the money in the account must equal the sum of what you are holding for every individual owner and tenant.
Proving that is the three-way reconciliation, and it is the single most consequential reconciliation in property management. It is also the one most likely to have quietly stopped tying.
What a three-way reconciliation actually compares
Three numbers, all as of the same date, all of which must agree:
- The bank balance — what the statement says, adjusted for outstanding items
- The book balance — what the trust ledger in AppFolio says the account holds
- The sum of individual beneficiary balances — every owner ledger and every tenant deposit, added up
Two of the three agreeing means nothing. Bank and book can match perfectly while the beneficiary ledgers underneath are wrong, which means you are holding the right total for the wrong people. That is the failure mode that hurts, because it survives a normal bank reconciliation without complaint.
What breaks it in AppFolio
Operating expenses paid from the trust account. The most common cause by far. A management fee, a software subscription, or a vendor bill gets paid from trust because that is where the balance was. The account is now short by that amount against what it owes, and it will never self-correct.
Owner draws taken beyond an owner’s balance. An owner is distributed more than their property actually generated. The total may still look fine because another owner’s funds cover it — which is precisely the problem.
Security deposits recorded as income. A deposit is a liability until it is applied or refunded. Booked as income, it leaves the liability schedule while remaining in the bank, and the beneficiary total stops matching.
Deposits applied to a ledger without moving the money. The tenant ledger shows a deposit applied to rent; the cash never moved from trust to operating. Book and beneficiary drift apart.
Manual adjustments made to force a match. An entry created purely to make the reconciliation balance conceals the real difference. The next month’s discrepancy is now built on a fiction, and the original cause is harder to find.
Why it matters beyond tidy books
Trust accounting is regulated at the state level, and requirements differ by state — in Georgia, brokers handling trust funds have obligations that come with real consequences for failure. Beyond the regulatory side, this is the reconciliation that determines whether you can prove you have not commingled funds. When an owner asks a hard question, or a broker’s license is at stake, the three-way is the evidence.
We are bookkeepers, not attorneys, and we do not advise on licensing or regulatory compliance. What we do is make the numbers provable.
What we do when a trust account will not tie
Work backward to the last period it did reconcile, then forward one period at a time until the break appears. Nothing gets plugged, and nothing gets forced to balance — a difference that cannot be explained is reported, not buried. Once found, the correction is made properly and the beneficiary schedule is rebuilt so the three-way ties for real.
Then the ongoing discipline: monthly three-way reconciliation with the backup filed, operating expenses kept out of trust, and owner draws checked against actual owner balances before they go out.
If your AppFolio trust account will not reconcile, you are not sure when it stopped, or you inherited books where someone forced a balance, book a free discovery call and we will find where it broke before quoting anything.
Trust reconciliation is one part of the month. The whole process is in our AppFolio bookkeeping guide.
For the full monthly comparison, see AppFolio to QuickBooks: what should match every month.
Recent Comments