> ## 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. # Reservations List Report > List and analyze reservations across arrival, departure, and creation dates with flexible grouping, sorting, and filters — the most complete front-desk listing report in Kwentra. 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**](https://manage.kwentra.com/reports/FrontDesk/Reservation%20List/) The report opens with a parameters form. Set the parameters you need, then preview or export the results. ### **Step-by-step:** 1. **With rate:** Select **With** to include rate and currency columns, or **Without** for guest and booking details only. 2. **Group by:** Organize results by **None, Arrival Date, Channel, Departure Date, Group, Meal Plan, Rate Code, Guest Flag,** or **Nationality**. 3. **Sort by:** Order the reservations by **Room number, Reservation number, Guest Name, Voucher Number, Arrival Date & Time,** or **Departure Date & Time**. 4. **Channel, Rate code, Room type:** *(Optional)* Limit the report to specific channels, rate codes, or room types. 5. **Show remarks / Show other names:** Choose whether to include reservation remarks and additional guest names. 6. **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. 7. **State:** Filter by reservation state — expected, checked in, checked out, cancelled, no show, etc. 8. **Booker:** Show reservations made under a specific booker. 9. **Room number:** Show reservations assigned to a specific room. 10. **On hold status / From hold date / To hold date:** Use these only when working with on-hold reservations. 11. **Include guest identity:** Set to **Yes** to include the guest's form of identification. 12. **Guest flag / Nationality:** Filter reservations by guest flag or guest nationality. 13. **Voucher number:** Filter by a specific voucher number. 14. **Minimum number of nights:** Show only reservations that stay at least the number of nights entered. 15. **Accommodation type / Accommodation data:** Filter by accommodation type, and choose whether to show accommodation breakdown data. 16. **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.