Every diagram you drew, every report you specified — built.
This document maps your handwritten process flows and departmental report requirements directly into a live system design. The diagrams, seeded data, and report formats below reflect exactly what you specified across all three pages of your notes.
Drawn from your handwritten flow diagram — every stage, every branch, every annotation faithfully reproduced as a process diagram.
Your diagram shows Main Stores as the backbone feeding Pharmacy, Lab, and Radiology with a two-way Supply and Report & Resupply loop. The Admin Wing feeds procurement back into this cycle.
Total patients per day, total cash collected, queue and department allocation — disaggregated by gender. Seeded with live sample data for today, Sunday 26 April 2026.
Emergency cases, RCH, injections, attending physician, tests prescribed (filterable), medicines prescribed, all products used — per encounter, pulled from triage and reception combined.
Tests conducted, consumables used per test with balance, stock received vs balance, stock variance on stock-taking — all exactly as you specified.
Receipts disaggregated by cash and credit, sales aggregated by payment method, stock balance and stock variation — nurse station dispensing tracked as a sub-report.
All columns exactly as you specified: Item Name, Strength, Brand/Chemical, Formulation, Category (Pharma/Lab/Consumable/Community), Use, Purchase Unit, Entry Qty, Add Qty, Selling Price, Min/Max, and Balance.
| Item Name | Strength | Brand / Chemical | Formulation | Category | Use | Purchase Unit | Entry Qty | Add Qty | Selling Price | Min | Max | Balance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amoxicillin | 500mg | Amoxil / Amoxicillin trihydrate | Capsule | Pharma | Oral antibiotic | Box/500 | 500 | +120 | TZS 850 | 200 | 1,000 | 620 check_circle |
| Paracetamol | 500mg | Panadol / Paracetamol | Tablet | Pharma | Analgesic / antipyretic | Box/1000 | 1000 | +500 | TZS 120 | 400 | 2,000 | 1,248 check_circle |
| Malaria RDT Kit | — | SD Bioline / CareStart | Rapid Test | Lab | Malaria diagnosis | Box/25 | 50 | +0 | TZS 4,500 | 20 | 100 | 8 warning |
| IV Cannula 18G | 18G | BD Venflon / Surflash | Catheter | Consumable | IV access | Box/50 | 100 | +0 | TZS 2,800 | 30 | 150 | 4 error |
| Surgical Gloves | M/L | Ansell / Medline latex | Latex pair | Consumable | Procedure use | Box/100pr | 300 | +100 | TZS 1,200 | 100 | 500 | 248 check_circle |
| Metformin | 500mg | Glucophage / Metformin HCl | Tablet | Pharma | Type 2 diabetes | Box/500 | 500 | +0 | TZS 340 | 150 | 800 | 322 check_circle |
| ORS Sachets | 20.5g | ORS / Oral Rehydration Salts | Sachet | Community | Rehydration | Box/100 | 200 | +50 | TZS 400 | 50 | 300 | 175 check_circle |
| Cotrimoxazole | 480mg | Septrin / Trimethoprim+Sulpha | Tablet | Pharma | Antibiotic — UTI, PCP | Box/1000 | 1000 | +0 | TZS 180 | 200 | 1,500 | 198 warning |
| Item Name | Strength | System Balance | Physical Count (Actual) | Variance | Status | Notes |
|---|---|---|---|---|---|---|
| Amoxicillin 500mg | 500mg | 620 | 615 | −5 | Discrepancy | Under investigation |
| Paracetamol 500mg | 500mg | 1,248 | 1,248 | 0 | Balanced | — |
| Malaria RDT Kit | — | 8 | 6 | −2 | Discrepancy | 2 expired batch disposed |
| IV Cannula 18G | 18G | 4 | 4 | 0 | Balanced | — |
| Surgical Gloves M/L | M/L | 248 | 248 | 0 | Balanced | — |
| Cotrimoxazole 480mg | 480mg | 198 | 195 | −3 | Discrepancy | Nurse station issued but not logged |
All reports are filterable by branch, date range, and role. Heads of department see their scope only. Management sees the consolidated multi-branch view.
Core patient flow goes live first. Inventory intelligence, reporting, and multi-branch capability are layered in progressively. Each phase delivers independently usable functionality.