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)
Related
- Break-even Occupancy Calculator
- Dynamic Pricing Calculator
- Cleaning Fee Optimizer
- Year-2 Operator Bundle
- Referral + Repeat Guest CRM
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.