history_forecast.txt data yet.
Open Analysis → Import Raw Data Files and upload the file to populate this dashboard.
res_statistics (closed dates) + res_forecast (remaining dates)
Import data to view analysis
Select an import date above to load data.
Pick the month, drop in the 4 Opera exports, press Run. All 5 reports come back as a ZIP.
Select all 4 files at once — the type is detected from the file contents, so the order and the exact file names don't matter.
| Username | Display Name | Role | Permissions | Created | Actions |
|---|---|---|---|---|---|
| Loading… | |||||
Define named groups of market codes for column display in the Today / Yesterday / Pick Up tabs.
| Order | Group Name | Market Codes | Actions |
|---|---|---|---|
| Loading… | |||
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.
| Order | Group Name | Market Codes | Actions |
|---|---|---|---|
| Loading… | |||
Map market codes to geographic regions (e.g. Australia, China, Vietnam). Used for the GEO MARKET OTB table in the Category-GEO weekly report.
| Order | Region Name | Market Codes | Actions |
|---|---|---|---|
| Loading… | |||
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.
| Order | Group Name | Country Codes | Actions |
|---|---|---|---|
| Loading… | |||
Map room codes from the PMS to blocks (e.g. Building, Villa, Lagoon Villa). Used to group the Category-GEO weekly report.
| Order | Room Code | Description | Block | Rooms | Actions |
|---|---|---|---|---|---|
| Loading… | |||||
Enter room nights and room revenue per month. OCC% and ADR are computed automatically.
Enter the management forecast for each month. Used as comparison alongside Budget in analysis views.
Enter full-month figures. The Daily Revenue Report pro-rates them by days
elapsed: M-T-D Budget = Budget (Full Month) × day ÷ days in month,
and the same for the forecast. Last Year (Full Month) is used only until
the previous year's POS data is imported — after that the report reads the real figures.
Which POS category counts as Food, as Beverage or as Other Income on the report. Other / unallocated is the remainder the POS export leaves when its category columns do not add up to Sales Total.
Opera names each export with a sequence number that changes every day, so use
* to match the variable part. For example res_forecast*
matches res_forecast120277864.txt. When several files match, the app
takes the most recently modified one.
smtp.gmail.com, port 587, TLS off
(STARTTLS is used automatically). The password must be a
Google App Password, not your normal one —
Google Account → Security → 2-Step Verification → App passwords.
Port 465 also works if you tick Implicit TLS.
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.
Shows every market code's pickup and which group (OTA/MICE/Others) it maps to. If the total matches but OTA vs Others splits differ from the manual report, the misclassified code will be visible here as (unmapped) or in the wrong group.
Compares system pickup total against the manual report under 4 scenarios (incl/excl today-date and COMP/HOU codes).
Finds all market codes in pickup_excel that are not mapped to any Summary Group,
causing them to appear as a phantom "Others" entry. Shows the actual reservations with
Opera confirmation numbers so you can track them down.
Configure system-wide parameters that affect data processing and reporting.
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.