How to Calculate the Cost of OPD No-Shows in a Hospital
Build a defensible baseline from your own scheduled visits, attendance, cancellations, refill rate, and finance-approved slot value.
Adapt this framework with hospital operations, privacy, security, and risk owners before production use.
Editorial standardsThe cost of an OPD no-show is hospital-specific. The useful question is not “What is the industry average?” but “Which scheduled capacity went unused, which part could have been recovered, and how will finance value that recovery?”
Define the appointment states before calculating anything
A no-show, late cancellation, early cancellation, and rescheduled visit create different operational opportunities. Combining them into one rate hides the recovery workflow.
| State | Operational meaning | Recovery question |
|---|---|---|
| No-show | The scheduled time passed without attendance or prior resolution | Can the patient be rebooked and the reason captured? |
| Late cancellation | The hospital learned too late to use its normal refill process | Could a faster cancellation signal have triggered backfill? |
| Early cancellation | Capacity became available with usable lead time | Was an eligible waitlist contacted? |
| Rescheduled | Demand moved to another slot | Was the original slot released and reused? |
Use a hospital-owned baseline formula
Use a contribution or capacity proxy approved by finance. Do not present scheduled charges as collected revenue.
Derive the recoverable share from the hospital workflow and a measured pilot, not a generic benchmark.
Minimum data required
- Scheduled appointments by specialty, provider, date, and appointment type
- Attended, cancelled, rescheduled, and no-show dispositions
- Time between cancellation and appointment
- Whether the released slot was filled by another patient
- A finance-approved capacity or contribution proxy
- Contact and rebooking outcomes from the recovery workflow
A hypothetical worked example
Suppose one department records 120 eligible no-show or late-cancellation slots in a month. If 30 are already refilled through existing operations, the unused baseline is 90 slots. If finance assigns a ₹1,200 contribution proxy, the baseline capacity value is ₹108,000. This is an illustration, not an Ethon outcome or a universal hospital benchmark.
Build the pilot scorecard
- 1Freeze the baseline definition
Document eligibility, exclusions, refill logic, and the financial proxy.
- 2Track the full funnel
Eligible opportunity, contacted, resolved, booked, attended, and financially recognized are separate stages.
- 3Prevent double counting
Do not count a rescheduled patient and a refilled original slot as the same recovery event.
- 4Review with operations and finance
Reconcile operational dispositions with the source system before reporting value.
Common calculation errors
- Using a national no-show figure instead of hospital data
- Treating list price, billed amount, contribution, and collected revenue as interchangeable
- Counting every contacted patient as recovered
- Ignoring capacity that would have remained unused even with perfect outreach
- Failing to separate appointment booking from completed attendance