> ## 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.

# Expected Arrival Report

> Report Business Value: This operational report helps you see all the reservations that are expected to arrive between selected dates, below are the benefits of utilizing this report in your daily o...

Instantly see all reservations due to arrive on any day or period, with full booking and guest details, supporting smooth hotel operations.

## **Report Business Value**

* **Get a real-time list** of all arrivals for any selected date or period—no reservation missed!
* **View all booking and guest details** (room, type, guest names, stay dates, voucher, market, meal plan, etc.) at a glance.
* **See source/channel info** for each reservation to monitor booking trends.
* **Identify group, FIT, and special arrivals** for focused guest service.
* **Internal notes (when enabled):** Front desk and management stay updated on special instructions.

***

## **Use Cases**

* **Front Desk:** Prepares daily check-in sheets, flags VIP or group arrivals, reviews internal notes.
* **Reservations:** Verifies bookings from key channels, handles overbooking or group requests.
* **Management:** Tracks room/occupancy for operational planning.
* **Housekeeping/F\&B:** Forecasts arrivals to align services.

***

## **How does it work?**

**Navigation:**

`Reports → FO → FrontDesk → Expected Arrival`

**Steps:**

1. **Select the date range** (use the same date for both fields to view a single day).
2. **Choose output options:**
   * Include/exclude rates
   * Filter by channel, rate code, or room type (optional)
   * Include internal notes (optional)
   * Set grouping (channel, market, meal plan, etc.), or use “None” for a full list
   * Choose sort criteria (room, guest name, etc.)
   * Show only confirmed/on-hold or all reservations
3. **Export or preview** in Excel (XLS, XLSX, ODS) or PDF.

***

## **Report Column Output**

| Column           | Description (English)                                   |
| ---------------- | ------------------------------------------------------- |
| Id               | Reservation unique ID                                   |
| Room             | Room assigned (blank if not yet assigned)               |
| Type             | Room type/category                                      |
| Name             | Main guest name (all guests shown if option enabled)    |
| Arrival / Time   | Arrival date and check-in time                          |
| Departure / Time | Departure date and check-out time                       |
| Voucher no       | OTA or manual voucher number (if provided)              |
| Adt / Chld       | Number of adults and children per reservation           |
| Channel          | Main booking channel (e.g. Booking.com, Fun\&Sun, ... ) |
| Source           | Usually same as Channel, or travel agent                |
| Market           | Segment or market code (TA, IND SOFT \$, etc.)          |
| Group            | Group/series name if part of a group                    |
| Meal Plan        | Meal plan (e.g. All Inclusive Hard, All Inclusive Soft) |
| On Hold          | Reservation status (CONFIRMED / ON HOLD)                |
| Hold Until       | If “on hold”, shows until when it is valid              |

**Group summary rows**

* After each channel/group block, summary lines give the total rooms, adults, and children arriving per that source.

***

## **Special Considerations & Best Practices**

* **Group Arrivals:**
  * Block summaries (e.g. “BOOKING.COM Rooms 10 Adults 19 Children 2”) help you quickly see volume per source.
  * Full group details are available if group bookings are enabled.
* **Duplicate/Linked Reservations:**
  * Some guests (like “Maria Anna Damato”) may appear more than once for split stays, or under the same voucher number—always verify voucher no/ID for clarity.
* **Internal Notes:**
  * If enabled, staff internal notes will appear under the reservation row, visible only for internal use (not shown to guests).
* **On Hold:**
  * “On Hold” reservations show the valid hold date; confirmed ones display “CONFIRMED”.
* **No assigned room:**
  * Room cell is blank if not yet assigned at the time of report.

***

## **Important Notes**

* **Default Currency:** All monetary amounts (if rates enabled) use the system’s base currency; currency conversion is automatic.
* **No two reservations share the same ID**—each is a unique record.
* **Totals at the bottom** of the report give the final arriving rooms, adults, and children for your selected period.

## ***Update: July 30, 2026***

### **Room Type Filter Hides Room Types With No Rooms**

The Room type filter now lists only room types that have at least one room mapped to them.

### **What's New?**

Room types with no rooms mapped to them no longer appear in the **Room type** filter. Retired room types stay in the system because historical reservations still reference them, but they are hidden from the filter instead of sitting there as options that return nothing.

### **How It Works**

1. Run the report from **Reports → FO → FrontDesk → Expected Arrival**.
2. Open the **Room type** filter — only room types with at least one room mapped to them are listed.
3. Map a room to a room type and it appears in the filter again; unmap every room and it disappears.

| Note: This affects the filter parameter only. The generated report still shows every room type it has data for, including retired room types and reservations kept after their room was moved to another type or deactivated. |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |