Airbnb Rental Tracker Plantilla Essentials
Track short-term rental bookings, income, and expenses. Monitor occupancy rates and net income per property.
Qué incluye
- 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
- Registra hasta 5 propiedades de alquiler con precio de compra, hipoteca, seguro, servicios y detalles del impuesto predial
- Registra hasta 100 reservas con fechas de entrada/salida, nombre del huésped, asignación de propiedad (desplegable), tarifa por noche, tarifa de limpieza, comisiones de Airbnb y gastos
- Panel con 6 tarjetas de KPI: ingreso neto total, total de reservas, total de noches, ingreso bruto, cantidad de propiedades y promedio neto por noche
- P&L Mensual mostrando ingreso neto por propiedad en 12 meses con totales anuales y promedios mensuales
- Análisis de ocupación rastreando noches reservadas por propiedad por mes con cálculos de tasa de ocupación (noches divididas entre 30)
Vista previa
Mira qué contiene esta plantilla
Cómo usar esta plantilla de 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.
Creadas por Claude AI. Perfeccionadas por nosotros.
Usamos Claude AI para crear el borrador de cada plantilla, después de una investigación profunda. Luego nuestro equipo interviene. Refinamos el diseño, probamos cada fórmula a fondo, corregimos casos especiales y pulimos el diseño hasta que se siente como algo que realmente usaríamos nosotros mismos. La IA nos lleva al 80%. El último 20% es criterio humano.
Preguntas frecuentes
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.
¿Cómo abro esto en Google Sheets?
Sube el archivo .xlsx a Google Drive y luego ábrelo con Google Sheets. Todas las fórmulas y el formato se conservarán.
Más plantillas Essentials de Business Finance
¿Buscas plantillas premium?
Nuestras plantillas de pago incluyen paneles avanzados con múltiples hojas, gráficos nativos de Excel y actualizaciones continuas.