Saved data available
Clover House — Prince Edward County
Booking Analytics
Upload your transaction data to generate
revenue analysis and tax reporting.
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
- Go to Airbnb.com → Menu
- Click Earnings → Transactions
- Click Export → CSV → All Time
Analysing performance data…
Covering all years on record — the period selector does not apply here.
Today
Where the period stands, and what needs you next.
Period summary
Performance
How the selected period earned, and how it compares.
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
Year Comparison
Revenue Heat Map
Month-by-month comparison · Hover cells for details · Color = revenue band
Show the monthly numbers
| Month | Revenue (L12M) | Revenue (P12M) | Variance | ADR (L12M) | ADR (P12M) | RevPAN (L12M) | Status |
|---|
All-time — since inception, highlights, year-over-year, repeat guests
Since Inception
All-time highlights
Year-over-Year Trends
All calendar years · Monthly gross revenue · Not affected by year filter
Repeat Guests
All-time guests with 2+ stays · Sorted by lifetime revenue
Tax & Filing
What you owe, what you file, and what the data can account for.
MAT & HST Tax Summary
Quarterly breakdown for MAT remittance filing (Prince Edward County By-Law #53-2020) · HST = (Room Revenue + MAT + Cleaning) × 13% · MAT = Room Revenue × 4%
How these are calculated
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. Resolution adjustments (refunds, damage claims) are excluded from all revenue and tax figures on this dashboard — they appear only as a separate line item in the QuickBooks export below.
Annual HST Summary (Airbnb Only)
HST collected by Airbnb on your behalf via Pass Through Tot rows
| Year | Bookings | Gross Revenue | Room Revenue | Cleaning Fees | MAT (4%) | HST Collected (13%) | Total Tax |
|---|
Direct Bookings Summary
Excluded from MAT remittance — separate tax reporting required
| Year | Bookings | Nights | Gross Revenue | Room Revenue | Cleaning Fees | MAT Due (4%) | HST Due (13%) | Avg Nightly Rate |
|---|
These bookings are excluded from the MAT remittance table above. The MAT Due and HST Due columns show what you're responsible for collecting and remitting yourself for direct bookings.
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
Preview the invoices
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 from the CSV are included here as a separate Exempt line item on the month's invoice (they are excluded from the dashboard revenue and tax tables above).
MAT rate: 4% of Room Revenue Service fee: from CSV if present, otherwise estimated at 3% of gross
Note: Resolution adjustments from the CSV are included here as a separate Exempt line item on the month's invoice (they are excluded from the dashboard revenue and tax tables above).
Compliance To-Do
Annual obligations organized by quarter · check off as completed · general guidance — confirm entity-specific dates with your accountant
Insights
Pricing power, demand patterns, and the gaps worth filling.
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 Mix
Where revenue comes from — lead time & length of stay segments · Check-in day pattern
Revenue Segments
Lead time & length of stay · % of period revenue
Check-in Day Distribution
Arrivals by day of week — when guests start a stay
Weekday Demand
Occupancy by night of the week across the period — which nights go unsold, and how that shifts with the season · Elapsed nights only
Occupancy Calendar
Recent months shown, expandable to the full window · Filled = booked · Outlined = 1-2 night gap that went unsold · Dashed outline = upcoming gap, still fillable