Statement of Invoice .ng

Statement of Invoice 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: Dual-section direct bill invoice governance, segregating outstanding customer debt from fully paid statements, auditing reservation batch volume per invoice, tracking settlement progression across net charges and statutory taxes, and monitoring invoice aging days to accelerate cash collections.

Date Parameter: Date Range Selector (Start / End Date) | Past Only | Maximum Range: 365 Days

Executive Summary

The Statement of Invoice report is an essential credit control, billing audit, and receivables settlement document within the πŸ“¬ Billing & Receivables (AR) category of the πŸ’° Finance & Accounting Reports hub. Designed to deliver complete administrative transparency over finalized commercial statements, it itemizes accounts receivable invoices generated over a selected historical date range, separating active unpaid receivables from fully settled customer accounts.

  • By organizing billing activity into 2 defined report sections: Open Invoices and Closed Invoices, this report establishes complete operational separation between uncollected debt and historical revenue collections. It correlates corporate client profiles (Company Name) with formal billing keys (Invoice Number, Invoice Date, Age), reservation batch metrics (Number of Reservations), settlement progression (Invoice Amount, Settled Amount, Invoice Balance), and financial revenue splits (Total Charges, Total Taxes, Total Amount). This structural distinction equips property controllers to identify aging collection bottlenecks, verify tax and charge breakdowns across multi-reservation corporate folios, audit zero-balance reconciliations, and ensure accurate direct bill ledger alignment.

Key Capabilities

  • Two-Section Invoice Lifecycle Segregation: Automatically categorizes direct billing statements into active unpaid portfolios (Open Invoices) and fully settled accounts (Closed Invoices).

  • Reservation Density & Batch Auditing: Tracks the physical volume of guest folios compiled into each corporate bill (Number of Reservations), providing clarity on consolidated group or corporate master statements.

  • Net Charge & Tax Disaggregation: Breaks down gross billings (Total Amount) into core room/incidental fees (Total Charges) and statutory lodging and occupancy taxes (Total Taxes).

  • Real-Time Settlement & Balance Verification: Monitors original invoice valuation (Invoice Amount) against received client payments (Settled Amount) to calculate exact remaining customer liability (Invoice Balance).

  • Aging & Delinquency Tracking: Measures the exact elapsed maturity of open invoices (Age), enabling credit managers to prioritize overdue corporate accounts and enforce contractual payment terms.

Report Views & Functional Breakdown

The Statement of Invoice report structures commercial invoicing activity across 2 defined sections:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                      STATEMENT OF INVOICE REPORT                       β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                       2 Defined Report Sections                        β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Open Invoices                 β”‚ 2. Closed Invoices                  β”‚
β”‚    (Active Unpaid & Partial AR)  β”‚    (Fully Settled Accounts)         β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Open Invoices Section (Active Unpaid & Partial AR)

Monitors all generated accounts receivable invoices carrying an outstanding, unpaid, or partially paid customer balance.

  • Primary Use: In-house credit control auditing, identifying overdue accounts, tracking aging days, and managing weekly collections workflows.

  • Key Metrics: Company Name, Invoice Number, Invoice Date, Age, Invoice Amount, Settled Amount, Invoice Balance, Number of Reservations, Total Charges, Total Taxes, Total Amount.

Image 8-13-26 at 9.13β€―AM.png
Open Invoices Section

2. Closed Invoices Section (Fully Settled Accounts)

Itemizes all historically generated invoices where the balance has been fully settled by customer payments, credits, or authorized adjustments.

  • Primary Use: Auditing completed payment reconciliations, reviewing multi-stay folio charge splits on paid bills, and substantiating past customer statements.

  • Key Metrics: Company Name, Invoice Number, Invoice Date, Age, Invoice Amount, Settled Amount, Invoice Balance, Number of Reservations, Total Charges, Total Taxes, Total Amount.

Image 8-13-26 at 9.25β€―AM.png
Closed Invoices Section

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 11 exact dynamic columns available across both report sections, sorted in alphabetical order by column name:

