Event Revenue Summary Report Overview
Parent Hub: π€ Sales, Groups & Events Reports
Category: π₯ Event Management (EventKey)
Target Roles: Catering & Event Directors, Hotel Controllers, Banquet Sales Managers, Directors of Sales, Food & Beverage Directors, General Managers
Key Value: Monitor comprehensive event financial postings across billing folios, track function space rental yields and adjustments, evaluate catering package earnings and service charges, audit line-item charge types, and reconcile master event ledger balances.
Date Parameter: Date Range Selector (Start & End) | Past & Future | Maximum Window: None
Executive Summary
The Event Revenue Summary Report is an essential catering sales audit, financial posting reconciliation, and banquet revenue accounting document within the π₯ Event Management (EventKey) category of the π€ Sales, Groups & Events Reports hub. Designed to provide full financial transparency over event billing lifecycles, it itemizes gross charges, billing adjustments, service fees, applied taxes, payments received, and outstanding folio balances across specified date ranges.
-
By organizing event revenue data into 5 defined report sections: Event Revenue Summary, Other Revenue, Revenue by Space, Revenue by Package, and Revenue By Charge Type, this report enables catering directors, sales managers, and hotel controllers to evaluate master event billing ledgers (
Event Revenue Summary), ancillary revenue streams (Other Revenue), physical function space rental yields (Revenue by Space), bundled catering package production (Revenue by Package), and granular line-item charge types (Revenue By Charge Type). It correlates event identifiers (Confirmation No,Event Name,Event Status) and calendar timeframes (Transaction Date,Event Start Date,Event End Date,Date,Day Of Week) with commercial classifications (Market Segment,Revenue Classification,Classification Name,Charge Type,Space Code,Space Name,Package Code,Package Name,Number of Events) and financial ledger postings (NET CHARGES,Net Taxes,Net Payments,NET BALANCE,TOTAL CHARGE ADJUSTMENTS,Total Charges,Total Taxes,Total Refunds,Total Payments,TOTAL TAX ADJUSTMENTS,Space Charges,Space Charge Adjustments,Net Space Charges,Service Charges,Service Charge Adjustments,Net Service Charges,Total Adjustments,Total Net Charges,Package Charges,Package Charge Adjustments,Net Package Charges,Revenue,Tax,Total Revenue).
Key Capabilities
-
Five-Section Comprehensive Revenue Structure: Separates macro folio ledgers (
Event Revenue Summary) and ancillary revenues (Other Revenue) from function space rentals (Revenue by Space), package earnings (Revenue by Package), and itemized charge codes (Revenue By Charge Type). -
Complete Folio Audit & Balance Tracking: Reconciles gross charges (
Total Charges), charge adjustments (TOTAL CHARGE ADJUSTMENTS), net charges (NET CHARGES), taxes (Net Taxes), payments (Net Payments), and outstanding balances (NET BALANCE) per event. -
Function Space & Rental Adjustment Analysis: Tracks gross space rental fees (
Space Charges), fee waivers or credits (Space Charge Adjustments), net space earnings (Net Space Charges), and attached service fees (Net Service Charges). -
Catering Package & Service Charge Oversight: Itemizes package charges (
Package Charges), package discounts (Package Charge Adjustments), net package yields (Net Package Charges), and administrative service charges (Service Charges,Service Charge Adjustments,Net Service Charges). -
Granular Line-Item Charge Type Tracking: Evaluates revenue postings disaggregated by specific charge categories (
Charge Type, e.g.,Outside Catering_Tax 1,Space_Rental,Accommodation_Upgrade) alongside taxes (Tax) and gross totals (Total Revenue).
Report Views & Functional Breakdown
The Event Revenue Summary Report presents catering and banquet financial data across 5 defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β EVENT REVENUE SUMMARY REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 5 Defined Report Sections β
ββββββββββββββββββββββββ¬βββββββββββββββββββββββ¬βββββββββββββββββββββββββββ€
β 1. Event Revenue β 2. Other Revenue β 3. Revenue by Space β
β Summary (Folios) β (Ancillary Feeds) β (Space Rentals & AV) β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββΌβββββββββββββββββββββββββββ€
β 4. Revenue by Package β 5. Revenue By Charge β
β (Bundled Packages & Service Fees) β Type (Itemized Lines) β
βββββββββββββββββββββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ
1. Event Revenue Summary Section (Master Folio Ledgers)
Monitors master event billing accounts, detailing transaction dates, stay windows, master confirmation numbers, market segments, net charges, net taxes, payments, refunds, adjustments, revenue classifications, and outstanding balances.
-
Primary Use: Reconciling master event folios, verifying client payments, auditing billing adjustments, and managing outstanding accounts receivable balances.
-
Key Metrics: Transaction Date, Event Start Date, Event End Date, Confirmation No, Market Segment, NET CHARGES, Net Taxes, Net Payments, NET BALANCE, TOTAL CHARGE ADJUSTMENTS, Total Charges, Total Taxes, Total Refunds, Total Payments, TOTAL TAX ADJUSTMENTS, Revenue Classification.
2. Other Revenue Section (Ancillary Feeds)
Tracks miscellaneous catering charges, incidental event fees, administrative billing items, and associated adjustments.
-
Primary Use: Auditing ancillary event revenue postings, reviewing fee adjustments, and reconciling non-rental catering charges.
-
Key Metrics: Transaction Date, Event Start Date, Event End Date, Confirmation No, Market Segment, NET CHARGES, Net Taxes, Total Charges, TOTAL CHARGE ADJUSTMENTS, Total Taxes, TOTAL TAX ADJUSTMENTS.
3. Revenue by Space Section (Function Space Rentals)
Analyzes function room and ballroom rental performance by date, space code, space name, market segment, and classification, tracking rental charges, space adjustments, service fees, and net charges.
-
Primary Use: Measuring ballroom and meeting room rental yields, tracking space fee discounts/waivers, and reviewing service charge revenue.
-
Key Metrics: Date, Day Of Week, Space Code, Space Name, Market Segment, Classification Name, Number of Events, Space Charges, Space Charge Adjustments, Net Space Charges, Service Charges, Service Charge Adjustments, Net Service Charges, Total Charges, Total Adjustments, Total Net Charges, Net Taxes.
4. Revenue by Package Section (Bundled Catering Packages)
Monitors bundled event packages, detailing package codes, package names, booking classifications, package charges, discounts, service charges, and total net revenue.
-
Primary Use: Evaluating catering package profitability, tracking package discount adjustments, and auditing banquet service charge additions.
-
Key Metrics: Date, Day Of Week, Package Code, Package Name, Market Segment, Classification Name, Number of Events, Package Charges, Package Charge Adjustments, Net Package Charges, Service Charges, Service Charge Adjustments, Net Service Charges, Total Charges, Total Adjustments, Total Net Charges, Net Taxes.
5. Revenue By Charge Type Section (Itemized Line Items)
Itemizes financial revenue by exact billing charge categories across events, detailing event names, statuses, charge types, net revenues, applied taxes, and gross revenues.
-
Primary Use: Conducting granular line-item billing audits, verifying tax application across specific charge codes, and reviewing charge-type distribution.
-
Key Metrics: Date, Event Status, Confirmation No, Event Name, Charge Type, Revenue, Tax, 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 41 exact dynamic columns available across the 5 report sections, sorted in alphabetical order by column name:
π° Financial Posting Logic: Figures in financial charge and revenue columns reflect net or gross charges posted to event master folios or BEO billing accounts. In Section 1,
NET BALANCEis dynamically calculated as ((NET CHARGES + Net Taxes) - Net Payments). In Sections 3 and 4,Total Net Chargesreflects Net Space Charges + Net Package Charges + Net Service Charges. In Section 5,Total Revenuereflects Revenue + Tax.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Charge Type |
Section 5 |
Categorical classification of the posted event charge (e.g., |
Billing Setup > Charge Code Category |
N/A |
|
Classification Name |
Sections 3, 4 |
Standardized event classification or purpose category (e.g., Banquet, Corporate Meeting, Reception). |
Event Master > Classification |
N/A |
|
Confirmation No |
Sections 1, 2, 5 |
Primary unique alphanumeric confirmation ID assigned to the master event record (e.g., |
Event Master > Confirmation ID |
N/A |
|
Date |
Sections 3, 4, 5 |
Calendar date on which the space charge, package posting, or event transaction occurred. |
Event Calendar > Execution Date |
N/A |
|
Day Of Week |
Sections 3, 4 |
Day of the week corresponding to the posting date (e.g., |
Calculated: Day Name |
N/A |
|
Event End Date |
Sections 1, 2 |
Calendar date on which the catering or function event officially concludes. |
Event Master > End Date |
N/A |
|
Event Name |
Section 5 |
Official title or descriptive name of the catering event or function (e.g., |
Event Master > Event Title |
N/A |
|
Event Start Date |
Sections 1, 2 |
Calendar date on which the catering or function event officially commences. |
Event Master > Start Date |
N/A |
|
Event Status |
Section 5 |
Operational lifecycle state of the event (e.g., |
Event Master > Lifecycle Status |
N/A |
|
Market Segment |
Sections 1, 2, 3, 4 |
Primary market segment classification linked to the event booking (e.g., |
PMS Setup > Market Segment |
N/A |
|
NET BALANCE |
Section 1 |
Remaining outstanding folio balance on the event account after deducting net payments ((NET CHARGES + Net Taxes) - Net Payments). |
Folio Ledger > Outstanding Balance |
π’ Yes |
|
NET CHARGES |
Sections 1, 2 |
Net total event charges after applying all fee adjustments and discounts (Total Charges + TOTAL CHARGE ADJUSTMENTS). |
Calculated: Net Line Charges |
β No |
|
Net Package Charges |
Section 4 |
Net revenue generated from bundled catering packages after deducting package adjustments (Package Charges + Package Charge Adjustments). |
Calculated: Net Package Yield |
β No |
|
Net Payments |
Section 1 |
Net monetary payments collected and posted toward the event folio (Total Payments - Total Refunds). |
Folio Ledger > Net Remittance |
π’ Yes |
|
Net Service Charges |
Sections 3, 4 |
Net service charges and gratuity fees posted after deducting service charge adjustments (Service Charges + Service Charge Adjustments). |
Calculated: Net Service Surcharges |
β No |
|
Net Space Charges |
Section 3 |
Net function space rental charges posted after deducting space charge adjustments (Space Charges + Space Charge Adjustments). |
Calculated: Net Room Rental Yield |
β No |
|
Net Taxes |
Sections 1, 2, 3, 4 |
Net sales, occupancy, and catering taxes applied after factoring in tax adjustments (Total Taxes + TOTAL TAX ADJUSTMENTS). |
Calculated: Net Tax Liabilities |
π’ Yes |
|
Number of Events |
Sections 3, 4 |
Numerical count of unique event bookings or functions associated with the space or package on the target date. |
Event Engine > Daily Booking Count |
N/A |
|
Package Charge Adjustments |
Section 4 |
Monetary adjustments, allowances, or discounts applied to bundled package charges. |
Folio Ledger > Package Credits |
β No |
|
Package Charges |
Section 4 |
Gross charges posted for bundled event catering packages prior to adjustments. |
Folio Ledger > Gross Package Charges |
β No |
|
Package Code |
Section 4 |
Alphanumeric code identifying the specific catering package (e.g., |
Product Master > Package Code |
N/A |
|
Package Name |
Section 4 |
Descriptive commercial name of the catering package (e.g., |
Product Master > Package Name |
N/A |
|
Revenue |
Section 5 |
Net revenue generated from the specific charge type before tax. |
Folio Ledger > Pre-Tax Line Revenue |
β No |
|
Revenue Classification |
Section 1 |
Financial category classification assigned to the revenue stream for general ledger accounting. |
Accounting Setup > GL Class Code |
N/A |
|
Service Charge Adjustments |
Sections 3, 4 |
Monetary adjustments, rebates, or credits applied to posted event service charges. |
Folio Ledger > Service Charge Credits |
β No |
|
Service Charges |
Sections 3, 4 |
Gross service fees and administrative catering surcharges posted to the event. |
Folio Ledger > Gross Service Fees |
β No |
|
Space Charge Adjustments |
Section 3 |
Monetary adjustments, credits, or fee waivers applied to function room rental charges. |
Folio Ledger > Space Rental Credits |
β No |
|
Space Charges |
Section 3 |
Gross rental fees posted for function space and meeting rooms prior to adjustments. |
Folio Ledger > Gross Space Rental |
β No |
|
Space Code |
Section 3 |
Alphanumeric code identifying the assigned function space or meeting room (e.g., |
Facility Master > Space Code |
N/A |
|
Space Name |
Section 3 |
Official descriptive name of the function space or ballroom (e.g., |
Facility Master > Space Name |
N/A |
|
Tax |
Section 5 |
Monetary tax amount applied to the specific charge type transaction. |
Folio Ledger > Line Tax Charges |
π’ Yes |
|
Total Adjustments |
Sections 3, 4 |
Combined sum of all space, package, and service charge adjustments (Space Charge Adjustments + Package Charge Adjustments + Service Charge Adjustments). |
Calculated: Total Fee Adjustments |
β No |
|
TOTAL CHARGE ADJUSTMENTS |
Sections 1, 2 |
Total monetary adjustments, discounts, and fee corrections applied to gross charges on the event folio. |
Folio Ledger > Total Charge Credits |
β No |
|
Total Charges |
Sections 1, 2, 3, 4 |
Gross event charges posted across all line items prior to adjustments and tax. |
Folio Ledger > Gross Line Charges |
β No |
|
Total Net Charges |
Sections 3, 4 |
Cumulative net charges combining space or package charges and net service charges ($\text{Net Space Charges} / \text{Net Package Charges} + \text{Net Service Charges}$). |
Calculated: Net Combined Charges |
β No |
|
Total Payments |
Section 1 |
Gross monetary payments received and posted to the event master folio. |
Folio Ledger > Gross Remittance |
π’ Yes |
|
Total Refunds |
Section 1 |
Total monetary refunds or payment reversals issued back to the client from the event folio. |
Folio Ledger > Issued Refunds |
π’ Yes |
|
Total Revenue |
Section 5 |
Total gross revenue generated combining net charge revenue and tax (Revenue + Tax). |
Calculated: Gross Line Total |
π’ Yes |
|
TOTAL TAX ADJUSTMENTS |
Sections 1, 2 |
Total monetary adjustments or corrections applied to event taxes. |
Folio Ledger > Tax Credits / Debits |
π’ Yes |
|
Total Taxes |
Sections 1, 2 |
Gross taxes applied across all event charges prior to tax adjustments. |
Folio Ledger > Gross Tax Charges |
π’ Yes |
|
Transaction Date |
Sections 1, 2 |
Calendar date on which the financial transaction or adjustment was posted in the ledger. |
Audit Trail > Financial Posting Date |
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:
-
Section 1: Event Revenue Summary
-
Calendar Dates & Event Identifiers (Cols 1β4):
Transaction Date|Confirmation No|Event Start Date|Event End Date -
Segmentation & Classification (Cols 5β6):
Revenue Classification|Market Segment -
Revenue Charges & Adjustments (Cols 7β9):
NET CHARGES|Total Charges|TOTAL CHARGE ADJUSTMENTS -
Tax Calculations & Adjustments (Cols 10β12):
Net Taxes|Total Taxes|TOTAL TAX ADJUSTMENTS -
Payments, Refunds & Folio Ledger Balance (Cols 13β16):
NET BALANCE|Net Payments|Total Payments|Total Refunds
-
-
Section 2: Other Revenue
-
Calendar Dates & Event Identifiers (Cols 1β4):
Transaction Date|Confirmation No|Event Start Date|Event End Date -
Market Segmentation (Col 5):
Market Segment -
Charges & Adjustments Breakdown (Cols 6β8):
NET CHARGES|Total Charges|TOTAL CHARGE ADJUSTMENTS -
Tax Calculations & Adjustments (Cols 9β11):
Net Taxes|Total Taxes|TOTAL TAX ADJUSTMENTS
-
-
Section 3: Revenue by Space
-
Schedule Window & Function Space Locators (Cols 1β4):
Date|Day Of Week|Space Name|Space Code -
Segmentation, Classification & Event Count (Cols 5β7):
Classification Name|Market Segment|Number of Events -
Space Rental Revenue Streams (Cols 8β10):
Net Space Charges|Space Charges|Space Charge Adjustments -
Service Charge Revenue Streams (Cols 11β13):
Net Service Charges|Service Charges|Service Charge Adjustments -
Cumulative Financial Totals & Taxes (Cols 14β17):
Total Net Charges|Total Charges|Total Adjustments|Net Taxes
-
-
Section 4: Revenue by Package
-
Schedule Window & Catering Package Locators (Cols 1β4):
Date|Day Of Week|Package Name|Package Code -
Segmentation, Classification & Event Count (Cols 5β7):
Classification Name|Market Segment|Number of Events -
Package Catering Revenue Streams (Cols 8β10):
Net Package Charges|Package Charges|Package Charge Adjustments -
Service Charge Revenue Streams (Cols 11β13):
Net Service Charges|Service Charges|Service Charge Adjustments -
Cumulative Financial Totals & Taxes (Cols 14β17):
Total Net Charges|Total Charges|Total Adjustments|Net Taxes
-
-
Section 5: Revenue By Charge Type
-
Event Identifiers & Lifecycle Status (Cols 1β4):
Event Name|Confirmation No|Event Status|Date -
Charge Type Categorization (Col 5):
Charge Type -
Financial Revenue & Tax Totals (Cols 6β8):
Total Revenue|Revenue|Tax
-
-
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. |
|
Bar Chart |
Displays report data in a visual bar chart format. |
|
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 Revenue Summary report includes a multi-tab interactive pie chart that illustrates catering and event revenue distributions across five independent reporting sections: Event Revenue Summary, Other Revenue, Revenue by Space, Revenue by Package, and Revenue By Charge Type. Users can toggle or expand/collapse sections and group records on the fly by Market Segment, Transaction Date, Space Name/Code, Package Name/Code, or Charge Type to evaluate ledger totals and line-item distributions. Selecting a metric from the section-specific Select Base Column dropdown menu dynamically updates the pie slices with percentage shares alongside an interactive color-coded legend.
-
Bar Chart Visualizer: The Event Revenue Summary report includes an interactive bar chart to track daily catering and event earnings trends chronologically over time. The Bar Chart feature is available exclusively on three sections: Revenue by Space, Revenue by Package, and Revenue By Charge Type. Depending on the active tab, users can select from the Select Column (Y-Axis) dropdown menu to dynamically plot metrics such as space charges, package charges, service charges, event counts, net revenue, tax, or total revenue alongside the detailed event data grid.
Advanced Controls
-
Outstanding Folio Balance Audits: Filter Section 1 (
Event Revenue Summary) byNET BALANCE > $0to generate an immediate aging list of unpaid event folios for collections follow-up. -
Rental Discount & Waiver Analysis: Review
Space Charge Adjustmentsin Section 3 to audit complimentary space waivers or rental discount approvals. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight unpaid event folios (
NET BALANCE > $0), high-value charge adjustments (TOTAL CHARGE ADJUSTMENTS < -$500), or top-revenue catering dates.
π 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 Covers Report β Three-section catering attendance and cover revenue audit report.
-
Event Deposit Schedules Report β Advance deposit schedule and payment compliance report.
Cross-Pillar Deep Dives:
-
π’ Corporate Accounts: Cross-reference event client revenues with Company Details Report, Top Accounts Report, and Company Analysis Report to evaluate total B2B spend across lodging and banquets.
-
π Financial & General Ledger: Reconcile net event charges (
NET CHARGES), service fees (Net Service Charges), and collected remittances (Net Payments) with monthly general ledger Trial Balance Report and Direct Bill Ledger Report.