Multi-Entity Consolidated P&L Spreadsheet for STR Investors — Multi-LLC Holding Company Reporting — Excel

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

═══════════════════════════════════════════
WHO THIS IS FOR
═══════════════════════════════════════════

· STR investors holding 3+ properties in separate LLCs
· Sarah/Pam-tier hosts with multi-entity asset-protection structure
· Operators who file Form 1065 for partnership LLCs
· Multi-member LLC owners needing consolidated reporting

═══════════════════════════════════════════
HOW IT DIFFERS FROM TAX-011
═══════════════════════════════════════════

· **TAX-011 Multi-Property Master P&L:** multiple properties, single entity (sole prop or single LLC)
· **FIN-006 (this workbook):** multiple LLCs, possibly different members per LLC, with intercompany handling

If you don't know which one you need: ask your CPA whether you file one Schedule E or multiple. One = TAX-011. Multiple = FIN-006.

═══════════════════════════════════════════
FILE COMPATIBILITY
═══════════════════════════════════════════

✅ Excel 2016+ · ✅ Excel 365 · ✅ Google Sheets

═══════════════════════════════════════════
REFUNDS
═══════════════════════════════════════════

14-day refund, no questions. hello [!at] thestrledger.com.

═══════════════════════════════════════════

⚠ Digital product. Not legal or tax advice. Multi-entity tax structures require CPA + attorney review.