πŸ’° Financial Balancing & Calculation Logic:

  • Invoice Balance: Calculated dynamically as $\text{Invoice Balance} = \text{Invoice Amount} - \text{Settled Amount}$. In Section 2 (Closed Invoices), Invoice Balance always reflects zero ($0.00$).

  • Gross Line-Item Valuation: $\text{Total Amount} = \text{Total Charges} + \text{Total Taxes}$.

  • Batch Allocation: On multi-reservation master invoices (e.g., Section 2 line items where Number of Reservations $> 1$), individual stay lines reflect their respective share of charges and taxes, rolling up to the header Invoice Amount.

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

Age

Both Sections

Number of elapsed calendar days from the invoice issuance date to the report run date (or settlement date for closed invoices).

Calculated: Report Run Date - Invoice Date

N/A

Company Name

Both Sections

Registered commercial trade name, corporate billing entity, or agency title associated with the direct-billed invoice (e.g., Crete Carrier Corp, CLC, NE State Patrol).

Company Master > Company Legal Name

N/A

Invoice Amount

Both Sections

Total gross monetary value of the accounts receivable invoice statement.

AR Invoicing Engine > Gross Invoice Total

🟒 Yes

Invoice Balance

Both Sections

Remaining unpaid balance on the accounts receivable invoice.

Calculated: (Invoice Amount - Settled Amount)

🟒 Yes

Invoice Date

Both Sections

Calendar date on which the direct bill accounts receivable invoice was finalized and issued.

AR Invoicing Engine > Generation Date

N/A

Invoice Number

Both Sections

Unique master system accounts receivable invoice number assigned to the direct billing statement.

AR Billing Engine > Master Invoice ID

N/A

Number of Reservations

Both Sections

Total count of individual guest reservations or stay folios batched into the invoice.

AR Invoicing Engine > Batched Reservation Count

N/A

Settled Amount

Both Sections

Cumulative monetary payments, deposits, or credit adjustments applied against the invoice.

AR Cashiering > Applied Settlement Total

🟒 Yes

Total Amount

Both Sections

Total gross transaction amount (Total Charges + Total Taxes) for the line item or invoice.

Calculated: Gross Transaction Total

🟒 Yes

Total Charges

Both Sections

Net room accommodation and incidental charges posted on the invoice, excluding statutory taxes and fees.

Folio Subledger > Net Invoiced Charges

❌ No

Total Taxes

Both Sections

Applicable state, local occupancy, and municipal taxes assessed on the billed charges.

Tax Subledger > Assessed Invoiced Taxes

🟒 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 the logical blocks:

    • Section 1: Open Invoices

      • Invoice & Account Identifiers (Cols 1–4): Invoice Number | Invoice Date | Age | Company Name

      • Reservation Context (Col 5): Number of Reservations

      • Charges & Tax Breakdown (Cols 6–8): Total Charges | Total Taxes | Total Amount

      • AR Settlement & Balance Status (Cols 9–11): Invoice Amount | Settled Amount | Invoice Balance

    • Section 2: Closed Invoices

      • Invoice & Account Identifiers (Cols 1–4): Invoice Number | Invoice Date | Age | Company Name

      • Reservation Context (Col 5): Number of Reservations

      • Charges & Tax Breakdown (Cols 6–8): Total Charges | Total Taxes | Total Amount

      • AR Settlement & Balance Status (Cols 9–11): Invoice Amount | Settled Amount | Invoice Balance

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 & Statement Delivery: Download in Excel or PDF format to distribute formal invoice statements directly to corporate accounts payable leads.

  • Filtering: Filter data by specific Company Name, Invoice Number, or Age thresholds.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight overdue open invoices (Age > 30 days) or partially settled bills.

Within πŸ“¬ Billing & Receivables (AR):

Cross-Pillar Deep Dives:

  • βš–οΈ Ledgers & Trial Balance: To reconcile city ledger invoice totals against 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.