Company Accounts .ng

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 = YES vs. 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.

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 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 Nights equals zero (e.g., day-use or non-room adjustments), Average Revenue Per Night reflects 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., 000003137, 000016434).

Company Master > Company Code

N/A

Company Name

Registered commercial trade name, corporate billing account, or agency title (e.g., STATE FARM INSURANCE COMPANY, NEBRASKA PUBLIC POWER DISTRICT).

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 (YES or NO).

Company Profile > Direct Bill Authorization

N/A

Status

Operational lifecycle state of the corporate profile in the PMS directory (e.g., ACTIVE, INACTIVE).

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

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.51β€―PM.png

Bar Chart

Displays report data in a visual bar chart format.

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.

Image 9-29-26 at 12.53β€―PM.png

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:

Cross-Pillar Deep Dives: