30+ day stays. MTR pipeline, monthly recurring revenue, occupancy gaps. Mid-term rental (MTR) tracker for hosts on Furnished Finder, Blueground, AnyPlace, or directly with corporate clients / travel nurses. Excel + Google Sheets. MTR is not STR. Different model: monthly rent (not nightly), longer stays (no daily turnover), recovery deposits, utility reimbursement decisions. A standard Airbnb spreadsheet doesn’t track tenant pipeline, monthly recurring revenue, or occupancy gap days between tenants. This workbook handles the MTR-specific reality. Pipeline tracking from inquiry through booked. Monthly recurring revenue calc. Occupancy-gap-day detection (target <14 days between tenants; >30 = pipeline is leaking). Source channel ROI per Furnished Finder / Blueground / direct. WHAT’S INCLUDED 📋 Property Roster (MTR-only) 📋 Channel Settings — Furnished Finder, Blueground, AnyPlace, direct 📋 Inquiry Pipeline Tab · Tenant name, source, requested dates, monthly rate quoted, deposit · Status: Inquiry → Application → Approved → Booked → Active → Departed 📋 Active Stay Tab · Move-in / move-out, monthly rent collected, utility reimbursement · Damage deposit held, issues during stay, renewal probability 📋 MRR Calc — your portfolio’s monthly recurring revenue 📋 Occupancy Gap Days — between one tenant’s departure and next’s arrival 📋 Source Channel ROI — was Furnished Finder’s $99/yr worth it? 📋 Renewal Rate Tracker — % of tenants who extend MTR vs STR ECONOMICS · STR: higher per-night ADR, higher cleaning + supplies, daily ops burden · MTR: lower effective nightly rate, near-zero ops burden during stay, occupancy-gap risk · Math typically: MTR nets 60-75% of STR gross at <30% of operational time
Related
- Referral + Repeat Guest CRM
- Rental Arbitrage Analyzer
- DSCR Tracker
- Insurance Policy Tracker
- Depreciation Tracker (Full MACRS)
- Glamping / Unique-Stay P&L
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.