Monthly Gross Revenue
Grand Total Revenue vs Gross Revenue
Gross Revenue — Monthly
Avg Revenue per Air Segment
Cumulative Commissions Received (Jan–Dec) by Year
Commission Rate History
Monthly Deductions (click bar for breakdown)
Clawbacks Over Time
Marketing Fund — Annual Summary
Marketing Fund — Cumulative Balance
Clawback Breakdown by Entity
Entity Clawback Summary — Selected Period
Air Segments & MIDT Market Share
Segment Tier Tracker
Monthly cumulative segments vs tier targets · Based on linear monthly pacing
Annual Summary
Annual Gross Revenue
Annual Clawbacks & Deductions
Gross Revenue by Month — Year over Year
Air Segments by Month — Year over Year
MIDT Segment Analysis
MIDT (Marketing Information Data Tapes) — Kanha segments vs total market. Share = Kanha / Total. Data from 2026 onwards auto-populated from Agents → Productivity MIDT uploads.
MIDT Share % — Monthly Trend
MIDT Segments — Kanha vs Total Market
Upload Commission Statement
Upload a Travelport commission Excel file (.xls/.xlsx). The system will extract the latest month's data automatically.
📄
Drop commission file here
or click to browse — .xls / .xlsx
Data Upload — Raw MIDT & Mapping
Upload daily segment files and manage the PCC mapping table · All data stored centrally for automated reporting
Daily Segment File
📂 Drop daily MIDT Excel here or browse
Raw segment file from Travelport · Both sheets auto-parsed
PCC Mapping File
📋 Drop mapping Excel here or browse
PCC → Group Name, Region, KAM reference table
Export
🔧 Date Correction Tool
Purge incorrect data for specific dates, then re-upload corrected files
Agent Productivity — Market Analysis
Group-level productivity with GDS share of wallet · Filterable by period, region, KAM, segmentation
Regional Summary
Segment breakdown by region with GDS share of wallet
Airline Report
Segment breakdown by airline across all GDS platforms
Incentives Calculation
Upload monthly files · Auto-calculates gross incentives, GTID, product charges & net payable per PCC
1. TSO File (.txt)
Drop TSO .txt file
2. GTID File (.xlsx)
Drop GTID Excel
3. Products File (AE/BBP/ETRK)
Drop Products Excel
4. DPRS File
Drop DPRS Excel
5. IP File (Itinerary Plus)
Drop IP Excel
6. TMA File
Drop TMA Excel
7. Galileo Terminal File
Drop Galileo Terminal Excel
E-Travel Annual Charges (auto-applied monthly)
63XM VERA INTERNATIONAL $125.00/mo
77E3 EMSLIES TRAVEL $183.33/mo
Technical Fund Tracker
Live balance tracking · Product charge deductions · Manual credits & adjustments · Full audit trail
$
Transaction History
Contract Expiry Tracker
All agents sorted by nearest contract expiry · Data sourced from Document Vault → Agent Contracts
Individual Agent Summary
GAL agent deep-dive · Production history, GDS breakdown, monthly trends
Operator Agreements
Archived Agreements
30 Nov 2015 → 31 Jul 2022
Expired
No file uploaded
Current Active Agreement
Operator Agreement 2022
Active
Effective Date
01 Aug 2022
Initial Term Ends
31 Dec 2027
Renewal
Auto 1-yr
Minimum MIDT Share Requirements
Y1 61.0%
Y2 63.3%
Y3 64.0%
Y4 64.5%
Y5 65.0%
Extracted Tier Schedule — Base Distribution Fee (Air Segments)
This data feeds Revenue → Tier Tracker
Enhanced Distribution Fee (Bonus for MIDT Growth)
Agent Contracts
Quick reference — contract expiry & commission structures
No agents added yet
Click "Add Agent" to get started
Supplier Contracts
Service providers & vendor agreements by entity
TRA — Tanzania Revenue Authority
Notices, letters, assessments & correspondence
Drop files here or click to upload
PDF, Word, Excel, images, emails
Audited Accounts
Company Documents
NDF Commission Statements
Auto-filed from Revenue → Upload · Original Excel files for each commission period
No NDF files uploaded yet. Upload a commission statement in Revenue → Upload and it will appear here automatically.
MIDT Market Reports
Auto-filed from Agents → Productivity · Monthly MIDT Excel files from Travelport
No MIDT files uploaded yet. Upload a MIDT file in Agents → Productivity and it will appear here automatically.