Project Summary
This project focused on automating order management and sales reporting at Jacko’s Kan-anan by implementing the Loyverse POS system using a Samsung Galaxy A10 tablet, a Kitchen Display System (KDS) and Booking Automation. The solution streamlined front-of-house operations, reduced kitchen errors, and enabled real-time sales and accounting integration through Make.com and Zapier.
Objectives
Implement a user-friendly POS and KDS solution to improve order accuracy and service speed
Enable real-time reporting and accounting automation
Eliminate manual sales tracking and reduce reporting delays
Scope
Included:
Setup and configuration of Loyverse POS on a Samsung Tablet
Deployment of a tablet-based Kitchen Display System
Integration with Google Docs and Google Sheets via Make.com and Zapier
Staff onboarding and testing
Excluded:
Multi-location synchronization (targeted for future expansion)
Loyalty program features
Timeline
Duration: 8 weeks (May– June 2023)
Milestones:
Week 1: Tool selection and procurement
Week 2: Loyverse and KDS configuration
Week 3: Integration setup with Google Sheets/Docs
Week 4: Staff training and dry runs
Week 5–6: Live deployment and system monitoring
Budget and Resources
Estimated Budget: 30,000 PHP
Actual Spend: 26,850 PHP
Key Resources:
Project Manager (self)
POS vendor documentation and community support
Restaurant team
Integration platforms: Make.com, Zapier
Methodology / Approach
Waterfall project approach for step-by-step rollout
Tools and Platforms:
Loyverse POS (tablet-based)
Kitchen Display System (Android-based)
Make.com and Zapier for sales and accounting automation
Google Sheets/Docs for real-time reporting dashboards
Challenges and Solutions
Challenge: Staff unfamiliarity with automation tools
Solution: Conducted personalized training and created visual SOPs
Challenge: Data formatting for accurate reporting
Solution: Standardized item names and structured Google Sheets templates for consistency
Project Implementation
Point-of-Sales (iOS)
Sales Reporting
Accounting/Balance Sheet Integration
Booking System
Outcomes / Results
Order accuracy improved within the first month
Average order-to-kitchen dispatch time reduced by 40%
Sales data automatically updated daily in Google Sheets, enabling instant access for accounting
Real-time Sales Report
Positive feedback from staff due to simplified workflow
Lessons Learned
Cloud-based tools like Loyverse and Google integrations are highly scalable and user-friendly
Automation platforms like Make.com and Zapier provide powerful, low-code integration options
Future improvements should include setting up backup reporting and automating inventory controls