A trust account audit is not supposed to be dramatic. A state regulator or an owner’s accountant asks a property management company to prove that every dollar collected on behalf of owners and tenants is where the books say it is. For companies running AppFolio with a disciplined process, that request is answered in an afternoon. For companies with quiet gaps in their reconciliation habits, it turns into weeks of digging through bank statements trying to explain a number that will not match.
REA, a national outsourced accounting firm and AppFolio Stack™ Partner serving property managers, commercial real estate operators, and developers, built its practice around exactly this problem: more than 175 accountants managing trust reconciliations across roughly 125,000 residential units and 30 million square feet of commercial space. That volume has surfaced the same handful of errors again and again, and all five show up long before an auditor ever gets involved.
What Is the Standard Every AppFolio Trust Reconciliation Has to Meet?
The standard is a three-way match: the bank statement balance, the trust ledger balance inside AppFolio, and the sum of every individual owner ledger balance all have to equal the same number, every month. When property managers ask REA to review their appfolio bookkeeping before an audit, a broken three-way match is almost always where the review starts, because it is the single check that catches the other errors on this list before a regulator does.
Error One: Reconciling the Bank Balance Without Reconciling the Owner Ledgers
The most common mistake is treating the bank statement as the only number that matters. A property manager who confirms the trust account bank balance matches AppFolio’s trust ledger, then stops there, has verified half the equation. The owner ledgers inside AppFolio, the sum of every individual owner’s balance, have to equal that same figure too. When they do not, the gap is often a posting error from months earlier that nobody caught because the bank side looked fine.
Error Two: Letting Uncashed Checks Sit Unresolved
Outstanding checks are the single most common source of reconciliation drift. A vendor or owner payment that was issued but never cashed keeps the bank balance looking lower than the trust ledger, and if that gap is not tracked and aged, it eventually gets misread as a real shortage or, worse, gets ignored until state escheatment rules require the funds to be turned over to the state.
Error Three: Commingling Operating and Trust Funds
Commingling, mixing trust funds with operating funds even briefly, is one of the most frequently cited violations in state real estate commission enforcement actions. It often starts small, covering a trust shortfall with operating cash “just until the next deposit clears,” and it is exactly the kind of shortcut that state regulators, including agencies like California’s Department of Real Estate, flag as a leading cause of disciplinary action against property managers and brokers.
Error Four: Inconsistent Chart of Accounts Across Properties
When each property in a portfolio categorizes the same expense differently, a maintenance charge coded as a repair on one property and a capital improvement on another, owner statements stop being comparable and reconciliations take longer because nothing lines up the same way twice. NARPM’s recommended standardized chart of accounts exists specifically to prevent this drift, and portfolios that skip it tend to discover the inconsistency only when an auditor asks why two similar properties report such different numbers.
- Incomplete three-way match: Bank balance reconciled, owner ledgers skipped; Bank, trust ledger, and owner ledgers all equal
- Aged uncashed checks: Old checks left open indefinitely; Outstanding items tracked and resolved on schedule
- Commingled funds: Operating cash covering a trust shortfall; Trust and operating accounts fully separated
- Inconsistent chart of accounts: Same expense coded differently by property; Standardized categorization portfolio-wide
- Late monthly reconciliation: Reconciliation done in batches, weeks late; Reconciliation completed on a fixed monthly cadence
Error Five: Reconciling Late, or in Batches
A monthly reconciliation done six weeks late is not really a monthly reconciliation. It is a backward-looking cleanup project, and the longer the gap between the transaction and the reconciliation, the harder it becomes to remember or document why a discrepancy exists. NARPM’s benchmark data puts operating expense ratios at roughly 35% to 45% of gross income for residential portfolios, and firms running close to that margin rarely have the staff slack to catch up a reconciliation that has fallen months behind.
“Every audit failure we get called in to help with traces back to one of these five things, usually more than one at once,” said Renee Castillo, Director of Client Accounting at REA. “None of them are complicated on their own. They just require someone to own the calendar, and in a lot of offices, nobody formally does.”
Why Do These Errors Keep Happening Even at Well-Run Companies?
They keep happening because trust reconciliation competes for time against tasks with a visible, immediate consequence, a maintenance emergency or a lease that needs signing today, and reconciliation errors are invisible until an audit or a year-end close forces them into view. REA’s process assigns reconciliation a fixed date on the calendar rather than leaving it to whoever has a free afternoon, which is the structural fix behind all five errors above rather than a fix for any one of them individually.
Trust accounting compliance is not a one-time setup. It is a habit that has to survive staff turnover, portfolio growth, and busy months, which is exactly the pattern property managers describe when they explain why the errors above showed up in the first place.
The fastest way for a company to find out where it stands is to run the three-way match today, on this month’s numbers, rather than waiting for an owner or a regulator to ask for it. A clean match across bank balance, trust ledger, and owner ledgers takes minutes to check and rules out the first and most common error on this list immediately. A gap that shows up in that check is not a crisis by itself, but it is a signal worth tracing back to its source before the next reconciliation cycle buries it under another month of transactions.
- Confirm bank balance, trust ledger balance, and owner ledger totals all match this month
- List every outstanding check older than 30 days and resolve or reissue it
- Verify trust and operating funds have not crossed at any point this quarter
- Spot-check that the same expense type is coded identically across at least three properties
- Note the exact date the last reconciliation was completed and compare it to the calendar
None of these checks require specialized software beyond what AppFolio already provides. What they require is a standing process that treats reconciliation as a scheduled obligation rather than a task that happens whenever the month allows for it, which is the difference between a portfolio that clears an audit calmly and one that scrambles to explain a number nobody can trace.
