Revenue Activity .ng

Revenue Activity Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 📊 Performance Summaries

Target Roles: Directors of Finance & Controllers, Directors of Revenue Management, General Managers, Financial Analysts, Accounting Supervisors

Key Value: Provide complete transaction-level and departmental revenue traceability across individual guest stays, house accounts, group master blocks, and grand summary totals across four structured analytical sections.

Executive Summary

The Revenue Activity Report is a primary financial auditing and revenue posting analysis document within the 📊 Performance Summaries category of the 📈 Revenue & Analytics hub. Designed to deliver end-to-end revenue traceability across all property earning centers, it captures itemized transaction charges posted to individual reservations, administrative house accounts, and group master accounts.

By organizing financial posting activity across four explicit operational sections (Reservations, House Account, Group, and Totals), this report bridges line-item guest charges with macro-level general ledger account balances. Controllers, night auditors, and financial analysts can audit daily posting dates (Date, Day Of Week), stay parameters (Arrival Date, Departure Date, Number Of Nights, Room Number), reservation setup details (Confirmation Number, Guest Name, Rate Plan Code, Market Segment), and 15 distinct revenue posting classifications (Room Rent, Misc Charge, Food, Bar, Laundry, Event, Phone, Beverage, Other, Non Revenue, Advanced Deposit) to ensure zero posting variances and perfect audit balancing.

Key Capabilities

• Four-Section Complete Revenue Governance: Integrates line-item guest stay charges (Reservations), administrative/folio account charges (House Account), group master billing postings (Group), and executive roll-up summaries (Totals).

• Comprehensive Departmental Revenue Split: Tracks charges across 15 revenue posting buckets, including accommodation (Room Rent), incidental fees (Misc Charge, Misc Expense), dining (Food, Bar, Non Alcoholic Beverages, Alcoholic Beverages, Beverage), services (Laundry, Phone, Event), and non-revenue balance sheet transfers (Non Revenue, Advanced Deposit).

• Stay & Segment Attribution: Maps every transaction directly to guest stay dates, assigned room numbers, rate plan codes (GCG01, IDAPF, IKPCM), and market segments (LEISURE GROUP, DISCOUNT AND TRANSIENT DISCOUNT, LEISURE OTHER, CORPORATE MEETING AND GROUPS).

• Executive Summary Roll-Up: Provides a consolidated grand total matrix (Totals) comparing gross earnings across transient reservations, house accounts, and group master accounts.

Report Views & Functional Breakdown (All 4 Sections)

The Revenue Activity Report presents property transaction data across four structured operational sections:

┌────────────────────────────────────────────────────────────────────────┐
│                        REVENUE ACTIVITY REPORT                         │
├────────────────────────────────────────────────────────────────────────┤
│ 1. Reservations Section                                                │
│    (Itemized Line-Item Guest Folio Charges & Stay Details)              │
├────────────────────────────────────────────────────────────────────────┤
│ 2. House Account Section                                               │
│    (Administrative & Internal House Account Revenue Postings)          │
├────────────────────────────────────────────────────────────────────────┤
│ 3. Group Section                                                       │
│    (Master Group Block Billing Charges & Event Postings)               │
├────────────────────────────────────────────────────────────────────────┤
│ 4. Totals Section                                                      │
│    (Executive Roll-Up Matrix of Revenues across Account Categories)    │
└────────────────────────────────────────────────────────────────────────┘

1. Reservations

Provides a complete line-item ledger of all charges posted to transient and group-member guest folios during the selected reporting window.

• Primary Use: Auditing individual guest folio postings, verifying daily room rate charges (Room Rent), checking incidental package add-ons (Misc Charge, Food, Beverage), and cross-referencing market segment attributions (LEISURE GROUP, LEISURE OTHER).

• Key Metrics: Date, Day Of Week, Arrival Date, Departure Date, Number Of Nights, Room Number, Confirmation Number, Guest Name, First Name, Last Name, Number of Guests, Rate Plan Code, Market Segment, Room Rent, Misc Charge, Food, Bar, Laundry, Non Alcoholic Beverages, Alcoholic Beverages, Phone, Event, Non Revenue, Advanced Deposit, Beverage, Other.

2. House Account

Tracks charges, allowances, and revenue postings recorded against property house accounts and internal administrative folios.

• Primary Use: Auditing internal departmental charges, house-use room postings, administrative expense accounts, and internal promotional allowances.

• Key Metrics: Date, Day Of Week, House Account Name, House Account Code, Start Date, End Date, Rate Plan Code, Market Segment, Room Rent, Misc Charge, Food, Bar, Laundry, Phone, Event, Non Revenue, Advanced Deposit, Beverage, Other.

3. Group

Logs charges posted directly to group master accounts, conference blocks, and corporate convention folios.

• Primary Use: Auditing master account group block charges (Group Name, Group Code), verifying corporate convention room postings (Room Rent), and reviewing banquet/event billing entries prior to city ledger invoicing.

• Key Metrics: Date, Day Of Week, Group Name, Group Code, Start Date, End Date, Rate Plan Code, Market Segment, Room Rent, Misc Charge, Food, Event, Non Revenue, Advanced Deposit.

4. Totals

Delivers an executive summary table aggregating gross revenue earnings by account category (Reservations, House Account, Group).

