| Date | Day | OTB Rooms |
OTB Revenue |
ADR | RevPAR | ARR | Occ % | Sellable Rooms |
LY Rooms |
LY Revenue |
LY ARR | LY Occ% | Var Rooms |
Var Rev |
Budget Rooms |
Budget Rev |
Budget ADR |
Budget Occ% |
Fcst Rooms |
Fcst Rev |
Fcst ADR |
Fcst Occ% |
|||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Select a month and press Sync Opera to load data. | |||||||||||||||||||||||||
Enter last year's actual daily performance. Dates entered here are the prior-year dates (e.g. May 2025 for a May 2026 view). ADR and Occ% are auto-calculated from Rooms & Revenue if left blank. You can also paste Opera's history_forecast export for May 2025 directly into the matching fields.
| LY Date | Day | LY Rooms | LY Revenue | LY ADR (auto) |
LY ARR | LY Occ% (auto) |
|---|---|---|---|---|---|---|
| Select a month and click "Load Current Values". | ||||||
Enter or paste daily budget and forecast values below. Click Save when done. Values are stored locally on this server and overlaid on the Daily OTB grid.
| Date | Day | Budget Rooms |
Budget Revenue |
Budget ADR |
Budget Occ % |
Fcst Rooms |
Fcst Revenue |
Fcst ADR |
Fcst Occ % |
|
|---|---|---|---|---|---|---|---|---|---|---|
| Select a month and click "Load Current Values". | ||||||||||
Weekly Occupancy % — OTB vs LY vs Budget
Weekly Revenue — OTB vs LY vs Budget
Weekly Room Nights — OTB vs LY vs Forecast
| Week | Dates | Days | OTB Rooms | OTB Occ% | OTB Rev | OTB ADR | LY Rooms | LY Occ% | LY Rev | Bgt Rooms | Bgt Occ% | Bgt Rev | Fcst Rooms | Fcst Occ% | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||||||||
Cumulative OTB Pace — Rooms On The Books by Date
Solid line = this year's running total OTB. Dashed = last year actual. Shows whether you're ahead or behind LY pace.
Daily OTB vs LY vs Budget — Room Nights
OTB vs Last Year — Room Surplus / Deficit by Stay Date
Green = ahead of last year's final occupancy for that date. Red = behind. As daily snapshots accumulate, the D-7 / D-14 / D-30 pickup columns in the table below will fill in automatically.
Pickup Detail by Stay Date
| Stay Date | Day | OTB Now | Pickup vs D-7 |
D-7 OTB | D-14 OTB | D-30 OTB | D-60 OTB | D-90 OTB |
LY Final | Var vs LY | Budget | Var vs Bgt | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||||||
Transient (individual) and Group (block) room night breakdown from Opera Business-On-The-Books export. Definite = contracted group blocks. Tentative = provisional allocations not yet confirmed.
Daily Transient vs Group Mix — Rooms On The Books
Stacked by day. Lighter = Group Tentative. Hover to see exact split.
Transient (Individual) — Segment Matrix
| Stay Date | Day | Transient Rooms |
Occ % (Trans) |
Revenue | ADR | Mix % vs Total |
LY Trans Rooms |
LY Trans Revenue |
Var Rooms |
|
|---|---|---|---|---|---|---|---|---|---|---|
| Click "Segments" to load data. | ||||||||||
Group (Block) — Segment Matrix
| Stay Date | Day | Total Group Rooms |
Grp Occ % | Definite Rooms |
Definite Revenue |
Tentative Rooms |
Tentative Revenue |
Group ADR |
Mix % vs Total |
|---|---|---|---|---|---|---|---|---|---|
| Click "Segments" to load data. | |||||||||
Source: Opera Business-On-The-Books export (INDRES = Transient, BLKRES = Group Definite, BLKBKS-N = Group Tentative). Re-export from Opera Reports and re-sync to refresh.