Direct Bill Reconciliation .ng

Direct Bill Reconciliation Report Overview

Parent Hub: πŸ’° Finance & Accounting Reports

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

Target Roles: Accounts Receivable Managers, Night Auditors, Front Desk Supervisors, Hotel Controllers, Billing Coordinators, Directors of Finance

Key Value: Operational reconciliation between guest reservation folios and corporate direct bill city ledgers, verifying billing accuracy across in-house and departed direct-billed stays, comparing posted charges against received settlements, and auditing guarantee and rate plan compliance prior to final invoice generation.

Date Parameter: Date Range Selector (Start & End) | Future | Maximum Window: 90 Days

Executive Summary

The Direct Bill Reconciliation report is an essential operational control, audit verification, and ledger balancing document within the πŸ“¬ Billing & Receivables (AR) category of the πŸ’° Finance & Accounting Reports hub. Positioned at the critical intersection between front desk operations and back-office accounting, it provides daily visibility into individual guest reservations routed to corporate direct bill accounts, loyalty programs, or group masters.

  • Centered on reservation billing reconciliation through the unified Direct Bill Reconciliation section, this report correlates corporate client metadata (Company Name) with complete guest stay parameters (Confirmation No, Guest Name, Group No, Group Name, Room Number, Rate Code, Source, Arrival, Nights, People, Guarantee, Status) and financial transaction totals (Total Charges, Total Payments). This detailed operational perspective allows night auditors and accounts receivable specialists to verify that room, tax, and incidental folios are correctly transferred to authorized city ledger accounts, detect open folio balances prior to guest checkout, reconcile guest advance deposits against posted room nights, and prevent billing disputes before monthly corporate invoices are issued.

Key Capabilities

  • Transaction-Level Direct Bill Auditing: Maps each individual direct-billed booking directly to its corporate account (Company Name), displaying cumulative charges (Total Charges) and applied credits (Total Payments).

  • Complete Guest & Stay Context: Captures critical front office stay parameters, including confirmation identifiers (Confirmation No), guest names (Guest Name), assigned room inventory (Room Number), arrival calendar dates (Arrival), booked stay lengths (Nights), and occupancy breakdown (People).

  • Reservation Lifecycle & Status Tracking: Audits bookings across operational stages (Status, e.g., CHECKED_IN, CHECKED_OUT, HOLD), enabling credit controllers to monitor in-house guest ledger balances before final folio settlement.

  • Contracted Rate & Channel Governance: Tracks booked pricing plans (Rate Code, e.g., REWARD NIGHTS, ANNIVERSARY NIGHT FLEX) and reservation booking origins (Source, e.g., WB for Web Booking, RO for Central Reservations Roll-over) to verify corporate negotiated rate adherence.

  • Group Master & Billing Association: Identifies group-affiliated reservations via dedicated block fields (Group No, Group Name) to substantiate master account billing routing.

  • Guarantee Verification: Confirms whether bookings hold authorized credit guarantees (Guarantee = Yes), protecting the property against uncollectible walk-outs or unauthorized direct billing transfers.

Report Views & Functional Breakdown

The Direct Bill Reconciliation report structures direct billing operational data into a unified single-table master matrix supporting three primary operational perspectives:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                   DIRECT BILL RECONCILIATION REPORT                    β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                         Unified Matrix View                            β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Account & Booking     β”‚ 2. Stay Demographics &   β”‚ 3. Folio Charges β”‚
β”‚    Identification        β”‚    Channel Attributes    β”‚    & Settlement  β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Account & Booking Identification

Tracks the primary corporate billing entity, guest confirmation numbers, group affiliations, and assigned room numbers.

  • Primary Use: Verifying corporate direct bill account linkages and matching front desk room assignments to corporate travel authorisations.

  • Key Metrics: Company Name, Confirmation No, Group No, Guest Name, Group Name, Room Number.

2. Stay Demographics & Channel Attributes

Audits contracted pricing plans, booking distribution channels, arrival dates, length of stay, guest occupancy counts, and reservation lifecycle states.

  • Primary Use: Ensuring rate code compliance, tracking multi-night stay progress, verifying guarantee status, and auditing in-house vs. checked-out accounts.

  • Key Metrics: Rate Code, Source, Arrival, Nights, People, Guarantee, Status.

3. Folio Charges & Settlement Balancing

Monitors the financial balance between cumulative posted folio charges and received payments or city ledger transfers.

  • Primary Use: Identifying outstanding balances on departed guests, verifying partial advance deposits, and balancing daily direct bill ledger transfers.

  • Key Metrics: Total Charges, Total Payments.

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 representing all 15 exact dynamic columns available in this report, sorted in alphabetical order by column name:

πŸ’° Financial Reconciliation Logic:

  • Total Charges: Reflects cumulative gross folio transactions (accommodation, dining, parking, taxes, and fees) assigned to the reservation.

  • Total Payments: Reflects all credits, cash/credit card payments, advance deposits, and transferred city ledger settlements applied to the reservation.

  • Net Due Calculation: An outstanding guest balance exists whenever Total Charges > Total Payments. For checked-out stays (Status = CHECKED_OUT), Total Charges must equal $Total Payments to confirm successful folio zero-out and direct bill transfer.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Arrival

Check-in or scheduled arrival calendar date for the guest reservation.

Reservation Engine > Arrival Date

N/A

Company Name

Name of the corporate direct billing account, loyalty program, or commercial entity associated with the reservation (e.g., HotelKey).

Company Master > Company Legal Name

N/A

Confirmation No

Primary unique central reservation system (CRS) or PMS confirmation number assigned to the booking.

Reservation Engine > Confirmation ID

N/A

Group Name

Official group block name or event title if the direct-billed reservation is affiliated with a group booking.

Group Master > Group Block Name

N/A

Group No

Unique group block identifier or master group code linked to the reservation.

Group Master > Group Block ID

N/A

Guarantee

Indicates whether the reservation holds a guaranteed booking status backed by corporate direct bill authorization or credit card (Yes or No).

Reservation Engine > Guarantee Flag

N/A

Guest Name

Full legal name of the registered guest staying in the room, formatted as FIRST LAST or LAST FIRST.

Guest Profile > Guest Full Name

N/A

Nights

Total number of room nights booked or stayed for the reservation.

Reservation Engine > Length of Stay

N/A

People

Guest occupancy distribution formatted as Adults-Children (e.g., 2-0 represents 2 adults, 0 children; 1-2 represents 1 adult, 2 children).

Reservation Engine > Occupancy Count

N/A

Rate Code

Contracted rate code or pricing tier applied to the stay (e.g., REWARD NIGHTS, ANNIVERSARY NIGHT FLEX).

Rate Master > Rate Tier Code

N/A

Room Number

Physical guest room number assigned to the reservation.

Room Master > Physical Room Number

N/A

Source

Booking channel or reservation source code (e.g., WB for Web Booking, RO for Central Reservations Roll-over).

Reservation Engine > Channel Source

N/A

Status

Operational lifecycle status of the reservation (e.g., CHECKED_IN, CHECKED_OUT, HOLD).

Reservation Engine > Operational Status

N/A

Total Charges

Cumulative monetary charges (lodging, tax, and incidental folios) posted to the reservation.

Folio Subledger > Gross Charges

Yes

Total Payments

Cumulative monetary payments, deposits, or direct bill settlements applied against the reservation charges.

Folio Subledger > Applied Payments

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 below 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

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-30-26 at 2.14β€―PM.png

Background Export

Allows users to download up to 365 days of data directly to their computer in CSV format.

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 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):

Cross-Pillar Deep Dives: