PMS Field Mapping
Pronity Technologies Pvt Ltd
Manager Report100% Fully Mapped & Active
Operations Report100% Fully Mapped & Active
Cashier Report100% Fully Mapped & Active
Forecast Report100% Fully Mapped & Active
In-House Occupancy List100% Fully Mapped & Active
Today Arrivals100% Fully Mapped & Active
| Source PMS Column / Cell Label | Indicates What | Data Type | Required | Notes | |
|---|---|---|---|---|---|
ResortOps dashboard preview Session demo · Supplied extract samples
Total Inventory
92
Occupied Rooms
61
Available Rooms
31
Occupancy Percentage
66.3%
Total Revenue
₹2,42,571.00
Room Revenue
₹1,46,622.50
Arr
₹2,403.65
Fnb Revenue
₹98,403.02
Guest Count
61
Forecast 7d Occ
70.03%
Source Sheet2 mapping evidence
Client file mapping · MANAGER_REPORT.xlsx
Detected sheet: Sheet2 · Label / value · Day / Month / Year
Supplied Sheet2 extract · Demo suggestions, not production ingestion
18 mapped0 review1 not mapped
| Source label / row | ResortOps field | Sample value | Status | Confidence / note |
|---|---|---|---|---|
| TOTAL ROOMS IN HOTEL · For The Day Sheet2 · supplied extract | total_rooms | 92 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| TOTAL ROOMS IN HOTEL · For The Month Sheet2 · supplied extract | total_rooms | 1748 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| TOTAL ROOMS IN HOTEL · For the year Sheet2 · supplied extract | total_rooms | 18584 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| ROOMS OCCUPIED · For The Day Sheet2 · supplied extract | occupied_rooms | 61 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| ROOMS OCCUPIED · For The Month Sheet2 · supplied extract | occupied_rooms | 1286 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| ROOMS OCCUPIED · For the year Sheet2 · supplied extract | occupied_rooms | 13137 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| COMPLIMENTARY ROOMS · For The Day Sheet2 · supplied extract | complimentary_rooms | 0 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| AVAILABLE ROOMS · For The Day Sheet2 · supplied extract | vacant_rooms | 31 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| GUEST IN HOUSE · For The Day Sheet2 · supplied extract | guest_count | 61 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| %ROOMS OCCUPIED · For The Day Sheet2 · supplied extract | occupancy_percent | 66.3% | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| HOTEL REVENUE · For The Day Sheet2 · supplied extract | total_revenue | ₹2,42,571.00 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| ROOM REVENUE · For The Day Sheet2 · supplied extract | room_revenue | ₹1,46,622.50 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| AVERAGE ROOM RATE (ARR) · For The Day Sheet2 · supplied extract | average_room_rate | ₹2,403.65 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| F&B REVENUE · For The Day Sheet2 · supplied extract | food_beverage_revenue | ₹98,403.02 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| REPEAT GUESTS · For The Day Sheet2 · supplied extract | repeat_guests | 41 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| COMPANY GUESTS · For The Day Sheet2 · supplied extract | company_guests | 57 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| COMPANY REVENUE · For The Day Sheet2 · supplied extract | company_revenue | ₹1,43,125.00 | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| %OCCUPANCY NEXT 7 DAYS · For The Day Sheet2 · supplied extract | seven_day_occupancy_percent | 70.03% | Mapped | High · Label and period matched. Current/prior-year context requires confirmation. |
| Report date / prior-year headings Not located in Sheet2 | report_date | — | Not mapped | Review · Business date and prior-year values were not included in the supplied extract; verify them in the workbook. |