How do I get AppFolio numbers into QuickBooks without retyping?
Short answer: AppFolio, a property management system with built-in accounting, does not list QuickBooks (small business accounting software from Intuit) on its Stack marketplace page, and an AppFolio customer story quotes a manager describing the two as having no integration. The practical route is a monthly export: run the report, turn it into a journal entry file, and load it with the Import Data tool in QuickBooks Online. If you are on AppFolio's Plus or Max plan, an API can automate that file.
You want AppFolio's numbers in QuickBooks at month end without a bookkeeper retyping them line by line.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
Most small property management companies end up with two sets of books. AppFolio holds the property side: rent, owner ledgers, vendor bills and deposits. QuickBooks holds the company side: your management fees, payroll, rent for your own office and your tax return. The two need to agree, and nobody wants to type the same numbers twice.
What AppFolio's own pages say
AppFolio's Stack marketplace lists accounting partners such as AvidXchange for paying vendor bills and ADP RUN for payroll. It does not list QuickBooks on the page. AppFolio's pricing page, as of November 2026, shows Core from $1.49 per unit per month, Plus from $3.20 and Max from $5.00, with minimums and a note to contact AppFolio for details. It does not mention QuickBooks at all. For what AppFolio connects to, see AppFolio integrations.
AppFolio's own customer story on BK Management, a student-housing company, quotes its accounting manager saying that between QuickBooks and AppFolio "there was just no integration whatsoever." The company moved its accounting into AppFolio and AppFolio's story reports it saved 3 hours per week. That is one company's result, and it shows the problem is real, not that moving is right for you.
Because of this, I would plan for a file-based handoff, and ask your AppFolio contact whether anything newer exists for your plan.
What actually needs to move
Not everything. Moving every owner transaction into QuickBooks is a common beginner mistake, because the owner money already lives in AppFolio's ledgers. Move only what your company's books need:
- Management fee income. What you earned from owners this month.
- Leasing, renewal and other fees you keep.
- Company expenses paid from the company's own bank account.
- Payroll and taxes, which usually stay in QuickBooks or a payroll service anyway.
Owner funds and security deposits are not your income. If you hold them in trust accounts (separate bank accounts for money that belongs to others), keep them out of your company income. Ask your accountant which balances should appear on your company's balance sheet, if any.
Step by step: the monthly export
- Pick a cut-off day. The last day of the month, after your bank reconciliation is done. Do not move numbers before the books are closed.
- Run the same report every time. Use a saved report that shows management fees by owner or property for the month. AppFolio's owner help page says a generated report has an Actions menu with export to Excel or CSV (a plain text spreadsheet file). Check your own Reports page for the export option on your account.
- Build the journal entry file. A journal entry is a bookkeeping record with debits and credits that balance. In a spreadsheet, make one entry for the month with a line per account. Keep the layout identical each month.
- Add new accounts first. Intuit's help article says to add any new accounts to your chart of accounts before importing.
- Import into QuickBooks Online. Intuit's steps: open Settings (the gear icon), choose Import Data, then Journal Entries, browse to your CSV file, and map each spreadsheet heading to a QuickBooks field. Fix any errors it reports, then select Start import.
- Check the result. Run a profit and loss report for the month and compare management fee income to AppFolio's total. They should match to the cent.
- Save the file and the AppFolio report together in a folder for the month, so an auditor can trace any number.
What the journal file needs
Intuit's article for QuickBooks Online lists these required columns for a journal entry import:
| Column | What goes in it |
|---|---|
| Journal No. | A number for the entry, such as 2026-10-FEES |
| Journal Date | The last day of the month |
| Account Name | Exactly as it is named in QuickBooks |
| Journal/Description | A short note, such as "October management fees from AppFolio" |
| Debits | Amount for the debit side |
| Credits | Amount for the credit side |
| Name | Required when the account is Accounts Payable or Accounts Receivable |
Intuit also says to turn off account numbers before importing and to write sub accounts as "Parent account: Sub Account." Writing only the sub account name causes a "Line Account Invalid" error. If the warning for duplicate journal numbers is on, an entry may be rejected if its number was used before, so give each month a unique number.
A worked example (made-up numbers)
A company manages 120 doors for 40 owners. For October it earned $14,400 in management fees (an average of $120 a door), $1,800 in leasing fees and $300 in late fee share. Its AppFolio fee report totals $16,500.
| Account | Debit | Credit |
|---|---|---|
| Management fees receivable (or operating bank) | $16,500 | |
| Management fee income | $14,400 | |
| Leasing fee income | $1,800 | |
| Late fee income | $300 |
Debits and credits both total $16,500, so the entry balances. Which account takes the debit depends on how your accountant set up the books. The point is the shape: one balanced entry a month, from one report, in one file layout.
When the API helps
If you are on AppFolio's Plus plan (API, read only) or Max plan (API, read and write), a developer can build a small program that reads the fee report, builds the journal file and drops it in a folder for your bookkeeper. QuickBooks has its own developer tools too, so a program could also post the entry, but I would not let software write into your books without a person approving it. See how the AppFolio API works for what to ask your contact first.
On Core, where AppFolio lists no API, the file route above still works. If your account can email a saved report on a schedule, that email can feed a script or a workflow tool. My page on business process automation covers the idea, and AI bookkeeping covers the parts a bookkeeping assistant can handle, like coding and flagging odd amounts.
Common problems
- Account names do not match. One extra space or a changed name and the import rejects the line.
- The entry does not balance. Rounding or a missing line. Add a check cell in the sheet that shows debits minus credits.
- Double counting. Moving owner money into company income. Keep the two separate.
- A changed report layout. Someone edits the saved report and your file builds wrong. Lock the report and note who may change it.
- Reopened months. A late correction in AppFolio after you moved the numbers. Post an adjusting entry in the next month, not a rewrite.
Should you keep QuickBooks at all?
Many firms do, because the company's books, payroll and taxes live there and the accountant knows it. If you are thinking of dropping it, remember the BK Management story: they moved company accounting into AppFolio and saved time, but that works only if you are comfortable running company accounting inside the property system. If cost is the issue, see my notes on QuickBooks alternatives, and ask your accountant before you switch mid-year.
How I'd approach this
Do the file route by hand for three months before you automate anything. That teaches you which numbers your bookkeeper actually needs, and which reports are stable. After three clean months, build the file automatically and keep a person on the final import step.
The pattern I would avoid is a live two-way sync between a property system and your books. It looks neat and it fails quietly. One bad mapping can post wrong numbers for weeks. A monthly, reviewed handoff is slower and far safer. If you want help scoping the small program that builds your file, see what this includes below.
Questions people ask
Does AppFolio integrate with QuickBooks?
QuickBooks is not on AppFolio's Stack marketplace page, and an AppFolio customer story quotes a manager saying there was no integration between the two. Ask your AppFolio contact whether anything is available for your plan.
Can I export AppFolio data to QuickBooks?
Yes, by file. Export a report to CSV or Excel, build a journal entry file, and load it with Import Data in QuickBooks Online. Intuit lists the required columns: journal number, date, account name, description, debits and credits.
Which AppFolio plan has an API?
AppFolio's pricing page lists an API on Plus (read only) and Max (read and write). Core does not list one. See the AppFolio API explained.
Should I keep QuickBooks if I use AppFolio?
Many firms do, for the company's own books, payroll and taxes. Ask your accountant which records belong where. If you want to compare options, see QuickBooks alternatives.
How often should I move data to QuickBooks?
Once a month, at close, is the usual choice. Pick a cut-off day, run the same saved report and load a single balanced entry. Weekly moves add work without adding much clarity.
Can AI do this for me?
AI can help code transactions and flag odd amounts, but a person should approve what goes into your books. See AI bookkeeping for what is practical today.
More in this topic: US property management: APIs and integrations (11 guides) →