> ## 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.
# Year View Rooms Forecast Report
> Visualize 12 Months of Daily Occupancy Trends in One View. The Year View Rooms Forecast report provides hotel management with a complete 12-month rolling view of daily expected or historical room o...
Visualize 12 Months of Daily Occupancy Trends in One View.
***
The **Year View Rooms Forecast** report provides hotel management with a complete 12-month rolling view of daily expected or historical room occupancy. This report helps teams identify occupancy trends, seasonality patterns, and pacing gaps using daily room-level data.
### **Business Value**
* **Better Long-Term Planning:** Analyze year-ahead occupancy to support forecasting and budgeting.
* **Identify Seasonality:** Compare daily occupancy trends across a full year.
* **Revenue Optimization:** Spot compression periods and low-demand months early.
* **Single, Consolidated View:** No need to generate multiple reports.
***
### **How to Access**
[**Reports → FO → Reservation → Year View Rooms Forecast**](https://manage.kwentra.com/reports/Reservation/Year%20View%20Rooms%20Forecast/)
### **Report Parameters**
* Single month picker, determines the **starting month** for the 12-month rolling view
Example: selecting **October 2025** generates data for **Oct 2025 → Sep 2026**
***
### **Report Outcome**
#### **Columns**
* Date range displayed (12 months from selected month)
#### **Rows (1–31)**
* Each row = day of the month
* Shows:
* **Occupied Rooms** (absolute number)
* **Occupancy %** (formatted to one decimal place)
> For dates that don’t exist (e.g., Feb 30), the cells appear N/A.
***
### **Summary Row (Bottom)**
For each month:
* **Total occupied room-nights**
* **Average occupancy percentage**
***
### **Daily Data Retrieval**
* Query retrieves daily occupancy values for the full 12-month period
* Supports **past**, **current**, and **future** dates
* Works with forecast data and historical room-night data
## ***Update: 6 May, 2026***
### **New Number Of Guests Column and Grand Total Row**
The Year View Rooms Forecast Report adds a Pax column, a Year Grand Total row, and a redesigned single-row-per-day layout with three sub-columns per month.
Each day of the month is now displayed as a single row with three sub-columns per month
The header is two-tiered: the month label (e.g. Apr-26) spans the three sub-columns above, with Rooms | Pax | OCC% as sub-headers beneath each month.
**Month Total Row**
The existing total row at the bottom of the report continues to show per-month sums of Rooms, Pax, and OCC% across all days of that month. OCC% on this row is calculated on the totals, not an average of daily values.
**Year Grand Total Row (New)**
A new Year Grand Total row appears below the Month Total row. It shows:
* Rooms — sum of all daily Rooms across the full 12 months
* Pax — sum of all daily Pax across the full 12 months
* OCC% — computed on the totals (total Rooms / total available inventory across the full year)
| The Year Grand Total row is visually distinct (bold/shaded) to distinguish it from the per-month total rows. Days that do not exist (e.g. Feb 30) display N/A and are excluded from totals. |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
