AppFolio Bank Reconciliation: Step-by-Step Walkthrough for Property Managers

Table of Contents

• Why Bank Reconciliation Errors Cost Property Managers More Than Time
• Setting Up AppFolio Before Your First Reconciliation
• The AppFolio Bank Reconciliation Process, Step by Step
• Common Reconciliation Errors AppFolio Helps You Catch
• Building a Reliable Monthly Bank Reconciliation Process
• Frequently Asked Questions
• Get Reliable Bank Reconciliations for Every Property You Manage

AppFolio bank reconciliation matches every transaction posted in your general ledger against your bank statement, so trust funds, security deposits, and owner draws stay accurate month over month. This walkthrough covers the exact steps property managers take inside AppFolio to close the books, flag discrepancies, and keep every bank account audit-ready.

By REA Team, Property Management Experts

For a property management company, a bank reconciliation is not a bookkeeping formality. It is the control that proves owner trust funds, security deposits, and operating cash match what the bank actually holds. When bank reconciliations slip for even one cycle, discrepancies compound: a duplicate check clears twice, a tenant refund posts to the wrong bank account, or a wire transfer never gets recorded in the general ledger. In most states, trust accounting rules require property managers to reconcile trust bank accounts monthly and retain records showing the reconciliation process was completed on schedule. Falling behind does not just create messy books, it creates liability with state regulators and with the owners whose funds you hold. REA built its Real Estate Accounting practice around this exact problem, catching reconciliation gaps before they become audit findings instead of after.

The stakes rise with portfolio size. A single-property manager might absorb a small reconciliation error without much fallout. A firm managing dozens of properties across multiple owners cannot. One unresolved discrepancy on a trust bank account can trigger a state audit, and depending on the jurisdiction, repeated failures to reconcile on schedule can put a broker's license at risk. AppFolio was built with this regulatory reality in mind, which is why its reconciliation tool ties directly into the general ledger rather than functioning as a standalone spreadsheet exercise. Owner statements pull straight from the same reconciled data, so an unresolved variance does not just sit quietly, it eventually shows up as a number an owner will ask about.

Before you run a single reconciliation, confirm three things inside AppFolio. First, every operating and trust bank account you manage needs an active bank feed connection, either through direct integration or manual statement upload, so transactions flow into the general ledger daily instead of arriving in batches at month end. Second, confirm your chart of accounts maps cleanly to each bank account. Property managers who inherit a portfolio from another platform often find GL codes that do not match AppFolio's default structure, and that mismatch throws off every reconciliation report downstream.

Third, verify your opening balance. AppFolio's reconciliation module compares your book balance to the bank statement balance as of a cutoff date, and if that starting number is wrong, every reconciliation after it inherits the same error, month after month, until someone catches it. Teams managing a full Property Management portfolio should audit these three items during onboarding, not after the first discrepancy shows up on an owner statement. A clean setup takes an afternoon. Unwinding a year of drifting opening balances can take weeks, and it usually means pulling twelve months of bank statements to rebuild the trail by hand.

If a bank feed stops updating mid-month, do not wait for the statement to arrive before investigating. A broken feed connection is one of the most common reasons a reconciliation comes up short, because transactions that should have imported automatically simply never post to the ledger. Checking feed status weekly, rather than only at reconciliation time, catches this before it becomes a bigger backlog.

AppFolio bank reconciliation follows a consistent workflow across every property in your portfolio, whether you manage two bank accounts or two hundred. Here is how the process runs from start to finish.

• Open the Reconciliation tool under Accounting and select the bank account you want to reconcile.
• Enter the statement ending date and ending balance exactly as shown on your bank statement.
• Review the list of outstanding transactions AppFolio pulls from the general ledger. The software pre-matches items with dates and amounts that align with your bank feed, which speeds up the initial pass considerably.

• Check off each transaction that has cleared the bank. Checks, deposits, ACH payments, and owner draws all appear on this list, and each one needs to be individually confirmed against the statement rather than bulk-approved.
• Investigate anything that will not check off cleanly. A transaction still outstanding after 60 to 90 days, or a bank-side item with no matching ledger entry, needs research before you close the period. Do not force a match just to zero out the balance.
• Confirm the difference between your book balance and the bank balance reads zero, then finalize and lock the reconciliation so it cannot be edited later without leaving an audit trail.

