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.
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, andTotal Revenuereflect net charges posted for catering events and attached room blocks.Commission Amountis dynamically calculated as Commission Base Revenue x Commission Rate based on configuredCommission Baserules.
|
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., |
Event Commission Setup > Base Categories |
N/A |
|
Commission Type |
Calculation model or structure applied to compute agency commission liabilities (e.g., |
Event Commission Setup > Calculation Type |
N/A |
|
Confirmation No |
Primary unique alphanumeric confirmation ID assigned to the master event record (e.g., |
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., |
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., |
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 |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
Filter |
Opens filter controls to isolate specific data within a column based on your selected criteria. |
|
Highlight |
Highlights column values in a designated color based on selected conditions. |
|
Export |
Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing. |
|
Configure |
Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros. |
|
Additional Configuration |
Provides advanced report configuration and display formatting options to customize data presentation. |
|
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.
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 Baseto 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.
π Related Reports & Next Steps
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:
-
π’ Corporate Accounts: Cross-reference travel agency event bookings with Travel Agent Checkout Report and Company And Travel Agent Reservations Report to evaluate total B2B agency contribution across lodging and catering.
-
π Financial & Accounts Payable: Reconcile total estimated event commissions (
Commission Amount) against monthly Accounts Payable Trial Balance Report and general ledger commission expense accounts.