AppFolio Cleanup: The 9 Errors Behind a Portfolio That Will Not Tie Out

A property management business relying on AppFolio usually runs into the same wall: month end totals that will not tie out. An appfolio cleanup finds where the numbers broke, fixes the underlying entries, and rebuilds trust between property managers and the owners who read every statement.

By REA Team, Property Management Experts

AppFolio's bank reconciliation module catches obvious problems, a duplicate deposit or a missing statement date, but it cannot catch errors that were coded correctly at the transaction level and wrong at the account level. A portfolio usually will not tie out because the difference is hiding inside categorization, not inside the bank feed, and it eventually shows up as a mismatch between the balance sheet and the bank statement. Common culprits include journal entries posted directly to a bank account outside the reconciliation screen, security deposits booked as income, and manual overrides used to force a reconciliation closed instead of finding the actual variance. Each of these clears the screen for one month while leaving a real financial gap that resurfaces later, usually right when an owner asks why their statement does not match their own bank records. What starts as a single miscoded fee becomes a corporate bookkeeping problem once it touches every owner statement the portfolio produces.

Most reconciliation breakdowns trace back to a small set of repeat offenders. Here are the nine errors REA's cleanup team sees most often in AppFolio portfolios:

1. Uncategorized or misclassified transactions sitting in the wrong account on the chart of accounts 2. Security deposits posted to income instead of a trust liability account 3. Owner draws recorded as operating expenses 4. Duplicate or missing transactions in the bank feed 5. Journal entries that bypass the reconciliation process entirely 6. Data migrated from another platform without a chart of accounts that matches AppFolio's structure 7. Trust and operating funds commingled inside the same reconciliation 8. Void and reissue cycles on checks that were never closed out 9. Prior period adjustments made after a reconciliation was already marked complete

Any one of these is usually a quick fix. Three or four stacked across several months is what turns into a full appfolio cleanup instead of a single afternoon of corrections.

What Causes AppFolio Trust Accounts to Go Out of Balance?

Trust accounts go out of balance for a narrower set of reasons than the operating side: a security deposit posted to the wrong bank account, an owner draw pulled from trust instead of operating, or a clearing account that never gets zeroed out at month end. State trust accounting rules add another layer, since requirements for commingling and reconciliation frequency differ by jurisdiction, and AppFolio's setup needs to reflect the state-by-state compliance rules a portfolio actually operates under before reconciliation will hold. A trust account that is even one dollar off is a compliance issue, not just a bookkeeping one, and it rarely resolves itself.

A handful of signals show up before a portfolio manager ever runs a full audit. Owner statements that do not match the property manager's own bank statements are the clearest one, followed by negative balances sitting in accounts that should never go negative, like a trust liability account. A monthly close that keeps sliding later each month is another sign, since it usually means someone is manually forcing reconciliations to balance rather than finding the real variance. Unexplained journal entries with no supporting transaction, accounts that have not been reviewed in more than a quarter, and an owner asking a question nobody on the team can answer with the software open are the signals that move a portfolio from routine maintenance to cleanup.

Fixing a broken reconciliation process starts with the bank statement, not the software. Pull every bank statement for the period in question and compare it to the AppFolio ledger transaction by transaction, not just ending balance to ending balance, since two portfolios can share the same ending number for entirely different reasons. Line-by-line transaction matching isolates the exact date and dollar amount where the ledger and the bank statement diverge, which is the only way to know whether the fix is a missing deposit, a duplicate charge, or a miscoded journal entry. Corrections belong in the ledger through proper journal entries, never as a forced adjustment inside the reconciliation screen, because a forced adjustment clears the screen without correcting the balance an owner statement pulls from.

How Often Should You Reconcile AppFolio?

Monthly is the baseline for every operating and trust account, timed to when the bank statement actually arrives rather than a fixed calendar date. Trust accounts often need a closer look, since many states expect more frequent internal review even when the formal reconciliation stays monthly. A portfolio that reconciles consistently rarely needs a cleanup at all.

Once a portfolio needs a real appfolio cleanup rather than a single correction, the next questions are practical: cost, team, and timeline.

How Much Does an AppFolio Cleanup Cost?

Cost scales with two variables: the number of units in the portfolio and how many months the books have been out of balance. A single month variance on a small portfolio is a different scope than a multi year reconstruction across a hundred units, so an accurate quote usually follows a short review of the account rather than a flat number. REA prices every cleanup after that review, once the actual scope is known.

Should You Hire a Bookkeeper or a CPA for AppFolio Cleanup?

A bookkeeper is usually the right fit for reclassification work: fixing miscoded transactions, rebuilding the chart of accounts, and correcting the reconciliation mechanics inside AppFolio. A CPA becomes necessary when the errors touch tax filings or an upcoming audit, since those corrections carry downstream reporting consequences a bookkeeper's fix alone will not resolve. A consultation with REA's Real Estate Accounting team can usually tell a property management business which path its portfolio needs within one call, before any cleanup work begins.

Can I Clean Up AppFolio Myself?

A single miscoded transaction or one missed deposit is usually within reach for an in house team already comfortable in AppFolio. A portfolio that has been out of balance for several months, or one where trust and operating funds have already commingled, carries more risk: manual fixes applied without isolating the original error tend to mask the variance rather than correct it, which can leave a property management business worse off than before the cleanup started.

How Long Does an AppFolio Cleanup Take?

Timelines vary with portfolio size and how far out of balance the books are. A single month correction on a small portfolio often wraps within a couple of weeks, while a multi year reconstruction across a larger portfolio can run one to two months. Setting a realistic timeline upfront, rather than promising a fixed date before the review is complete, is usually what keeps a cleanup from stalling halfway through.

Can bad AppFolio bookkeeping trigger an audit? Bad AppFolio bookkeeping alone does not trigger an audit, but it makes one far more painful if a lender, investor, or tax authority requests one. Miscoded transactions and unreconciled trust accounts are exactly what an auditor flags first, since they point to a chart of accounts that does not reflect what actually happened financially.

What happens if a trust account never gets reconciled? An unreconciled trust account puts a property management business out of compliance in most states, and the gap between what the ledger shows and what the bank actually holds tends to grow every month it goes unchecked. Some states allow penalties over unreconciled trust funds, so this is usually treated as the most urgent item in any cleanup.

Does an AppFolio cleanup fix owner statements? Yes. Owner statements pull directly from the same ledger that a reconciliation corrects, so fixing the underlying transactions and account coding also fixes every owner statement generated from that data going forward. Statements already sent for prior periods may still need a separate correction and reissue.

Is a portfolio wide cleanup different from a one time reconciliation fix? Yes. A one time fix corrects a single variance in a single account. A portfolio wide cleanup reviews every account across every property for the same nine error types, since an error found in one unit's ledger is often present in several others that have not been flagged yet.

A portfolio that will not tie out gets harder to trust with every month it stays that way, for the team running it and for every owner reading a statement from it. Lets Connect with REA to scope what an appfolio cleanup would take for your portfolio.