AppFolio Trust Account Not Balancing: Fast Diagnosis
The bank says one number. The ledger says another. A third report disagrees with both, and owner draws go out in the morning. An AppFolio trust account not balancing at 9 p.m. is not a software failure. It is a sequencing problem, and it has a name.
An AppFolio trust account not balancing breaks at one of three checkpoints: the bank rec, the bank account activity report plus undeposited receipts, or the bank balance detail. The variance amount tells you which one. So test the difference first: does it match a single item, match your undeposited receipts, or divide evenly by nine?
Accounting guidance, not legal advice. Trust and escrow rules differ by state and license type. Check your own state real estate commission’s rule text, or ask counsel, before you act.
Key Takeaways
- All three checkpoints must reconcile on the same date and reflect identical totals, per AppFolio’s own published process, and undeposited receipts sit inside checkpoint two, so a receipt you never deposited shifts which checkpoint agrees instead of raising an error.
- Five root faults explain almost every case, and the same five stall a Buildium rec or a Yardi bank book: undeposited receipts, a missing or edited opening balance, postings into a closed period, plug entries, and one-sided items. Only the report names change.
- Florida Rule 61J2-14.012 sets a frequency of once monthly and no day-of-month deadline, but demands a written description of any difference plus the corrective action taken, so the risk is an undocumented gap, not a late one.
Why It Is a Three-Leg Problem
A trust account has three legs; a normal bank rec has two. By comparison, a standard rec ties the statement to the book. A trust rec must also tie both to the sum of every owner ledger, every tenant deposit, and every broker reserve. So a trust account can match the bank to the penny and still be out of trust. California’s Department of Real Estate says auditors have seen numerous cases where trust funds were properly recorded on the books but never deposited to the trust account. Books right, bank wrong, ledgers untouched.
Let the Variance Amount Diagnose It
First, write down the exact difference before you open anything. In fact, that number is your best clue.
| Pattern in the variance | Likely fault | Where to look first |
|---|---|---|
| Matches one item on your register | An item posted, voided, or dated wrong | Transaction warnings; the register |
| Matches your undeposited receipts total | Receipts keyed but never deposited | Undeposited funds; make deposit |
| Divides evenly by 9 | A transposition, like $500.50 keyed as $500.05 | Deposit and check detail |
| A round number ending in 00 | A manual plug entry | Bank adjustments and journal entries |
| Matches last period’s ending gap | Opening balance never set, or edited later | Prior rec; beginning balance |
Bring Your Variance, We Name the Checkpoint
Find Which Checkpoint Broke
AppFolio publishes a three-way structure that few managers ever see. For example, checkpoint one is the Bank Reconciliation Report, which proves the bank side. Checkpoint two is the Bank Account Activity Report, where ending book balance plus undeposited receipts equals available balance, so a receipt keyed and never deposited throws no error and quietly moves the tie-out. Checkpoint three is the Bank Balance Detail, which breaks the available balance down by property and beneficiary and decides whether you are actually in trust. The same faults appear in Buildium as undeposited funds and opening-balance gaps, and in Yardi Voyager as unposted receipts and GL cutoff mismatches. Only the vocabulary shifts.
The Diagnostic Sequence
Write down the exact variance and run it through the table above. Confirm the statement date range matches the bank statement exactly. Tie the beginning balance to last period’s ending balance. Run the platform’s diagnostic report. Total your undeposited receipts and test that figure against the variance. Pull every bank adjustment and journal entry, splitting true bank errors from plugs. Rebuild checkpoint three by adding owner ledgers, tenant deposits, and broker reserve. Then write the explanation and corrective action into the file before you sign it, because in several states that note is the actual requirement.
Frequently Asked Questions
How often must a property manager reconcile a trust account? Florida Rule 61J2-14.012 asks for a written statement-reconciliation once monthly with no day-of-month deadline, while Arizona asks for a monthly three-way reconciliation plus a written explanation of any variation. Frequency and deadlines differ by state, so verify your own commission’s text.
Can I post an adjustment to force it to balance? No. A plug hides the fault, and regulators treat an unexplained overage or shortage as the finding itself. Save adjustments for genuine bank errors, and write the description and corrective action into the file.
Related reading: three-way reconciliation and security deposit journal entries and the three-way tie-out.
Get the Tie-Out Right Before an Examiner Does
Ready to Talk Through Your Property Accounting?
Schedule a free strategy call with a property accounting specialist who works with property managers daily.
Schedule a Free Strategy Call