Channel Revenue YTD - Kwentra Help Center

See year-to-date revenue, nights, ADR, and occupancy share broken down by booking channel — in any currency. Business Value

Know exactly which booking channels — wholesale, online TA, or direct — are driving revenue and nights.
Compare Gross Rate, Net Rate, Room Revenue, ADR, ASR, and Net Rate Per Adult side by side for every channel.
See cancellations and no-shows per channel to identify reliability issues.
View each channel’s share of total occupancy with the Occ. Share % column.
Run the report in any configured currency using live exchange rates.

Use Cases

Revenue manager reviews April–May YTD to compare wholesale vs. online TA performance and adjust channel mix.
Finance team generates the report in USD for group-level currency consolidation across properties.
Director of Sales tracks Net Rate Per Adult by channel to identify which sources yield the highest revenue per guest.
General manager monitors cancellations and no-shows by channel to evaluate booking reliability.

How It Works Running the Report

Where: Reports → FO → Reservation → Channels Revenue YTD

Set the following parameters before running:

From Date / To Date — The date range for the report. Revenue is based on audit date.
Channel — Select one or more specific channels to filter (optional — leave empty to include all channels).
Currency — Select from all currencies configured in the system. Defaults to the property’s base currency. Exchange rates are applied at the time of report generation.
File Type — Choose the export format: XLS, XLSX, ODS, or PDF.

Report Structure The report is grouped in a three-level hierarchy: Channel Group → Sub-Group → Individual Channel. Each level shows a summary row. The Total row at the bottom aggregates all channels. Example grouping structure:

Full Inclusive Tour “Wholesale” → Contracted TA and Tour Operator → Biblio Globus, ETI AUT, EXIM CZE …
Full Inclusive Tour “Wholesale” → Online TA → Online Website → Booking.com, Expedia.com …
Others → Complimentary → Complimentary
Others → House Use → House Use
Others → Retail → Best Available Rate → Individual

Report Columns

Column	Description	Example
Nights	Total room nights for the channel in the selected period	2,531
Rate Amount (Gross)	Total gross rate — the full rack/contracted rate before any deductions or taxes	37,292,172.40
Rate Amount (Net)	Total net rate — gross rate minus taxes	27,735,733.89
Room Revenue	Total net room revenue posted to folios for this channel	24,441,860.27
Net Rate Per Adult	Net Rate Amount divided by the number of adults (children excluded). Calculated on totals in the summary row.	5,769.86
ADR	Average Daily Rate — Rate Amount (Gross) without packagesdivided by total nights	14,116.62
ASR	Average Selling Rate — Rate Amount including packages and extras divided by total nights	10,953.43
Cancellations	Total number of cancelled reservations from this channel	811.00
No Shows	Total number of no-show reservations from this channel	9.00
Adults	Total number of adult guests in the selected period	4,807
Children	Total number of child guests in the selected period	544
Occ. Share %	This channel’s room nights as a percentage of the property’s total room nights across all channels	10.37%

Only debit-type income departments are included in Room Revenue. Payment and credit postings are excluded. Group paymaster accounts (e.g., GRP-xxxx) may appear as channel rows when the channel is assigned at the paymaster level.

Summary and Total Rows Each channel group and sub-group displays a bold summary row showing aggregated values for all channels within it. The grand Total row at the bottom of the report shows the full property total across all channels. Occ. Share % on the Total row always equals 100%.

Net Rate Per Adult in the Total and summary rows is calculated on the totals (total Net Rate Amount ÷ total Adults), not as an average of individual channel values.