How to Use the Free OTA Booking Tracker
Manage your bookings from Airbnb, Booking.com, Viator, and GetYourGuide — in one place.
If you're manually copying booking info into notebooks, inboxes, or random spreadsheets… this free tracker will make your life easier.
✅ What It Does
This free Google Sheet template helps you:
- ✓Track bookings from multiple OTAs
- ✓Calculate total revenue, commission, and payout status
- ✓Spot trends and payout delays with a dashboard
It's built for:
- → Tour operators
- → Vacation rental hosts
- → Small team agencies managing OTA channels
🧠 How It Works
- 1Open the Booking_Tracker tab
- 2Add info: platform, guest name, check-in/out, payout status, etc.
- 3Commission and net revenue are auto-calculated
- 4View totals and performance in the Dashboard tab
📦 What's Inside the Sheet
| Column | Example |
|---|---|
| Platform | Airbnb, Viator, BDC, GYG |
| Guest Name | John Smith |
| Check-in / Check-out | 2025-06-18 to 2025-06-21 |
| Booking Total (€) | 500 |
| Commission (%) | 15 |
| Net Revenue (€) | Auto-calculated |
| Notes | "Late check-in" |
📉 Dashboard Metrics (Auto-Calculated)
Total bookings
Total revenue
Total commission paid
Net revenue
Average commission %
🎁 Download the Free Tracker
📍 No sign-up required.
⚙️ Want to Automate It?
This template is useful — but it's still manual.
🧠 If you want to auto-fill this sheet by just forwarding OTA emails from Airbnb, Viator, Booking.com, or GetYourGuide…
Need help setting it up?
Contact us or use the live chat. We're here to make your OTA workflow easier.