Direct Bill Reconciliation .ng | HotelKey Knowledge Base

Direct Bill Reconciliation Report Overview

Parent Hub: 💰 Finance & Accounting Reports

Category: 📬 Billing & Receivables (AR)

Target Roles: Directors of Finance & Controllers, Accounting Managers & Clerks, Group Rooms Coordinators

Key Value: Streamline corporate and group invoicing by giving accounting teams complete line-item stay visibility, comparing total charges directly against total payments to spot payment gaps and finalize direct bills with confidence.

Executive Summary

The Direct Bill Reconciliation Report is a key operational audit tool within the 📬 Billing & Receivables (AR) module. Designed for end-to-end corporate and group account reconciliation, it provides complete visibility into individual stay itineraries billed to corporate accounts or group master folios.

By pairing comprehensive stay details (Arrival, Nights, Room Number, Rate Code, Guarantee status) directly alongside real-time ledger figures (Total Charges vs. Total Payments), this report enables controllers, night auditors, and accounting leads to quickly spot payment discrepancies, verify guarantee terms, audit no-show/cancellation charges, and finalize direct-bill invoicing prior to transfer.

Key Capabilities

Stay & Billing Reconciliation: Compares Total Charges directly against Total Payments for every corporate or group reservation to calculate real-time net balances.
Guarantee & Booking Verification: Audits booking channels (Source), rate plans (Rate Code), and guarantee states (Guarantee: Yes/No) for corporate policy compliance.
Multi-Segment Coverage: Accommodates both transient corporate guest bookings and structured group block accounts (Group No / Group Name).

Report Views & Functional Breakdown

The Direct Bill Reconciliation Report presents transaction data across three structured operational perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   DIRECT BILL RECONCILIATION REPORT                    │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Direct Bill Account   │ 2. Billing & Charge      │ 3. Guarantee &   │
│    Ledger                │    Reconciliation        │    Reservation   │
│                          │                          │    Audit         │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Direct Bill Account Ledger

Aggregates stays by corporate client and group master account, providing a clean overview of guest names, room assignments, and reservation codes.

Primary Use: Grouping corporate billings by account name to verify guest stay rosters before generating final client invoice packages.
Key Metrics: Company Name, Group No, Group Name, Confirmation No, Guest Name, Room Number.

2. Billing & Charge Reconciliation

Cross-references cumulative folio charges against payments and posted deposits to highlight unsettled amounts or credit balances.

Primary Use: Spotting payment gaps, auditing total room charges against posted tender, and reconciling net balances.
Key Metrics: Total Charges, Total Payments, Nights, Status (CHECKED_IN, CHECKED_OUT, NO_SHOW, CANCELLED).

3. Guarantee & Reservation Audit

Evaluates booking origin, rate code applications, occupancy counts, and payment guarantee flags for corporate compliance.

Primary Use: Enforcing direct-bill guarantee terms, auditing rate eligibility, and investigating no-show billing exceptions.
Key Metrics: Rate Code, Source, Arrival Date, Nights, People (Adults-Children), Guarantee (Yes/No).

Image 8-10-26 at 9.37 PM.png — Direct Bill Reconciliation Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary available for this report:

💡 Tax Treatment Note: Total Charges and Total Payments represent Gross Amounts (Includes Taxes and Fees) billed to the guest or group folio.

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Company Name	Name of the contracted corporate entity receiving the direct bill.	`Company Profile > Name`	N/A
Confirmation No	Unique confirmation number assigned to the individual guest reservation.	System Reservation ID	N/A
Group No	Unique master identifier code assigned to the group block.	`Group Profile > Group Number`	N/A
Guest Name	Primary guest full name assigned to the reservation.	`Guest Profile > Full Name`	N/A
Group Name	Name of the group or event block tied to the reservation.	`Group Profile > Group Name`	N/A
Room Number	Assigned physical guest room number during the stay.	`Reservation > Room Number`	N/A
Rate Code	Rate code or pricing structure applied to the reservation.	`Reservation > Rate Code`	N/A
Source	Channel through which the booking was created (e.g., `WALK IN`, `PHONE`, `GDS`).	`Reservation > Source`	N/A
Arrival	Scheduled check-in date for the reservation.	`Reservation > Check In Date`	N/A
Nights	Total duration of the stay in calendar nights.	`Reservation > Length of Stay`	N/A
People	Guest occupancy ratio formatted as `Adults-Children` (e.g., `1-0`).	`Reservation > Occupancy`	N/A
Guarantee	Indicates if the stay is backed by a corporate guarantee (`Yes` / `No`).	`Reservation > Guarantee Status`	N/A
Total Charges	Total cumulative gross charges posted to the folio.	`SUM(Folio Charges + Taxes)`	🟢 Yes
Total Payments	Total cumulative payments, credits, or deposits applied to the folio.	`SUM(Folio Payments)`	🟢 Yes
Status	Current state of the stay (`CHECKED_IN`, `CHECKED_OUT`, `NO_SHOW`, etc.).	Reservation System State	N/A

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 4 logical blocks:
- Direct Bill & Account Context (Cols 1–3): Company Name | Group Name | Group No
- Reservation & Guest Identifiers (Cols 4–7): Confirmation No | Guest Name | Room No | Status
- Stay & Booking Details (Cols 8–13): Arrival | Nights | People | Rate Code | Source | Guarantee
- Financial Reconciliation (Cols 14–15): Total Charges | Total Payments

Advanced Controls

Exporting & Report Distribution: Download in Excel or PDF format to attach supporting stay documentation to outgoing client invoices.
Filtering: Filter data by specific Company Name, Status (NO_SHOW, CHECKED_OUT), or date ranges.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight reservations where Total Charges ≠ Total Payments or non-guaranteed direct-bill stays.

Within 📬 Billing & Receivables (AR):

Accounts Receivable Activity Report – Audit detailed line-item transactions hitting the city ledger.
AR Invoice Aging Report – Categorize open invoice balances across 30-day time bands.
Direct Bill Aging Report – Segment corporate debt across AR, Invoices, and Settlements.
Customer Statement Report – Generate client-facing statements with invoice details and bank info.
Invoice Details Report – Detailed lifecycle tracking of every generated invoice.

Cross-Pillar Deep Dives:

⚖️ Ledgers & Trial Balance: To verify master folio setup and routing before check-out, cross-reference In House Guest Folio Balances Report or Group Ledger Report.
💳 Payments & Transactions: To inspect direct-bill payment settlements, review Payment Activity or Payment Transactions.
📈 Forward Revenue & Analytics: Looking for forward-facing revenue projections or macro performance metrics (like RevPAR or ADR)? Please visit the [📈 Revenue & Analytics] reporting hub.