Skip to main content

Free tool

Hospital revenue leakage estimator

Revenue leakage is money a hospital earned and never collected — a consultation that never reached a bill, medicine handed over on credit and forgotten, a test reported while the bill still had a balance, a discharge cleared without the balance being settled. This adds up what each is costing you per month. Every input is your own number; it supplies no industry averages, because a calculator that guesses your leakage for you is a sales pitch with a text box.

In short

Four vectors, each one you can count for yourself in about an hour of record-checking. The arithmetic is deliberately simple; getting your own percentages honestly is the hard part, and the only part that matters.

What it needs
Ten figures from last month
What it assumes
Nothing — no benchmarks, no averages
Hardest input
The unbilled-visit percentage
Best used
Monthly, watching the trend
Every consultation, including follow-ups.
What one OPD visit is meant to bill.
Count a week of visits against bills raised, then scale up. Guessing here is the commonest mistake.
Counter and inpatient dispensing together.
Credit given at the counter, or an IP dispense never posted to the bill.
Tests ordered, not samples collected.
Across the whole order, not per test.
Reported or verified while the bill still had a balance.
All dispositions, not only routine ones.
What is written off or never collected at clearance, averaged across ALL discharges — not only the ones that fell short.
Estimated leakage per month₹1,01,700

About ₹12,20,400 a year, on your own figures.

Where it comes from
Unbilled OPD visits₹21,60021%
Pharmacy dispensed unpaid₹18,00018%
Diagnostics released unpaid₹8,1008%
Unrecovered at discharge₹54,00053%

Method

How each figure is worked out

Each line is one multiplication, on purpose. Anything more elaborate would hide where the number came from.

  • Unbilled OPD visits — visits × fee × the share that never reached a bill.
  • Pharmacy dispensed unpaid — sales value × the share handed over without collection, whether that is counter credit or an inpatient dispense that never posted to the bill.
  • Diagnostics released unpaid — orders × average order value × the share reported while the bill still carried a balance.
  • Unrecovered at discharge — discharges × the average unrecovered amount. Note this averages across all discharges, not only the ones that fell short, which is the commonest way this line gets overstated by a factor of five.

Honesty

What this cannot tell you

It is an estimate built on percentages you supplied, so it is exactly as good as those percentages. If you enter a feeling rather than a count, the output is a feeling with a rupee sign on it.

A longer treatment of where the effort actually pays back is in reducing hospital operational costs with automation.

The one input worth spending real time on is the share of OPD visits that never reach a bill. Take one week, count encounters recorded against bills raised, and use that. It is usually the largest line and almost always the most under-estimated, because the visits that go unbilled are precisely the ones nobody remembers.

It also cannot tell you whether a gap is leakage or policy. A consultation waived for a staff member's family is not lost revenue — it is a decision. The number only becomes useful once waivers are recorded as waivers, which is the same discipline that makes the estimate worth running twice.

Next

Read the guide, or measure the other numbers

In Trisvio

The same four numbers, counted rather than estimated

Trisvio records each of these as it happens — an unbilled visit, an underpaid dispense, a test released against an outstanding bill, a discharge short of its balance — so the figure on the dashboard is a count with a queue behind it, not a percentage anyone had to guess.