Airbnb Rental Tracker Modello Essentials
Track short-term rental bookings, income, and expenses. Monitor occupancy rates and net income per property.
Cosa include
- Dashboard with rental performance overview showing total bookings, gross income, occupancy rate, and net profit
- Booking log with guest name, check-in, check-out, nightly rate, cleaning fee, and total booking amount columns
- Income and expense tracking with separate entries for cleaning costs, supplies, maintenance, and platform fees
- Occupancy rate calculations based on booked nights vs. available nights across the selected time period
- Net income per booking with color-coded input cells (yellow) and auto-calculated performance metrics (blue)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with rental performance overview showing total bookings, gross income, occupancy rate, and net profit
- Booking log with guest name, check-in, check-out, nightly rate, cleaning fee, and total booking amount columns
- Income and expense tracking with separate entries for cleaning costs, supplies, maintenance, and platform fees
- Occupancy rate calculations based on booked nights vs. available nights across the selected time period
- Traccia fino a 5 rental properties with purchase price, mortgage, insurance, utilities, and property tax details
- Registra fino a 100 bookings with check-in/out dates, guest name, property assignment (menu a tendina), nightly rate, cleaning fee, Airbnb fees, and expenses
- Dashboard con 6 schede KPI: total net income, total bookings, total nights, gross income, property count, and average net per night
- Monthly P&L showing net income by property across 12 mesi with annual totals and monthly averages
- Analisi dell'occupazione che traccia le notti prenotate per proprietà per mese con calcoli del tasso di occupazione (notti divise per 30)
Anteprima
Scopri cosa contiene questo modello
Come usare questo modello Airbnb Rental Tracker
Log each booking
Enter guest name, check-in and check-out dates, nightly rate, cleaning fee, and total booking amount for each reservation.
Record expenses
Add cleaning costs, supplies, maintenance, and platform fees for each booking or as monthly totals.
Check occupancy rate
The template calculates occupancy by dividing booked nights by available nights in the period.
Review the dashboard
See total bookings, gross income, expenses, net profit, and occupancy rate on the performance dashboard.
Creati da Claude AI. Perfezionati da noi.
Utilizziamo Claude AI per creare ogni modello, dopo una ricerca approfondita. Poi interviene il nostro team. Miglioriamo il layout, testiamo ogni formula, correggiamo i casi limite e rifiniamo il design fino a ottenere qualcosa che useremmo noi stessi. L'AI ci porta all'80%. L'ultimo 20% è tutto giudizio umano.
Domande frequenti
How is occupancy rate calculated?
Occupancy rate equals booked nights divided by total available nights. The template calculates this automatically from your booking dates.
Does it track Airbnb host fees?
Yes. Enter the platform service fee per booking or as a percentage. The net income calculation accounts for this deduction.
Can I track multiple listings?
This template covers one property. Duplicate it for each listing to keep bookings and financials separate per property.
Does it include cleaning costs?
Yes. Record cleaning fees received from guests and your actual cleaning costs. The net difference flows into the profit calculation.
Come posso aprirlo in Google Sheets?
Carica il file .xlsx su Google Drive, poi aprilo con Google Sheets. Tutte le formule e la formattazione saranno conservate.
Altri modelli Essentials Business Finance
Cerchi modelli di fogli di calcolo premium?
I nostri modelli a pagamento includono dashboard multi-foglio avanzate, grafici nativi Excel e aggiornamenti continui.
Privato e sicuro
I tuoi dati finanziari restano sul tuo dispositivo. Non li vediamo mai.
Scopri di piu →