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

# Occupancy By Room Type Report

> Track daily occupancy, availability, and revenue for every room type or room category across a date range, at three levels of detail.

Track daily occupancy and availability per room type across a date range, with optional revenue and ADR.

### **Business Value**

* Monitor occupancy and availability per room type, day by day.
* Switch between room type and room category breakdowns.
* Includes revenue and ADR at the deepest level of detail.
* Spots oversold room types before they reach the front desk.
* Export to XLS, XLSX, ODS, or PDF for revenue meetings.

### **Use Cases**

* Revenue manager reviews month-to-date occupancy per room type before a pricing call.
* Reservations manager checks which room types are oversold on peak dates.
* General manager exports monthly ADR per room type for the owner's report.

### **How It Works**

| **Where:** Reports → FO → Reservation → Occupancy By Room Type |
| -------------------------------------------------------------- |

#### **Running the Report**

| **Parameter**               | Description                                                                                               |
| --------------------------- | --------------------------------------------------------------------------------------------------------- |
| **From date** / **To date** | The date range to report on. The report returns one row per date in the range.                            |
| Level of detail             | **Simplified**, **Detailed**, or **Detailed with Revenue** — controls which columns appear per room type. |
| Data type                   | **Room Type** or **Room Category** — controls whether the breakdown is by room type or by room category.  |
| Reservation confirmation    | Which reservations to count, for example **Confirmed Only**.                                              |
| Room type                   | Optional. Limit the report to one or more room types.                                                     |
| Room category               | Optional. Limit the report to one or more room categories.                                                |
| File type                   | Choose XLS, XLSX, ODS, or PDF.                                                                            |

Use **Download** to export, **Preview** to view on screen, or **Print** to send it to a printer.

#### **How the Level of Detail Changes the Output**

The report is laid out as one column block per room type (or room category), with dates down the left and a **Total** block on the right. The level of detail decides how many columns each block has.

| **Level of detail**   | Columns per room type            |
| --------------------- | -------------------------------- |
| Simplified            | Occ, Avl                         |
| Detailed              | Occ, Avl, OOO, TR, Alc           |
| Detailed with Revenue | Occ, Avl, OOO, TR, Alc, Rev, ADR |

At the **Detailed** levels the report also adds a **Total** row at the bottom, summing each column over the whole date range.

#### **Report Columns**

| **Column**        | Description                                                        | Example   |
| ----------------- | ------------------------------------------------------------------ | --------- |
| Occ               | Rooms occupied on that date for the room type.                     | 22        |
| Avl               | Rooms available on that date for the room type.                    | 18        |
| OOO               | Rooms out of order on that date.                                   | 14        |
| TR                | Total rooms counted for the room type.                             | 40        |
| Alc               | Rooms allocated on that date.                                      | 0         |
| Rev               | Room revenue for the room type on that date.                       | 17,113.87 |
| ADR               | Average Daily Rate for the room type on that date.                 | 777.90    |
| Total (Occ / Avl) | Occupied and available totals across all room types for that date. | 277 / 225 |

| **Note:** Availability can show a negative number when more rooms are occupied or allocated than the room type actually has — a useful early signal that the room type is oversold on that date. |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |

The report header carries the property name, the user who ran it, the run timestamp, and the reported date range.

## ***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 → Reservation → Occupancy By Room Type**.
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. |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |