MediCore — Pharmacy Management System

💰

₹1,24,580

Today's Revenue

↑ 12.4% vs yesterday

🧾

284

Bills Today

↑ 8 from yesterday

⚠

12

Low Stock Alerts

↑ 3 critical

👤

1,842

Total Customers

↑ 24 this month

📅

₹38,200

Pending Payments

7 overdue

Revenue Trend — Last 7 DaysWeekly

Payment Breakdown

⚠ Low Stock Alerts12 items

Paracetamol 500mg

Only 8 strips left • Min: 50

Critical

Amoxicillin 250mg

23 caps left • Min: 100

Low

Metformin 500mg

31 tabs left • Min: 60

Low

ORS Sachets

5 units left • Min: 40

Critical

📅 Expiry Alerts6 soon

Cough Syrup B-12

Exp: 15 May 2026 • Batch: B2204

14 days

Insulin Glargine

Exp: 10 May 2026 • Batch: IG2210

9 days

Vitamin D3 Caps

Exp: 30 Jun 2026 • Batch: VD031

60 days

Eye Drops 0.5%

Exp: 25 Jun 2026 • Batch: ED044

55 days

🏆 Top Selling Medicines — Today

#	Medicine	Category	Qty Sold	Revenue	Margin
1	Paracetamol 500mg	Analgesic	142 strips	₹2,840	34%
2	Azithromycin 500mg	Antibiotic	89 tabs	₹5,340	28%
3	Pantoprazole 40mg	Antacid	76 strips	₹3,800	41%
4	Cetrizine 10mg	Antihistamine	64 strips	₹1,280	22%
5	Metformin 500mg	Diabetic	58 strips	₹2,900	37%

Patient & Bill Info

Bill # INV-2026-0284

Customer Name

Phone Number

Doctor Name

Payment Method

Medicine Items

Medicine	Batch	Qty	MRP (₹)	Disc%	Amount
					₹47.50
					₹180.00

Bill Summary

Subtotal₹227.50

Discount-₹2.50

GST (12%)₹27.00

Total Payable ₹252.00

Amount Received (₹)

Change / Balance ₹48.00

🏥 MediCore Pharmacy
123 Health St, Mumbai 400001
GST: 27AAAAA0000A1Z5

Recent Bills

Bill ID	Customer	Date	Items	Total	Payment	Status
INV-0283	Ramesh Kumar	01 May 2026	4	₹1,240	Cash	Paid
INV-0282	Priya Sharma	01 May 2026	2	₹580	UPI	Paid
INV-0281	Walk-in	01 May 2026	1	₹95	Cash	Paid
INV-0280	Arjun Mehta	30 Apr 2026	6	₹3,420	Card	Paid
INV-0279	Sunita Patel	30 Apr 2026	3	₹780	Credit	Pending

Showing 5 of 284

📦

₹4,28,000

Month Purchases

⏳

₹82,400

Pending to Pay

✅

42

Orders This Month

🏭

18

Active Suppliers

Purchase Orders

PO Number	Supplier	Invoice	Date	Items	GST	Total	Status
PO-1042	Sun Pharma Dist.	SP/2026/4821	28 Apr 2026	12	₹3,840	₹35,840	Paid
PO-1041	Cipla Healthcare	CH/0452	25 Apr 2026	8	₹2,100	₹19,600	Pending
PO-1040	Mankind Pharma	MP/26/009	22 Apr 2026	15	₹5,200	₹48,700	Paid
PO-1039	Abbott India	AI/2026/331	20 Apr 2026	6	₹1,560	₹14,560	Overdue
PO-1038	Lupin Ltd.	LL/2026/87	18 Apr 2026	20	₹8,400	₹78,400	Paid

Showing 5 of 42

All Items

⚠ Low Stock

📅 Expiring Soon

Analgesics

Antibiotics

Diabetic

Medicine Inventory

Medicine	Category	Batch	Expiry	Stock Level	Cost	MRP	Status
Paracetamol 500mg	Analgesic	B2204	Dec 2027	8 strips	₹12	₹20	Critical
Azithromycin 500mg	Antibiotic	AZ001	Sep 2027	156 tabs	₹120	₹180	Good
Metformin 500mg	Diabetic	MF0088	Mar 2028	31 tabs	₹28	₹50	Low
Omeprazole 20mg	Antacid	OM2023	Jan 2028	420 caps	₹9	₹15	Good
Insulin Glargine 100U	Diabetic	IG2210	May 2026	24 vials	₹380	₹520	Expiring
Vitamin D3 60k IU	Supplement	VD031	Jun 2026	280 caps	₹45	₹80	Expiring