Running this same reconciliation process on the same schedule, ideally within five business days of each statement closing, is what keeps discrepancies small enough to resolve in minutes instead of hours. Property managers who wait until quarter end to catch up are always working from a bigger, harder backlog, and the person who could explain a strange transaction in month one is rarely still available to explain it in month three.

Even with a clean process, certain errors show up again and again across property management portfolios. AppFolio's reconciliation report is built to surface these before they reach an owner statement.

Duplicate transactions happen when a payment gets entered manually and again through the automated bank feed, creating a phantom balance that will not clear until one of the two entries is deleted. Misapplied trust funds occur when security deposits or reserve funds post to the wrong bank account, distorting both the trust ledger and the operating account at once, which is exactly the error state regulators and boards look for during an audit. Timing differences are usually harmless: checks written near month end that have not cleared the bank yet are normal, but they need to be tracked as outstanding rather than ignored or written off. GL mapping drift shows up when a new expense category gets added without mapping it to the correct bank account, so transactions post successfully but never reconcile cleanly no matter how many times you run the report. Void and reissued checks add another wrinkle: if the original check was never voided in AppFolio before the replacement was cut, both can show as outstanding indefinitely, inflating your outstanding-items list and hiding the actual variance underneath it.

Property managers switching from another platform run into these patterns most often, especially when opening balances do not carry over cleanly into the new system, which is worth confirming in detail during any platform migration. Firms comparing platforms before they commit should look closely at how each system handles reconciliation tooling and outstanding-item tracking, since those are exactly the workflows most likely to break during a switch.

A reconciliation is only as good as the habit behind it. Property management companies that stay current, reconciling every bank account within the first week of a new statement period, catch small errors while they are still one-line fixes. Teams that let reconciliations pile up quarterly often spend days untangling what should have taken an hour, and by then the person who can explain a strange line item may not remember the details.

Build a simple monthly checklist: reconcile every operating and trust bank account, review any transaction still outstanding past 60 days, confirm GL mappings for new vendors or expense categories, and document any adjusting entries with a short note explaining why the entry was needed. If your portfolio also runs accounts outside AppFolio, whether that is a legacy QuickBooks file from an acquired property or a separate corporate entity, apply the same monthly checklist there instead of running two different standards, and lean on QuickBooks for real estate for the platform-specific setup steps.

Outsourcing this function is common once a portfolio grows past a handful of properties. A dedicated reconciliation team applies the same checklist across every bank account you manage, on the same schedule every month, which is often the difference between reconciliations finishing in days instead of dragging into weeks and pulling attention away from leasing and operations. It also means the same reviewer catches recurring patterns across the portfolio, a duplicate vendor payment on one property often points to the same error waiting to happen on another.

How often should property managers run AppFolio bank reconciliation? Monthly at minimum, and within the first five business days after each statement closes. Trust accounting rules in most states require monthly reconciliation of trust bank accounts, and running the process on a fixed schedule keeps error volume low. Portfolios with high transaction counts sometimes reconcile operating accounts weekly for tighter visibility between statement periods.

What causes a bank reconciliation to not balance in AppFolio? The most common causes are duplicate entries, transactions posted to the wrong bank account, an incorrect opening balance carried from a prior period, or a bank-side transaction that was never entered into the general ledger. Working through the outstanding items list line by line usually isolates the cause within minutes rather than hours.

Can AppFolio reconcile trust and operating bank accounts separately? Yes. AppFolio treats each bank account as its own reconciliation, so trust accounts and operating accounts are matched independently against their own statements. This separation matters for compliance, since commingling trust and operating funds during reconciliation can trigger regulatory issues with state licensing boards.

How long does a typical bank reconciliation take in AppFolio? For a well-maintained account with a clean GL mapping, a reconciliation typically takes 15 to 30 minutes once the bank feed has pre-matched most transactions. Accounts with a backlog of unresolved outstanding items, or ones being reconciled for the first time, can take considerably longer to work through.

What happens if a reconciliation is locked with an error still open? AppFolio allows you to finalize a reconciliation with a documented variance, but that variance carries forward and should be investigated and corrected in the following period rather than left open indefinitely. Leaving unresolved variances across multiple periods is one of the fastest ways to lose track of where an error actually originated.

Bank reconciliation should never be the reason an owner statement goes out late or a trust account falls out of balance. REA's team reconciles AppFolio accounts for property management companies of every size, catching the errors above before they reach your books. Lets Connect to talk through your current reconciliation process.