AppFolio Trust Accounting: How to Keep It Clean
Short answer: Trust accounting in AppFolio means keeping other people’s money — tenant security deposits and owner funds — in separate bank accounts, tracked so precisely that you can prove at any moment whose dollar is whose. The discipline that proves it is the three-way reconciliation, run monthly. Get the setup right and reconcile on a schedule, and trust accounting is routine. Skip either one, and it drifts quietly until an audit finds it.
What “trust accounting” actually means
If you manage property, most of the money moving through your bank accounts isn’t yours. Security deposits belong to tenants. Rent collected belongs to owners until you disburse it. Your actual revenue — management fees — is a thin slice on top.
Trust accounting is the practice of keeping that distinction perfectly clean: client funds sit in dedicated trust accounts, segregated from your company’s operating cash, with records detailed enough to show every beneficiary’s balance on demand. AppFolio is built around this, which is why property managers use it instead of generic accounting software.
The software, though, only enforces what you set up. It will happily record a mess if you hand it one.
Get the setup right first
Almost every messy trust account we see traces back to a shortcut taken at go-live. The rules are simple and worth auditing today:
- One bank account in AppFolio = one real bank account. Not a rough approximation, not two real accounts collapsed into one record.
- Keep the operating trust account and the security deposit account separate. Many states require deposits held separately; even where they don’t, mixing them makes reconciliation far harder.
- Map each bank account to the correct GL cash account.
- Set the correct default bank account for each transaction type, so routine entries don’t land in the wrong place by default.
- Never let management fees accumulate in the trust account. Your earned income sitting in a trust account is a classic finding — sweep it to operating on a schedule.
The three-way reconciliation
This is the part most people underestimate. A normal bank reconciliation is two-way: the bank statement matches your general ledger. That can balance perfectly while individual ledgers are still wrong.
A three-way reconciliation — the standard for trust accounts — requires three numbers to agree as of the same cutoff date:
| # | What it is | Where it comes from |
|---|---|---|
| 1 | Bank balance | The trust account bank statement, adjusted for outstanding checks and deposits in transit |
| 2 | Book balance | The GL cash balance for that account in AppFolio |
| 3 | Beneficiary ledgers | The sum of every individual owner, tenant, and security deposit ledger |
If the bank and the book agree but the sum of the ledgers doesn’t, someone’s money is covering someone else’s — and the total looks fine, which is precisely why it goes unnoticed. That third leg is the whole point.
Most state real estate commissions require this monthly, with the worksheet retained on file. California’s Regulation 2832 is a representative example, and reconciliation gaps — missing worksheets, unexplained variances — are among the most commonly cited findings in state audits. (More on why in the companion piece: the most common real estate license violation.)
How trust accounts drift
None of these are dramatic. That’s the problem:
- A payment posted from the wrong bank account — operating expense paid from trust, or vice versa.
- An owner draw that the property couldn’t cover, creating a negative owner balance funded by other owners’ money.
- Management fees left in trust past the sweep.
- A deposit recorded against the wrong property, so two ledgers are wrong and the total is right.
- Security deposit liabilities that no longer match what’s actually in the deposit account.
- Negative property or owner balances nobody chased, because the bank balance still looked healthy.
Run AppFolio’s trust account balance and diagnostics reports and review the security deposit section every month. Negative balances are the signal to act on immediately.
Cleaning up an account that has already drifted
If you’re behind, the sequence is boring and it works:
- Gather every bank statement for the affected period.
- Reconcile month by month, in order, back to actual bank balances — don’t start in the middle.
- Identify every unexplained variance rather than forcing a balance.
- Re-code transactions to the correct property, owner and ledger.
- Clear negative balances, funding them properly from the right source.
- Verify security deposit liabilities tie to the deposit account.
- Start a monthly three-way reconciliation and don’t miss one.
Steps 1–6 fix the past. Step 7 is the one that matters, because a cleanup without a recurring close routine puts you right back here in six months.
When to hand it off
Trust accounting isn’t hard — it’s unforgiving and relentless. It has to be right every month, and the person doing it is usually the same person handling maintenance calls, leasing and owner complaints. That’s how a month gets skipped, and then three.
Handing the books to a dedicated team is less about difficulty and more about guaranteeing the close actually happens. DaxHive works inside your existing AppFolio account — you own it, we work in it — doing reconciliations, coding, owner statements and month-end close. See AppFolio bookkeeping services for how that works, or bookkeeping services for the broader picture. On Yardi or Buildium instead? Same discipline: Yardi, Buildium, and a side-by-side comparison if you’re still choosing.
Bookkeeping starts at from $399/mo, or bundled with the rest of the back office in MATRIX at $3,000/mo — see pricing or the full outsourced back office overview.
One honest caveat: the broker or licensee remains legally responsible for trust fund compliance — that can’t be outsourced, and nothing here is legal advice. What a bookkeeper does is make compliance achievable, by keeping the records accurate, current and reconciled so nothing drifts in the first place. Regulatory questions belong with your state commission and your attorney.
If your trust accounts haven’t been reconciled in a while and you’d rather not find out during an audit, book a free discovery call and we’ll tell you honestly how big the cleanup looks.
AppFolio, Yardi and Buildium are trademarks of their respective owners. DaxHive is an independent bookkeeping and back-office provider and is not affiliated with, endorsed by, or sponsored by any of them.
Frequently asked questions
What is trust accounting in AppFolio? +
Trust accounting in AppFolio means holding money that belongs to other people — tenant security deposits and owner funds — in dedicated bank accounts that are kept completely separate from your management company's operating cash. AppFolio mirrors your real bank accounts and tracks every dollar back to the owner, tenant, or property it belongs to, so you can prove whose money is whose at any moment.
What is a three-way reconciliation and why does it matter? +
A three-way reconciliation confirms that three numbers match on the same cutoff date: the trust bank statement balance, the general ledger cash balance in your software, and the sum of every individual owner, tenant, and security deposit ledger. It matters because a two-way bank reconciliation can balance perfectly while individual ledgers are still wrong. The third leg is what proves no beneficiary is short.
How often should a property manager reconcile trust accounts? +
Monthly at minimum, because most state real estate commissions require it — California's Regulation 2832 is a typical example. Many managers reconcile weekly or biweekly because smaller gaps are far easier to find and fix than a month of accumulated errors, and it makes the month-end close much faster.
How should bank accounts be set up in AppFolio? +
One bank account in AppFolio should equal exactly one real bank account. Keep the operating trust account and the security deposit account separate, map each to the correct GL cash account, and set the correct default account for each transaction type. Most trust account messes trace back to a setup shortcut taken at go-live.
What causes a trust account to go out of balance in AppFolio? +
The usual causes are a payment posted from the wrong bank account, an owner draw taken when the property ledger could not cover it, management fees left sitting in the trust account, deposits recorded in the wrong property, and negative owner or property balances that nobody chased. Each one is individually small, which is exactly why it goes unnoticed.
What is a negative owner balance and why is it a problem? +
A negative owner balance means you spent more on a property than that owner's funds could cover, so another owner's money in the same trust account is temporarily covering it. It is one of the most common trust findings in an audit because the bank account still looks fine in total. AppFolio's balance and diagnostics reports surface these so you can resolve them.
Can you clean up an AppFolio trust account that is already a mess? +
Yes. The sequence is to reconcile each account month by month back to actual bank statements, re-identify every unexplained variance, re-code transactions to the correct property and ledger, clear negative balances, and then run a clean three-way reconciliation going forward. The cleanup fixes the past; a monthly close routine is what keeps it fixed.
Does DaxHive do bookkeeping inside our AppFolio account? +
Yes. DaxHive works inside your existing AppFolio instance — you own the account and the data, and we do the reconciliations, coding, owner statements and month-end close in it. Bookkeeping starts from $399/mo, or comes bundled with the other services in MATRIX at $3,000/mo.
Do you handle trust accounting for property managers using Yardi or Buildium instead? +
Yes. The same trust discipline applies across platforms and DaxHive supports Yardi, Buildium and AppFolio. The reports and screen names differ, but the requirement is identical: separate trust bank accounts, per-beneficiary ledgers, and a monthly three-way reconciliation that ties out.
Who is responsible for trust account compliance, us or our bookkeeper? +
The broker or licensee remains legally responsible for trust fund compliance — that responsibility cannot be outsourced. A bookkeeper's job is to make compliance achievable by keeping the records accurate, current and reconciled so nothing drifts. DaxHive does the bookkeeping and reconciliation; your broker and attorney own the regulatory position.
Want this handled for you?
DaxHive runs your marketing, bookkeeping, tax, fractional CFO & COO and more — single services from $299/mo, or everything on MATRIX at $3,000/mo.
Book a free call