Invoice Summary Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π¬ Billing & Receivables (AR)
Target Roles: Accounts Receivable Managers, Credit Managers, Hotel Controllers, Staff Accountants, Billing Coordinators, Directors of Finance
Key Value: Corporate accounts receivable billing governance, tracking invoice volume distributions across open, closed, and voided statuses, evaluating client settlement efficiency, and auditing total open versus collected accounts receivable exposure by company account.
Date Parameter: Date Range Selector (Start / End Date) | Past Only | Maximum Range: none
Executive Summary
The Invoice Summary report is an essential high-level credit control, invoicing audit, and accounts receivable reconciliation document within the π¬ Billing & Receivables (AR) category of the π° Finance & Accounting Reports hub. Designed to provide finance directors and controllers with consolidated commercial billing intelligence, it aggregates all accounts receivable invoicing activity across corporate direct bill accounts, airline contracts, and travel agencies over a selected date range.
-
Centered on account-level billing governance through the unified Invoice Summary section, this report correlates corporate client profiles (
Company Name,Company Code,Status) with quantitative invoice counts (Open Invoices,Closed Invoices,Voided Invoices,Total Invoices) and financial valuation metrics (Total Open Invoice Amount,Settled Invoice Amount,Balance Invoice Amount,Closed Invoices Amount,Voided Invoices Amount,Total Invoices Amount). By contrasting open unsettled balances against fully paid statements and voided billings, this report enables property controllers to benchmark client payment performance, monitor corporate billing volume, prioritize collection follow-ups, and ensure strict alignment between accounts receivable subledgers and general ledger balances.
Key Capabilities
-
Comprehensive Invoice Volume Distribution: Categorizes total generated invoice counts across distinct operational lifecycle stages: active unpaid statements (
Open Invoices), fully settled billings (Closed Invoices), and cancelled records (Voided Invoices). -
Complete Monetary Portfolio Valuation: Aggregates gross invoiced debt (
Total Invoices Amount) alongside current outstanding exposure (Balance Invoice Amount) and collected revenue (Closed Invoices Amount). -
Partial Settlement & Open Balance Tracking: Reconciles open invoice debt by isolating original gross open billings (
Total Open Invoice Amount), applied partial cash settlements (Settled Invoice Amount), and net remaining open liability (Balance Invoice Amount). -
Voided & Cancelled Billing Audit: Quantifies cancelled corporate invoices (
Voided Invoices,Voided Invoices Amount) to audit billing adjustments, rebills, and administrative invoice voids. -
Corporate Account Master Synchronization: Displays company profile metadata (
Company Name,Company Code,Status) to substantiate client identity and verify operational profile states.
Report Views & Functional Breakdown
The Invoice Summary report structures commercial invoicing data into a unified single-table master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β INVOICE SUMMARY REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Account Profile & β 2. Invoice Volume Counts β 3. Monetary β
β Operational Status β (Open/Closed/Voided) β Valuations β
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Account Profile & Operational Status
Monitors corporate debtor credentials, client identification codes, and profile active states in the master directory.
-
Primary Use: Identifying debtor companies and verifying client account codes.
-
Key Metrics: Company Name, Company Code, Status.
2. Invoice Volume Counts (Open / Closed / Voided)
Tracks quantitative billing transactions generated across each operational status category during the reporting window.
-
Primary Use: Auditing invoice volume, measuring transaction processing output, and tracking the proportion of paid vs. unpaid statements.
-
Key Metrics: Open Invoices, Closed Invoices, Voided Invoices, Total Invoices.
3. Monetary Valuations & Settlement Balances
Itemizes financial totals across open, closed, voided, and partially settled invoices to establish net outstanding customer exposure.
-
Primary Use: Monitoring cash collection velocity, identifying client debt concentrations, auditing voided invoice amounts, and evaluating credit risk.
-
Key Metrics: Total Open Invoice Amount, Settled Invoice Amount, Balance Invoice Amount, Closed Invoices Amount, Voided Invoices Amount, Total Invoices Amount.
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 13 exact dynamic columns available in this report, sorted in alphabetical order by column name:
π° Financial Balancing & Mathematical Calculation Logic:
Invoice Count Parity: Total Invoice} = Open Invoices + Closed Invoices + Voided Invoices.
Open Balance Valuation: Balance Invoice Amount = Total Open Invoice Amount - Settled Invoice Amount.
Gross Portfolio Valuation: Total Invoices Amount = Total Open Invoice Amount + Closed Invoices Amount + Voided Invoices Amount.
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Balance Invoice Amount |
Remaining unpaid balance on open accounts receivable invoices for the company. |
Calculated: (Total Open Invoice Amount - Settled Invoice Amount) |
π’ Yes |
|
Closed Invoices |
Total count of fully settled, paid, and closed accounts receivable invoices issued to the company during the reporting period. |
AR Invoicing Engine > Closed Invoice Count |
N/A |
|
Closed Invoices Amount |
Total cumulative monetary value of all fully paid and closed accounts receivable invoices. |
AR Invoicing Engine > Closed Invoiced Total |
π’ Yes |
|
Company Code |
Unique corporate alphanumeric identifier or city ledger account code assigned to the direct billing account (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 |
|
Open Invoices |
Total count of accounts receivable invoices currently carrying an unsettled, unpaid, or partially paid balance. |
AR Invoicing Engine > Open Invoice Count |
N/A |
|
Settled Invoice Amount |
Cumulative monetary payments, partial settlements, or credits applied against open invoices. |
AR Cashiering > Open Invoice Payments |
π’ Yes |
|
Status |
Operational lifecycle state of the corporate profile in the property management system (e.g., |
Company Master > Account Status |
N/A |
|
Total Invoices |
Cumulative total count of accounts receivable invoices generated for the company. |
Calculated: (Open Invoices + Closed Invoices + Voided Invoices) |
N/A |
|
Total Invoices Amount |
Cumulative gross monetary value of all invoices generated for the company (Total Open Invoice Amount + Closed Invoices Amount + Voided Invoices Amount). |
Calculated: (Total Open Invoice Amount + Closed Invoices Amount + Voided Invoices Amount) |
π’ Yes |
|
Total Open Invoice Amount |
Total original gross invoiced monetary value of all currently open accounts receivable invoices. |
AR Invoicing Engine > Gross Open Invoiced Total |
π’ Yes |
|
Voided Invoices |
Total count of accounts receivable invoices formally cancelled, voided, or reversed. |
AR Invoicing Engine > Voided Invoice Count |
N/A |
|
Voided Invoices Amount |
Total cumulative monetary value of all voided or cancelled accounts receivable invoices. |
AR Invoicing Engine > Voided Invoiced Total |
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|StatusInvoice Volume & Counts (Cols 4β7):
Total Invoices|Open Invoices|Closed Invoices|Voided InvoicesFinancial Balances & Settlement (Cols 8β13):
Total Invoices Amount|Total Open Invoice Amount|Settled Invoice Amount|Balance Invoice Amount|Closed Invoices Amount|Voided Invoices Amount
-
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. |
|
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. |
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.
π Related Reports & Next Steps
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 Report.
-
π Forward Revenue & Analytics: Looking for forward-facing revenue projections or macro performance metrics (like RevPAR or ADR)? Please visit the π Revenue & Analytics reporting hub.