Export AppFolio owner statements to QuickBooks without retyping

Why doesn’t the statement drop straight into QuickBooks?

It comes from your manager’s books. Their accounts, property names and fee lines don’t match your chart of accounts.
The distribution is a net number. It is rent minus fees, repairs and any reserve held back.
Your tax return needs the gross figures. Schedule E asks for rents received (line 3) and each expense on its own line (lines 5 to 19).
Some lines need splitting. A mortgage payment the manager makes for you is part interest (line 12) and part principal.

How do you set up QuickBooks Online once?

1. Add an account for the money your manager holds. Go to All apps > Accounting > Chart of accounts and select New account. Name it (for example “Held by property manager”), choose an asset Account type and a Detail type, enter the latest statement’s ending cash balance as the Opening Balance with that statement’s date in As of, and select Save.

2. Match your income and expense accounts to Schedule E. One account per line keeps tax time simple. Ask your CPA to confirm the mapping.

Line on the statement	QuickBooks account	Schedule E line
Rent, late fees, other tenant charges	Rents received	3
Management fee	Management fees	11
Repairs, plumber, handyman	Repairs	14
Cleaning, landscaping, turnover	Cleaning and maintenance	7
Water, trash, electric	Utilities	17
Leasing fee, listing ads	Commissions, Advertising	8, 5

3. Track each property with a class. On QuickBooks Online Plus or Advanced, go to Settings > Account and settings > Advanced > Categories, turn on Track classes, and under Assigned classes choose One to each row in transaction. Select Save, then add one class per property. If months are already posted without classes, see how to add a class to past transactions.

How do you turn one month’s statement into an entry?

Export the month. Sign in at www.appfolio.com/login-owner and open the Reports tab. Select the report in the left column, pick the property and date range on the Customize screen, select Update, then use Actions to export to Excel or CSV.
Keep the PDF. On the Statements tab, select Download Packet and save it with the month’s records.
Label every line. In Excel, add a column with the QuickBooks account for each line and a column with the property’s class.
Build the entry. Income goes in Credits, expenses in Debits, and the difference goes to the held-by-manager account.

Example, one property for one month:

Account	Debits	Credits
Rents received (rent 2,400 and late fee 50)		2,450
Management fees	196
Repairs	310
Utilities	64
Held by property manager	1,880
Total	2,450	2,450

Lay out the import file. Intuit lists Journal No., Journal Date, Account Name, Journal/Description, Debits and Credits. Put each line on its own row with the entry’s number on every row, and save as CSV. The free journal entry import checker flags entries that don’t balance and account names missing from your chart of accounts.
Prepare QuickBooks. Intuit says to turn off account numbers before the import, add any new accounts first, and write sub-accounts as Parent:Sub-account. If Warn if duplicate journal number is used is on, entries that reuse a number won’t upload, so use new numbers.
Import. Select Settings, then Import Data, then Journal Entries. Select Browse, choose the CSV, select Next, map each column, select Next, then Start import and Done.
Record the distribution. When the deposit appears in All apps > Accounting > Bank transactions, expand it, choose the held-by-manager account in Category, and select Post.

For a single property, skip the file: select + Create, then Journal entry, and type the same lines.

If your manager uses Buildium, the same method works. Buildium says owners can view and download the reports their manager shares, including profit and loss statements and property-specific transactions.

How do you check it worked?

The held-by-manager balance ties. On the Balance Sheet as of the statement date, it equals the cash the statement says the manager holds. In the example, it rises by 380 if the distribution was 1,500.
Each property’s profit matches its statement. Go to Reports > Standard reports, then Business overview, and run Profit and Loss by Class for the month.
The year’s rent matches the 1099. The IRS says a property manager “must use Form 1099-MISC to report the rent paid over to the property owner.” Payee statements are due by January 31, which falls on a Sunday in 2027, so the IRS next-business-day rule moves your 2026 form to Monday, February 1, 2027. If the numbers differ, ask your manager how they built the form.

What usually goes wrong?

The distribution gets counted twice. Categorized as rental income in the bank feed, it inflates income by the whole payout.
Security deposits end up as income. If the statement shows tenant deposits the manager holds, ask your CPA how to record them.
Corrections arrive a month late. When the manager reverses a charge on the next statement, post the reversal in the month it appears and leave last month as posted.
A login gets handed to a stranger. In a BiggerPockets thread on this problem, a property manager flagged a tool offered there as phishing: “they ask your credentials on the first page.” AppFolio’s Owner Portal periodically asks for a security code by text or phone call, and that code should stay with you.

What can you hand off, and what stays with you?

Hand off to an AI worker	Keep with you or your CPA
Downloading each month’s reports and packets	Which QuickBooks account each kind of line belongs to
Labeling every line with an account and a property	Mortgage interest and principal splits
Building and importing the balanced entries	How security deposits are recorded
Matching each distribution to the held-by-manager account	Questions to the manager about a charge
A monthly note when a balance doesn’t tie	Signing off before taxes are filed

Check the work each month by tying the held-by-manager balance to the statement, and each year by tying the rent to the 1099.

What are your options?

Option	Good for	Watch for
Do it yourself with the export and the import file	One manager and a few properties	Hours each month, and a spreadsheet only you understand
Ask the manager for a custom export	Managers who already run custom reports for owners	It still has to be mapped to your accounts
Hire a bookkeeper	Owners who want the whole set of books kept	Who checks the mapping, and how fast statements get posted
Bring in an outside team (AI workers)	Several managers, many properties, or a backlog of months	Read access to the portal and QuickBooks, and your CPA’s mapping in writing

FAQ

Can AppFolio export straight into my QuickBooks? The Owner Portal exports reports to Excel or CSV. QuickBooks Online imports journal entries from CSV, so the mapping happens in the file between them.

How should I record the net distribution? As money moving from your manager to your bank. Gross rent and each expense come from the journal entry.

Do I need class tracking? Only if you want profit by property. It needs QuickBooks Online Plus or Advanced.

Why does my import fail with “Line Account Invalid”? Intuit says it happens when only the sub-account name is entered. Write the parent and sub-account with a colon.

What if I own the properties through more than one LLC? AppFolio says portal access is based on your email address, and you scroll down the Statements page to see separate packets for each entity. Keep each LLC in its own QuickBooks company if your CPA keeps separate books for each.