> ## Documentation Index
> Fetch the complete documentation index at: https://help.kwentra.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Booker Revenue by Channel — Consolidated (Multiproperty) Report

> Run a single consolidated report that totals room nights and revenue per channel, grouped under the booker who owns each channel, across all the hotels in your company.

See how much revenue each booker brings in across every hotel in the portfolio, in one run.

### **Business Value**

* Compare booker performance across the whole portfolio in one run.
* Attribute room nights and revenue to the booker owning each channel.
* Replace per-hotel channel reports and hand-added totals with one export.
* Narrow any run by hotels, bookers, or channels.
* Restrict access through a dedicated consolidated report permission.

### **Use Cases**

* Multi-property financial controller compares booker contribution across all hotels for the quarter.
* Multi-property night auditor exports portfolio room nights and revenue per channel in one pass.
* Group revenue manager reviews a single booker's channels across two properties using the filters.

### **How It Works**

| **Where:** Group Dashboard → Reports → Booker Revenue by Channel |
| ---------------------------------------------------------------- |

Each channel carries the booker who owns that channel relationship, set as the Default Booker on the channel profile. See [Add a channel and link it to a rate](/front-office/front-office-settings/front-office/how-do-i-add-a-channel-and-link-it-to-a-rate) for how that booker is configured.

#### Running the report

| **Parameter** | Description                                                      |
| ------------- | ---------------------------------------------------------------- |
| **From date** | Required. Start of the stay-night date range.                    |
| **To date**   | Required. End of the stay-night date range.                      |
| Hotels        | Multi-select, optional. Empty means all of the company's hotels. |
| Booker        | Multi-select, optional. Empty means all bookers.                 |
| Channel       | Multi-select, optional. Empty means all channels.                |

Filters combine. From and To dates plus two selected hotels and one booker returns only that booker's channels within those two hotels for the date range.

| **Note:** The report is download-only and exports to Excel (XLSX), matching the other consolidated dashboard reports. There is no on-screen preview on this screen. |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

#### Report columns

| **Column**                   | Description                                                                                           | Example           |
| ---------------------------- | ----------------------------------------------------------------------------------------------------- | ----------------- |
| **Booker / Channel / Hotel** | The name of the booker, channel, or hotel the row represents, depending on its level in the grouping. | Al Dyiafah travel |
| **Room Nights**              | The count of in-range room nights.                                                                    | 128               |
| **Revenue**                  | Total net rate amount of the in-range room nights.                                                    | 96,400.00         |

#### How the report is grouped

* Top level: each booker, showing that booker's total room nights and revenue across all their channels and all selected hotels.
* Under each booker: one row per channel that booker owns, with the channel's totals.
* Under each channel: one row per hotel, with that hotel's room nights and revenue for the channel.
* A grand-total row at the bottom sums room nights and revenue across everything in the result.

Channels with no booker assigned are collected under a **No booker assigned** group, so no revenue is dropped from the totals.

#### What the figures include

* Individual reservations only. Group reservations are excluded.
* Expected, Checked-in, and Checked-out reservations only. Cancelled and No Show reservations are excluded entirely.
* The From and To dates select stay nights: each room night whose date falls within the range counts. A reservation spanning the range boundary contributes only its in-range nights.
* Revenue is the net room rate only, taken from the reservation's rate amounts whether or not the night's charges have been posted yet.
* Amounts are summed as-is with no currency conversion, matching the Channel Summary and Consolidated Revenue & Statistics Summary reports.

| **Note:** Demo and head-office instances are excluded from the consolidated run. They are not offered in the Hotels parameter, and their data is not included when Hotels is left empty. Access is controlled by a dedicated report permission granted to the **Multi Property Financial Controller** and **Multi Property Night Auditor** groups. Users without the permission do not see the report in the Reports menu. |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |