Upload Your Booking Data
Combine Airbnb + direct bookings for complete analysis
📊
Airbnb Transactions (Required)
Export from Airbnb.com → Earnings → Transactions
✓ File selected
💵
Cash Bookings (Optional)
Direct bookings not in Airbnb
✓ File selected
Required CSV format →
Start date, Nights, Gross earnings, Cleaning fee, Guest
2025-07-15, 3, 1500, 250, John Smith
📋 How to export Airbnb CSV:
  1. Go to Airbnb.com → Menu
  2. Click Earnings → Transactions
  3. Click Export → CSV → All Time

Analysing performance data…

📈Since Inception
💡 What Am I Looking At? (Click to expand)
📅 Time Periods
L12M = Last 12 complete months
P12M = Previous 12 months (for comparison)
🎨 Colors
● Green = Good performance
● Red = Needs attention
● Orange = Mixed results
📊 Key Metrics
ADR = Average Daily Rate (nightly price)
Occupancy = % of nights booked
RevPAN = Earnings per day you own it
Key Performance Indicators
Last 12 months performance metrics
Revenue Performance
Rolling 12-month comparison with trend analysis
Monthly Revenue: Last 12 Months vs Previous 12 Months
Rolling 12-month comparison · Month-by-month
Seasonal Performance
Revenue by season · L12M vs P12M
Pricing Effectiveness
Understanding your pricing power and opportunities
Occupancy vs ADR Trade-off
Hover for month · Size = revenue · Quadrants = performance zones
ADR & Occupancy Trend
Dual-axis view · ADR (bars) + Occupancy (line)
Revenue Heat Map
Month-by-month comparison · Hover cells for details · Color = revenue band
Revenue Segments
Where your revenue comes from · Lead time & length of stay
Booking Patterns
Timing and behaviour insights
Check-in Day Distribution
ADR by day of week
Booking Lead Time
Days booked in advance
Length of Stay
Revenue by duration
Optimization Recommendations
Data-driven actions to improve performance
Monthly Performance Detail
Complete breakdown with rolling 12-month variance
MonthRevenue (L12M)Revenue (P12M) VarianceADR (L12M)ADR (P12M) RevPAN (L12M)Status
🏛️ MAT & HST Tax Summary
Quarterly breakdown for MAT remittance filing (Prince Edward County By-Law #53-2020) · HST = Gross Revenue × 13% · MAT = Room Revenue × 4%
Room Revenue (Box A)
Gross Earnings − Cleaning Fee
Taxable accommodation base
→
MAT Payable (Box D)
Room Revenue × 4%
Filed quarterly to PEC
+
HST Collected
Gross Earnings × 13%
Remitted by Airbnb (2025+)
=
Total Tax on Booking
MAT + HST
= Pass Through Tot amount
Quarterly MAT Remittance Filing Data
Use these figures to complete Section 3 of the Prince Edward County MAT form · Click "Copy" on any row to copy Box values to clipboard
Quarter Period Box A
Room Revenue		 Box B
Exempt Rev		 Box C
A − B		 Box D
MAT (C×4%)		 Box E
Adjustments		 Total MAT
D ± E		 Nights
Sold		 HST Collected
by Airbnb		 Copy
ℹ️ Note: These tables show only Airbnb platform bookings. HST collection via Airbnb Pass Through began in 2025. Direct/cash bookings have separate tax reporting requirements and are excluded from this MAT remittance data.
Annual HST Summary (Airbnb Only)
HST collected by Airbnb on your behalf via Pass Through Tot rows
YearBookingsGross Revenue Room RevenueCleaning Fees MAT (4%)HST Collected (13%)Total Tax