Event Commission Report

Event Commission Report Overview

Parent Hub: 🀝 Sales, Groups & Events Reports

Category: πŸ₯‚ Event Management (EventKey)

Target Roles: Travel Agency Commission Managers, Accounts Payable Supervisors, Catering & Event Directors, Hotel Controllers, Directors of Sales, General Managers

Key Value: Monitor travel agency commissions earned on event bookings, audit commissionable event revenue streams across function space, packages, and guest rooms, verify commission calculation rules, and streamline agency payout reconciliation.

Date Parameter: Date Range Selector (Start & End) | Past | Maximum Window: 731 Days

Executive Summary

The Event Commission Report is an essential catering sales audit, accounts payable reconciliation, and travel agency commission tracking document within the πŸ₯‚ Event Management (EventKey) category of the 🀝 Sales, Groups & Events Reports hub. Designed to deliver complete financial transparency over commission liabilities generated by third-party travel agencies and event planners, it itemizes event confirmation details, function stay windows, revenue stream disaggregation, calculation structures, and net commission payout amounts over specified reporting periods.

  • By mapping travel agency profiles (Travel Agent Name) and event identification details (Event Name, Confirmation No) to contractual event execution dates (Event Start Date, Event End Date), itemized revenue postings (Space Revenue, Package Revenue, Room Revenue, Total Revenue), and commission calculation parameters (Commission Type, Commission Base, Commission Amount), this report enables finance teams, catering managers, and hotel controllers to audit agency commission claims, verify eligible revenue bases, process accurate accounts payable clearing, and maintain strong agency partner relationships.

Key Capabilities

  • Catering & Event Commission Audit: Consolidates all travel agency commission liabilities generated through EventKey catering and function space bookings into a single master reference matrix.

  • Itemized Multi-Category Revenue Disaggregation: Separates net event revenue (Total Revenue) into distinct revenue streamsβ€”function space rental (Space Revenue), bundled catering packages (Package Revenue), and attached lodging room blocks (Room Revenue).

  • Commission Rule & Base Verification: Displays configured commission calculation models (Commission Type, e.g., PERCENT) and eligible revenue categories (Commission Base, e.g., SPACE, ROOM REVENUE, PACKAGE) to ensure billing accuracy.

  • Automated Payout Calculation: Computes exact monetary commission liabilities (Commission Amount) owed to third-party agency partners.

  • Travel Agency Profile Traceability: Connects event revenue directly to registered travel agency profiles (Travel Agent Name) for seamless monthly accounts payable processing.

Report Views & Functional Breakdown

The Event Commission Report presents travel agency event commission data in a unified single-table master matrix supporting three primary operational perspectives:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                   EVENT COMMISSION REPORT                              β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                         Unified Matrix View                            β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Agency Identity &     β”‚ 2. Itemized Event        β”‚ 3. Commission    β”‚
β”‚    Event Schedule Trace  β”‚    Revenue Breakdown     β”‚    Calculation   β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Agency Identity & Event Schedule Trace

Monitors registered travel agency names, master event titles, PMS confirmation numbers, and contractual event execution dates.

  • Primary Use: Matching event commission records against third-party agency invoices and verifying event execution dates.

  • Key Metrics: Travel Agent Name, Event Name, Confirmation No, Event Start Date, Event End Date.

2. Itemized Event Revenue Breakdown

Tracks net revenue generated across individual function space rentals, catering packages, attached room blocks, and net combined totals.

  • Primary Use: Auditing revenue stream totals and confirming which event categories contributed to agency earnings.

  • Key Metrics: Space Revenue, Package Revenue, Room Revenue, Total Revenue.

3. Commission Calculation & Payout Audit

Audits commission calculation types, eligible revenue stream rules, and total monetary commission amounts payable.

  • Primary Use: Reconciling accounts payable liabilities, verifying commission rule compliance, and processing agency payouts.

  • Key Metrics: Commission Type, Commission Base, Commission Amount, Total Revenue.

Image 10-20-26 at 8.06β€―PM.png
Event Commission Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (βš™οΈ) icon on the report page. Below is the full data dictionary representing all 12 exact dynamic columns available in this report, sorted in alphabetical order by column name:

πŸ’° Financial Posting Logic: Figures in Space Revenue, Package Revenue, Room Revenue, and Total Revenue reflect net charges posted for catering events and attached room blocks. Commission Amount is dynamically calculated as Commission Base Revenue x Commission Rate based on configured Commission Base rules.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Commission Amount

