Solving Pharmacy Stock Leakage: The SIMBAT Ecosystem

Ever wondered how clinics and pharmacies struggle to track thousands of drug batches, expiry dates, and stock movements across multiple locations?

We saw small healthcare businesses drowning in Excel sheets and manual ledgers, risking expired medications reaching patients and suffering from “silent” stock leakage. That’s when we built SIMBAT (Sistem Informasi Manajemen Obat dan Alat Kesehatan)—a robust fullstack inventory management system designed to bring enterprise-grade accuracy to local clinics.

Figure 1: The real-time sales dashboard and inventory overview.

---

1. The Problem: The High Stakes of Healthcare Inventory

Managing medicine is far more critical than standard retail. A single error can lead to:

• Expired Inventory: Medications hitting patients past their shelf life due to poor batch tracking.
• Repackaging Errors: Losing track of quantities when bulk supplies are broken down into unit doses.
• Audit Gaps: No way to verify stock movements between central warehouses and clinic units.

Manual processes were not just slow; they were dangerous.

---

2. The Solution: Comprehensive Audit Trails

Built on Laravel 11, SIMBAT provides a “single source of truth” for every tablet and medical tool in the system.

Core Technical Features:

• Batch-Level Tracking: Full visibility into expiry dates and production batches to enforce FIFO (First-In, First-Out) logic.
• Automated Repackaging: A system that automatically handles the logic of breaking down bulk units into outpatient-ready doses while maintaining quantity integrity.
• Warehouse-to-Unit Flow: Orchestrated stock movement between central warehouses and clinic units with mandatory audit trails.
• Unified POS & Analytics: Integrated Point of Sale (POS) system that updates inventory in real-time, with professional PDF and Excel export capabilities for financial reporting.

Figure 2: The automated checkout calculation and POS interface.

---

3. The Impact: Catching Errors Before Shipment

The real game-changer was building the automated verification logic for stock flow. By implementing a strict audit trail, we enabled the clinic to:

• Zero Expired Shipments: Catch expired inventory before it ever leaves the warehouse.
• Automated Reordering: Prevent stockouts through real-time threshold alerts.
• Financial Transparency: Accurate sales dashboards that match physical stock counts perfectly.

Figure 3: Handling complex drug batch inputs and stock metadata.

---

The Team Behind SIMBAT

This project was a collaborative effort to bring stability to healthcare operations:

• Dimal Karim Ahmad: Project Manager
• Dwi Yoanda Febriarsa: UI/UX Designer
• Karina Andriani: Fullstack Developer
• Kamaluddin Fadllillah (Me): Fullstack Developer

Ready to modernize your inventory systems? Let’s discuss how customized solutions can protect your business.

#Laravel #PHP #HealthcareTech #InventoryManagement #Fullstack #SIMBAT