Revenue Summary .ng | HotelKey Knowledge Base

Revenue Summary 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: Audit daily property-wide revenue postings, track gross vs. net revenue realizations, evaluate departmental charge type configurations, and reconcile itemized tax accruals across municipal and state jurisdictions.

Executive Summary

The Revenue Summary Report is a primary financial audit and tax reconciliation document within the 📊 Performance Summaries category of the 📈 Revenue & Analytics hub. Designed to deliver comprehensive transaction-level transparency across all property earning centers, it pairs daily charge postings with their corresponding tax accruals, charge categories, and general ledger system classifications.

By mapping calendar business dates (Date, Day Of Week) and charge code configurations (Charge Type, Transaction Code, Charge Type Category, System Category) directly to financial ledger metrics (Revenue Including Taxes, Revenue Excluding Taxes, Total Taxes) and itemized statutory tax columns (STATE TAX, CITY TAX, VAT, Service Charge, Stay Enhancement Tax, Occupancy Tax), this report enables controllers, revenue managers, and accounting staff to audit gross vs. net revenue realizations, verify tax calculation accuracy across jurisdictions, and ensure seamless general ledger posting tie-outs.

Key Capabilities

Transaction-Level Revenue & Tax Governance: Itemizes daily charge code activity (Transaction Code) alongside gross revenue (Revenue Including Taxes), net base revenue (Revenue Excluding Taxes), and cumulative tax accruals (Total Taxes).
Multi-Jurisdictional Tax Breakdown: Unbundles itemized statutory tax liabilities across state tax (STATE TAX), municipal/city tax (CITY TAX), value-added tax (VAT 10 PER), service fees (Service charge), and regional occupancy levies (Occupancy 2, Stay Enhancement Tax).
System & Departmental Category Traceability: Maps every active charge code to both property-defined categories (Charge Type Category like ROOM RENT, STAY, OUTLET 1, BAR 1, TRANSPORTATION, LAUNDRY) and core system engine categories (System Category like ROOM_RENT, FOOD, MISC_CHARGE).

Report Views & Functional Breakdown

The Revenue Summary Report presents daily revenue postings and tax accruals in a unified single-table matrix that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                      REVENUE SUMMARY REPORT                            │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Charge Code & System  │ 2. Gross vs. Net Revenue │ 3. Statutory Tax │
│    Categorization Audit  │    Realization           │    Accrual Audit │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Charge Code & System Categorization Audit

Audits individual transaction codes, charge type descriptions, and GL posting category assignments.

Primary Use: Verifying charge code mappings (Transaction Code), checking departmental charge categories (Charge Type Category), and ensuring correct revenue routing to core system categories (System Category).
Key Metrics: Date, Day Of Week, Charge Type, Transaction Code, Charge Type Category, System Category.

2. Gross vs. Net Revenue Realization

Monitors daily transaction postings comparing gross revenue collected against net base revenue earned after tax exclusions.

Primary Use: Evaluating gross collection volume (Revenue Including Taxes), auditing net base revenue realizations (Revenue Excluding Taxes), and assessing departmental revenue contribution shares across room, food/beverage, and incidental outlets.
Key Metrics: Date, Charge Type, Transaction Code, Revenue Including Taxes, Revenue Excluding Taxes.

3. Statutory Tax Accrual Audit

Itemizes tax dollar accruals generated by each specific charge code posting across active municipal, state, and local tax rules.

Primary Use: Reconciling tax liabilities during night audit close, verifying tax-inclusive vs. tax-exclusive rate calculations, and preparing monthly municipal/state tax remittance schedules.
Key Metrics: Date, Transaction Code, Revenue Excluding Taxes, Property Configured Taxes (e.g., STATE TAX, CITY TAX, VAT 10 PER, City Tax for SE 3 Percent, Service charge, State Tax for SE 7 Percent, Stay Enhancement Tax 7, OCCUPANCY 2), Total Taxes.

Image 10-6-26 at 8.27 PM.png — Revenue Summary Report

Data Dictionary (Dynamic View Columns)

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

