How to create owner statements for property management in QuickBooks?
By the Propfina team · Last updated
QuickBooks Online has no native owner-statement report for a property-management trust account. Rebuild each owner’s packet from the owner-funds liability after the three-way rec, or run the statement in AppFolio, Rentvine or Buildium, which already keep those ledgers.
This is the month-end path for a property-management office that keeps QuickBooks Online. Pull last month’s rec, the owner-ledger export, and the owner-funds register.
What you are building
An owner statement is a named cash ledger for one owner, for one cutoff. It is not a customer invoice list.
| Piece | What it shows | Where it lives |
|---|---|---|
| Beginning owner funds | What you still held for that owner on the first day | Last month’s ending balance |
| Cash in | Rent batches, other receipts posted to that owner | Owner-funds liability, that class |
| Cash out | Vendor bills, owner draw, fee transfer | Same liability |
| Management fee | What the firm earned on that owner | The only income line |
| Ending owner funds | What you still hold after the draw | Must equal the rec |
How to do a three-way trust account reconciliation has to close first. How to reconcile a property management trust account in QuickBooks Online is the two-way rec if the trust bank sits in QuickBooks.
Run it in the property-management software first
AppFolio, Rentvine and Buildium win this job. They keep owner and tenant ledgers in the same system as the bank rec. On their own books, the statement is a report, not a rebuild.
AppFolio’s owner portal (read 2026-10-08) is where owners view those statements. AppFolio (June 16, 2026) calls the monthly job a Triple Tie Out of owners, banks, and the general ledger. Rentvine (read 2026-10-08) ships a custom statement whose summary looks like a bank statement. Buildium (May 12, 2026) can schedule the statement by email or the owner portal. Growth and Premium include that automation.
If those ledgers are the books, generate the statement there after the rec. Do not retype it into QuickBooks. On r/appfolio in October 2025, an office tried to export the enhanced owner statement to key it into QuickBooks. A reply asked why they were transferring managed-property accounting into QuickBooks at all. How to export AppFolio data to QuickBooks is the summary-journal path for the CPA file, not a second owner ledger. Post the management fee into QuickBooks. Leave the owner packet in the PM software.
The QuickBooks-only rebuild
Use this only when QuickBooks is the ledger. Classes are the split. They exist on Plus and Advanced. Intuit’s usage limits (updated 2026-08-05) give Plus 40 combined classes and locations. Simple Start and Essentials have none. Advanced removes the cap. A class per door on a 50-door book blows Plus. Class per owner.
- Go to Settings, Account and settings, Advanced, Categories. Turn on Track classes. Assign One to each row in transaction so a rent batch can split across owners. Intuit’s class-tracking help (updated 2026-08-03) is this setup.
- Keep owner funds as Other Current Liabilities, the shape in Intuit’s retainer help (updated 2026-08-04). Rent in raises that liability. A plumber paid for that owner lowers it. The management fee is the only income line, after you move it to operating.
- Go to Reports, Standard reports. Open Transaction Detail by Account. Set the Report period to the rec cutoff.
- Select Customize. Filter Distribution Account to owner funds and Class to that owner. Keep Date, Memo/Description, Amount, and Balance. Intuit’s customize-reports help (updated 2026-09-15) is that pane.
- Run it. The opening Balance is beginning owner funds. Receipts raise it. Bills, the fee, and the draw lower it. The last Balance is ending owner funds.
- Save customization. Name it with the owner and the month.
- Export/Print, then Export to Excel, or print to PDF. Intuit’s export help (updated 2026-08-04) is that button. Attach the vendor invoices that hit this owner.
Example shape for one owner, not a real office. Beginning $4,200, rent $3,700, vendor bills $650, management fee $370, owner draw $2,880, ending $4,000. That ending figure has to equal the owner’s class on owner funds as of the statement date.
Intuit’s run-reports-by-class help (updated 2026-08-05) will also give you Profit and Loss by Class. Use it for the firm’s fee income by owner. Do not send it as the owner packet. Rent in a trust account is not sales.
Intuit’s community, September 30, 2024, told a property-management bookkeeper to run Statement of Cash Flows, export to Excel, and add columns, or export the Balance Sheet. Statement of Cash Flows is company cash. It is not whose money it is. Intuit’s balance-sheet-by-class help (updated 2026-09-08) says you cannot filter a balance sheet by class, because headers are not linked to classes. A class-column balance sheet puts A/R and A/P under Not specified. Do not use it as the owner ledger.
What never becomes an owner statement
| Thing | Send it to an owner? |
|---|---|
| Create Statement (Balance Forward, Open Item, or Transaction Statement) | No. That is customer AR |
| Profit and Loss by Class as the packet | No. That is the firm’s P&L |
| Statement of Cash Flows | No. That is company cash flow |
| Balance Sheet by Class | No. Intuit says it is not accurate by class |
| A class with no floor, and a negative owner | No. Hold the draw |
| Last month’s PDF with new dates typed over | No. Re-run the report |
Intuit’s customer-statement help (updated 2026-06-01) lists Balance Forward, Open Item, and Transaction Statement. All three list invoices and unpaid balances. The click path is All apps, Customer Hub, Customers & leads, Batch action, Statement. That is how you bill a customer.
When the packet still disagrees
Work rec-to-ledgers first, then ledger-to-statement.
| Symptom | Likely cause | What to do |
|---|---|---|
| Ending balance does not match last month’s statement | A backdated bill, or the wrong start date | Re-run both months to the rec cutoff |
| Rent is on the P&L, not on owner funds | Rent posted as income | Reverse it. Credit the liability |
| One owner is short, the three-way still ties | Class missing on a split, or rent applied to the wrong owner | Rebuild that class from the deposit batch |
| Plus will not add another class | 40 combined classes and locations | Class per owner, or move to Advanced |
| Create Statement is blank | No invoices on that name | Correct. Owners should not have invoices for rent |
| Bank rec is $0.00, the statement is still wrong | Two-way rec only | Sum the owner and tenant ledgers |
On r/PropertyManagement in February 2026, an office on AppFolio wrote that the canned owner statement was fine for a few owners, and that custom Excel tabs for the rest ate the close. Extra tabs are a second set of numbers.
Do not send a draw while that owner’s ending balance is negative. Cash in the trust account can still belong to other owners and tenants. Colorado’s Division of Real Estate lists negative ledger balances among common violations (audit process, read 2026-10-08). Rules vary by state. This is not legal advice. Check your own state’s commission and your CPA.
What the software already does
AppFolio, Rentvine and Buildium win native owner statements. QuickBooks Online wins the two-way rec and the CPA file.
| Job | AppFolio, Rentvine or Buildium | QuickBooks Online |
|---|---|---|
| Owner statement from the same ledgers as the rec | Yes, that is the product | No. Rebuild from owner funds |
| Blocks a negative owner before a draw | Visible on the owner balance report | No floor on a class |
| Owner portal with the PDF | Yes | No. Export and email |
| Class per owner without a 40-item cap | Not the constraint | Plus caps at 40 combined classes and locations |
| CPA-ready company file | Extra, or a summary journal | Yes, that is the product |
Someone still has to pick the cutoff, refuse a negative draw, and keep rent off income. Most small offices keep statements in the PM software and QuickBooks for payroll, operating, and the CPA.
How to tell this month is closed
The three-way rec is $0.00. No owner ledger is negative. Each packet’s ending balance equals that owner’s owner-funds class as of the statement date. Last month’s ending is this month’s beginning. Rent did not land in income. The management fee left trust and landed in operating.
If AppFolio, Rentvine or Buildium already holds the ledgers, run the owner statement there after the rec. If QuickBooks is the only ledger, pull the owner-funds register, last month’s rec, and the class list. Start with those files.
Frequently asked questions
Does QuickBooks Online have a built-in owner statement for property managers?
No. Create Statement is a customer AR statement for invoices and unpaid balances. An owner statement is a trust-ledger packet: beginning owner funds, cash in, cash out, management fee, draw, and ending balance. Rebuild it from the owner-funds liability after the three-way rec, or generate it in AppFolio, Rentvine or Buildium.
Can I send Create Statement as the owner packet?
No. Intuit's customer-statement help, updated 2026-06-01, is for reminding customers about unpaid invoices. Using it for owners means treating owners as customers and rent as invoices, which books trust money as sales. Filter Transaction Detail by Account to owner funds instead.
Should I use Profit and Loss by Class as the owner statement?
Only if you booked rent as income, which is the wrong setup for a trust account. Rent in trust raises owner-funds liability. P&L by Class then shows the management fee, not the owner's cash. The owner packet is the liability activity for that class.
Do I send owner statements before the trust rec is closed?
No. If the bank, the trust ledger, and the sum of owner and tenant ledgers disagree, the statement is someone else's money with a name on it. Close the three-way rec, hold any negative owner, then build the packet from those ledgers.