Guides
AppFolio verifies that what you entered is internally consistent. It has no way to know whether you entered the right thing.
Updated 2026-08-02 · TrustRecon research team
AppFolio handles the mechanics of trust accounting competently. Receipts post to tenant ledgers and roll up to property and owner balances. Disbursements draw against owner funds. The bank register tracks the trust account, and the reconciliation screen compares that register against your bank statement, producing an adjusted cash balance that accounts for outstanding items.
For most day-to-day work this is sufficient, and it is considerably better than the spreadsheet-plus-QuickBooks arrangement it usually replaces. The property-level ledger structure in particular is what makes per-beneficiary accounting possible at all — without it, the third leg of a three-way reconciliation cannot be computed.
Understanding the boundary of what it verifies is what separates companies that pass audits from companies that are surprised by them.
AppFolio's reconciliation answers one question: does the trust bank register, adjusted for outstanding checks and deposits in transit, match the bank statement ending balance? That is a two-way comparison — books against bank.
A three-way reconciliation adds a third leg: does the sum of every individual owner balance, tenant prepayment, and security deposit held also equal that same figure? This is the leg state auditors check, because it is the only one that reveals a trust shortage. AppFolio computes the components but does not run the comparison as a gate, and nothing in the software prevents you from closing a month where the third leg disagrees.
The consequence is specific and worth stating plainly: a receipt posted to the wrong property reconciles perfectly. Bank and register agree, because the cash arrived and was recorded. Only the beneficiary detail is wrong. The software has no basis on which to object, because from its perspective nothing is inconsistent.
Cross-period voids. A receipt or check clears the bank and its period is reconciled. Months later the transaction is voided. The reversal lands in the current period while the original sits in a closed one, and the adjusted cash balance shifts by that amount permanently. This is the most common cause of a constant offset we encounter, and we walk through locating it in this diagnostic guide.
Activity that bypassed the software. Owner distributions or fee sweeps executed directly in online banking, with no corresponding register entries. The bank balance drops; the register does not. AppFolio cannot detect a transaction it was never told about — it can only compare against the bank feed, and a feed line with no matching entry is presented as an unmatched item that someone must interpret.
Stranded clearing and transit accounts. Security deposit clearing accounts left non-zero after a move-out; undeposited funds carrying receipts whose deposits were never recorded. Both represent cash your books cannot assign to a beneficiary, and both make the third leg disagree by exactly their balance, every month. We cover the transit case in undeposited funds in AppFolio.
Migration-era opening balances. If the balance you entered when you moved onto AppFolio was itself wrong, every reconciliation since has been verified against a false starting number. The software has no way to question its own opening balance, and the error is invisible in every subsequent period while remaining fully present.
Deposits are where the largest number of state findings concentrate, partly because the rules differ by jurisdiction and partly because the move-out workflow crosses several accounts at once.
Two things need to be true continuously. The deposit liability by tenant must equal the cash held for deposits, whether that cash sits in a dedicated bank account or is tracked within the main trust account. And the clearing account used during move-outs must return to zero once each move-out is complete.
The characteristic failure is a partial move-out: damages are applied, a refund is issued, and a residual amount remains in the clearing account because the applied amount and the refund do not sum to the original deposit. Nothing errors. The residual persists. Multiply by a few dozen move-outs a year and the accumulated balance becomes the unexplained difference someone eventually goes looking for.
The word doing the work here is independent. AppFolio verifying AppFolio is a closed loop: it can confirm that its own records are internally consistent and that they agree with the bank feed, but it cannot evaluate whether a receipt belongs to the property it was posted to, whether an opening balance was ever correct, or whether the sum of what you owe still equals what you hold.
An independent layer re-derives the numbers from source data rather than accepting the software's computed balances: every bank transaction matched, every owner balance recomputed from transactions, every clearing account tested for zero, management fees checked against contract rates. That is a different question from the one the reconciliation screen answers, and it is the question auditors ask.
You can run the aggregate version yourself in a few seconds with our free three-way checker: enter the adjusted bank balance, the ledger balance, and the sum of owner and tenant balances, and it tells you whether they agree and which leg is off. Nothing is uploaded; the arithmetic runs in your browser.
The per-beneficiary version — which is where wrong-property postings, negative sub-ledgers, and stranded clearing balances actually surface — requires transaction-level work. That is what our AppFolio reconciliation service does monthly, and what the free first audit does once, with every finding tied to a record ID, within 48 hours.
Run AppFolio's reconciliation as you already do. Then, before closing, compute the third leg and compare it to the reconciled balance. Then confirm that undeposited funds and every clearing account are zero, or that any balance is explained by a specific item dated within the last few days. Then check that no individual owner or tenant balance is negative, because a single negative sub-ledger means one client's funds are covering another's obligations regardless of how healthy the aggregate looks.
Four checks, ten minutes, and they catch the categories the software structurally cannot. The trust account audit checklist covers the full version of this routine, including the documentation auditors expect you to have retained.
Upload three exports. Within 48 hours you get a discrepancy report with every finding tied to a record ID. Built from the same failure patterns state auditors look for.
For property management companies on Buildium or AppFolio. No call required.