Trips program
Expedia report
Dashboard
Distribution
Analytics
Settings
Trip list
✎ Unsaved changes.
📄 Import from PDF — Gemini AI extracts trip details. Select one or multiple PDFs.
📂 Click to upload program PDF(s)
Multiple files supported — each trip shown for confirmation
Trips saved with year tags (e.g. ONAP01-2026). Expires 12 months after end date. City-name matching only. OSTALO never auto-assigned. 8-digit SM number required.
| Code | Year | Trip name | Start | End | Expires | Destinations | SM number |
|---|
No trips yet.
Upload Expedia Travel Agency Report
📂
Click to upload Expedia report
Standard Travel Agency Report (.xlsx)
Preview (first 8 purchases)
| Itinerary | Status | Start | End | City | Country | Hotel | Earnings |
|---|
Commission by trip
| Code | Year | Trip name | Destinations | Dates | Bookings | Net earnings | Share |
|---|
Active transactions
Clean
Partially cancelled
| Itinerary | Traveller | Start | End | City | Country | Hotel | Net | Trip | Status |
|---|
⚠ Unmatched transactions
| Itinerary | Traveller | Start | End | City | Country | Hotel | Net |
|---|
🚫 Cancelled reservations
| Itinerary | Traveller | Start | End | City | Country | Hotel | Booked | Cancelled | Net | Trip |
|---|
Run the distribution first — upload an Expedia report and click Run distribution.
🗃 Pre-fill from saved program
Pull a saved trip — SM pre-fills automatically.
Select trip
SM number
8 digits required
Step 1 — Stroškovno mesto for matched trips
Pre-filled where available. Exactly 8 digits required.
Step 2 — Resolve unmatched bookings
Link to existing trip, create a new project, or assign straight to OSTALO. Drag a trip from the panel on the right onto a booking to link it. Resolved bookings collapse automatically.
📋 Trips in this period
Drag a trip onto a booking to link it. Includes trips spanning a month boundary.
Ready to confirm distribution?
Locks all assignments. Export buttons appear on the Dashboard.
✓ Distribution confirmed
Use Edit distribution on the Dashboard to make corrections.
📊 Agency-wide totals by month
Commission grouped by travel month (when bookings actually took place). Trips spanning two months split per booking.
| Month | Net earnings | Bookings | vs. previous year |
|---|
🏆 Top trips by commission
| Trip | Net earnings |
|---|
🌎 Top countries by commission
| Country | Net earnings |
|---|
🏠 Top cities by commission
| City | Country | Net earnings | Bookings |
|---|
🚫 Cancellation rate by month
Percentage of bookings cancelled (zero net) vs. active, per travel month.
| Month | Active bookings | Cancellations | Cancellation rate |
|---|
📅 Trips spanning two months
Total commission plus the per-month split for trips whose bookings fall across a month boundary.
📋 Report summaries
One row per confirmed Expedia report: our total commission, plus how much on that same report belonged to other agents (not ours to distribute).
| Period | Our earnings | Our bookings | Other agents' earnings |
|---|
🕐 Trip earnings history
Cumulative commission per trip. Recorded on each confirmed distribution.
💾 Database backup
Export all trips, earnings history, and report records to a file you can move to another computer. Import restores from a backup file.
↑ Import database file
👤 User management
Manage who can access this tool and what they can do. Only administrators can see this section.
📋 Activity log
| Time | User | Action | Details |
|---|
🔒 Account
Change your PIN or sign out.