Invoice Details .ng

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 = OPEN vs. 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 Amount vs. 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.

Image 8-11-26 at 8.57β€―AM.png
Invoice Details

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 Payments reflects the total billable debt: Total Payments = Settled Amount + Unsettled Amount.

  • Settlement Status: When Unsettled Amount = 0, the Invoice Status transitions to CLOSED. When an outstanding balance remains (Unsettled Amount > 0), the status displays as OPEN.

  • 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., BAUER UNDERGROUND, CLC, Crete Carrier Corp).

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 (CLOSED) or carries an outstanding balance (OPEN).

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 Age

      Account Context & PO (Cols 6–7): Company Name | PO Number

      Guest & Reservation Context (Cols 8–11): Guest Name | First Name | Last Name | Confirmation No

      Financial & Revenue Breakdown (Cols 12–17): Billing Date | Room Revenue | Room Tax / Other Fee | Other Charges | Other Taxes / Fees | Total Payments

      AR 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

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

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

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.