Why Your AppFolio Adjusted Cash Balance Doesn't Match (And How to Fix It)

The Adjusted Cash Balance is AppFolio's version of the triple tie-out — the master check that tells you whether your books are actually clean. When it doesn't match your bank statement, it's tempting to assume it's a minor rounding error. It almost never is.

Here's how to diagnose the root cause and fix it the right way.

What the Adjusted Cash Balance Actually Means

The Adjusted Cash Balance is AppFolio's calculation of what your bank account balance *should* be, assuming every transaction in the system is accurate. It's calculated as:

Property cash account balances (all properties tied to that bank account) - Less: Unreconciled deposits and receipts deposited after the current period - Plus: Unreconciled checks and outstanding eCheck/ACH batches - Plus: Uncleared checks voided after the reconciliation period

This number must match your bank statement's ending balance for a reconciliation to be considered clean. If it doesn't match, AppFolio displays it in red as a warning.

The Three Accounts That Must Tie

A proper AppFolio reconciliation is a three-way match:

1. 1Bank Statement Balance — the ending balance on your actual bank statement
2. 2GL Cash Account Balance — the sum of all cash transactions posted to the bank's linked GL accounts in AppFolio
3. 3Owner Ledger Totals — the aggregate of all owner/property cash balances across every property tied to that bank account

When all three agree, you have a clean close. When even one is off, the Adjusted Cash Balance will flag it.

How to Run the Financial Diagnostics Report

The Financial Diagnostics report is AppFolio's built-in tool for surfacing cash discrepancies. Here's how to use it:

1. 1Go to Reports > Financial Diagnostics
2. 2Select the bank account in question
3. 3Run the report for the period you're investigating
4. 4Review each section carefully — AppFolio will flag areas where balances don't agree

Key sections to focus on: - Bank Account Balance vs. Property Cash Balances — shows whether your GL and owner ledger totals match - Security Deposit Funds — a common source of mismatch - Undeposited Funds — receipts that have been entered but not yet deposited

Each flagged item is a lead. Investigate each one before making any corrections.

Common Root Causes

Undeposited Funds Receipts entered in AppFolio but not yet deposited to a bank account sit in "undeposited funds." If these aren't deposited in the system promptly, they inflate your GL cash balance without appearing on the bank statement.

Wrong Bank Account on a Transaction If a payment was posted to the wrong bank account — especially common when a company has multiple trust accounts — the GL balance for one account will be overstated and another understated. Search transactions by amount across accounts to find misrouted entries.

Journal Entries Hitting Cash Directly Journal entries that debit or credit the cash GL account directly (instead of using a bank deposit or payment flow) can throw off your Adjusted Cash Balance without triggering any reconciliation warnings. Run a GL report filtered to the cash account and look for any JEs — these are almost always the problem.

Prepaid Rent Issues Prepaid rent collected before the lease start date can be posted to the wrong period or the wrong property, creating a mismatch between what's in the bank and what the owner ledger shows.

Security Deposit Mismatches Security deposits must be held in a segregated account in most states. If security deposit receipts are deposited into the operating account (or vice versa), both accounts will show discrepancies.

Step-by-Step Triage Process

When your Adjusted Cash Balance doesn't match, work through this triage in order:

1. 1Run the Bank Reconciliation Diagnostic — determine if the issue is in the current period or a prior period
2. 2Check for undeposited funds — clear any lingering undeposited items that should have been deposited
3. 3Review journal entries — run a GL report filtered to the cash account and look for any JEs posted directly to cash
4. 4Check for wrong-account transactions — search for transactions that may have been posted to the wrong bank account
5. 5Review security deposit account — run the Financial Diagnostics security deposit section and trace any flagged amounts
6. 6Look for backdated edits — check the transaction audit log for any changes made to previously reconciled transactions

When You Need a Journal Entry vs. Fixing the Source Transaction

• Fix the source transaction when: the original entry was wrong (wrong account, wrong amount, wrong property). Editing the source is always preferable because it maintains an accurate history.
• Use a journal entry when: the source transaction is locked, cleared, or can't be edited without creating other problems. Journal entries should always include a clear memo explaining what they're correcting and why.

Never use a journal entry to "plug" a number you can't explain. If you can't trace it to a root cause, keep digging.

---