If you run your own portfolio on AppFolio and keep your financial books in QuickBooks, the two systems should tell the same story. In practice they drift apart quietly. A monthly comparison catches the drift while it is still a small fix. Here is what should match, and where it usually does not.
Why the two systems disagree
AppFolio is the operational record: leases, charges, receipts, and property-level activity. QuickBooks is the financial record: bank accounts, categories, and reports for your CPA and lender. Neither one is wrong on its own. Problems appear when an entry lives in one system but not the other, or lands in different periods.
The checks that matter every month
- Rent collected. Total receipts in AppFolio for the month should equal rental income deposited and recorded in QuickBooks, after accounting for anything that is still in transit between the two.
- Bank balance. The bank balance in AppFolio, the bank balance in QuickBooks, and the statement should agree on the same date. If two match and one does not, find out which one is off before you do anything else.
- Security deposits. Deposits held should be a liability on your books, and the total should equal what AppFolio shows as held for tenants. If deposits are landing in income, profit is overstated.
- Owner or investor distributions. Money you pay yourself or your partners is a distribution, not an expense. Confirm it is coded consistently and matches the bank.
- Repairs versus improvements. A repair is expensed. An improvement that extends the life or value of the property is capitalized. Check that large work orders in AppFolio were classified the same way in QuickBooks.
- Fees and charges. Software fees, payment processing fees, and management fees show up in AppFolio activity or on the bank statement. Make sure each one reached QuickBooks once, not twice and not zero times.
The three-way reconciliation, for trust money
Where you hold funds for others, the strongest check is a three-way reconciliation: the adjusted bank balance, the trust ledger in AppFolio, and the total of the individual balances underneath it. All three must agree. We explain the mechanics in AppFolio trust account reconciliation.
Common reasons they drift
- A deposit recorded in one system in the last days of a month and the next month in the other.
- A transfer between your own accounts entered as income and expense instead of a transfer.
- A refund or reversal entered in AppFolio but never reflected in QuickBooks.
- One entity’s transaction booked in another entity’s file when you run several LLCs.
Who should do this
If you have a handful of doors, an hour a month with both reports open is enough. With more properties, multiple entities, or a lender waiting on numbers, it is worth handing off. We do this inside your AppFolio instance every month for investors with roughly 5 to 50 doors. See AppFolio bookkeeping for real estate investors in Atlanta, or book a free discovery call.
Frequently asked questions
How often should I compare AppFolio and QuickBooks?
Every month, right after the bank statements are available, so you are comparing complete periods and can reconcile to the statement.
Which system is the source of truth?
Neither by itself. AppFolio is the operational record and QuickBooks is the financial record, and the goal is to keep them reconciled to each other and to the bank.
What is the most common mismatch?
Timing. Deposits and refunds that fall on either side of a month-end, followed by transfers between your own accounts coded as income or expense.
Reconciliation exceptions are a job an AI agent can draft for your bookkeeper to review. See how AI agents work.
Recent Comments