Invoice Details Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π¬ Billing & Receivables (AR)
Target Roles: Accounts Receivable Managers, Credit Managers, Hotel Controllers, Staff Accountants, Billing Specialists, Directors of Finance
Key Value: Itemized corporate direct bill invoice tracking, auditing settlement progression across open and closed client invoices, reconciling room revenue and tax breakdowns against non-lodging ancillary charges, and tracking invoice aging days and payment settlement milestones.
Date Parameter: Date Range Selector (Start / End Date) | Past Only | Maximum Range: Any Unsettled Past Invoice will display regardless of date range.
Executive Summary
The Invoice Details report is the authoritative invoice tracking, settlement auditing, and direct billing receivables document within the π¬ Billing & Receivables (AR) category of the π° Finance & Accounting Reports hub. Designed to provide finance directors and accounts receivable teams with complete visibility into finalized direct billing statements, it itemizes every corporate city ledger invoice generated over a designated historical date range.
-
Centered on invoice lifecycle governance through the unified Invoice Details section, this report bridges master corporate accounts (
Company Name) with billing identification parameters (Invoice Number,Confirmation No,PO Number), chronological aging metrics (Invoice Date,Invoice Age,Due Date,Billing Date,Last Settled Date), guest stay context (Guest Name,First Name,Last Name), settlement states (Invoice Status = OPENvs.CLOSED), balance tracking (Total Payments,Settled Amount,Unsettled Amount), and granular financial revenue splits (Room Revenue,Room Taxes,Other Charges,Other Taxes). This level of line-item detail equips property controllers to track collection velocity, substantiate corporate billing inquiries, identify partially settled invoices, and reconcile city ledger balances against general ledger revenue accounts.
Key Capabilities
-
Invoice Lifecycle & Settlement Tracking: Details each generated accounts receivable invoice, distinguishing fully paid accounts (
Invoice Status = CLOSED) from outstanding direct billing statements (Invoice Status = OPEN). -
Mathematical Balance Reconciliation: Maintains strict settlement integrity by tracking original invoice gross amounts (
Total Payments), cumulative client payments (Settled Amount), and remaining open liability (Unsettled Amount). -
Granular Revenue & Tax Breakdown: Separates billed amounts into core lodging revenue (
Room Revenue) and municipal occupancy taxes (Room Taxes) alongside non-room ancillary fees (Other Charges) and applicable ancillary taxes (Other Taxes). -
Aging & Payment Milestone Monitoring: Calculates chronological delinquency in real-time (
Invoice Age), preserves contractual settlement deadlines (Due Date), logs periodic billing close dates (Billing Date), and records the most recent settlement transaction (Last Settled Date). -
Multi-Guest Folio Traceability: Maps corporate invoices containing single or multi-stay batches directly to individual guest reservations (
Guest Name,First Name,Last Name) and central confirmation numbers (Confirmation No). -
Statutory & Direct Bill Control: Preserves corporate purchase order codes (
PO Number) and billing dates to support client invoice verification and expedite dispute resolution.
Report Views & Functional Breakdown
The Invoice Details report presents accounts receivable invoices in a unified master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β INVOICE DETAILS REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Invoice Identificationβ 2. Settlement Balance & β 3. Departmental β
β & Guest Stay Context β Aging Chronology β Revenue Splitsβ
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Invoice Identification & Guest Stay Context
Monitors corporate debtor profiles, master invoice numbers, and all associated guest reservations batched into each bill.
-
Primary Use: Locating specific customer invoices, verifying purchase order numbers (
PO Number), and identifying the guest stays billed to the corporate account. -
Key Metrics: Company Name, Invoice Number, Confirmation No, PO Number, Guest Name, First Name, Last Name.
2. Settlement Balance & Aging Chronology
Tracks elapsed invoice maturity, payment deadlines, settlement dates, and outstanding balances.
-
Primary Use: Evaluating invoice collection status, monitoring partially paid invoices (
Settled Amountvs.Unsettled Amount), and identifying overdue accounts exceeding payment terms. -
Key Metrics: Invoice Date, Invoice Age, Due Date, Billing Date, Last Settled Date, Invoice Status, Total Payments, Settled Amount, Unsettled Amount.
3. Departmental Revenue Splits
Itemizes the underlying transaction charges comprising the invoice total across room accommodations, taxes, and incidental fees.
-
Primary Use: Auditing tax calculation accuracy, separating room revenue from miscellaneous hotel charges, and reconciling direct bill transfers with general ledger department sales.
-
Key Metrics: Room Revenue, Room Taxes, Other Charges, Other Taxes.
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 20 exact dynamic columns available in this report, sorted in alphabetical order by column name:
π° Financial Posting & Settlement Balancing Logic:
Invoice Valuation Parity: The gross invoiced amount labeled
Total Paymentsreflects the total billable debt: Total Payments = Settled Amount + Unsettled Amount.Settlement Status: When Unsettled Amount = 0, the
Invoice Statustransitions toCLOSED. When an outstanding balance remains (Unsettled Amount > 0), the status displays asOPEN.Revenue Reconciliation: For newly billed room transactions, Total Payments balances to Room Revenue + Room Taxes + Other Charges + Other Taxes.
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Billing Date |
Calendar date on which the billing period or cycle closed for the invoice. |
AR Invoicing Engine > Billing Cycle Date |
N/A |
|
Company Name |
Registered commercial trade name, corporate billing account, or agency title associated with the direct-billed invoice (e.g., |
Company Master > Company Legal Name |
N/A |
|
Confirmation No |
Central reservation system (CRS) or PMS reservation confirmation number(s) included on the invoice. |
Reservation Engine > Confirmation ID(s) |
N/A |
|
Due Date |
Contractual payment deadline by which the corporate client must settle the outstanding invoice balance. |
AR Invoicing Engine > Payment Due Date |
N/A |
|
First Name |
First name(s) of the registered guest(s) whose stay charges are billed on the invoice. |
Guest Profile > First Name |
N/A |
|
Guest Name |
Full name(s) of the primary guest(s) included on the invoice, formatted as LAST FIRST. |
Guest Profile > Full Name |
N/A |
|
Invoice Age |
Number of elapsed calendar days from the invoice issuance date to the report run date. |
Calculated: (Report Run Date - Invoice Date) |
N/A |
|
Invoice Date |
Calendar date on which the direct bill accounts receivable invoice was generated and finalized. |
AR Invoicing Engine > Generation Date |
N/A |
|
Invoice Number |
Unique master system accounts receivable invoice number assigned to the direct billing statement. |
AR Billing Engine > Master Invoice ID |
N/A |
|
Invoice Status |
Current settlement state of the invoice, indicating whether the balance is fully paid ( |
AR Invoicing Engine > Settlement Status |
N/A |
|
Last Name |
Last name(s) or surname(s) of the registered guest(s) included on the invoice. |
Guest Profile > Last Name |
N/A |
|
Last Settled Date |
Calendar date on which the most recent payment, deposit, or credit settlement was applied to the invoice. |
AR Cashiering > Last Settlement Timestamp |
N/A |
|
Other Charges |
Non-lodging ancillary fees and miscellaneous charges (e.g., parking, meeting room, resort fees) included on the invoice. |
Folio Subledger > Ancillary Charges |
β No |
|
Other Taxes |
Applicable sales, municipal, or service taxes assessed on non-lodging ancillary charges. |
Tax Subledger > Ancillary Taxes |
π’ Yes |
|
PO Number |
Customer purchase order number or client billing authorization reference code. |
Folio Billing Setup > PO / Voucher Ref |
N/A |
|
Room Revenue |
Total room accommodation charges (excluding taxes and non-lodging fees) billed on the invoice. |
Revenue Ledger > Room Sales |
β No |
|
Room Taxes |
Total occupancy, state, and local lodging taxes assessed on the billed room accommodation charges. |
Tax Subledger > Lodging Taxes |
π’ Yes |
|
Settled Amount |
Cumulative monetary payments, credits, or write-offs applied against the invoice. |
AR Cashiering > Applied Settlements |
π’ Yes |
|
Total Payments |
Total original monetary value billed on the invoice ($\text{Settled Amount} + \text{Unsettled Amount}$). |
AR Invoicing Engine > Gross Invoice Total |
π’ Yes |
|
Unsettled Amount |
Remaining outstanding monetary balance owed on the invoice awaiting client settlement. |
AR Invoicing Engine > Open Invoice Balance |
π’ 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 5 logical blocks:
-
Invoice Identifiers & Status (Cols 1β5):
Invoice Number|Invoice Date|Due Date|Invoice Status|Invoice AgeAccount Context & PO (Cols 6β7):
Company Name|PO NumberGuest & Reservation Context (Cols 8β11):
Guest Name|First Name|Last Name|Confirmation NoFinancial & Revenue Breakdown (Cols 12β17):
Billing Date|Room Revenue|Room Tax / Other Fee|Other Charges|Other Taxes / Fees|Total PaymentsAR Settlement & Balance Audit (Cols 18β20):
Settled Amount|UnSettled Amount|Last Settled Date
-
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 & Report Distribution: Download in Excel or PDF format to attach supporting invoice audit schedules to outgoing client statements or collection notices.
-
Filtering: Filter data by specific Company Name, Invoice Status, or PO Number.
-
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight overdue invoices (
Invoice Age > 30) or partially settled bills with remaining unsettled balances.
π Related Reports & Next Steps
Within π¬ Billing & Receivables (AR):
-
Accounts Receivable Activity Report β Audit line-item transaction entries hitting the direct-bill ledger.
-
AR Invoice Aging Report β Categorize open invoice balances across 30-day time bands.
-
Invoice Summary Report β Review macro-level corporate billing totals and open vs. voided invoice counts.
-
Statement of Invoice Report β Audit corporate billing lifecycles broken down into Open and Closed invoice sections.
-
Direct Bill Reconciliation Report β Identify payment gaps and verify guarantee statuses for corporate invoicing.
Cross-Pillar Deep Dives:
-
βοΈ Ledgers & Trial Balance: To reconcile city ledger invoice totals against general ledger balances, 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.