Import data to view analysis
Upload statistics and/or forecast files, set a date range, then click Analyse.
Select an import date above to load data.
Select a month, import the month-end Opera files, then analyze and export all 5 standard reports.
Upload the Opera export files for the selected month. Files are automatically detected and stored with the last day of the month as the import date.
Queries the imported data, fills all 5 Excel templates, and packages them as a ZIP.
| 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.
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.