Running Analysis
⏱ 00:00
Month 1 OTB
Month 2 OTB
Month 3 OTB
This Month Pickup
This Month Pickup
(excl. HOU/COMP/VCOM/VHOUSE)
Total Pickup
(all months)
2026 Pickup YTD
(excl. HOU/COMP/VCOM/VHOUSE)
Monthly OTB Analysis
Click yellow cells to edit Last Year data

Import data to view analysis

Month 1 — ON THE BOOK REPORT (Physical Rooms: 79)
Month 2 — ON THE BOOK REPORT (Physical Rooms: 79)
Month 3 — ON THE BOOK REPORT (Physical Rooms: 79)
Month 4 — ON THE BOOK REPORT (Physical Rooms: 79)
Month 5 — ON THE BOOK REPORT (Physical Rooms: 79)
Month 6 — ON THE BOOK REPORT (Physical Rooms: 79)
Today — OTB by Market Code & Date
Import date:
Yesterday — OTB by Market Code & Date
Import date:
Pick Up (Today − Yesterday) by Market Code
Pick Up & Cancel by Arrival Month
ADR Analysis
Import Data Files

Upload statistics and/or forecast files, set a date range, then click Analyse.

New Reservation Report

Select an import date above to load data.

Daily Pick Up Q4 — By Market Segment
Summary Pickup
Loading…
Detail Pickup
Loading…
Weekly Report
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
GEO Market Report
Import one file per month — each becomes a column

Import one or more matrix files to generate the GEO report.
PAX ANA — On The Books (OTB) Report

Select a month to view OTB data.
PAX ANA — New Reservations

Select a month to view bookings.
PAX ANA — Cancellations

Select a month to view cancellations.
User Management
UsernameDisplay NameRolePermissionsCreatedActions
Loading…
Market Groups

Define named groups of market codes for column display in the Today / Yesterday / Pick Up tabs.

OrderGroup NameMarket CodesActions
Loading…
Summary Groups Market Group 2

Define named groups of market codes for the pickup summary widget on the Summary tab (e.g. OTA, MICE). Codes not assigned to any group appear as Others.

OrderGroup NameMarket CodesActions
Loading…
Geo Market Groups Geographic Origin

Map market codes to geographic regions (e.g. Australia, China, Vietnam). Used for the GEO MARKET OTB table in the Category-GEO weekly report.

OrderRegion NameMarket CodesActions
Loading…
Country Groups GEO Report

Map country codes (e.g. VN, KR, AU) to regional groups (e.g. Vietnam, Korea, Australia). Used to aggregate the GEO Market Report rows. Countries not mapped to any group appear under Others.

OrderGroup NameCountry CodesActions
Loading…
Room Types

Map room codes from the PMS to blocks (e.g. Building, Villa, Lagoon Villa). Used to group the Category-GEO weekly report.

OrderRoom CodeDescriptionBlockRoomsActions
Loading…
Budget Data

Enter room nights and room revenue per month. OCC% and ADR are computed automatically.

Annual Forecast Data

Enter the management forecast for each month. Used as comparison alongside Budget in analysis views.

Import Status
Imported Missing (required) Not imported (optional) Locked Not locked
Loading…
Diagnostics
Intraday Gap — Morning Excel vs Evening DB

Upload the morning Opera Excel for a date. The system compares it stayover-date by stayover-date against the DB import for that evening, then shows only the specific bookings that caused the gap — not all bookings for the day.

Pickup Compare — System vs Manual

Compares system pickup total against the manual report under 4 scenarios (incl/excl today-date and COMP/HOU codes).

Settings

Configure system-wide parameters that affect data processing and reporting.

New Reservation — Early Checkout

Reservations that are CHECKED OUT on the same day as the daily Opera export are included in the New Reservation list as Early Checkouts. Set the cutoff time to match when your daily export runs. Any booking checked out before this time will appear in today's New Reservation list.

Default: 09:00
Bookings with CHECKED OUT status and same-day departure (checked out before 09:00) are included in the New Reservation list with an Early C/O label.