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.,WBfor Web Booking,ROfor 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.
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., |
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 ( |
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., |
Reservation Engine > Occupancy Count |
N/A |
|
Rate Code |
Contracted rate code or pricing tier applied to the stay (e.g., |
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., |
Reservation Engine > Channel Source |
N/A |
|
Status |
Operational lifecycle status of the reservation (e.g., |
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 |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Background Export |
Allows users to download up to 365 days of data directly to their computer in CSV format. |
|
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 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 Paymentsor non-guaranteed direct-bill stays.
π Related Reports & Next Steps
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 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.