Company Accounts Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π¬ Billing & Receivables (AR)
Target Roles: Accounts Receivable Managers, Directors of Sales, Corporate Sales Managers, Hotel Controllers, Revenue Managers, General Managers
Key Value: Corporate account production analysis, tracking company room night volume and revenue generation, auditing direct billing privileges and credit limits, evaluating corporate Average Revenue Per Night (ADR), and monitoring commercial account performance over designated operating windows.
Date Parameter: Date Range Selector (Start / End Date) | Past Only | Maximum Range: 365 Days
Executive Summary
The Company Accounts report is an essential corporate portfolio governance, commercial sales production, and direct bill credit auditing document within the π¬ Billing & Receivables (AR) category of the π° Finance & Accounting Reports hub. Designed to bridge property sales production with back-office accounts receivable administration, it itemizes the daily lodging volume, guest counts, room nights, and room revenue generated by contracted corporate clients, travel agencies, and third-party billing accounts.
-
Centered on commercial account management through the unified Company Accounts section, this report correlates client profile metadata (
Company Name,Company Code,Direct Bill Privilege,Status,Credit Limit) with chronological stay dates (Date) and key production indicators (Total Guests,Total Revenue,Total Nights,Average Revenue Per Night). This multi-dimensional visibility allows finance and revenue teams to audit direct billing authorizations, track client contract performance against negotiated room night commitments, assess account profitability, and monitor authorized credit limits before approving extended direct billing terms.
Key Capabilities
-
Corporate Production & Volume Auditing: Tracks daily lodging output per corporate client, detailing occupant counts (
Total Guests), occupied room inventory (Total Nights), and net room revenue (Total Revenue). -
Direct Bill Privilege Governance: Audits whether accounts maintain authorized direct billing privileges (
Direct Bill Privilege = YESvs.NO), ensuring non-approved corporate accounts settle charges via credit card at check-in or checkout. -
Corporate Yield & ADR Benchmarking: Calculates client-specific average daily room rates (
Average Revenue Per Night), enabling sales directors to measure corporate rate integrity against contracted corporate negotiated rates. -
Credit Exposure Monitoring: Displays established corporate credit ceilings (
Credit Limit) alongside production figures to evaluate credit utilization and mitigate bad debt exposure. -
Profile Status Verification: Validates account operational lifecycles (
Status = ACTIVE), identifying dormant, expired, or suspended corporate profiles.
Report Views & Functional Breakdown
The Company Accounts report presents account production and credit parameters in a unified master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β COMPANY ACCOUNTS REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Account Profile & β 2. Stay Volume & β 3. Financial β
β Credit Privileges β Occupancy Activity β Yield & ADR β
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Account Profile & Credit Privileges
Tracks corporate master profile identifiers, operational account statuses, direct billing permissions, and authorized credit lines.
-
Primary Use: Verifying corporate direct bill eligibility, reviewing credit limits, and confirming account active states.
-
Key Metrics: Company Name, Company Code, Direct Bill Privilege, Status, Credit Limit.
2. Stay Volume & Occupancy Activity
Details the physical room night volume and guest counts generated on each operating calendar date.
-
Primary Use: Measuring commercial room production, auditing corporate traveler density, and tracking corporate contract room night thresholds.
-
Key Metrics: Date, Total Guests, Total Nights.
3. Financial Yield & ADR
Measures daily revenue output and calculates the achieved average daily room rate per corporate account.
-
Primary Use: Evaluating corporate rate yield, monitoring contracted discount adherence, and auditing corporate revenue performance.
-
Key Metrics: Total Revenue, Average Revenue Per Night.
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 10 exact dynamic columns available in this report, sorted in alphabetical order by column name:
π° Financial Posting & Yield Calculation Logic:
Average Revenue Per Night: Average Revenue Per Night: Calculated as Total Revenue Γ· Total Nights. On dates where
Total Nightsequals zero (e.g., day-use or non-room adjustments),Average Revenue Per Nightreflects zero.Total Revenue: Captures room accommodation charges generated by the company's travelers, excluding taxes and external pass-through fees.
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Average Revenue Per Night |
Daily corporate average daily room rate achieved for the company account. |
Calculated: Total Revenue Γ· Total Nights |
β No |
|
Company Code |
Unique alphanumeric client code or city ledger identifier assigned to the company profile (e.g., |
Company Master > Company Code |
N/A |
|
Company Name |
Registered commercial trade name, corporate billing account, or agency title (e.g., |
Company Master > Company Legal Name |
N/A |
|
Credit Limit |
Authorized maximum direct billing credit cap established in the corporate profile. |
Company Credit Master > Authorized Limit |
N/A |
|
Date |
Calendar date on which room nights, guest stays, and revenue production were recorded. |
Night Audit Ledger > Production Date |
N/A |
|
Direct Bill Privilege |
Indicates whether the company profile is authorized for direct billing to city ledger ( |
Company Profile > Direct Bill Authorization |
N/A |
|
Status |
Operational lifecycle state of the corporate profile in the PMS directory (e.g., |
Company Profile > Account Status |
N/A |
|
Total Guests |
Total number of individual guests staying in-house under the corporate profile on the designated date. |
In-House Ledger > Occupant Count |
N/A |
|
Total Nights |
Number of physical room nights occupied by travelers attached to the company account on the designated date. |
In-House Ledger > Room Night Count |
N/A |
|
Total Revenue |
Total net room revenue generated by the company's travelers on the designated date. |
Revenue Ledger > Room Charge Postings |
β 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
-
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 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.
-
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.
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.
π Related Reports & Next Steps
Within π¬ Billing & Receivables (AR) & π° Finance & Accounting Reports:
-
Direct Bill Ledger Details Report β Deep dive into individual direct-bill folio transfers, invoice numbers, and city ledger aging balances.
-
Settlement By Payment Type Report β 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 Report or Revenue Activity Report.