💡 Monetary & Tax Calculation Note: Revenue Including Taxes represents Gross Revenue (Includes Taxes & Fees). Revenue Excluding Taxes represents Net Base Revenue (Excludes Taxes & Fees). Total Taxes is calculated as Total Taxes = Revenue Including Taxes - Revenue Excluding Taxes and represents the sum of all itemized tax columns (STATE TAX, CITY TAX, etc.).

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Date	Official business date on which the revenue transaction charge was posted.	System Business Date	N/A
Day Of Week	Calendar day of the week corresponding to the posting date (e.g., Monday, Tuesday).	System Calendar Engine	N/A
Charge Type	Human-readable title of the posting charge code (e.g., Accommodation, Manual Guest Room, No Show Fee, Late Cancel Room Revenue, Bar-Lounge Outlet 1 Breakfast - Food, Valet Parking, Guest Laundry).	Charge Code Setup Master	N/A
Transaction Code	Unique alphanumeric or numerical identifier assigned to the charge code (e.g., `RR`, `MRR`, `NSFC`, `CVRR`, `1303`, `1304`, `1310`, `1313`, `2000`, `2030`, `3000`, `5100`, `5102`, `5301`, `5302`, `5303`, `15000`, `15100`, `15200`, `15800`).	Transaction Code Configuration	N/A
Charge Type Category	Property-defined departmental charge group (e.g., ROOM RENT, STAY, OUTLET 1, BAR 1, TRANSPORTATION, LAUNDRY, MISC).	Charge Category Setup	N/A
System Category	Core system engine classification used for global financial reporting (e.g., ROOM_RENT, FOOD, MISC_CHARGE).	System Revenue Mapping	N/A
Revenue Including Taxes	Gross monetary revenue collected, inclusive of all statutory taxes and fees.	`Revenue Excluding Taxes + Total Taxes`	🟢 Yes
Revenue Excluding Taxes	Net base room or outlet revenue earned, excluding all taxes and fees.	`Folio Ledger > Net Base Charges`	❌ No
VAT 10 PER	Value-added tax accrued at the 10% statutory rate.	Tax Calculation Engine	🟢 Yes
STATE TAX	State-level statutory tax liabilities accrued for the transaction.	Tax Calculation Engine	🟢 Yes
City Tax for SE 3 Percent	Municipal city tax accrued at the 3% rate for special enhancement zones.	Tax Calculation Engine	🟢 Yes
Service charge	Mandatory property or outlet service charge fees accrued.	Fee Engine Mapping	🟢 Yes
CITY TAX	Local municipal or city accommodation tax liabilities accrued.	Tax Calculation Engine	🟢 Yes
State Tax for SE 7 Percent	State tax accrued at the 7% rate for special enhancement zones.	Tax Calculation Engine	🟢 Yes
Stay Enhancement Tax 7	Local stay enhancement tax accrued at the 7% rate.	Tax Calculation Engine	🟢 Yes
OCCUPANCY 2	Secondary municipal occupancy tax or flat room fee accrued.	Tax Calculation Engine	🟢 Yes
Total Taxes	Consolidated total statutory tax dollar liabilities accrued for the transaction code posting.	`SUM(Itemized Tax Columns)`	🟢 Yes

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:
- Audit Timeline & GL Identifiers (Cols 1–4): Date | Day Of Week | Transaction Code | Charge Type
- Category & System Classifications (Cols 5–6): Charge Type Category | System Category
- Gross vs. Net Revenue Anchors (Cols 7–8): Revenue Including Taxes | Revenue Excluding Taxes
- Itemized Tax Liabilities by Jurisdiction (Cols 9–16): Property Specific Tax Types (e.g., City Tax, State, Tax)
- Total Tax Liability (Col 17): Total Taxes

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 Summary Report features an interactive pie chart to help analyze revenue and tax distribution across posting categories. Users can group transaction records on the fly by Charge Type Category, Charge Type, or Date to analyze revenue posting distributions. By selecting a metric from the Select Base Column dropdown menu—such as Revenue Excluding Taxes, Revenue Including Taxes, or Total Taxes—the chart dynamically displays percentage share breakdowns alongside an interactive color-coded legend.

Image 10-6-26 at 8.29 PM.png — *Group By & Pie Chart Visualization*

Bar Chart Visualizer: The Revenue Summary Report includes a customizable bar chart to help visualize daily financial totals and tax collections across a defined date range. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically switch the chart to display gross revenue (Revenue Including Taxes), net revenue (Revenue Excluding Taxes), or individual tax and fee breakdowns (such as Total Taxes, STATE TAX, or Service charge) alongside the detailed transaction table.

Image 10-6-26 at 8.30 PM.png — *Bar Chart Visualizer*

Advanced Controls

Exporting & General Ledger Tie-Outs: Download in Excel or PDF format to support night audit balancing, month-end general ledger reconciliations, and municipal tax return filings.
Filtering: Filter data by specific Transaction Code, System Category (ROOM_RENT, FOOD, MISC_CHARGE), or date ranges.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-value tax accruals, room rate adjustments, or negative charge entries.

Within 📈 Revenue & Analytics & 📊 Performance Summaries:

Revenue Activity – Line-item transaction audit showing individual guest reservation charges, house accounts, and group master postings.
Net Revenue – Daily property-wide net revenue realizations across primary operational charge categories.
General Manager Report – Review property-wide macro statistics, total room revenues, ADR, and RevPAR performance.

Cross-Pillar Deep Dives:

🏛️ Taxes & Expenses: Reconcile statutory tax accruals against master tax configuration rules in Tax Summary or Active Taxes & Charge Types.
⚖️ Ledgers & Trial Balance: Verify general ledger posting tie-outs in Trial Balance or Day End Summary.