Package Revenue Summary .ng

Package Revenue Summary Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 📊 Performance Summaries

Target Roles: Directors of Revenue Management, General Managers, Directors of Finance & Controllers, Food & Beverage Supervisors, Accounting Managers

Key Value: Evaluate aggregated non-room package element financial earnings, audit package revenue routing across general ledger charge codes, and monitor package sales performance across two distinct analytical sections.

Executive Summary

The Package Revenue Summary Report is a primary financial rollup and package yield analysis document within the 📊 Performance Summaries category of the 📈 Revenue & Analytics hub. Designed to provide executive-level visibility into non-room package earnings, it aggregates package component revenues across the property over a selected operating period.

By organizing package financial data across two structured operational sections (Details By Charge Type and Details by Package Element), this report maps package setup identifiers (Package Code, Package Name, Element Code, Element Name) to financial ledger posting structures (Charge Type Name, Charge Type Code, Posted Revenue). This enables revenue managers and controllers to audit package revenue distribution across general ledger charge codes (e.g., 2000 - Breakfast, 2030 - Dinner, 5303 - Parking), verify component pricing splits, and evaluate total product line yield without combing through individual guest folios.

Key Capabilities

• Dual-Section Package Governance: Combines a general ledger charge-code mapping view (Details By Charge Type) with a consolidated component yield view (Details by Package Element).

• GL Charge Code Routing Verification: Maps package elements directly to PMS charge codes (2000, 2030, 5303) to confirm that non-room package earnings route accurately to food, beverage, parking, or amenity revenue accounts.

• Macro Package Yield Analysis: Aggregates total posted package revenues per package code (e.g., BRKGRP, BFS Inc, DIN Inc, PRK Inc) to evaluate package product line demand and financial contributions.

Report Views & Functional Breakdown (All 2 Sections)

The Package Revenue Summary Report presents aggregated package financial data across two structured operational sections:

┌────────────────────────────────────────────────────────────────────────┐
│                     PACKAGE REVENUE SUMMARY REPORT                     │
├────────────────────────────────────────────────────────────────────────┤
│ 1. Details By Charge Type Section                                      │
│    (Itemized Package Component Revenue Mapped to GL Charge Codes)      │
├────────────────────────────────────────────────────────────────────────┤
│ 2. Details by Package Element Section                                  │
│    (Consolidated Total Revenue Roll-Up per Package Component)          │
└────────────────────────────────────────────────────────────────────────┘

1. Details By Charge Type

Itemizes posted package revenues broken down by their underlying general ledger posting charge code and department.

• Primary Use: Auditing how multi-component packages (e.g., Dinner bed & breakfast, Breakfast & Parking) split revenue across multiple department charge codes (e.g., splitting breakfast revenue to code 2000 and dinner revenue to code 2030).

• Key Metrics: Package Code, Package Name, Element Code, Element Name, Charge Type Name, Charge Type Code, Posted Revenue.

2. Details by Package Element

Rolls up cumulative financial earnings per package element into a single summary table.

• Primary Use: Evaluating overall product line demand, comparing gross earnings across package packages (e.g., Breakfast Only for Groups vs. Bed & Breakfast), and reviewing package contribution totals for period-end accounting reviews.

• Key Metrics: Package Code, Package Name, Element Code, Element Name, Posted Revenue.

Data Dictionary (Dynamic View Columns Across Both Sections)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available across both sections of this report:

💡 Monetary & Revenue Treatment Note: Posted Revenue represents Gross Financial Amounts (Includes Taxes & Fees) allocated to the non-room package element unless configured as net base revenue items. In multi-component packages, Posted Revenue reflects the specific dollar share earned by each element.

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: Details by Charge Type

    • Package Identifiers (Cols 1–2): Package Code | Package Name

    • Package Element Metadata (Cols 3–4): Element Code | Element Name

    • GL Charge Mapping Controls (Cols 5–6): Charge Type Code | Charge Type Name

    • Financial Revenue Allocation (Col 7): Posted Revenue

  • Section 2: Details by Package Element

    • Package Identifiers (Cols 1–2): Package Code | Package Name

    • Package Element Metadata (Cols 3–4): Element Code | Element Name

    • Financial Revenue Total (Col 5): Posted Revenue

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.

Advanced Controls

• Exporting & General Ledger Auditing: Download in Excel or PDF format to support departmental food & beverage revenue reconciliations, package breakage audits, and month-end general ledger posting reviews.

• Filtering: Filter data by specific Package Code, Element Code, or Charge Type Code.

• Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-performing packages or elements exceeding specific revenue thresholds.

🔗 Related Reports & Next Steps

Within 📈 Revenue & Analytics & 📊 Performance Summaries:

• Package Revenue Activity – Line-item guest reservation audit showing individual guest package postings, room revenue vs. package revenue splits, and loyalty tiers.

• Add-On Revenue – Review itemized non-room add-on product sales, purchase touchpoints (Booking Time vs. On Demand), and fulfillment dates.

• General Manager Report – Review property-wide macro statistics, room revenues, ADR, and RevPAR performance.

Cross-Pillar Deep Dives:

• ⚖️ Ledgers & Trial Balance: Reconcile package charge code revenue totals against General Ledger control accounts in Trial Balance or Day End Summary.

• 💳 Payments & Transactions: To inspect specific guest payments and folio transactions driving package revenue, review All Transactions.