Project Details
| Case Study | SharePoint based Room Booking Management System for Hotel Prince |
| Industry | Hospitality |
| Location | India |
| Environment | Microsoft SharePoint On-Premise |
About Client
Hotel Prince came up with a simple and specific requirement of having a SharePoint-based Room Booking Management System. The client is into the hospitality industry, gets multiple bookings for their varied room types. Bookings are made in two categories which are advance or walk-in. Our application assisted users in keeping track of records for booking, rooms available, daily check-in/out.
Challenge
The client had a huge amount of room bookings in advance and walk-ins. To keep a daily track of confirmed bookings, walk-ins, room availability, or cancellation were the few key concerns. The system had to be utilized across multiple users in the organization with varied user permission and authorization.
Solution
AscenWork Technologies developed an end-t0-end Room Booking Management System that provided a trail of bookings which are done in advance, daily walk-ins, any cancellation of existing bookings, and room availability in real-time. The solution helped the client in planning the sales and occupancy of the entire room inventory. The system also captured room categories, room tariffs, special rates, discounts, and other utilities at the time of Invoice preparation. In addition, our SharePoint application was integrated with the GoFrugal System for accounting purposes.
Results
Tracking Room Availability, Daily Check-In / Check-Outs, Booking Calendar, and User-wise Dashboard helped Hotel Prince in automating the manual business process. In addition, we developed an Integrated Room Booking Management System with Restaurant application and Accounting Application. The system enabled automation from Guest check-in to Invoice Processing with a click of a single button. The system provided more than 25 key MIS Reports.
Features of Room Booking Management System
- Room Categorisation ( Standard / Deluxe / Suite )
- Room Occupancy Management ( Single / Dual / Family )
- Create Reservations for Rooms, Apartments, Studios, Halls, etc.
- Book multiple rooms in each reservation
- Define check-in and check-out times
- Select from the list of rooms available
- Live View of Reservations
- Live View of Capacity
- Live calendar View of Allocated Rooms and Capacity
- Customer Quick Search
- Define standard or seasonal room rates
- Automatic bill calculations
- Flexibility to add charges viz laundry/towels etc.
- Track deposits and customer payments
- Print Confirmations and Receipts
- Track Agent Commission Accounts and Payments
- Automatic tax calculation
- View Customer overdue amounts
Tools and Technology
- Microsoft SharePoint
- SharePoint Designer
- Visual Studio
- Web parts
- SharePoint Workflow
“It was a pleasure to be associated with AscenWork Team. The team of professionals helped our organizations to put up a great Application. Their efficiency can be seen from the end result. We are looking forward to collaborating again with AscenWork.”
