Challenge

Customer required a windows based restaurant management system to automate all the transactions occurring in the restaurant beginning with staff management, ordering and order process, billing, inventory management and accounting.

Key challenges of the project were:
  • Developing and integrating total accounting modules including calculation of VAT, Tax, Foreign Exchange transactions and MTM Gains or losses etc.
  • Implementing touch screen PDA user interface for sales counter
  • Integrating centralized kitchen with different restaurants and bars.
  • Inventory management of food items.
Solution
TatvaSoft provided a solution that was highly effective in managing the restaurant business while meeting the following requirements:
  • Customer management with gift voucher functionality and happy hours feature where customers can avail discounts on food items
  • Bill Payment options like cash, cheque, credit cards etc. in multiple currencies
  • Sales counter with touch screen facility that includes:
    • Opening, assigning and reserving table
    • Kitchen Order Ticket (KOT) management like KOT order, served rejected etc.
    • Take away meal service
    • Managing shift timings of staff
    • Reports with Complete Sales and other transaction Summary with Currency wise cash balance of counter
  • Providing catering services on different occasions
  • Inventory management in store/kitchen/bar
  • Generation of GRN, Purchase order, Supplier invoice etc.
  • Report generation for different processes like:
    • Purchase
    • Sales & POS Repots
    • Inventory
    • MIS
    • Financial
  • Currency management with exchange rate change effects with one base currency
  • Maintaining year wise details for each company in separate Database
  • Category wise Staff details (Chef, Waiter, accountants etc.)
Result

We developed a fully automated restaurant management system with touch screen facility for sales counter and different modules including staff management, inventory and accounting system. Different reports can be generated to analyze data and help manager to make appropriate business decisions for the restaurant. For example, knowing the number of customers for a particular time interval, manager can decide whether more waiters and chefs are required.

Technology
  • Server: Microsoft Windows Server
  • Web Server: IIS
  • Programming Language: C#
  • Database: MySQL 5.0
  • Framework: Microsoft .Net Framework
  • Reporting Tool: Crystal Report 10