Hotel & Restaurant Management System
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu and daily reports behind a login screen.
- Industry
- Hospitality
- Deliverable
- Hotel Management System.xlsm
- Built with
- Excel VBA, UserForms, Shapes
Before
Room status, table bookings and orders were tracked on paper and in separate files.
After
A building map shows live room status and the restaurant module handles bookings, orders and daily reports.
More like this
Related projects
Trade Opportunity Finder & Profitability Analysis
International Trade
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading…
View project
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project
Property Management Rent Ledger
Property Management
A rent and landlord statement system. Each property has its own ledger of rent, fees, VAT and landlord payments, statements are imported, and the dashboard totals…
View project