I am looking to develop a property management system for small hotels. I had selected a software development company then stopped to think I use gdocs & forms in my business could something be developed to meet the needs?
I know the foundation for many of the requirements exist but need tweaking and integration with each other. But also need to understand if the over all system requirements would even be capable?
-At a high level functionality would need to include
-Room reservation and confirmation by room type;
-Rooms database to assigning room number to room type, amenities, maintenance log,
-Room pricing schedule on June 17 a standard room is 1000 and on June 18 1200 etc
-method to create specials and or special coupon codes
-Customer Database (standard customer info)
-Expense & bill tracking
-Customer room minibar, restaurant and laundry charges and payments
-I'd like translation built in. I was thinking of building a master table (in English) of menu items and field entry title the the next column as needed I could add Thai, Japanes etc then via vlookup the data would change based on user language selection example below is over simplified ...
English Japanese Thai Chinese
-importurl functions to pull in hotel ratings from sites like TripAdvisor, Agoda Expedia
-can importurl functions pull in data from sites requiring a user name and password?
-employee database tracking of basic employee info and assigning a security providing/ limiting their access to tables/reports/function
-reporting (daily/weekly/monthly/ user defined period) sales, room use. rates etc
-agents database to tie reservations sources ie Expedia or Agoda to the reservation and track commissions paid
-housekeeping database ability to create cleaning types ie daily we do A,B,C if there is a customer, if a customer checks out that day we do A,B,C,D,E, monthly, quarterly etc so based off the reservations calendar a daily report would show cleaning needed for each room.
-products database for minbar, restaurant, gift shop, tours, items cost, customer price, inventory etc
-approval workflow for expenses, time off etc
-invoicing of agents and customers
I grouped things together as best I could. If you think this is feasible for pricing maybe quote as a whole package and smaller chunks like reservations, employee, invoicing, or however you thing best completed.