We have implemented a custom Hotel / Guest House Management App in Frappe ERPNext for managing hotel and guest house operations in a structured and automated way. The app is designed to handle the complete flow from reservation to room booking, guest management, check-in, check-out, room status updates, reporting, and integrations with external systems.

The app includes master management for Rooms and Room Types. Each room can be configured with its room type, room number, lock ID, and current room status. Room statuses such as Vacant, Occupied, Dirty, Clean, Maintenance Blocked, and Reserved Blocked are used to track the real-time condition and availability of rooms.

A Reservation module has been created to manage upcoming reservations with details such as customer, reservation dates, room type, guest details, and related booking information. The system supports date-based availability checking so that only available room types and rooms are shown during reservation or booking. This helps prevent double booking and improves front-desk accuracy.

The Room Booking module manages the actual booking process. It includes fields such as from date, to date, room type, room number, total amount, pending amount, check-in time, check-out time, workflow state, and guest child table. We also implemented logic for handling primary guests, where only one guest can be marked as the primary guest in a booking.

Room booking workflow automation has also been implemented. When a guest is checked in, the selected room status is updated to Occupied. When the guest checks out, the room status is updated to Dirty, so housekeeping can clean and prepare the room again. Custom buttons and logic were added to manage room status changes like Clean and Vacant from the Rooms screen.

The app also includes calculations for booking amount and pending amount. The pending amount can be set based on payment status or manually controlled depending on the requirement. This helps track whether a booking has full payment, partial payment, or pending dues.

We have also worked on Reports and Dashboard features. Reports such as the Arrivals Report show upcoming guest arrivals with details like date of reservation, room type, guest type, customer, and booking reference. Dashboard-style views were planned and designed to show important hotel KPIs such as total rooms, vacant rooms, occupied rooms, dirty rooms, upcoming reservations, revenue, profit, loss, occupancy rate, and booking trends.

Overall, the Hotel Management App currently provides a complete foundation for managing reservations, room bookings, guest records, room availability, room status, check-in/check-out operations, housekeeping flow, reports, dashboard analytics, and external hotel service integrations inside Frappe ERPNext.