How to Reconcile Bank Accounts in AppFolio

Bank reconciliation is the backbone of clean property management accounting. If your books don't match your bank, you're flying blind — and that puts your owners' trust (and your business) at risk. AppFolio has built-in reconciliation tools, but knowing how to use them correctly makes all the difference.

Why Bank Reconciliation Matters

Every dollar that flows through your property management company — rent payments, security deposits, vendor invoices, owner distributions — needs to be accounted for. Bank reconciliation is how you verify that your AppFolio records match your actual bank balances.

Failing to reconcile regularly leads to:

• Undetected errors in tenant charges or owner distributions
• Trust accounting violations that can result in license revocation
• Cash flow surprises when expected funds aren't where they should be
• Audit failures that damage your reputation with owners and investors

Step-by-Step Reconciliation in AppFolio

1. Gather Your Bank Statements

Before you start, download or access your bank statements for the period you're reconciling. You'll need the ending balance and a list of all cleared transactions. Most banks offer CSV downloads that make cross-referencing easier.

2. Navigate to Bank Reconciliation

In AppFolio, go to Accounting > Bank Reconciliation. Select the bank account you want to reconcile and enter the statement ending date and balance from your bank statement.

3. Match Cleared Transactions

AppFolio will display all outstanding transactions. Check off each transaction that appears on your bank statement. Pay attention to:

• Deposits in transit: Money you've recorded in AppFolio but hasn't cleared the bank yet
• Outstanding checks: Payments you've issued that haven't been cashed
• Bank fees: Charges from your bank that you may not have recorded yet

4. Investigate Discrepancies

If your reconciled balance doesn't match the bank statement, you have a discrepancy. Common causes include:

• Duplicate entries: The same transaction recorded twice in AppFolio
• Missing transactions: Bank fees, interest, or transfers not yet entered
• Incorrect amounts: Typos or rounding errors in transaction amounts
• Timing differences: Transactions that cleared in a different period than expected

5. Record Adjustments

For legitimate differences like bank fees or interest income, create the appropriate journal entries in AppFolio before finalizing your reconciliation. Never force a reconciliation to balance — every difference needs an explanation.

6. Finalize and Document

Once your balance matches, finalize the reconciliation. AppFolio will lock the reconciled transactions to prevent accidental changes. Save a PDF of your reconciliation report for your records.

Best Practices for AppFolio Reconciliation

Reconcile Frequently

Don't wait until month-end. Weekly or even daily reconciliation catches errors early when they're easiest to fix. Many of our clients at TP Operations reconcile trust accounts daily and operating accounts weekly.

Separate Trust and Operating Accounts

Always reconcile trust accounts and operating accounts separately. Trust funds have strict regulatory requirements, and commingling creates compliance risks that can be costly to untangle.

Use the Bank Feed Feature

AppFolio's bank feed integration can import transactions automatically, reducing manual data entry and the errors that come with it. Set up your bank feeds and review imported transactions daily.

Create a Reconciliation Checklist

Standardize your process with a checklist that covers every step. This ensures consistency regardless of who performs the reconciliation and makes training new team members straightforward.

Keep a Running Log of Common Issues

Track recurring discrepancies and their resolutions. Over time, this log becomes an invaluable troubleshooting resource and helps you identify process improvements.

When to Call in the Experts

If you're consistently finding large discrepancies, your reconciliations take more than a few hours per account, or you've fallen behind by several months, it may be time to bring in specialized help. At TP Operations, we handle bank reconciliations for property management companies across the country, averaging a 2-day month-end close with zero tolerance for unresolved differences.

Clean reconciliations aren't just good accounting — they're the foundation of every owner relationship you have. Get them right, and everything else gets easier.