K-1-ready capital accounts. Per-partner allocations done right. Partnership distribution tracker for STR LLCs taxed as partnerships. Capital contributions, P&L allocation by ownership %, distributions paid, ending capital per partner. Excel + Google Sheets. You partner-up to buy a cabin. Three partners, 50/30/20 split. Year 1 ends — who gets what cash distribution? What’s each partner’s K-1 figure for tax filing? Without a system, partner relationships get tense fast: someone thinks they got short-changed, the K-1s don’t reconcile, and your tax preparer charges 3 hours to clean it up. This workbook tracks: capital contributions by partner + date, profit allocation by ownership %, distributions paid per partner per date, ending capital account. Outputs the per-partner figures needed for K-1 prep on Form 1065. WHAT’S INCLUDED 📋 Partnership Roster — partners + ownership % + capital contributions 📋 P&L Inputs — annual revenue, expenses, NOI for the partnership 📋 Distribution Schedule — every cash distribution per partner per date 📋 Capital Account Per Partner — opening + contributions + allocated profit − distributions − allocated losses = ending 📋 K-1 Summary Per Partner — ordinary income, guaranteed payments, distributions, ending capital 📋 Allocation Reconciliation — flags if profit allocations don’t sum to 100%
Related
- Multi-Entity Consolidated P&L
- Schedule C Tax Prep Workbook (Active STR)
- The P&L Tracker
- Commission / Split Calculator for Co-Hosts
- Depreciation Tracker (Full MACRS)
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.