Bookkeeping for Real Estate Investors with Multiple LLCs
How to structure the chart of accounts, track per-property P&L, handle intercompany transfers, and produce portfolio roll-ups across multiple real estate LLCs in QuickBooks Online.
Real estate investors quickly outgrow single-entity bookkeeping. By the time you own three or four properties — each typically in its own LLC for liability protection — the question isn't whether to keep separate books, it's how to do it in a way that gives you per-property profitability and a clean portfolio roll-up without drowning in administrative work.
This is a practical playbook for investors and family offices running multiple real estate LLCs in QuickBooks Online: how to structure the chart of accounts, track per-property P&L, handle intercompany activity, and produce the roll-up that actually answers "how is the portfolio doing?"
One QBO file per LLC
The cleanest setup is one QuickBooks Online file per LLC, with a standardized chart of accounts mirrored across every file. This keeps each entity's books defensible at the legal level, makes lender packages straightforward, and supports clean year-end CPA work.
The alternative — running multiple LLCs as classes inside a single QBO file — is cheaper but creates serious legal, lending, and audit-trail problems as the portfolio grows. We do not recommend it above two properties.
Chart of accounts: standardize across entities
Build one master chart of accounts and replicate it across every property LLC. At minimum: rental income (broken out by unit if multi-unit), other income (laundry, parking, application fees), repairs and maintenance, property management, utilities, insurance, property taxes, mortgage interest, depreciation, and capital improvements.
Standardized accounts make portfolio roll-ups straightforward and let you benchmark properties against each other without translation.
Intercompany activity, handled symmetrically
Owner contributions, distributions, and intercompany loans should be booked symmetrically across entities — every debit in one file has a matching credit in another. Use clearly named accounts ("Due to LLC A" / "Due from LLC A") and reconcile them monthly. Year-end cleanup of unreconciled intercompany activity is one of the most expensive things a CPA can do for you.
Portfolio roll-up: the report that matters
Every month, the deliverable that matters is the portfolio roll-up: a consolidated P&L and balance sheet across all properties with per-property columns and a total column. Built correctly, it answers in one page: which properties are profitable, which are dragging, how much cash the portfolio is generating, and how much is in operating versus reserve accounts.
Key Takeaways
- Run one QBO file per LLC; replicate a standardized chart of accounts across every file
- Book intercompany loans, contributions, and distributions symmetrically and reconcile monthly
- The monthly deliverable that matters is a portfolio roll-up with per-property columns
- Don't run multiple LLCs as classes inside a single QBO file above two properties — the legal and lending risk isn't worth the savings
Related Insights
AI Won't Replace Your Bookkeeper — It Frees Them for the Work That Pays
AI is automating data entry and categorization fast — but it isn't replacing your bookkeeper. It's clearing the busywork so they can finally do the advisory work that actually moves your business forward.
ArticleFrom Spreadsheets to Immutable Records: A CFO's Guide to Migrating Legacy Bookkeeping Systems
A practical, non-technical playbook for finance leaders moving from spreadsheets and legacy software to blockchain-backed, immutable ledgers — covering the business case, migration phases, controls, and team readiness.
ArticleThe Q2 Financial Checkup Every Business Owner Needs
Spring is the perfect time to audit your financial operations. A practical checklist covering cash reserves, tax estimates, vendor terms, and mid-year forecast adjustments before summer hits.