The Client
UB Ayurved is a comprehensive Ayurvedic and Panchakarma center seeking a customized digital management system. The client aims to streamline clinic operations across multiple branches, manage patient records, handle product sales (with GST compliance), and generate real-time business reports from a centralized web portal.
Solution Required
The client requires an integrated platform that enables:
– Patient management (registration, history, treatments)
– Doctor and staff management
– Branch-wise access and admin roles
– Inventory, billing, and invoice generation
– Product sales with GST compliance
– Reporting and data export functionality
– System updates as per regulatory requirements (e.g., HSN code, IGST)
Key Features
1. Multi-branch Access Control : Centralized admin panel and role-based branch login
2. Doctor & Patient Management – Registration, visits, symptoms, prescription, and record keeping
3. Inventory & Product Sales – Item-wise billing, stock control, and discounts
4. Invoice & Billing System – GST-compliant invoices, downloadable PDF
5. Reporting Module – Daily/Monthly sales, medicine reports, doctor reports
6. Regulatory Enhancements – HSN Code Integration in items, invoices, and reports, IGST Support for interstate transactions, and Patient ID and Mobile Number Separation for better data management
Our Roles
As the technology partner, our roles include:
– System architecture and development
– UI/UX design and dashboard creation
– Database modeling and security protocols
– Feature rollout as per GST and healthcare norms
– Ongoing support and upgrade implementation
Technology Stack
– Frontend: HTML5, CSS3, JavaScript, Bootstrap
– Backend: PHP (Laravel/Custom PHP framework)
– Database: MySQL
– Reporting: Dynamic reports with filter and export options
– PDF Generation: TCPDF/Dompdf (for invoice and receipts)
– Security: Role-based access, encrypted sessions
Challenges
– Ensuring compliance with evolving GST laws (HSN, IGST structure)
– Decoupling patient contact from system-generated identity
– Designing a smooth UI for health professionals with minimal tech usage
– Handling multi-branch access with real-time synchronized data
– Generating legally acceptable GST-compliant invoices and tax reports
Solution
To address the new requirements and existing scope:
1. HSN Code Integration: Add HSN field in Item Master, show in invoices (UI + PDF), and include in sales reports.
2. “IGST Handling:* Auto-detect based on customer vs clinic state, apply IGST/CGST+SGST logic, reflect in invoice UI and reports.
3. “Patient ID Separation:” Redesign patient forms to store and display Patient ID and Mobile Number as distinct fields, allow filtering/search by both.
These are built on top of the existing robust modules for patient and doctor management, billing, and reporting.
Results
Upon implementation, UB Ayurved will benefit from:
– Full GST Compliance: Legal invoices ready for filing and audits
– Improved Data Accuracy: Clear separation of patient identity and contact
– Operational Transparency: Branch-wise tracking and audit-friendly reports
– Scalability Ready: The system is modular to accommodate future branches, new features, and integrations
