Skip to main content

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.

Analyse guest arrivals and revenue by country of origin across any date range — with optional grouping by channel or rate code. Business Value
  • Identify which countries generate the most revenue and room nights in any given period.
  • Compare arrival volumes and net revenue per adult by country to prioritise sales markets.
  • Group data by Channel or Rate Code to see how each market books and at what rates.
Use Cases
  • Sales manager reviews the top 5 source countries by net revenue each quarter to focus outbound marketing efforts.
  • Revenue manager groups by Rate Code to see which countries book at discounted rates versus best available rate.
  • GM presents a country-level revenue breakdown to hotel ownership at the end of each month.
How It Works Running the Report Where: Reports → FO → Reservations → Country Start Date / End Date Select the date range for the report. The report will include all reservations that have at least one night falling within this range. Group By Leave blank to see one row per country across the full period. Select Channel to sub-group each country’s data by booking channel, or Rate Code to sub-group by the rate applied. Exclude Expected Reservations Set to Yes to exclude reservations that are in Expected (not yet arrived) status. Set to No to include all reservation statuses: Expected, Checked In, and Checked Out. Currency Select the currency for all revenue figures in the report. Note: Revenue figures are converted at the current exchange rate at the time the report is generated. Actions Click Download to export the file, Preview to view the report on screen, or Print to send directly to a printer. Report Columns
ColumnDescriptionExample
CountryGuest’s country of origin as recorded on the reservationGERMANY
AdultsTotal number of adult guest nights in the period9,589
ChildrenTotal number of child guest nights in the period545
Arrival adultsNumber of adults whose reservations arrived (checked in) during the period1,237
Arrival childrenNumber of children whose reservations arrived during the period71
NightsTotal room nights for all reservations from this country4,894
RoomsTotal number of rooms booked by guests from this country634
Net RevenueTotal net revenue from all charges for this country23,761,621.32
Net Room RevenueNet revenue from room charges only (excludes F&B and other charges)17,904,505.09
Net Revenue Per AdultNet Revenue divided by total number of adults2,478.01
A TOTAL row appears at the bottom of the report, summing all numeric columns across all countries.