Showing 6 of 348

👥

1,842

Total Customers

✅

1,612

No Dues

💳

230

On Credit

⚡

₹38,200

Total Outstanding

Customer Directory

Name	Phone	Address	Total Bills	Total Spent	Outstanding	Status
Ramesh Kumar	98765 43210	Andheri, Mumbai	24	₹18,400	₹0	Clear
Priya Sharma	87654 32109	Bandra, Mumbai	12	₹9,200	₹2,400	Due
Arjun Mehta	76543 21098	Powai, Mumbai	38	₹56,800	₹0	Clear
Sunita Patel	65432 10987	Thane, Mumbai	7	₹4,600	₹780	Due
Mohammed Ali	54321 09876	Kurla, Mumbai	15	₹11,200	₹5,200	Overdue
Deepika Nair	43210 98765	Colaba, Mumbai	31	₹34,600	₹0	Clear

Showing 6 of 1,842

Supplier Directory

Supplier	Contact	GST Number	City	Orders	Total Value	Pending
Sun Pharma Dist.	98001 23456	27SUNAA0000A1Z5	Mumbai	18	₹4,20,000	₹0
Cipla Healthcare	98002 34567	27CIPLA0000A1Z5	Mumbai	12	₹2,10,000	₹19,600
Mankind Pharma	98003 45678	27MANKI0000A1Z5	Delhi	8	₹1,50,000	₹0
Abbott India	98004 56789	27ABBOT0000A1Z5	Delhi	6	₹90,000	₹14,560
Lupin Ltd.	98005 67890	27LUPIN0000A1Z5	Mumbai	15	₹3,20,000	₹0

💸

₹28,400

This Month

🏠

₹12,000

Rent & Utilities

👥

₹8,200

Salary Advances

🚚

₹4,800

Transport

Expense Ledger

Date	Category	Description	Amount	Paid By	Notes
01 May 2026	Utility	Electricity Bill - May	₹4,200	Cash	Shop meter reading
30 Apr 2026	Rent	Monthly Shop Rent	₹12,000	Bank Transfer	HDFC ref #4821
28 Apr 2026	Transport	Medicine delivery charges	₹800	Cash	Sun Pharma order
27 Apr 2026	Misc	Stationery & Packaging	₹350	Cash	Monthly stock
25 Apr 2026	Repair	AC Servicing	₹1,200	Cash	Annual maintenance

📈

Sales Report

Daily / Monthly / Yearly analysis

📦

Purchase Report

Supplier-wise purchase analysis

💰

Profit & Loss

Revenue vs expense breakdown

🗃

Stock Report

Current inventory valuation

📅

Expiry Report

Medicines expiring in 30/60/90 days

🏛

GST Report

GSTR-1 / GSTR-3B export

Monthly P&L — 2026

May 2026 — Summary

Total Revenue₹3,84,200

Total Purchases₹2,28,000

Gross Profit₹1,56,200

Total Expenses₹28,400

Net Profit₹1,27,800

Profit Margin33.3%

GST Collected₹41,124

GST Input Credit₹24,696

Net GST Payable₹16,428

👥

8

Total Staff

✅

7

Present Today

💰

₹1,24,000

Monthly Payroll

📋

₹28,000

Advance Paid

Staff Directory

Name	Role	Phone	Salary	Attendance	Advance	Net Pay	Status
Sanjay Gupta	Admin	98001 11111	₹28,000	25/26	₹5,000	₹23,000	Active
Meena Rao	Pharmacist	98002 22222	₹22,000	26/26	₹0	₹22,000	Active
Kiran Shah	Billing Staff	98003 33333	₹18,000	24/26	₹3,000	₹15,000	Active
Ravi Joshi	Store Keeper	98004 44444	₹15,000	22/26	₹2,000	₹13,000	Active
Pooja Desai	Cashier	98005 55555	₹14,000	0/26	₹0	₹0	On Leave

🚚

28

Deliveries This Month

💸

₹12,400

Transport Cost

✅

25

Delivered

Transport Log

Transport ID	Supplier / Order	Vehicle No.	Driver	Cost	Delivery Date	Status
TRP-028	Sun Pharma / PO-1042	MH 01 AX 4821	Rajesh	₹800	28 Apr 2026	Delivered
TRP-027	Cipla / PO-1041	MH 02 BX 1234	Suresh	₹650	26 Apr 2026	Delivered
TRP-026	Mankind / PO-1040	MH 04 CY 5678	Ramesh	₹1,200	23 Apr 2026	Delivered
TRP-025	Abbott / PO-1039	MH 01 DZ 9012	Rajesh	₹500	21 Apr 2026	Pending