Company Accounts .ng | HotelKey Knowledge Base

Company Accounts Report Overview

Parent Hub: 💰 Finance & Accounting Reports

Category: 📬 Billing & Receivables (AR)

Target Roles: Accounts Receivable (AR) Managers, Directors of Finance & Controllers, Credit Managers, Sales & Corporate Account Managers

Key Value: Maintain corporate credit risk controls, audit direct-bill privileges, monitor corporate production yields, and evaluate accounts receivable credit limits across contracted corporate profiles.

Executive Summary

The Company Accounts Report is a primary credit risk governance and corporate accounts receivable management document within the 📬 Billing & Receivables (AR) section of the 💰 Finance & Accounting Reports hub. Designed to support corporate credit auditing, direct-bill privilege verification, and corporate sales yield analysis, it provides a comprehensive ledger logging corporate profile attributes alongside production performance metrics over a selected date range.

By combining master corporate identifiers (Company Name, Company Code) and direct-bill configuration parameters (Direct Bill Privilege, Status, Credit Limit) with real-time stay production metrics (Date, Total Guests, Total Revenue, Total Nights, Average Revenue Per Night), this report enables controllers, credit managers, and sales teams to audit direct-bill authorization status (YES/ACTIVE vs. NO/None), monitor corporate credit limit caps, evaluate account production performance, and enforce property credit policy compliance.

Key Capabilities

Corporate Credit & Direct-Bill Privilege Audit: Identifies corporate profiles authorized for direct-bill city ledger privileges (Direct Bill Privilege = YES, Status = ACTIVE) versus non-direct-bill accounts (NO).
Credit Limit Risk Control: Tracks authorized corporate credit caps (Credit Limit) to prevent account balances from exceeding pre-approved credit lines.
Corporate Production & Yield Tracking: Measures total guest headcounts (Total Guests), cumulative room nights (Total Nights), gross corporate revenue (Total Revenue), and average rate yield (Average Revenue Per Night).
Daily Account Activity Traceability: Logs daily date-by-date corporate stay transactions (Date) to support invoicing and accounts receivable statement generation.

Report Views & Functional Breakdown

The Company Accounts Report presents corporate account performance in a unified single-table operational ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                        COMPANY ACCOUNTS REPORT                         │
├────────────────────────────────────────────────────────────────────────┤
│                       Unified Operational Ledger                       │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Account Authorization │ 2. Corporate Yield &     │ 3. Credit Limit  │
│    & Status Audit        │    Production Metrics    │    & Risk Control│
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Account Authorization & Status Audit

Monitors corporate master profile setups, direct-bill billing authorization statuses, and account activity states.

Primary Use: Verifying active direct-bill account setups (Direct Bill Privilege = YES, Status = ACTIVE), auditing non-direct-bill corporate stays (Direct Bill Privilege = NO), and identifying corporate account codes (Company Code).
Key Metrics: Date, Company Name, Company Code, Direct Bill Privilege, Status.

2. Corporate Yield & Production Metrics

Evaluates guest room night volume, gross revenue generation, and average rate yield for each corporate account.

Primary Use: Ranking top corporate accounts by total revenue (Total Revenue) and room nights (Total Nights), assessing corporate account profitability (Average Revenue Per Night), and supporting sales contract renegotiations.
Key Metrics: Date, Company Name, Total Guests, Total Revenue, Total Nights, Average Revenue Per Night.

3. Credit Limit & Risk Control

Audits authorized direct-bill credit caps to manage corporate accounts receivable risk exposure.

Primary Use: Monitoring direct-bill credit caps (Credit Limit), ensuring high-volume corporate accounts hold sufficient credit lines, and auditing corporate payment privileges.
Key Metrics: Company Name, Direct Bill Privilege, Credit Limit, Total Revenue.

Image 10-7-26 at 10.28 AM.png — Company Accounts 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 & Yield Calculation Note: Total Revenue represents Gross Corporate Revenue (Excludes Taxes & Fees) generated from room stays during the period. Average Revenue Per Night is calculated as Average Revenue Per Night = Total Revenue ÷ Total Nights.

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Date	Official business date associated with the corporate stay activity.	System Business Date	N/A
Company Name	Full legal or commercial title of the contracting corporate account (e.g., AMERICAN AIRLINES, ACME DESIGN, CORPORATE LODGING, HOTELKEY, INC.).	Corporate Profile Setup	N/A
Company Code	Unique alphanumeric master identifier code assigned to the corporate profile (e.g., `AA`, `ACME`, `CLC`, `HTLKEY`).	Corporate Profile Setup	N/A
Direct Bill Privilege	Indicates whether the corporate account is pre-approved for direct-bill city ledger posting (`YES` / `NO`).	Corporate Credit Config	N/A
Status	Active operational status of the direct-bill credit profile (`ACTIVE` / `None`).	Corporate Credit Config	N/A
Credit Limit	Maximum pre-approved dollar limit authorized for direct-bill city ledger balances (e.g., `$10,000.00`, `$100,000.00`).	Corporate Credit Config	❌ No
Total Guests	Registered guest occupant headcount associated with corporate stays on the business date.	`Reservation > Occupancy`	N/A
Total Revenue	Gross base room revenue generated by the corporate account on the business date.	`SUM(Corporate Room Charges)`	❌ No
Total Nights	Cumulative room nights occupied by corporate guests on the business date.	Stay Nights Counter	N/A
Average Revenue Per Night	Realized Average Daily Rate (ADR) earned per corporate room night (`Total Revenue / Total Nights`).	`Total Revenue / Total Nights`	❌ No

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:
- Corporate Account Identifiers (Cols 1–2): Company Code | Company Name
- Credit & Direct Bill Controls (Cols 3–5): Status | Direct Bill Privilege | Credit Limit
- Audit Timeline Parameter (Col 6): Date
- Production Volumes & Revenue Yields (Cols 7–10): Total Guests | Total Nights | Total Revenue | Average Revenue Per Night

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 Company Accounts report features an interactive pie chart to analyze corporate account production and revenue contributions. Users can group corporate records on the fly by Company Name or Company Code to analyze account performance. By selecting a metric from the Select Base Column dropdown menu—such as Total Guests, Total Revenue, Total Nights, or Average Revenue Per Night—the chart dynamically displays percentage share breakdowns accompanied by an interactive color-coded legend.

Image 10-7-26 at 10.33 AM.png — *Group By & Pie Chart Visualization*

Bar Chart Visualizer: The Company Accounts report includes an interactive bar chart to help visualize corporate account trends and production over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically toggle the chart view to plot guest counts (Total Guests), revenue totals (Total Revenue), or room nights (Total Nights) alongside the detailed corporate account data grid.

Image 10-7-26 at 10.35 AM.png — *Bar Chart Visualizer*

Advanced Controls

Exporting & AR Auditing: Download in Excel or PDF format to support corporate accounts receivable aging reconciliations, credit limit reviews, and corporate sales contract audits.
Filtering: Filter data by specific Direct Bill Privilege (YES), Company Name, or non-zero Total Revenue (Total Revenue > $0.00).
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-revenue corporate accounts, profiles with high credit limits, or accounts with Direct Bill Privilege = NO.

Within 📬 Billing & Receivables (AR) & 💰 Finance & Accounting Reports:

Direct Bill Ledger Details – Deep dive into individual direct-bill folio transfers, invoice numbers, and city ledger aging balances.
Settlement By Payment Type – Audit direct-bill settlements (BILL TO COMPANY) processed at checkout.

Cross-Pillar Deep Dives:

📈 Revenue & Analytics: Cross-reference corporate account production against Market Segment Summary or Revenue Activity.