Company Analysis .ng

Company Analysis Report Overview

Parent Hub: 🀝 Sales, Groups & Events Reports

Category: 🏒 Corporate Accounts

Target Roles: Directors of Sales, Corporate Account Managers, Revenue Managers, General Managers, Hotel Controllers, Regional Sales Leads

Key Value: Evaluate monthly and annual corporate account production, track company-driven accommodation, food, and ancillary revenues, analyze room night volume alongside cancellations and no-shows, and audit negotiated account performance.

Date Parameter: Date Range Selector (Start & End) | Past | Maximum Window: 365 Days

Executive Summary

The Company Analysis Report is a vital corporate sales dashboard, revenue performance matrix, and account production tracking document within the 🏒 Corporate Accounts category of the 🀝 Sales, Groups & Events Reports hub. Designed to deliver clear month-by-month and annual performance visibility, it itemizes both financial revenues and room stay statistics associated with corporate account profiles across the calendar year.

  • Flexible Account Filtering: Users can run this report without selecting a specific company account to generate an aggregated sum of overall property-wide corporate production, OR apply a filter for a specific corporate account (e.g., HotelKey, Inc.) to isolate and analyze production strictly for that selected account.

  • By organizing corporate production data into 2 defined report sections: Revenue and Statistics, this report enables sales directors, corporate account managers, and revenue leaders to separate financial postings (Revenue) from operational volume metrics (Statistics). It maps annual reporting periods (Year) and monthly performance columns (January through December, plus Totals) against financial posting types (Revenue Accommodation, Revenue Food, Revenue Other, Total Revenue) and room movement categories (Arrival Rooms, Cancelled Rooms, Day Use Rooms, Departure Rooms, No Show Rooms, Room Nights).

Key Capabilities

  • Two-Section Production Matrix: Separates monetary financial performance (Revenue) from operational volume counters (Statistics) for streamlined sales auditing.

  • Macro & Account-Specific Reporting Flexibility: Supports unrestricted property-wide execution to audit overall corporate market segment production, or single-account filtering (e.g., HotelKey, Inc.) to review individual negotiated contract performance.

  • Full-Year Monthly Trend Analysis: Spans all 12 calendar months (January through December) alongside cumulative annual totals (Totals) to identify corporate booking seasonality and peak travel months.

  • Revenue Category Breakdown: Disaggregates net corporate revenue into core room charges (Revenue Accommodation), dining/beverage spend (Revenue Food), and incidental or meeting charges (Revenue Other).

  • Room Movement & Slippage Tracking: Monitors actual corporate room night volume (Room Nights, Arrival Rooms, Departure Rooms, Day Use Rooms) alongside account attrition and slippage (Cancelled Rooms, No Show Rooms).

Report Views & Functional Breakdown

The Company Analysis Report presents corporate account performance data across 2 defined sections:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                        COMPANY ANALYSIS REPORT                         β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                       2 Defined Report Sections                        β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Revenue Section       β”‚ 2. Statistics Section    β”‚                  β”‚
β”‚    (Financial Postings)  β”‚    (Room Night Volume)   β”‚                  β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Revenue Section

Monitors monetary financial posting totals generated by corporate accounts disaggregated across monthly calendar columns.

  • Primary Use: Evaluating corporate account spend, auditing room rate revenue versus food/beverage spend, and reviewing account contract threshold fulfillment.

  • Key Metrics: Transaction Type (Revenue Accommodation, Revenue Food, Revenue Other, Total Revenue), Year, January – December, Totals.

Image 10-19-26 at 9.50β€―AM.png
Revenue Section (No Company Selected - aggregated sum of overall property-wide corporate production)
Image 10-19-26 at 9.59β€―AM.png
Revenue Section (Company Selected - production strictly for that selected account)
2. Statistics Section

Tracks physical room volume, arrival/departure counts, and reservation turnover metrics generated by corporate accounts.

  • Primary Use: Analyzing corporate room night production, evaluating account cancellation ratios, and identifying high no-show patterns.

  • Key Metrics: Transaction Type (Arrival Rooms, Cancelled Rooms, Day Use Rooms, Departure Rooms, No Show Rooms, Room Nights), Year, January – December, Totals.

Image 10-19-26 at 10.03β€―AM.png
Statistics Section (No Company Selected - aggregated sum of overall property-wide corporate production)

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 15 exact dynamic columns available across both report sections, sorted in alphabetical order by column name:

πŸ’° Calculation & Accounting Logic:

  • Section 1 Totals: Totals = SUM(January:December) for each revenue stream.

  • Total Revenue: Total Revenue = Revenue Accommodation + Revenue Food + Revenue Beverage + Revenue Other.

  • Section 2 Totals: Totals = SUM(January:December) for each physical stay metric.

  • Net Yield / ADR: Derived as Revenue Accommodation Γ· Room Nights.

All financial figures represent net amounts excluding taxes and service fees.

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

April

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of April.

Revenue Ledger / Statistics Subledger

❌ No

August

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of August.

Revenue Ledger / Statistics Subledger

❌ No

December

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of December.

Revenue Ledger / Statistics Subledger

❌ No

February

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of February.

Revenue Ledger / Statistics Subledger

❌ No

January

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of January.

Revenue Ledger / Statistics Subledger

❌ No

July

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of July.

Revenue Ledger / Statistics Subledger

❌ No

June

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of June.

Revenue Ledger / Statistics Subledger

❌ No

March

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of March.

Revenue Ledger / Statistics Subledger

❌ No

May

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of May.

Revenue Ledger / Statistics Subledger

❌ No

November

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of November.

Revenue Ledger / Statistics Subledger

❌ No

October

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of October.

Revenue Ledger / Statistics Subledger

❌ No

September

Both Sections

Monetary revenue generated (Section 1) or physical room count recorded (Section 2) during the month of September.

Revenue Ledger / Statistics Subledger

No

Totals

Both Sections

Cumulative annual sum of revenue (Section 1) or physical room metrics (Section 2) across all 12 operating months

Calculated: Cumulative 12-Month Total

❌ No

Transaction Type

Both Sections

Descriptive categorization of the revenue stream (Revenue Accommodation, Revenue Food, Revenue Beverage, Revenue Other, Total Revenue) in Section 1, or operational room metric (Arrival Rooms, Cancelled Rooms, Departure Rooms, Room Nights, No Show Rooms, Day Use Rooms) in Section 2.

Reporting Engine > Classification Label

N/A

Year

Both Sections

Operating calendar year represented by the report data row (e.g., 2026).

System Calendar > Fiscal / Calendar Year

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:

    • Standardized Optimal Layout (Both Sections)

      • Transaction Identifiers & Annual Total (Cols 1–3): Transaction Type | Year | Totals

      • Monthly Breakdown (Cols 4–15): January | February | March | April | May | June | July | August | September | October | November | December

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

Advanced Controls
  • Annual Contract Renewal Audits: Run the report for a specific corporate client prior to rate renegotiations to verify if negotiated room night thresholds (Totals under Room Nights) were achieved.

  • Filtering: Leave the Company Account filter blank to generate total property-wide corporate production, or select an individual company profile from the search dropdown.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight peak revenue months, high no-show months (No Show Rooms > 10), or low room night volume quarters.

Within 🀝 Sales, Groups & Events Reports & 🏒 Corporate Accounts:

Cross-Pillar Deep Dives: