Project overview

TSD developed a comprehensive, centralized ERP and CRM system for HydroLogic Social Enterprise, the operator of Super Tunsai clean water products. The platform integrates sales tracking, inventory management, HR and payroll, customer support, delivery scheduling, financial accounting, and advanced reporting. Built as a responsive web application with a companion mobile app, it supports office staff and field teams across Cambodia. Custom dashboards provide real-time KPIs on revenue, orders, top products, and pending tasks. The solution replaced scattered Excel files with a secure, unified system aligned with the enterprise’s mission to expand access to safe drinking water.

client

Hydrologic Social Enterprise (Tunsai Water)

Services Provided

Custom ERP/CRM Development, Web & Mobile Application Design, Data Migration & Integration, Dashboard & Analytics Implementation, Role-Based Access Control, User Training & Change Management

Objectives

The goal was to replace fragmented manual processes with a single, centralized ERP/CRM platform accessible on web and mobile, covering all core business functions for Super Tunsai’s water purification distribution and social impact operations. The system aimed to boost efficiency, accuracy, and scalability while maintaining affordability for a social enterprise.

‣ Centralize sales, stock, HR, payroll, CRM, delivery, accounting, and reporting.

‣ Provide real-time visibility and analytics across all departments.

‣ Enable mobile access for field sales, delivery, and customer service teams.

‣ Reduce manual errors and time spent on data reconciliation.

‣ Support data-driven decision-making for business growth and impact.

Banner 60 12 - TSD Software Development in Cambodia

Banner 60 16 - TSD Software Development in Cambodia

Key Outcomes

The centralized ERP platform unified Super Tunsai’s operations, delivering real-time insights and significantly improving efficiency across sales, delivery, and support functions. It empowered leadership with accurate data for strategic decisions and supported sustainable growth in water access initiatives.

‣ Eliminated Excel silos with single-source-of-truth data management.

‣ Enabled real-time dashboards for revenue, orders, customers, and stock levels.

‣ Improved delivery accuracy and field team productivity via mobile app.

‣ Streamlined HR, payroll, and customer support processes.

‣ Provided actionable analytics driving operational and financial improvements.

Challenges

HydroLogic Social Enterprise (Super Tunsai) relied on fragmented Microsoft Excel files and manual processes to manage sales, inventory, HR, payroll, delivery, customer support, and financials across multiple teams and locations. This led to data silos, errors, delayed reporting, and inefficiencies in scaling operations for clean water product distribution.

‣ Disconnected data across separate Excel sheets for each department.

‣ Time-consuming manual data entry and reconciliation.

‣ Lack of real-time visibility into sales, stock, and delivery performance.

‣ No centralized customer view or support ticket tracking.

‣ Difficulty accessing insights on mobile devices for field and delivery staff.

03 scaled - TSD Software Development in Cambodia

Strategy & Approach

TSD began by deeply analyzing existing Excel-based workflows and interviewing stakeholders across sales, operations, HR, and finance to capture all requirements. We prioritized a modular, scalable architecture that allowed phased implementation without disrupting daily operations. UX/UI design focused on simplicity and mobile-first principles to accommodate varying user technical skills. Agile development with bi-weekly sprints incorporated continuous feedback and iterative improvements. Data migration was handled carefully to ensure accuracy and integrity during transition. Robust security, offline capabilities for mobile, and comprehensive training ensured smooth adoption across the organization.

Strategy & Approach

TSD began by deeply analyzing existing Excel-based workflows and interviewing stakeholders across sales, operations, HR, and finance to capture all requirements. We prioritized a modular, scalable architecture that allowed phased implementation without disrupting daily operations. UX/UI design focused on simplicity and mobile-first principles to accommodate varying user technical skills. Agile development with bi-weekly sprints incorporated continuous feedback and iterative improvements. Data migration was handled carefully to ensure accuracy and integrity during transition. Robust security, offline capabilities for mobile, and comprehensive training ensured smooth adoption across the organization.

Execution

TSD conducted comprehensive requirement workshops and analyzed existing Excel workflows to map all business processes. We designed a unified data model and built the core ERP platform with modular components for sales, inventory, HR/payroll, CRM, delivery scheduling, accounting, and analytics. A responsive web application was developed alongside a companion mobile app for field teams to handle orders, deliveries, and customer interactions on the go. Role-based access controls ensured data security across departments. Iterative prototyping and user testing refined dashboards, task management, and reporting features. The system was deployed with data migration from legacy files, followed by comprehensive staff training and phased rollout.

Execution

TSD conducted comprehensive requirement workshops and analyzed existing Excel workflows to map all business processes. We designed a unified data model and built the core ERP platform with modular components for sales, inventory, HR/payroll, CRM, delivery scheduling, accounting, and analytics. A responsive web application was developed alongside a companion mobile app for field teams to handle orders, deliveries, and customer interactions on the go. Role-based access controls ensured data security across departments. Iterative prototyping and user testing refined dashboards, task management, and reporting features. The system was deployed with data migration from legacy files, followed by comprehensive staff training and phased rollout.

Results & Impact

The ERP system dramatically improved operational efficiency and data accuracy for Super Tunsai, enabling faster decision-making and better resource allocation. Real-time visibility reduced stockouts, delivery delays, and administrative overhead. Mobile capabilities empowered field teams to process orders and update deliveries instantly. Leadership gained reliable financial and performance insights previously unavailable. The platform supported scalable growth without proportional increases in back-office staff. Overall, it strengthened Super Tunsai’s ability to deliver social impact while maintaining commercial sustainability.

Results & Impact

The ERP system dramatically improved operational efficiency and data accuracy for Super Tunsai, enabling faster decision-making and better resource allocation. Real-time visibility reduced stockouts, delivery delays, and administrative overhead. Mobile capabilities empowered field teams to process orders and update deliveries instantly. Leadership gained reliable financial and performance insights previously unavailable. The platform supported scalable growth without proportional increases in back-office staff. Overall, it strengthened Super Tunsai’s ability to deliver social impact while maintaining commercial sustainability.

Key Learnings & TSD's Value Add

This project demonstrated the transformative impact of centralized systems on social enterprises with limited resources and distributed teams. We learned the importance of designing intuitive mobile interfaces for low-connectivity environments common in distribution operations. TSD’s value add was delivering a fully custom, scalable ERP tailored to the client’s unique clean-water mission without relying on expensive off-the-shelf solutions. Our modular architecture allowed future expansion while keeping initial costs manageable. Strong change management and hands-on training minimized adoption resistance. Future phases could incorporate IoT integration for water purifier monitoring and predictive inventory analytics.

Key Learnings & TSD's Value Add

This project demonstrated the transformative impact of centralized systems on social enterprises with limited resources and distributed teams. We learned the importance of designing intuitive mobile interfaces for low-connectivity environments common in distribution operations. TSD’s value add was delivering a fully custom, scalable ERP tailored to the client’s unique clean-water mission without relying on expensive off-the-shelf solutions. Our modular architecture allowed future expansion while keeping initial costs manageable. Strong change management and hands-on training minimized adoption resistance. Future phases could incorporate IoT integration for water purifier monitoring and predictive inventory analytics.

your ideal Innovative software. Scalable products. Proven results.