Calculated monetary commission payout due to the travel agency based on eligible event revenue (Commission Base Revenue} x Commission Rate).

Event Commission Engine > Payable Amount

❌ No

Commission Base

Eligible revenue stream categories configured to calculate commission payouts (e.g., SPACE, ROOM REVENUE, PACKAGE).

Event Commission Setup > Base Categories

N/A

Commission Type

Calculation model or structure applied to compute agency commission liabilities (e.g., PERCENT, FLAT RATE).

Event Commission Setup > Calculation Type

N/A

Confirmation No

Primary unique alphanumeric confirmation ID assigned to the master event record (e.g., OXFBR009509, OXFBR009515, OXFBR009852).

Event Master > Confirmation ID

N/A

Event End Date

Calendar date on which the catering or function event officially concludes.

Event Master > End Date

N/A

Event Name

Official title or descriptive name of the catering event or function (e.g., IBM, Travel Agency, EventKey Quarterly Meeting).

Event Master > Event Title

N/A

Event Start Date

Calendar date on which the catering or function event officially commences.

Event Master > Start Date

N/A

Package Revenue

Total net revenue generated from bundled event catering packages.

Event Ledger > Package Revenue

Yes

Room Revenue

Total net lodging revenue generated from attached guest room blocks.

Group Ledger > Room Revenue

❌ No

Space Revenue

Total net rental revenue generated from function room and meeting space rentals.

Event Ledger > Space Rental Revenue

❌ No

Total Revenue

Total net event revenue generated combining space, package, and room revenues (Space Revenue + Package Revenue + Room Revenue).

Calculated: Net Total Event Yield

❌ No

Travel Agent Name

Official business name of the travel agency or intermediary profile linked to the event booking (e.g., GHPA GLO PROMOTED HOTELS).

Profile Master > Travel Agency Name

N/A

Customization & Platform Features

User & Property Preferences
  • Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.

  • Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:

      • Travel Agency Account & Event Identifiers (Cols 1–3): Travel Agent Name | Event Name | Confirmation No

      • Event Execution Schedule Window (Cols 4–5): Event Start Date | Event End Date

      • Revenue Stream Breakdown & Total (Cols 6–9): Total Revenue | Space Revenue | Package Revenue | Room Revenue

      • Commission Calculation Setup & Amount (Cols 10–12): Commission Type | Commission Base | Commission Amount

Report Toolbar & Quick Actions

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon

Action / Feature

Description

Image 9-29-26 at 1.04β€―PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.

Image 9-29-26 at 12.37β€―PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.

Image 9-29-26 at 12.39β€―PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.

Image 9-29-26 at 12.40β€―PM.png

Highlight

Highlights column values in a designated color based on selected conditions.

Image 9-29-26 at 12.42β€―PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.

Image 9-29-26 at 12.43β€―PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.

Image 9-29-26 at 12.44β€―PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.

Image 9-29-26 at 12.53β€―PM.png

Group By

Summarize and group report data dynamically in real time.


Interactive Visualizations & Grouping Controls
  • Group By & Pie Chart Visualization: The Event Commission Report features an interactive pie chart to help analyze agency-driven event revenue and total commission payouts. Users can group event commission entries on the fly by Travel Agent Name to evaluate commission liabilities per agency or calculation structure. By selecting a metric from the Select Base Column dropdown menuβ€”such as Space Revenue, Package Revenue, Room Revenue, Total Revenue, or Commission Amountβ€”the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

Image 10-20-26 at 8.08β€―PM.png
Group By & Pie Chart Visualization
Advanced Controls
  • Monthly Accounts Payable Audit: Export the report at month-end to verify travel agency commission claims against calculated system liabilities (Commission Amount).

  • Commission Base Rule Verification: Filter by Commission Base to confirm that non-commissionable items (such as service charges or taxes) are excluded from agency payouts.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high commission payouts (Commission Amount > $100), zero-commission agency bookings, or unassigned travel agent names.

Within 🀝 Sales, Groups & Events Reports & πŸ₯‚ Event Management (EventKey):

  • All Events Report – Two-section master event summary and sub-event execution log.

  • Event Books Report – Three-section catering sales audit tracking status-based yields, sub-event revenues, and attached room blocks.

  • Event Cancellation Reason Code Report – Two-section audit tracking root causes and staff logs for cancelled catering events.

  • Event Detail Report – Detailed chronological timeline of all daily functions and space allocations.

Cross-Pillar Deep Dives: