Reservations List Report - Kwentra Help Center

List and analyze your reservations by any combination of dates, then group, sort, and filter them to answer almost any front-desk question in a single report.

Report Business Value

Combines arrival, departure, and creation views in one flexible listing report.
Filters by reservation state — expected, checked in, checked out, cancelled, no show, and more.
Groups and sorts results by channel, date, room, guest, and other criteria.
Adds guest details such as nationality, guest flag, and other guest names.
Shows on-hold reservations with their hold status and expiry.

Use Cases

Front Desk: List every reservation arriving between two dates for shift planning.
Reservations: Review all bookings created within a date range to audit new business.
Management: Group by channel to compare booking sources across a period.

How does it work?

Navigation: Reports → FrontDesk → Reservation List The report opens with a parameters form. Set the parameters you need, then preview or export the results.

Step-by-step:

With rate: Select With to include rate and currency columns, or Without for guest and booking details only.
Group by: Organize results by None, Arrival Date, Channel, Departure Date, Group, Meal Plan, Rate Code, Guest Flag, or Nationality.
Sort by: Order the reservations by Room number, Reservation number, Guest Name, Voucher Number, Arrival Date & Time, or Departure Date & Time.
Channel, Rate code, Room type: (Optional) Limit the report to specific channels, rate codes, or room types.
Show remarks / Show other names: Choose whether to include reservation remarks and additional guest names.
Date-range filters (all optional and can be combined):
- From date / To date: All reservations that fall within the selected period, regardless of their arrival or departure dates.
- From arrival date / To arrival date: Reservations arriving within the selected range.
- From departure date / To departure date: Reservations departing within the selected range.
- From creation date / To creation date: Reservations created (booked) within the selected range.
State: Filter by reservation state — expected, checked in, checked out, cancelled, no show, etc.
Booker: Show reservations made under a specific booker.
Room number: Show reservations assigned to a specific room.
On hold status / From hold date / To hold date: Use these only when working with on-hold reservations.
Include guest identity: Set to Yes to include the guest’s form of identification.
Guest flag / Nationality: Filter reservations by guest flag or guest nationality.
Voucher number: Filter by a specific voucher number.
Minimum number of nights: Show only reservations that stay at least the number of nights entered.
Accommodation type / Accommodation data: Filter by accommodation type, and choose whether to show accommodation breakdown data.
File type: Choose XLS, XLSX, ODS, or PDF, then click Download, Preview, or Print.

Report Column Output

Column	Description
Id	Unique reservation ID.
Room	Room number assigned to the reservation.
Type	Room type assigned to the reservation.
Name	Primary guest name; additional guests appear beneath it when Show other names is enabled.
Arrival / Time	Arrival date and actual arrival (check-in) time.
Departure / Time	Departure date and actual departure (check-out) time.
Voucher no	Voucher number entered on the reservation.
Nights	Number of nights for the reservation.
Adt	Number of adults.
Chld	Number of children.
Channel	Booking channel the reservation was created under.
Guest Flag	Guest flag applied to the reservation or guest profile.
Nationality	Guest nationality.
Booker	Booker selected on the reservation.
Group	Group name, when the reservation belongs to a group.
Status	Current reservation state (expected, checked in, checked out, cancelled, no show, etc.).
Meal Plan	Meal plan / board type on the reservation.
Hold Status	Whether the reservation is confirmed or on hold.
On Hold Until	Time the on-hold status expires.
Created on	Timestamp of when the reservation was created.
Created by	User who created the reservation.

Update: 21 Apr, 2026

Total Stay and Currency Columns

The Reservation List Report now shows total stay amounts and the rate currency for each reservation when the “With Rate” parameter is selected. Select the “With Rate” parameter to enable the new columns. New and Updated Columns When “With Rate” is selected, the following changes apply:

Two existing columns are renamed for clarity:
Rate → Rate Per Night
Base Rate → Base Rate Per Night
Three new columns are added after the “Net Base Rate” column.

	Note: The 3 new columns only appear when the “With Rate” parameter is selected.

Report Columns

Column	Description	Example
Rate Per Night	Nightly rate for the reservation in its original currency (renamed from “Rate”).	SAR 450
Base Rate Per Night	Nightly rate converted to the property base currency (renamed from “Base Rate”).	USD 120
Net Base Rate	Net nightly rate in base currency after discounts.	USD 108
Base Total Stay	Total stay amount based on the accommodation breakdown in the base currency. Includes a grand total in the report’s total row.	USD 756
Total Stay	Total stay amount in the reservation’s original currency.	SAR 3,150
Currency	The currency code for the reservation’s rate.	SAR

Update: July 20, 2026

[New Filter & Column] Source

Business Need: The Source field — the reservation’s booking channel source, editable from the Individual Reservation screen — is already available in the Expected Arrival report but was missing from the Reservation List report, the most commonly used listing report for front desk and management. Without it, staff could not filter or review reservations by booking source and had to cross-reference other reports for channel tracking. How it works:

A new Source multi-select filter parameter is added to the report’s search form, alongside the existing lookup filters.
A new Source column is added to the report output, showing each reservation’s current source value (as last updated on the Individual Reservation screen).
When one or more sources are selected, only reservations whose source matches the selection appear in the results. Leaving it empty includes all sources.

Benefits:

Track channel and source performance directly from the reservation list.
Validate that source updates made on reservations are reflected in operational reports.
Reduce cross-referencing with other reports for booking-source analysis.

​Report Business Value

​Use Cases

​How does it work?

​Step-by-step:

​Report Column Output

​Update: 21 Apr, 2026

​Total Stay and Currency Columns

​Update: July 20, 2026

​[New Filter & Column] Source