5 LLCs. 5 P&Ls. One holding-company view. Multi-entity consolidated P&L for STR investors holding each property in its own LLC. Aggregates per-LLC income statements with intercompany eliminations + member distributions. Excel + Google Sheets. You hold each property in its own LLC for liability isolation. Smart move for asset protection. Hard for portfolio reporting: 5 LLCs = 5 separate P&Ls + 5 K-1s, and your overall income picture lives in your head. This workbook aggregates per-LLC income statements into a holding-company- level consolidated P&L. Adds entity-level allocation, intercompany eliminations (one LLC’s expense = another LLC’s revenue, must net to zero), and member-distribution tracking. WHAT’S INCLUDED 📋 Entity Roster — every LLC with state, EIN, members, ownership %, properties 📋 Per-LLC P&L tabs — paste from each entity’s bookkeeping 📋 Intercompany Transactions — loans, management fees, shared expenses 📋 Member-Distribution Schedule — per-member cash distributed per period 📋 Consolidated P&L — holding-company view after eliminations 📋 Per-LLC Summary — revenue, expenses, NOI, distributions per entity 📋 Member-View P&L — per-member share across all entities owned
Related
- Multi-Owner Consolidated Reporting
- Partnership Distribution Tracker
- The P&L Tracker
- 3-Property Side-by-Side Comparison
- Cleaner CRM + Payroll
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.