Clover House — Prince Edward County
Booking Analytics
Upload your transaction data to generate
revenue analysis and tax reporting.
Airbnb Transactions
Required
Airbnb.com → Earnings → Transactions → Export CSV
No file selected
Direct Bookings
Optional
Cash or direct bookings outside Airbnb
No file selected
CSV format
Start date, Nights, Gross earnings, Cleaning fee, Guest
2025-07-15, 3, 1500, 250, John Smith
How to export from Airbnb
  1. Go to Airbnb.com → Menu
  2. Click Earnings → Transactions
  3. Click Export → CSV → All Time

Analysing performance data…

Revenue Overview
Period comparison & composition for selected range
Period Revenue
Current period vs prior period · Month-by-month
Revenue Mix
Room revenue vs cleaning fees · Selected period
Key Performance Indicators
Current period vs prior period · All metrics for selected range
Revenue Heat Map
Month-by-month comparison · Hover cells for details · Color = revenue band
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)
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
Revenue Segments
Where your revenue comes from · Lead time & length of stay
Occupancy Calendar
Night-by-night view · Amber = booked · Soft amber = checkout · Blue outline = orphan gap
All-Time View
Since Inception
Year-over-Year Trends
All calendar years · Monthly gross revenue · Not affected by year filter
Monthly Performance Detail
Complete breakdown with rolling 12-month variance · Click to expand
▾
MonthRevenue (L12M)Revenue (P12M) VarianceADR (L12M)ADR (P12M) RevPAN (L12M)Status
Repeat Guests
All-time guests with 2+ stays · Sorted by lifetime revenue
Tax & Reporting
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
(Room Rev + MAT + Cleaning) × 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
QuickBooks Export
Generate monthly Airbnb invoices for QuickBooks Online import · One invoice per calendar month · 4 line items each
Export Options
Select date range — empty months are skipped automatically
From
To
Line items per invoice: Nightly Room Fees (HST ON)  ·  Cleaning Fees (HST ON)  ·  MAT Taxes Collected (HST ON)  ·  Airbnb Service Fees (Out of Scope)
MAT rate: 4% of Room Revenue   Service fee: from CSV if present, otherwise estimated at 3% of gross
Note: Resolution adjustments are not captured by the CSV import and are excluded from this export.
Compliance To-Do
Annual obligations organized by quarter · check off as completed