> ## 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. # Channels Revenue YTD Consolidated Report > Run Channels Revenue YTD once for all your hotels and see each hotel under its channel. See market, source and channel revenue for all your hotels in one run. ### **Business Value** * Replaces running the report hotel by hotel and adding it up by hand. * Keeps the same columns and layout staff already know. * Adds a Hotel row under each channel, so you see who sold it. * Works out ADR, ASR and Occ.Share % from totals, not averages. * Opens only for users with the report's own permission. ### **Use Cases** * A director of revenue sees which channels sold best across the whole group. * A financial controller compares one hotel's Booking.com nights with the group total. * A multi-property night auditor downloads group channel revenue without opening each hotel. ### **How It Works** | **Where:** Multiproperty → Reports → Channels Revenue YTD Consolidated | | - | Before, this report ran one hotel at a time. Now it runs across the hotels you pick and returns one file. The single-hotel [Channels Revenue YTD](/front-office/reports/reservation-reports/channel-revenue-ytd) report does not change. #### **Running the Report** | **Parameter** | Description | | - | - | | **From date** | Required. | | **To date** | Required. It cannot be before From date. | | **Hotels** | Pick one hotel or more. All your hotels are picked by default. | | **Channel** | Optional. Pick one channel or more. Leave it empty for all channels. | * If To date is before From date, you see: **To date cannot be before from date.** * Each channel name is listed once, not once per hotel. Picking **Booking.com** covers every hotel that has it. * There is no **Currency** parameter. | **Note:** Demo and head-office instances are never listed and never counted. | | - | #### **Report Layout** The sheet keeps today's header, columns, shading and number formats. The body now has four levels: 1. **Market** row. A blank market shows as **Others**. 2. **Source** rows under their market. 3. **Channel** rows under their source. Names appear as set up, such as `{code}_Booking.com`. 4. **Hotel** rows under their channel. This level is new. * Market, Source and Channel rows are subtotals across the hotels you picked. * A Hotel row shows that hotel's figures for the channel. * A hotel is listed under a channel only if it has nights, cancellations or no-shows there. * One **Total** row sits at the bottom. It is the whole group's total. * The header lists the hotels you picked, or **All hotels**. * The title row reads **Channels Revenue YTD Consolidated** with your date range. #### **Report Columns** | **Column** | What it shows | | - | - | | **Nights** | Room nights in the date range. | | **Rate Amount (Gross)** | Gross room rate plus included packages. | | **Rate Amount (Net)** | Net room rate plus included packages, without taxes. | | **Room Revenue** | Net room rate only. No packages, no taxes. | | **Net Rate Per Adult** | Rate Amount (Net) ÷ Adults. | | **ADR** | Room Revenue ÷ Nights. | | **ASR** | Rate Amount (Gross) ÷ Nights. | | **Cancellations** | Cancelled room nights in the range. | | **No Shows** | No-show room nights in the range. | | **Adults** | Adult-nights. | | **Children** | Child-nights. | | **Occ.Share %** | The row's share of nights. Shown to two decimals. | A row with zero nights but some cancellations or no-shows is still listed. The other columns show zero. #### **How the Figures Are Combined** Counts and amounts are added up. Ratios are worked out again on every row. | **Row** | How Occ.Share % is worked out | | - | - | | Market, Source, Channel, Total | Row nights ÷ total nights of all hotels in the result. | | **Hotel** | The hotel's nights ÷ that hotel's own total nights in the result. | **Example:** the group has 1,000 nights in the result. A channel row has 250 nights, so it shows 25.00%. Hotel A sold 150 of those nights. Hotel A's own total in the result is 500 nights. So the Hotel A row shows 30.00%. * ADR, ASR and Net Rate Per Adult are worked out from each row's own totals. * They are never an average of the hotel rows, and never added up. * A **Channel** filter narrows the total too. #### **Names Must Match Exactly** Markets, sources and channels are matched across hotels by exact name. * `{code}_Booking.com` at two hotels makes one Channel row with two Hotel rows. * Names that differ even slightly stay as separate rows. The code prefix counts. #### **What Counts** * **Dates** pick stay nights. Only room nights inside the range count. A stay crossing the edge adds only its in-range nights. * **Rates** come from the reservation's rate breakdown per night, posted or not. * Manual charges and direct postings are not counted. * **Individual reservations:** everything except Cancelled and No Show counts. * **Group reservations:** only nights still in **Expected** status count. Groups add nothing to Children or No Shows. * Reservations with no channel are left out. | **Note:** Amounts are added as they are, in each hotel's base currency. There is no currency conversion. Use this report for hotels that share one base currency. | | - | #### **Permission** The report has its own permission pair. One permission runs it. The other opens every file format. Both are given to **Consolidated GM**, **Multi Property Financial controller** and **Multi Property Night auditor**. Without them, the report does not show in the Reports menu. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.