Does AppFolio Integrate with QuickBooks? No, Here's the Workflow That Works
Short answer
No. AppFolio doesn't offer a native QuickBooks integration, Online or Desktop. It has full property and trust accounting built in, so most firms don't need one. When you do need QuickBooks (for the management company's own books, an owner's CPA, or during a migration), the reliable approach is a scheduled export from AppFolio, mapped into summarized QuickBooks journal entries and imported.
When you actually need AppFolio data in QuickBooks
- The management company's own books. Management fees, leasing fees, maintenance markups and other company income often live in AppFolio. Your company's P&L lives in QuickBooks.
- Owners who keep their own books, or whose CPA wants QuickBooks files at year-end.
- Consolidated reporting alongside businesses that aren't in AppFolio.
- Transitions, moving into or out of AppFolio.
If none of those apply, you likely don't need QuickBooks at all. AppFolio's own accounting produces the owner statements, trust reports and financials most management companies run on.
Your three options
1. Manual monthly export and import
Export the general ledger or the relevant reports from AppFolio to Excel, reformat them to QuickBooks' import layout, and import. It works, but it costs hours each month and depends on one person remembering every step.
2. Scheduled export plus automated mapping
AppFolio emails the report on a schedule. An automation reads it and applies your mapping table (accounts, properties, owners). It then produces summarized journal entries for QuickBooks, and flags anything it can't map instead of guessing. We're building this as a Google Sheets tool, the QuickBooks Journal Builder. Join the list below to hear when it's ready.
3. Third-party connectors and bookkeepers
Some tools and bookkeeping firms offer AppFolio-to-QuickBooks syncs. Ask how they get data out of AppFolio (exports, the API on Plus or Max, or a bot logging in), which QuickBooks version they support, and what happens when an account can't be mapped.
The export-map-import workflow
- Export the same report every month. Save a general ledger report in AppFolio filtered to the properties or entities QuickBooks needs, on the same basis (cash or accrual) as your QuickBooks file. Schedule it to email as CSV after month-end close.
- Apply the mapping table. Each AppFolio GL account maps to one QuickBooks account; each property maps to a class or location; each owner or entity maps to a QuickBooks company file.
- Summarize. Roll the detail up to one journal entry per period (and per class, if you track them), with debits equal to credits.
- Check and import. Stop if any account is unmapped or the period was already imported, then import the file into QuickBooks.
Importing journal entries into QuickBooks Online
QuickBooks Online has a built-in CSV import for journal entries. According to Intuit's help article, the file needs these columns:
| Column | What goes in it |
|---|---|
| Journal No. | A number per entry, e.g. AF-2026-09, which also helps you spot duplicates |
| Journal Date | Usually the last day of the period |
| Account Name | The QuickBooks account from your mapping. Sub-accounts need the parent name too, as Parent: Sub |
| Journal/Description | e.g. "AppFolio management fees, Sept 2026" |
| Debits / Credits | The summarized amounts; each entry must balance |
Then go to Settings → Import Data → Journal Entries, upload the CSV, map the columns and start the import. Intuit's notes worth following: add any new accounts to your chart of accounts first, turn off account numbers during the import, and turn on class or location tracking if you want to import those too.
What the mapping needs to get right
| Decision | Why it matters |
|---|---|
| GL account → QuickBooks account | Different charts of accounts; one-to-many and many-to-one mappings are common |
| Property → class or location | Keeps per-property reporting in QuickBooks |
| Owner → entity or company file | Owner books must never mix |
| Cash vs. accrual | Both systems must report on the same basis, or the numbers won't tie out |
| Summary vs. detail | Monthly summary entries are easier to reconcile than thousands of line items |
| Trust vs. operating money | Avoid counting tenant and owner funds as company income |
Ask your CPA to sign off on the mapping before automating it. Automation makes a good process faster, and a bad one faster too.
QuickBooks Desktop vs. QuickBooks Online
Both can take AppFolio data through an import, but Online is the easier target: the journal entry CSV import is built in, and it's where Intuit is putting its development. On Desktop, journal imports usually go through IIF files or a third-party import tool.
If you're wondering whether Desktop is going away: after September 30, 2024, Intuit stopped selling new Desktop Pro Plus, Premier Plus and Mac Plus subscriptions to new US customers. Existing subscribers can keep renewing, and Desktop Enterprise is still sold. Each Desktop version still reaches end of support on Intuit's schedule, so check the current dates if your firm is on an older release.
Common pitfalls
- Importing the same period twice. Every run needs a period lock or a duplicate check.
- New GL accounts in AppFolio that aren't in the mapping yet. Flag them; don't drop them.
- Mismatched basis (cash in one system, accrual in the other).
- Pushing tenant-level detail into QuickBooks and slowing it to a crawl.
- Editing the saved AppFolio report, so next month's export has different columns.
- Sub-account names without the parent, which QuickBooks Online rejects.
In development
QuickBooks Journal Builder
Turns AppFolio's scheduled GL export into summarized QuickBooks journal entries using your mapping table, and flags any account it can't map. One-time price, runs in your Google account.
We're not affiliated with AppFolio or Intuit; AppFolio and QuickBooks are trademarks of their owners. This guide is general information, not accounting advice.
Sources
Frequently asked questions
Can AppFolio export to QuickBooks?+
Not directly. You export reports such as the general ledger from AppFolio to Excel or CSV, then import them into QuickBooks, usually as journal entries. That step can be automated on a schedule.
Does AppFolio integrate with QuickBooks Online or QuickBooks Desktop?+
Neither, natively. Both can receive AppFolio data through exports and imports. QuickBooks Online has a built-in journal entry import from CSV, which makes it the easier target.
Is there property management software that integrates with QuickBooks?+
Yes. Some platforms, DoorLoop for example, advertise a built-in QuickBooks Online sync. AppFolio takes a different approach: accounting lives inside AppFolio, and QuickBooks gets exports.
Will QuickBooks Desktop be discontinued?+
Not as a product line. Intuit stopped selling new Desktop Pro Plus, Premier Plus and Mac Plus subscriptions to new US customers after September 30, 2024, but existing subscribers can renew and Enterprise is still sold. Individual Desktop versions do reach end of support on Intuit's schedule.
Should we run our property accounting in both AppFolio and QuickBooks?+
Usually not. Keep AppFolio as the system of record for property and trust accounting, and send QuickBooks only what it needs: summarized entries for the management company, or per-owner summaries.
Is there a template for AppFolio to QuickBooks?+
Every firm's chart of accounts differs, so a mapping table is the real template: AppFolio GL account → QuickBooks account, property → class or location, owner → entity. Set it up once, with your CPA's sign-off, and reuse it every month.