🧠
AI Business Advisor PREMIUM
Nexus Smartness forecasting + live analysis of stock, expiry, orders, returns & dues · Invex Import
Analysed 13 Oct, 04:53 PM
✨ AI REFINING…
💡
Good afternoon, here's what needs you today
You are holding ₹4.26 Cr of stock. ₹35.61 L has already expired and needs write-off. ₹1.64 Cr is dead stock that has never sold. ₹6.67 L is stuck in receivables from 53 customers. Watch ₹15.32 L expiring within 90 days.
Key Numbers Live
📦
Live stock value
₹4.26 Cr
8,462 active items
🔴
Expired in hand
₹35.61 L
634 batches
⏳
Expiring < 90 days
₹15.32 L
243 batches
🧊
Dead stock
₹1.64 Cr
never sold
💰
Receivables
₹6.67 L
53 customers
🧾
Sales this month
₹208
today ₹0
📋
Pending orders
3 / 5,030
sales / purchase
↩️
Returns (90d)
₹1.38 L
sales ₹15.9 K · buy ₹1.22 L
Suggestions
18 findings✨ AI refining…
🔴₹35.61 L
Expired stock still on shelves
₹35.61 L of stock across 634 batches is already past expiry but still in hand.
💬 Write these batches off and clear the shelf space.
🧊₹1.64 Cr
Dead stock — money frozen
₹1.64 Cr sits in items that have never sold. Largest: PREVEXXION INJ 2000 DOSE.
💬 Run a clearance scheme or return the slow items to the supplier.
⏳₹15.32 L
Expiring within 90 days
₹15.32 L across 243 batches will expire in the next 90 days — sell or return before it is a loss.
💬 Push these to customers who buy them, or arrange an expiry return.
⚠️Aug 26
Sales trend break detected
Nexus Smartness flagged an unusual change in the sales trend around Aug 26. Investigate the cause (pricing, reps, or a data gap).
💬 Investigate what changed that month — pricing, reps, or a data gap.
🛒8
Reorder soon
Nexus Smartness predicts 8 fast-moving item(s) will run out — e.g. OMNACORTIL-10 TAB (stock 471, needs ~1,698/mo). Reorder now.
💬 Raise purchase orders for these fast-movers before they stock out.
🚨1
Over credit limit
1 customer(s) have crossed their credit limit — e.g. DR BHUPENDRA SAXENA (100% used). Hold billing until they clear dues.
💬 Hold further billing until these customers clear dues below their limit.
🐢260 d
Slow-paying customers
DR SUNIL PAL takes ~260 days to pay. Tighten credit terms for your slowest payers before dues pile up.
💬 Put your slowest payers on stricter terms or advance payment.
💰₹6.67 L
Outstanding receivables
₹6.67 L is owed by 53 customers. Oldest overdue ~2752 days.
💬 Send payment reminders to the oldest overdue customers first.
📦1
Items below reorder level
1 item(s) are at or under their minimum stock level — reorder to avoid a stockout.
💬 Raise a purchase order before you run out.
📥5,030
Purchase orders pending
5,030 purchase orders are still open. Close or cancel stale ones to keep the pipeline clean.
💬 Close or cancel stale purchase orders to clean the pipeline.
🧾₹57.43 L
Biggest expense head
Discount Allowed is your largest operating expense — ₹57.43 L over 12 months. Review it for savings.
💬 Review your biggest expense heads for savings.
🧑🤝🧑₹49.99 L
At-risk customers (Nexus)
Nexus Smartness grouped 204 customers (worth ₹49.99 L) who have gone quiet — last purchase ~256 days ago. Win them back.
💬 Review and act on this today.
🔮₹73.62 L
Next-month sales forecast
Nexus Smartness projects about ₹73.62 L in sales next month, from 24 months of history. Plan stock and cash around it.
💬 Plan purchasing and cash flow around this projection.
💵+₹69.77 L
Positive cash flow (90d)
Cash in ₹1.67 Cr vs out ₹97.36 L over 90 days — net +₹69.77 L.
💬 Match collections against payments to protect cash.
📤3
Sales orders pending
3 sales orders are open and not yet billed — convert them to invoices.
💬 Convert open sales orders into invoices.
↩️₹1.22 L
Purchase returns (debit notes)
₹1.22 L returned to suppliers in the last 90 days. Recover the credit and review the cause.
💬 Recover supplier credit and review why goods were returned.
🔁₹15.9 K
Sales returns (credit notes)
₹15.9 K of goods came back from customers in the last 90 days.
💬 Check returned batches for quality or wrong-supply patterns.
🔮₹1.04 L
Expense forecast (Nexus)
Nexus Smartness projects about ₹1.04 L in operating expenses next month.
💬 Review your biggest expense heads for savings.
What's Coming Next Nexus Smartness · projected next month
📈
Sales — next month
₹73.62 L
expected to rise vs recent months
▲ +9%
🛒
Purchase — next month
₹55.02 L
expected to rise vs recent months
▲ +7%
💸
Expenses — next month
₹1.04 L
expected to dip vs recent months
▼ -51%
🛒 Purchase & forecast
View All →₹1.07 Cr
Feb
₹1.16 Cr
Mar
₹1.17 Cr
Apr
₹1.08 Cr
May
₹1.01 Cr
Jun
₹99.29 L
Jul
₹1.53 Cr
Aug
₹20.0 K
Sep
₹230
Oct
₹55.02 L
+1m
₹51.09 L
+2m
₹53.16 L
+3m
🔮 Purchase forecast by Nexus Smartness · 24 months trained
Item Flow Forecast Nexus Smartness · next-month demand
🚀 Fast movers
View All →VAXX HVT+IBD+ND INJ 4000DSstock 0 · ₹43.77 L/90d
~255/mo
VAXX HVT+IBD+ND INJ 2000DSstock 700 · ₹21.30 L/90d
~233/mo
PREVEXXION INJ 4000 DOSEstock 152 · ₹7.26 L/90d
~50/mo
GUDCEF-200 TABstock 150 · ₹3.53 L/90d
~810/mo
ZERODOL-SP TABstock 184 · ₹2.80 L/90d
~850/mo
PREVEXXION INJ 2000 DOSEstock 493 · ₹2.52 L/90d
~18/mo
🛒 Reorder soon
View All →OMNACORTIL-10 TABstock 471 · needs ~1,698/mo
short 1,227
ARGIPREG SACHET stock 531 · needs ~1,722/mo
short 1,191
PACIMOL-500 TABstock 166 · needs ~1,031/mo
short 865
OMNACORTIL-5 TABstock 516 · needs ~1,287/mo
short 771
AI-DISPO SYRINGEstock 2,655 · needs ~3,403/mo
short 748
ZERODOL-SP TABstock 184 · needs ~850/mo
short 666
🐌 Slow movers
View All →S.V.SET-BLonly 5 sold / 90d
986 in stock
ENERGY VITA-V POWonly 5 sold / 90d
757 in stock
GR.GLUCOSE-D ORG POW.only 5 sold / 90d
272 in stock
DROTAPRO-INJ.only 2 sold / 90d
191 in stock
MONTUP-L TABonly 3 sold / 90d
191 in stock
UPMOX-CV TABonly 5 sold / 90d
179 in stock
Analysis
⏳ Expiring soon
next 90 daysLED TV HAIER (GLENSMITH)b.L32A7 · exp 28 Oct 26
₹1
LEUREA BOLUS (VET)b.T23381 · exp 28 Oct 26
₹75
AZIFLEX-FS KIT TABb.4231066 · exp 28 Oct 26
₹270
DOUBLE BED SHEET (SMART)b.301123 · exp 28 Oct 26
₹2
EAK CAPb.AL719 · exp 28 Oct 26
₹871
SYNO MALT SYPb.SM45 · exp 28 Oct 26
₹16.2 K
💰 Top overdue customers
by amountGIRRAJ MEDICAL STORE2386 days overdue
₹52.2 K
DR BHUPENDRA SAXENA2386 days overdue
₹50.2 K
DR SK MANDAL CHANDSI 2752 days overdue
₹40.8 K
DR MALKHAN SINGH DANGI2386 days overdue
₹39.8 K
NIRMAN MEDICOSE2752 days overdue
₹39.1 K
MANGALDYENI HOSPITAL2386 days overdue
₹34.8 K
🧊 Dead stock
never soldPREVEXXION INJ 2000 DOSE493 in hand
₹25.62 L
VAXX HVT+IBD+ND INJ 2000DS700 in hand
₹24.91 L
BDA BLEN 2000DS930 in hand
₹13.39 L
PREVEXXION INJ 4000 DOSE152 in hand
₹12.63 L
VOLVAC ND CONC. KV 2500545 in hand
₹10.51 L
VOLVAC ND+IB KV 1000 DOS162 in hand
₹4.59 L
🧩 Customer segments
Nexus Smartness · last 12 months🏆
Champions
68 customers
₹7.08 Cr · last buy ~44 d
🙂
Regular
627 customers
₹5.16 Cr · last buy ~63 d
⚠️
At-risk / lapsing
204 customers
₹49.99 L · last buy ~256 d
Customer Payment Behaviour last 12 months
🏆 Top revenue
View AllSUSHANT POULTRIES PVT.LTD.
₹81.56 L
SAWARIYA MEDICAL AGENCY
₹75.73 L
AVEE BROILERS PVT.LTD.
₹61.95 L
BAJRANG MEDICAL AGENCY
₹59.26 L
JHARKHAND WOMEN'S SELF SUPPORTING POULTRY CO-OPRATIVE FEDERATION LTD.
₹51.92 L
ARJAV MEDICAL STORE
₹35.12 L
💵 Top payers
View AllSUSHANT POULTRIES PVT.LTD.
₹82.03 L
MANKIND PHARMA LTD. (PHARMA)
₹81.77 L
SAWARIYA MEDICAL AGENCY
₹73.06 L
MANKIND PHARMA LTD (LIFE)
₹72.99 L
BAJRANG MEDICAL AGENCY
₹56.72 L
JHARKHAND WOMEN'S SELF SUPPORTING POULTRY CO-OPRATIVE FEDERATION LTD.
₹51.14 L
⚡ Best payment timing
View AllRAMESH KIRAR₹59.8 K paid · 163 pmts
0 d
AK MEDICAL STORE ₹55.2 K paid · 61 pmts
0 d
SHREE BALAJI MEDICAL₹51.6 K paid · 39 pmts
0 d
DR AMIT YADAV₹33.8 K paid · 21 pmts
0 d
NEMA MEDICOSE₹31.2 K paid · 12 pmts
0 d
DR DEVENDRA SHING JATAV₹30.6 K paid · 35 pmts
0 d
🐢 Slow / loose payers
View AllDR SUNIL PAL 5 payments · avg cycle
260 d
DR NILESH JAIN95 payments · avg cycle
221 d
DR BHARAT BADHWANI7 payments · avg cycle
201 d
DR PRADEEP SHARKAR7 payments · avg cycle
175 d
DR BHUPENDRA DUBAY10 payments · avg cycle
161 d
JAIN AYUSHMAN MEDICAL15 payments · avg cycle
150 d
🚨 Credit limit watch
View AllDR BHUPENDRA SAXENAdue ₹50.2 K / limit ₹50.0 K
100%
DR SK MANDAL CHANDSI due ₹40.8 K / limit ₹50.0 K
82%
NIRMAN MEDICOSEdue ₹39.1 K / limit ₹50.0 K
78%
Accounting & Cash Flow general ledger
💵 Cash flow
last 90 days
Net +₹69.77 L
🧾 Top expense heads
12 months📉 Expenses & forecast
View All →₹5.13 L
May
₹4.30 L
Jun
₹5.46 L
Jul
₹4.96 L
Aug
₹1.34 L
Sep
-₹5
Apr
₹1.04 L
+1m
₹1.04 L
+2m
₹66.5 K
+3m
🔮 Expense forecast by Nexus Smartness
🏆 Top selling items
last 90 days📈 Sales & forecast
View All →₹1.04 Cr
May
₹88.21 L
Jun
₹1.09 Cr
Jul
₹1.80 Cr
Aug
₹21.45 L
Sep
₹208
Oct
₹73.62 L
+1m
₹68.06 L
+2m
₹66.16 L
+3m
🔮 Forecast & anomalies by Nexus Smartness · 24 months trained