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.
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.
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 Balancealways 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 headerInvoice 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., |
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 |
|
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 & 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.
π 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.
-
Invoice Summary Report β Macro-level corporate billing totals and open vs. closed vs. voided invoice counts.
-
AR Invoice Aging Report β Categorize open invoice balances across standardized 30-day aging bands.
-
Customer Statement Report β Generate client-facing account statements with invoice details and remittance bank info.
-
Accounts Receivable Activity Report β Audit every line-item transaction hitting the city ledger.
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.