Invoice Summary .ng

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.

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 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., 225, 539, 31).

Company Master > Company Code

N/A

Company Name

Registered commercial trade name, corporate billing account, or agency title (e.g., CRETE CARRIER CORP, CLC, NE STATE PATROL).

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., ACTIVE, INACTIVE).

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 | 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

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.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.

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):

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.