• Primary Use: Providing macro-level revenue totals for executive briefings, verifying night audit revenue tie-outs, and confirming general ledger posting totals across all property earning centers.

• Key Metrics: Account Category (Reservations, Group, House Account), Room Rent, Misc Charge, Misc Expense, System, Food, Bar, Laundry, Non Alcoholic Beverages, Alcoholic Beverages, Other, Phone, Event, Non Revenue, Advanced Deposit, Beverage.

Data Dictionary (Dynamic View Columns Across All 4 Sections)

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

💡 Monetary & Revenue Treatment Note: Revenue columns (Room Rent, Misc Charge, Food, Beverage, Event, Other) represent Gross Financial Amounts (Includes Taxes & Fees) unless configured as net base revenue items. Positive values indicate net revenue earned or charges posted, while negative values indicate credit adjustments or allowances.

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: Reservations

    • Room & Confirmation Anchors (Cols 1–2): Room Number | Confirmation Number

    • Guest Profile & Demographics (Cols 3–6): Guest Name | First Name | Last Name | Number of Guests

    • Stay Window Parameters (Cols 7–10): Date | Day Of Week | Arrival Date | Departure Date | Number Of Nights

    • Rate & Market Classification (Cols 11–12): Rate Plan Code | Market Segment

    • Accommodation Revenue (Col 13): Room Rent

    • Food & Beverage Outlets (Cols 14–17): Food | Bar | Beverage | Non Alcoholic Beverages | Alcoholic Beverages

    • Ancillary Guest Services (Cols 18–21): Event | Laundry | Phone | Other

    • Ledger Adjustments & Deposits (Cols 22–26): Misc Charge | Misc Expense | System | Non Revenue | Advanced Deposit

  • Section 2: House Accounts

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

    • Posting Timeline & Market Classification (Cols 3–7): Date | Day Of Week | Start Date | End Date | Market Segment | Rate Plan Code

    • Accommodation & Operational Charges (Col 8): Room Rent

    • Food & Beverage Outlets (Cols 9–12): Food | Bar | Beverage | Non Alcoholic Beverages | Alcoholic Beverages

    • Ancillary Services (Cols 13–16): Event | Laundry | Phone | Other

    • Ledger Adjustments & Deposits (Cols 17–21): Misc Charge | Misc Expense | System | Non Revenue | Advanced Deposit

  • Section 3: Groups

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

    • Contract Timeline & Market Classification (Cols 3–7): Date | Day Of Week | Start Date | End Date | Market Segment | Rate Plan Code

    • Group Accommodation Revenue (Col 8): Room Rent

    • Food & Beverage Outlets (Cols 9–12): Food | Bar | Beverage | Non Alcoholic Beverages | Alcoholic Beverages

    • Ancillary Services & Banquet Events (Cols 13–16): Event | Laundry | Phone | Other

    • Ledger Adjustments & Deposits (Cols 17–21): Misc Charge | Misc Expense | System | Non Revenue | Advanced Deposit

  • Section 4: Totals

    • Module Classification (Col 1): Module Name (Reservations / Group / House Account)

    • Accommodation Revenue (Col 2): Room Rent

    • Food & Beverage Revenue (Cols 3–6): Food | Bar | Beverage | Non Alcoholic Beverages | Alcoholic Beverages

    • Ancillary Revenue (Cols 7–10): Event | Laundry | Phone | Other

    • Ledger Adjustments & Deposits (Cols 11–15): Misc Charge | Misc Expense | System | Non Revenue | Advanced Deposit

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 Revenue Activity report features an interactive pie chart to help analyze posted revenue and volume distributions across rate plans and account types. Users can group transaction entries on the fly by Rate Plan Code, Day Of Week, or Date to analyze posting distributions. By selecting a metric from the Select Base Column dropdown menu—such as Number Of Nights, Number of Guests, Room Rent, or Misc Charge—the chart dynamically renders percentage share breakdowns alongside a color-coded legend across the Reservations, House Account, Group, and Totals sub-tabs.

• Bar Chart Visualizer: The Revenue Activity report includes an interactive bar chart to help visualize posted earnings over time across individual account categories (Reservations, House Account, Group, or Totals). By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically switch the chart to track specific revenue categories—such as Room Rent, Food, Bar, or Misc Charge—alongside the detailed transaction grid below.

Advanced Controls

• Exporting & General Ledger Tie-Outs: Download in Excel or PDF format to support night audit balancing, month-end general ledger reconciliations, and owner financial statement preparation.

• Filtering: Filter data by specific Market Segment, Rate Plan Code, Group Code, or date ranges.

• Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-value room rent charges, incidental food/beverage postings, or negative allowance adjustments.

🔗 Related Reports & Next Steps

Within 📈 Revenue & Analytics & 📊 Performance Summaries:

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

• Net Revenue – Review daily net revenue realizations across primary operational charge categories.

• Hotel Statistics – Complete 360-degree operational overview including room counts, occupancy, taxes, payments, and booking activity.

Cross-Pillar Deep Dives:

• ⚖️ Ledgers & Trial Balance: Reconcile transaction revenue postings against General Ledger control accounts in Trial Balance or Day End Summary.

• 💳 Payments & Transactions: To inspect specific guest payments, credit card tokens, and cashier shift drops driving revenue activity, review All Transactions or Settlement By Payment Type.