Invoice Summary .ng | HotelKey Knowledge Base

Invoice Summary Report Overview

Parent Hub: 💰 Finance & Accounting Reports

Category: 📬 Billing & Receivables (AR)

Target Roles: Directors of Finance & Controllers, Accounting Managers & Clerks, AR Specialists

Key Value: Provide executive-level visibility into macro accounts receivable health by consolidating open, closed, and voided invoice counts alongside their respective financial balances per corporate account.

Executive Summary

The Invoice Summary Report is a macro-level accounts receivable governance tool within the 📬 Billing & Receivables (AR) module. Designed for executive oversight, it aggregates city ledger invoice billing history into consolidated, account-level summary totals across corporate clients and direct-bill accounts.

By evaluating both invoice volume (Open, Closed, Voided, and Total Invoices) and monetary value (Total Open, Settled, Balance, Closed, Voided, and Total Invoices Amount) per company, this report empowers controllers and finance leads to monitor account billing health, track void ratios, evaluate client payment velocity, and assess total city ledger risk exposure without getting lost in individual line-item details.

Key Capabilities

Dual Volume & Value Tracking: Simultaneously audits invoice volume counts alongside total financial amounts across all invoice lifecycle states.
Complete Lifecycle Segmentation: Categorizes billing history into Open (active unpaid), Settled (partially paid), Closed (fully paid), and Voided (cancelled/invalidated) status buckets.
Voided Revenue Governance: Isolates voided invoice counts and amounts (Voided Invoices Amount) to enforce internal controls and prevent unrecorded revenue write-offs.

Report Views & Functional Breakdown

The Invoice Summary Report presents consolidated billing data across three structured analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                         INVOICE SUMMARY REPORT                         │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Account Billing       │ 2. Outstanding Balance & │ 3. Closed & Void │
│    Volume Audit          │    Settlement Audit      │    Audit Ledger  │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Account Billing Volume Audit

Evaluates invoice processing volume across active corporate accounts by tracking total generated invoices against lifecycle states.

Primary Use: Monitoring billing transaction activity and evaluating client administrative workload per corporate account.
Key Metrics: Company Name, Company Code, Status, Open Invoices, Closed Invoices, Voided Invoices, Total Invoices.

2. Outstanding Balance & Settlement Audit

Tracks open invoice liabilities, applied partial settlements, and remaining unpaid account balances.

Primary Use: Assessing active city ledger credit exposure, prioritizing collection outreach, and auditing client payment velocity.
Key Metrics: Total Open Invoice Amount, Settled Invoice Amount, Balance Invoice Amount, Total Invoices Amount.

3. Closed & Void Audit Ledger

Isolates financial values associated with fully settled (closed) invoices and cancelled/voided invoices.

Primary Use: Verifying completed revenue collection and auditing voided invoice amounts for supervisory compliance.
Key Metrics: Closed Invoices Amount, Voided Invoices Amount, Voided Invoices (Count), Total Invoices Amount.

Image 8-11-26 at 9.52 PM.png — Invoice Summary

Data Dictionary (Dynamic View Columns)

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

💡 Tax Treatment Note: All monetary amount fields (Total Open Invoice Amount, Settled Invoice Amount, Balance Invoice Amount, Closed Invoices Amount, Voided Invoices Amount, and Total Invoices Amount) represent Gross Amounts (Includes Taxes & Fees).

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Company Name	Official name of the contracted corporate account or direct-bill client.	`Company Profile > Name`	N/A
Company Code	Unique identifier code assigned to the corporate account.	`Company Profile > Code`	N/A
Status	Active status of the corporate account profile (`ACTIVE`, `INACTIVE`).	`Company Profile > Status`	N/A
Open Invoices	Total count of generated invoices currently in an open/unpaid state.	`COUNT(Open Invoices)`	N/A
Closed Invoices	Total count of fully paid and settled invoices.	`COUNT(Closed Invoices)`	N/A
Voided Invoices	Total count of cancelled or invalidated invoices.	`COUNT(Voided Invoices)`	N/A
Total Invoices	Total cumulative count of all generated invoices across all states.	`SUM(Open + Closed + Voided)`	N/A
Total Open Invoice Amount	Gross total face value of all currently open invoices.	`SUM(Open Invoices Gross Amount)`	🟢 Yes
Settled Invoice Amount	Gross total payments applied toward open invoices.	`SUM(Applied Partial Settlements)`	🟢 Yes
Balance Invoice Amount	Gross net remaining unpaid balance on open invoices.	`Total Open Amount - Settled Amount`	🟢 Yes
Closed Invoices Amount	Gross total value of all fully settled and closed invoices.	`SUM(Closed Invoices Gross Amount)`	🟢 Yes
Voided Invoices Amount	Gross total value of all voided or cancelled invoices.	`SUM(Voided Invoices Gross Amount)`	🟢 Yes
Total Invoices Amount	Cumulative gross monetary value generated across all invoices.	`SUM(Open + Closed + Voided Amount)`	🟢 Yes

Customization & Platform Features

User & Property Preferences

Personal Preference: Tailor your individual view by hiding or dragging columns. Your preference saves 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 3 logical blocks:
- Account Context (Cols 1–3): Company Name | Company Code | Status
  
  Invoice Volume & Counts (Cols 4–7): Total Invoices | Open Invoices | Closed Invoices | Voided Invoices
  
  Financial Balances & Settlement (Cols 8–13): Total Invoices Amount | Total Open Invoice Amount | Settled Invoice Amount| Balance Invoice Amount | Closed Invoices Amount | Voided Invoices Amount

Advanced Controls

Exporting & Executive Distribution: Download in Excel or PDF format to present high-level accounts receivable summaries to General Managers or corporate controllers.
Filtering: Filter data by specific date ranges, corporate account status, or minimum open invoice balances.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight accounts with high void ratios (Voided Invoices > 2) or open balances exceeding authorized thresholds.

Within 📬 Billing & Receivables (AR):

Invoice Details Report – Line-item deep dive breaking down every individual charge, tax, and settlement within generated invoices.
Statement of Invoice Report – Audit corporate billing lifecycles broken down into Open and Closed invoice sections.
AR Invoice Aging Report – Categorize open invoice balances across 30-day time bands.
Accounts Receivable Activity Report – Track every detailed transaction hitting the AR ledger.
Direct Bill Aging Report – Segment corporate debt across AR, Invoices, and Settlements.

Cross-Pillar Deep Dives:

⚖️ Ledgers & Trial Balance: To reconcile total city ledger balances against property general ledger accounts, review Direct Bill Ledger Details Report.
💳 Payments & Transactions: To inspect corporate checks, wire receipts, or credit card settlements applied to these invoices, cross-reference Payment Activity or Payment Transactions.
📈 Forward Revenue & Analytics: Looking for forward-facing revenue projections or macro performance metrics (like RevPAR or ADR)? Please visit the [📈 Revenue & Analytics] reporting hub.