Sri Venkateshwara Multi-Speciality Hospital · Kukatpally, Hyderabad · 60 beds
GP
Analytics
నమస్తే, Dr. Prakash — your hospital at a glance · Saturday, 18 Jul 2026 · 09:42 AM
Today
Last 8 weeks
This quarter
✦
Try:
How did OPD revenue trend last 8 weeks?
Which department earns the most?
How are my doctors performing?
Where am I losing money?
How many no-shows this month?
✦
HOS Analyst — answer
Draft — awaiting approval
Generated 09:42 AM · 1.8s
OPD revenue grew 14% in 8 weeks — Gynecology drove most of it; Ortho dipped after Dr. Anil's leave.
General Medicine
Gynecology
Orthopedics
Weekly OPD revenue, ₹ lakh · 25 May – 18 Jul 2026
Computed from 3,214 OPD billing events, 25 May – 18 Jul 2026 · consults GST-exempt · excludes pharmacy counter sales
Revenue — last 8 weeks
₹94,80,000
▲ 11% vs prior 8 weeks
OPD count — last 8 weeks
3,214
▲ 9% vs prior 8 weeks
IPD occupancy — 8-week avg
76%
avg 41 of 54 staffed beds
Pharmacy margin — 8-week avg
21.8%
▲ 0.4 pt vs prior period
Return on HOS
Month to date · 1 – 18 Jul 2026
₹36,120 realised so far this month, against a ₹40,000 subscription.
That is 18 days of a 31-day month, so the fair comparison is ₹36,120 against
₹23,226 of subscription consumed — 1.6× so far, with
13 days left to run. A further ₹59,400 is identified
and waiting on an approval, which would take the month to 2.4×.
₹36,120
realised — landed or released
₹59,400
identified — awaiting your approval
₹40,000
Hospital Plus · per month
Realised — money that landed, or time you got back
₹36,120
WhatPeriodWhere it came fromAmount
Staff time released
212 hours across 1,284 AI actions, valued at ₹150/hour
1 – 18 Jul
AI Workforce — 5 workers, every output approved by a named human
₹31,800
Charted care that was never billed
3 dressing kits, 1 physio session, 1 X-ray across 6 IPD charts — ₹950 of it on B. Srinu's bill alone
12 – 18 Jul
Billing Agent, confirmed by Anasuya before settlement
₹4,320
The billing line counts one week only — earlier weeks of this month are not
included, so ₹36,120 understates the month. We would rather be checked and found
conservative.
Identified — found, drafted, waiting on you
₹59,400
WhatPeriodWhere it came fromAmount
Follow-ups that were never rebooked
34 patients, at the same consult fee plus your typical pharmacy attach rate
Last 30 days
OPD register — WhatsApp nudges drafted, none sent
₹40,800
Stock that will expire before it sells
7 batches at cost, of which ₹5,810 is still inside the distributor's return window
Next 90 days
Pharmacy batch register — return list drafted for Ravi Teja
₹18,600
Both approvals live in Money Leaks, where the drafts were made. HOS keeps one
artifact in one place with one state — a second approve button here would let the two
disagree.
Still leaking — measured, and not yet fixed
Loss, not savings
WhatPeriodWhere it came fromAmount
Theatre time paid for and not used
37 late minutes on OT-1's first case and 100 cancelled minutes, at ₹502 per theatre-minute
Today
OT schedule — 4 of this month's 11 cancellations share one cause, no anaesthetist window
₹68,774
Booked patients who did not arrive
41 no-shows, 7.2% of bookings — patients who get a WhatsApp reminder no-show 31% less
1 – 18 Jul
Appointment book — worst slot is Tuesday 11 AM – 1 PM
₹28,700
Prescriptions the counter could not fill
169 lines left unfilled and were bought outside — ₹25,688 of topline, of which ₹5,754 was our margin. Counted at margin, not topline.
1 – 18 Jul
Dispense log against the stock ledger — 9 of the 12 SKUs below reorder point appear in these lines
₹5,754
One of these is a single day and the other two are eighteen. Adding them would produce a
number that means nothing, so this bucket is not totalled — it is the size of what is
still on the table. None of it is counted in the ₹36,120 realised above, and none of it
improves the verdict below.
Monthly value statement
July value statement drafted — every line traced to its source record
Draft — awaiting approval
One page for your records: what HOS returned, what it found, what is still open, and
the assumptions behind each figure — including the ₹150/hour staff rate and the
₹502 theatre-minute. Nothing is included that is not already on a screen you can open.
How to read this honestly
Realised value is ₹36,120 against ₹23,226 of subscription consumed over
the same 18 days. On a full month at ₹40,000, HOS has not yet paid for itself outright
— it is at 90%, with 13 days and ₹59,400 of approved-and-actioned upside available.
We would rather show you that than round it up.
What the biggest number is not
₹68,774 of idle theatre is the largest figure on this page and it is a loss, not a
saving. HOS measured it; it has not recovered it. It sits in the third bucket for
exactly that reason.
Revenue by department — MTD
1 – 18 Jul 2026 · ₹44.6L totalGynecology overtook General Medicine in W6 · IPD room & nursing charges billed daily, shown here as MTD total
By payment mode
MTD| Mode | Amount | Share | Txns |
|---|---|---|---|
| Cash | ₹12,40,000 | 27.8% | 612 |
| UPI | ₹18,90,000 | 42.4% | 1,340 |
| Card | ₹6,80,000 | 15.2% | 298 |
| Insurance / TPA | ₹6,50,000 | 14.6% | 84 |
| Total | ₹44,60,000 | 100% | 2,334 |
UPI overtook cash as the leading mode in Apr 2026 · Insurance/TPA settlements average 11 days to clear
OPD census — last 7 days
Sat peak 12812 – 18 Jul 2026 · Sunday is half-day OPD (09:00 AM – 01:00 PM)
IPD occupancy trend
78% today9 – 18 Jul 2026 · target line 75% · peaked 82% on 13 Jul after 4 post-op admissions
Doctor performance leaderboard — this month
1 – 18 Jul 2026 · Dr. Anil on leave 6 – 12 Jul
Doctor
Consults this month
Revenue / consult
Patient satisfaction
Avg consult time
Revenue this month
Dr. K. RameshGeneral Medicine
486
₹350
★ 4.7
Avg 11 min
₹1,70,100
Dr. Sunitha RaoGynecology
402
₹600
★ 4.9
Avg 17 min
₹2,41,200
Dr. Meena IyerPediatrics
356
₹400
★ 4.8
Avg 9 min
₹1,42,400
Dr. P. Anil KumarOrthopedics
218
₹550
★ 4.3
Avg 15 min
₹1,19,900
Follow-up consults counted at full rate · satisfaction from post-visit WhatsApp rating (1–5★, min. 20 responses) · Dr. Anil's numbers reflect 6 working days lost to leave
Missed follow-ups
34 patientsFollow-ups due in the last 30 days that were never rebooked. Estimated lost revenue assumes the same consult fee + typical pharmacy attach rate.
WhatsApp nudges drafted for all 34
Draft — awaiting approval
- K. Yadamma — T2DM review, due 02 Jul 2026
- M. Sailoo — post-fracture check, due 28 Jun 2026
- Padma Sree — antenatal 28w review, due 10 Jul 2026
- + 31 more, grouped by treating doctor
KY K. Yadamma Preview 1 of 34
Sent via WhatsApp Assistant on approval · Telugu/English auto-detected per patient preference
Unbilled items caught before discharge
System auto-flags orders and consumables charted on a patient's record but missing from the draft bill; billing clerk confirms before settlement.
- 3 dressing kits — B. Srinu, GM-05, flagged 15 Jul, added by Anasuya
- 1 physiotherapy session — B. Srinu, flagged 17 Jul
- 1 X-ray (knee, AP/lateral) — flagged 17 Jul, added before final settlement
Pharmacy expiry risk
7 batchesBatches expiring within 90 days, valued at cost. Trending down as Ravi Teja works through last month's return-to-distributor list.
Return-to-distributor list drafted
Draft — awaiting approval
- Syp. Ambroxol 100ml — 14 units, batch AMB-2504-C2, exp Sep 2026
- Tab. Amoxicillin-Clav 625mg — 312 units, batch AMC-2503-F1, exp Oct 2026
- + 5 more batches, full list in Pharmacy → Stock & Batches
Routed to Ravi Teja (Pharmacist) for distributor pickup on approval
Prescriptions we could not fill
169 linesA line the counter cannot fill does not become a smaller sale — it becomes the chemist's sale. This is the only leak on this tab that is already gone: it is measured so the next one can be prevented, not recovered.
| How we get to the number | Lines | Value |
|---|---|---|
| Prescription lines presented at the counter 1 – 18 Jul · OP walk-in + IP discharge scripts |
5,124 | — |
| Filled from stock 95.8% fill rate |
4,910 | — |
| Could not be filled 9 of the 12 SKUs now below reorder point appear in these lines |
214 | — |
| Recovered — same molecule substituted, or collected next day The pharmacist's save; these did not leave |
−45 | — |
| Left the counter unfilled bought outside Average ₹152 per line at our own selling price — higher than the ₹95 all-lines average, because stock-outs skew to the less-frequently-stocked items |
169 | ₹25,688 |
| Gross margin forgone the actual loss ₹25,688 × 22.4%, this month's pharmacy margin. The topline went to the chemist; this is what it cost us. |
— | ₹5,754 |
214 − 45 = 169. 169 × ₹152 = ₹25,688. ₹25,688 × 22.4% = ₹5,754.
Counted conservatively: the loss is the margin, not the ₹25,688 of topline, because
the drug still had to be bought. At this rate the run-rate is about ₹1,16,700 a year
— which is the number worth acting on, not the eighteen-day one.
Not included in the ₹59,400 below. That total is what an approval can still recover.
This is not recoverable — it is preventable, and the prevention is a reorder-point change
on 9 SKUs, which belongs in Pharmacy where the stock ledger lives.
Every number is live from the event spine.