Where Go Beyond revenue data lives
Date documented: 2026-05-15
Source: 2026-05-15-board-pack-budget-analysis
Actuals: Joiin / Xero
External Agent Revenue (main source)
- Entity: GB Indochina (HK) —
companyId: 0875a3f0-b296-11ee-b1e4-33c398921fa2 - Joiin tool:
run_sales_report— run per month (comparison mode strips customer names) - Customers: Kilroy International A/S (×8 countries), World Insight, Explore Worldwide, Riksja Travel, Wilderness Travel, Travel Center (Vietnam), plus small direct/website entries
National/Local Revenue
- Thailand: GL account
Tour Revenue (Thailand National)in GB Thailand —joiinAccountId: Revenue|Revenue||Tour Revenue (Thailand National) - Vietnam: GL account
Tour Revenue (Vietnam National)in GB Vietnam —joiinAccountId: Revenue|Revenue||Tour Revenue (Vietnam National) - Tool:
journal_drill_down— returns THB/VND amounts; convert to USD using Joiin sales report totals as anchor
Intercompany (eliminated in consolidated view)
- GB Thailand bills “Go Beyond Indochina Limited” for tours — this is the intercompany leg
- GB Vietnam bills “Go Beyond Indochina” — same
- After IC elimination, consolidated revenue = GB Indochina external + National GL accounts
Budget: 2026 Budget.xlsx (Downloads, 60MB)
| Sheet | Contents | Notes |
|---|---|---|
Rev26 | 2026 budget by agent×country×month, columns H–S | Columns U2:AH35 contain 2025 actuals (agent×country, no FIT/Groups split) |
Rev25Detail | Pivot: agent×businesstype×country×month | ⚠️ Header says 2026 — may be 2026 budget projection using 2025 data, NOT pure 2025 actuals |
BoardPrepData | Revenue by country summary (2025B vs 2025A) | Useful for high-level country mix |
Revenue | New tab created 2026-05-15 — flat table: Agent×BusinessType×Country×Year×Month×Amount | Canonical going forward |
Revenue_Budget_Table.xlsx
Standalone file in C:\Users\DamienGoBeyond\Claude\workspace\.
31 combos × 12 months × 2 years. The canonical structured source for budget work.
Key Limitation: FIT vs Groups Not Split in 2025 Actuals
Rev26 U:AH range combines B2B FIT and B2B Groups per agent/country. For Jysk and Kilroy, Groups rows in Revenue_Budget_Table are blank for 2025. To get the split, would need to cross-reference individual invoices or booking system.