MedTechTree Executive Pharmacy Analytics

MediFlow HMS Connected • Andheri West Flagship • DL: 20-MH-123456 • GSTIN: 27AAACM1234F1Z5

Today's Gross Sales

₹48,920.00

+14.2% vs yesterday

Net Gross Margin

22.4%

+1.8% overall margin

Active Stock Value

₹8,42,150.00

1,240 Batches on-hand

Near-Expiry Risk (90d)

₹18,450.00

4 Batches require return

Real-time counter bills with GST & Schedule H1 tags

Invoice No	Patient / Buyer	Items	Amount	Payment	Time
BR01/26-27/001429H1	Amit Verma	2	₹356.00	UPI Dynamic	08:12 PM
BR01/26-27/001428	Pooja Mehta	4	₹640.00	Cash	08:05 PM
BR01/26-27/001427	Suresh Gupta	1	₹150.00	Card	07:52 PM
BR01/26-27/001426H1	Neha Sharma	3	₹890.00	UPI Dynamic	07:38 PM

Batches expiring within 90 days

Augmentin 625 DuoExp: 2028-05-31

Batch: AUG-2026-B1Stock: 120 tabs

Value: ₹2,640.00Initiate Supplier Return →

Pan 40 TabletExp: 2027-11-30

Batch: PAN-40-X1Stock: 180 tabs

Value: ₹1,800.00Initiate Supplier Return →

Human Mixtard 100IUExp: 2027-08-31

Batch: MIX-100-F1Stock: 25 pens

Value: ₹4,875.00Initiate Supplier Return →

Section 170 CGST Act Compliant • State Code: 27 (Maharashtra)

GSTIN: 27AAACM1234F1Z5

HSN Code	Category Description	Tax Slab	Taxable Turnover	CGST (Output)	SGST (Output)	IGST (Inter-state)	Total GST Output
3004	Allopathic Medicaments & Formulations	12.0%	₹41,200.00	₹2,472.00	₹2,472.00	₹0.00	₹4,944.00
300431	Insulin & Essential Cold-Chain Biologics	5.0%	₹4,875.00	₹121.88	₹121.88	₹0.00	₹243.76
2106	Food Supplements & Protein Nutraceuticals	18.0%	₹2,845.00	₹256.05	₹256.05	₹0.00	₹512.10
Total GSTR-1 Taxable Realization			₹48,920.00	₹2,849.93	₹2,849.93	₹0.00	₹5,699.86