Co-Host Commission Calculator Spreadsheet — Airbnb Property Manager Split + 1099 NEC Tool — Excel

Co-host commission math. Per-booking + per-month + year-end 1099-NEC. Commission/split calculator for Airbnb / VRBO co-hosts and property managers handling someone else's STR. % of revenue, flat per booking, or hybrid models all supported. Excel + Google Sheets.

You manage your friend's cabin for a 20% revenue share. By month 6 you
realize: the 20% works out to fine pay on busy months, terrible pay on
slow months, and you can't remember if the September distribution
already went out or not. Year-end rolls around and you scramble to
reconstruct what got paid for the 1099-NEC.

This workbook handles all of it. Per-property commission model
(% of revenue, flat per booking, hybrid). Per-month commission owed.
Owner payment tracker. Year-end 1099-NEC summary auto-feeding TAX-003.

═══════════════════════════════════════════
WHAT'S INCLUDED
═══════════════════════════════════════════

📋 Per-Property Commission Agreement
· % of revenue (15-25% typical)
· Flat per booking (e.g., $50/booking)
· Hybrid (e.g., $50 + 10%)

📋 Booking Log → Commission Calc auto-applies the model
📋 Per-Owner Payment Schedule — what's owed to whom
📋 Year-End 1099-NEC Summary
· Recipient name + EIN/SSN + address (W-9 required)
· Total paid in calendar year
· Missing-W-9 flag (chase before December 15)
📋 Two-Direction Support
· You manage someone's property → owner gets 1099 (you paid them)
· Someone manages your property → you get 1099 (they paid you)

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

· Co-hosts managing 1-10 properties for other owners
· Property owners using a co-host
· Family arrangements (you co-host your in-laws' cabin)
· Anyone whose tax preparer asked "where are last year's 1099-NEC totals?"

═══════════════════════════════════════════
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. Verify worker-classification rules (W-2 vs 1099-NEC) for your jurisdiction.