Go Beyond Wiki

2026-05-15-board-pack-budget-analysis

3 min read

Session: Board Pack & Budget Revenue Analysis

Date: 2026-05-15
Machine: DAMIEN
Duration: ~3 hours
Participants: Damien

What We Did

Full Cowork session building out the FY2026 Board Pack revenue comparison (Budget vs Actuals) and laying the groundwork for a structured revenue budget table.

Files Worked On

  • State of Play (March 2026).xlsx — added a Revenue tab with Budget vs Actuals comparison
  • Revenue_Budget_Table.xlsx — new standalone file: 31 agent×businesstype×country combos × 12 months × 2025+2026, 2025 actuals populated
  • GB_Board_Pack_Mar2026.pptx — opened for reference
  • 2026 Budget.xlsx — source for budget figures
  • All files saved to C:\Users\DamienGoBeyond\Claude\workspace\

Key Findings

Revenue data architecture:

  • External agent revenue lives in GB Indochina (HK entity) in Joiin/Xero
  • Kilroy International A/S is the Xero contact for ALL Kilroy + Jysk programmes
  • Jysk programmes are invoiced through Kilroy International A/S — they are not a separate contact in Xero
  • Thailand/Laos/Cambodia are separate invoices under the same “Kilroy (Thailand)” contact, distinguishable by invoice reference suffix: TH, LA, KH
  • National/local revenue sits in “Tour Revenue (Thailand National)” and “Tour Revenue (Vietnam National)” GL accounts in GB Thailand and GB Vietnam respectively

Budget data architecture:

  • Best 2025 actuals source: Rev26 sheet, columns U2:AH35 (agent × country × 12 months)
  • This range does NOT split B2B FIT vs B2B Groups — combined per agent/country
  • Rev25Detail sheet has the FIT/Groups split but is 2026 budget projections, not 2025 actuals
  • 2026 budget figures: still TBD — user was about to identify the correct sheet before battery ran out

Budget vs Actuals Q1 2026 highlights:

  • Kilroy Thailand: +$80K (+7%) vs combined budget — broadly on track
  • Kilroy Vietnam: +$78K (+7%) — slightly ahead
  • Kilroy Cambodia: +$10K (+10%) — on track once invoice split applied
  • Kilroy Laos: +$35K (+181%) — well ahead
  • Kilroy Sri Lanka: +$50K (+58%) — strong outperformance
  • Kilroy China: +$23K (+31%) — ahead
  • Kilroy Nepal: +$1.8K (+2%) — on budget
  • Kilroy India: -$1.9K (-4%) — essentially flat
  • World Insight: +$78K (+21%) — ahead of budget (WAS in budget, Rev25Detail row 38)
  • Explore Worldwide: +$91K (+138%) — large positive surprise
  • Travel Center (Thailand): +$33K (+141%) — well ahead
  • Travel Center (Vietnam): +$16K — well ahead (budget was minimal)

Agents in revenue system: Kilroy (incl. Jysk), World Insight, Explore Worldwide, Riksja Travel, Wilderness Travel, Travel Center (Thailand), Travel Center (Vietnam), Miscellaneous (~$75K 2025)

What Was Left Incomplete

  1. 2026 budget figures not yet populated in Revenue_Budget_Table.xlsx — user was identifying correct sheet in budget file when battery ran low
  2. Jysk/Kilroy Groups split for 2025 actuals — Rev26 U:AH range combines FIT+Groups; Groups rows are blank
  3. Revenue tab in State of Play uses Rev25Detail (2026 budget projection data) for budget column — may need replacing with correct 2026 budget once identified

Graph View

Backlinks