Wholesale Pharmacy ERP
Admin Dashboard
Today's Sales
Rs. 485,200
↑ 12%
42 invoices today
Today's Purchase
Rs. 312,800
↑ 8%
13 purchase invoices
Receivables
Rs. 2.84M
↑ 5%
156 pending · Rs. 165,000 collected today
Payables
Rs. 1.92M
↓ 3%
41 suppliers pending
Cash & Bank
Rs. 2.89M
Available liquidity
Low Stock
18
Items below minimum level
Near Expiry
24
Expiring within 90 days
Expired Items
7
Need immediate action
Sales vs Purchase Trend
Last 30 days overview
Monthly Target
Rs. 8.4M of Rs. 10M
84% target achieved this month.
Receivable Aging
Customer outstanding by age
| Period | Amount |
|---|---|
| 0 - 30 Days | Rs. 1.20M |
| 31 - 60 Days | Rs. 850k |
| 61 - 90 Days | Rs. 480k |
| 90+ Days | Rs. 310k |
Rs. 790k is older than 60 days.
Recent Activity
Latest system transactions
-
SISale Invoice created for Al-Madina Pharmacy — Rs. 84,5005 min ago
-
RCReceipt posted from City Medical Store — Rs. 55,00018 min ago
-
PIPurchase Invoice received from Getz Pharma — Rs. 212,00022 min ago
-
EXExpiry Alert generated for 6 batches of Cefixime48 min ago
-
SRSale Return recorded for damaged stock — Rs. 8,7002 hours ago
Recent Sales Invoices
Latest 5 sales transactions
| Invoice | Customer | Amount | Status | Date |
|---|---|---|---|---|
| SI-10241 |
AM
Al-Madina Pharmacy
|
Rs. 84,500 | Paid | Today |
| SI-10240 |
CM
City Medical Store
|
Rs. 55,000 | Partial | Today |
| SI-10239 |
SH
Shifa Traders
|
Rs. 132,700 | Credit | Today |
| SI-10238 |
HM
Hassan Medical
|
Rs. 39,200 | Paid | Yesterday |
| SI-10237 |
BK
Bismillah Pharma
|
Rs. 91,800 | Overdue | Yesterday |
Business Insights
System recommendations
Restock Suggested
Panadol 500mg may go out of stock in 4 days.
Expiry Risk
6 Cefixime batches should be discounted or returned.
Payment Risk
Bismillah Pharma has 38 days overdue balance.
Sales Opportunity
Antibiotics category is up 18% this month.
Top Customers
View all
Al-Madina PharmacyRs. 580k
City Medical StoreRs. 440k
Shifa TradersRs. 395k
Hassan MedicalRs. 310k
Bismillah PharmaRs. 280k
Top Products
View all
| Product | Qty | Sales |
|---|---|---|
| Panadol 500mg | 1,240 | Rs. 186k |
| Augmentin 625mg | 860 | Rs. 344k |
| Cefixime 400mg | 710 | Rs. 291k |
| Calpol Syrup | 530 | Rs. 118k |
| Brufen 400mg | 480 | Rs. 72k |
Top Suppliers
View all
Getz PharmaRs. 920k
GSK PakistanRs. 760k
SearleRs. 640k
HighnoonRs. 420k
AbbottRs. 390k
Salesman Performance
Monthly target
Ahmed · Sales Officer
96%
Ali · Sales Officer
84%
Usman · Sales Officer
71%
Bilal · Sales Officer
48%
Risk Monitoring
Action required
| Risk | Type | Value | Status |
|---|---|---|---|
|
Bismillah Pharma
38 days overdue
|
Receivable | Rs. 184,000 | High |
|
City Medical Store
31 days overdue
|
Receivable | Rs. 142,000 | High |
|
Cefixime 400mg
Expiry in 42 days
|
Expiry | 320 units | Medium |
|
Panadol 500mg
Below minimum stock
|
Stock | 42 units | High |
|
Getz Pharma
Payment due tomorrow
|
Payable | Rs. 420,000 | Due |
Quick Actions