Event Revenue Summary Report

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.

Image 10-25-26 at 3.00β€―PM.png
Event Revenue Summary Section
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.

Other Revenue.png
Other Revenue Section
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.

Image 10-25-26 at 3.04β€―PM.png
Revenue by Space Section
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.

Image 10-25-26 at 3.05β€―PM.png
Revenue by Package Section
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.

Revenue by Charge.png
Revenue by Charge Type Section

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 BALANCE is dynamically calculated as ((NET CHARGES + Net Taxes) - Net Payments). In Sections 3 and 4, Total Net Charges reflects Net Space Charges + Net Package Charges + Net Service Charges. In Section 5, Total Revenue reflects 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., Outside Catering_Tax 1, Space_Rental, Accommodation_Upgrade).

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., OXFBR003791, OXFBR004841).

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., Wednesday, Thursday, Friday).

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., 50th Birthday Bash, RetailKey Board Meeting, HotelKey Board Meeting).

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., ENDED, CONFIRMED, CANCELLED).

Event Master > Lifecycle Status

N/A

Market Segment

Sections 1, 2, 3, 4

Primary market segment classification linked to the event booking (e.g., Corporate_Business Segments).

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., DFD, AttackerCode, 10AP).

Product Master > Package Code

N/A

Package Name

Section 4

Descriptive commercial name of the catering package (e.g., 10 Anniversary Package, Meeting + 2 Cours).

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., ASTON, Aston_1).

Facility Master > Space Code

N/A

Space Name

Section 3

Official descriptive name of the function space or ballroom (e.g., Aston Grand Horizon Ballroom, Horizon Room A (East Wing)).

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

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.51β€―PM.png

Bar Chart

Displays report data in a visual bar chart format.

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 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.

Image 10-25-26 at 3.31β€―PM.png
Group By & Pie Chart Visualization
  • 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.

Image 10-25-26 at 3.35β€―PM.png
Bar Chart Visualizer
Advanced Controls
  • Outstanding Folio Balance Audits: Filter Section 1 (Event Revenue Summary) by NET BALANCE > $0 to generate an immediate aging list of unpaid event folios for collections follow-up.

  • Rental Discount & Waiver Analysis: Review Space Charge Adjustments in 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.

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

Cross-Pillar Deep Dives: