Template · Published Nov 14, 2026 · Updated Nov 2026
No-Show Cost Calculator: What Missed Appointments Cost Your Practice
Missed appointments feel like a scheduling annoyance until you put a dollar figure on them. Enter your own schedule, no-show rate, and revenue per visit, and this calculator shows what empty slots cost per year, per month, and per provider, plus what each point of improvement is worth.
The calculator runs in your browser, and the same math is laid out cell by cell under the spreadsheet formulas, ready to copy into Excel or Google Sheets once per provider or visit type. No email needed.
Jump to the calculatorNo-show cost per year equals scheduled visits per year, times your no-show rate, times the share of slots you fail to refill, times your average collected revenue per visit. At 20 visits a day, two providers, 220 clinic days, a 6.8% no-show rate, and $150 per visit, that is about $89,760 a year. Use the calculator below with your own numbers.
Key takeaways
- MGMA's single-specialty no-show rate was 6.81% in 2023, up from 5% in 2021 and 2022. Published studies in other settings report 18% to 23%, so know what a benchmark counted before you compare.
- At example inputs, two providers lose about $89,760 a year to empty slots.
- Each 1-point drop in the no-show rate is worth about $13,200 a year at those inputs.
- Refilling slots the same day cuts the loss without changing patient behavior. In one family practice residency clinic, walk-ins filled 61.0% of failed appointments but only 42.4% of the time blocked for them (Moore et al., 2001; an older, single-clinic study). Start there.
- Use your own slot value: collected revenue per visit, not list charges and not a national per-visit figure. Anything else inflates the number and erodes trust in it.
A 7% no-show rate sounds small. It is one empty slot in every fourteen, on every schedule, every day, and each one is a visit you staffed, reminded, and never got paid for. In MGMA's August 11, 2026 Stat poll, 32% of medical groups said no-shows were higher than the year before, 58% about the same, and 10% lower (MGMA, 2026). Put your own numbers in and see what that looks like in dollars.
The no-show cost calculator
Every field is pre-filled with an example. Replace each one with your own number. Nothing you type leaves this page.
The default no-show rate is MGMA's 2023 single-specialty aggregate from its DataDive benchmarks, 6.81%, rounded to 6.8 (MGMA, 2025). Every other default is an obviously round example, not a benchmark: replace visits, providers, clinic days, and revenue per visit with your own figures. The result updates as you type. We tested the math on November 14, 2026 against the worked example below and against edge cases (a blank field counts as zero, a rate above 100% is capped at 100%), and it returns the same figures.
Copy the cell layout in the next section into Excel or Google Sheets, then add one column per provider, visit type, or month. It is the same math as the calculator, so the totals will match.
See the spreadsheet formulasThe formula
If the calculator does not load, or you want to run it in a spreadsheet, here is the math in four lines.
| Line | Calculation |
|---|---|
| Scheduled visits per year | Visits per provider per day × providers × clinic days per year |
| Missed visits per year | Scheduled visits × no-show rate × (1 minus same-day refill rate) |
| Revenue lost per year | Missed visits × average collected revenue per visit |
| Value of a 1-point improvement | Scheduled visits × 1% × (1 minus refill rate) × revenue per visit |
The refill rate is the term most practices forget. A slot that goes empty and gets refilled from a same-day list is not lost revenue. A slot that stays empty is.
To run it in a spreadsheet, use this layout. Copy column B across for each provider or visit type and the segmented numbers fall out.
| Cell | Label | Value or formula |
|---|---|---|
| B1 | Visits per provider per day | 20 (replace) |
| B2 | Providers | 2 (replace) |
| B3 | Clinic days per year | 220 (replace) |
| B4 | No-show rate, % | 6.8 (replace) |
| B5 | Collected revenue per visit, $ | 150 (replace) |
| B6 | Same-day refill rate, % | 0 (replace) |
| B8 | Scheduled visits per year | =B1*B2*B3 |
| B9 | Missed visits not refilled | =B8*(B4/100)*(1-B6/100) |
| B10 | Revenue lost per year | =B9*B5 |
| B11 | Per month | =B10/12 |
| B12 | Per provider | =B10/B2 |
| B13 | Value of a 1-point drop in the rate | =B8*0.01*(1-B6/100)*B5 |
A worked example
| Step | Value |
|---|---|
| Visits per provider per day | 20 |
| Providers | 2 |
| Clinic days per year | 220 |
| Scheduled visits per year | 20 × 2 × 220 = 8,800 |
| No-show rate (MGMA 2023 single-specialty) | 6.8% |
| Missed visits per year, no refills | 8,800 × 6.8% = 598.4, shown as 598 |
| Average collected revenue per visit (example) | $150 |
| Revenue lost per year | 598.4 × $150 = $89,760 |
| Per month; per provider | $7,480; $44,880 |
| Value of each 1-point drop in the no-show rate | 88 visits × $150 = $13,200 a year |
Now change one input. If the front desk refills a quarter of empty slots from a same-day list, the annual loss falls to about $67,320, with no change in how many patients miss. That is why the refill rate is the first lever, not the last.
Where to find your inputs
| Input | Where it lives | Tip |
|---|---|---|
| Visits per provider per day | Scheduling report: booked visits by provider | Use scheduled, not completed, visits |
| Clinic days per year | Your calendar | Subtract holidays and planned time off |
| No-show rate | No-shows divided by scheduled visits, same period | Pull 90 days; define late cancellations once and stick to it |
| Revenue per visit | Total collections divided by completed visits, same period | Collections, not charges |
| Same-day refill rate | Slots that went empty and were refilled, divided by all empty slots | If you do not track it, it is probably near zero |
These are schedule totals and averages, not patient information. No names, no chart details, nothing that belongs in a medical record, and the calculator sends nothing anywhere.
What the benchmarks say
| Measure | Value | Source |
|---|---|---|
| No-show rate, single-specialty aggregate, 2019 | 7% | MGMA DataDive, via MGMA Stat, Jan 2025 |
| No-show rate, 2020 | 5.55% | MGMA DataDive, via MGMA Stat, Jan 2025 |
| No-show rate, 2021 and 2022 | 5% | MGMA DataDive, via MGMA Stat, Jan 2025 |
| No-show rate, 2023 | 6.81% | MGMA DataDive, via MGMA Stat, Jan 2025 |
| Groups reporting higher no-shows in 2026 than 2025 | 32% (58% same, 10% lower) | MGMA Stat poll, Aug 11, 2026, 190 responses |
| Appointment cancellation rate, 2024 single-specialty | 19.95% | MGMA DataDive, via MGMA Stat, Aug 2026 |
| Canceled visits rescheduled within 30 days | 27.40% | MGMA DataDive, via MGMA Stat, Aug 2026 |
MGMA itself warns that published no-show estimates vary by definition, specialty, population, and setting, and that its cancellation rate, which counts patient- and practice-initiated cancellations, is not a target (MGMA, 2026). In MGMA's own words: "Do not treat 19.95% as a universal target." Compare against your own trend first. A practice moving from 9% to 7% has made real progress even if a benchmark says 6.8%.
What is a typical no-show rate for an independent practice?
For US medical groups that report to MGMA, about 5% to 7%: the single-specialty aggregate no-show rate was 7% in 2019, 5% in 2021 and 2022, and 6.81% in 2023 (MGMA, 2025). MGMA's DataDive data covers primary care, nonsurgical, and surgical single-specialty groups, so it is the closest published benchmark for an independent practice. Treat it as a reference point, not a target.
Peer-reviewed studies report much higher rates, because they measure different places and different things. A VA medical center averaged 18.8% across 10 main clinics, an outpatient endoscopy suite averaged 18%, and a review of 105 studies worldwide put the average near 23%, from 13.2% in Oceania to 43.0% in Africa. One family practice residency clinic counted no-shows and cancellations together at 31.1%. The same review found the factors most often tied to no-shows were long lead times and a prior no-show history (Dantas et al., 2018).
| Source | Setting and period | What it counted | Rate |
|---|---|---|---|
| MGMA DataDive, via MGMA Stat, 2025 | Single-specialty medical groups (primary care, nonsurgical, surgical), 2019 to 2023 | No-shows as a share of scheduled appointments | 7% (2019), 5.55% (2020), 5% (2021 and 2022), 6.81% (2023) |
| Berg et al., Medical Decision Making, 2013 | US outpatient endoscopy suite | Historical no-show rate used in a scheduling simulation | 18% average (12% to 24% tested) |
| Kheirkhah et al., BMC Health Services Research, 2016 | VA medical center and 10 regional hospitals, fiscal years 1997 to 2008 | Mean no-show rate in 10 main clinics; highest in subspecialty clinics | 18.8% |
| Moore et al., Family Medicine, 2001 | Family practice residency clinic, 4,055 visits over 20 business days | No-shows plus cancellations | 31.1% |
| Dantas et al., Health Policy, 2018 | Systematic review of 105 studies, all specialties, worldwide | Average reported no-show rate | About 23%; 13.2% Oceania, 43.0% Africa |
Count your own rate as no-shows divided by scheduled appointments for the same period, with late cancellations handled one consistent way. If your number sits well above 7%, the segments in the next sections usually show why.
What the number leaves out
The calculator counts only collected revenue from the empty slot. The real cost is higher. It leaves out staff time on reminders and rescheduling, rooms and equipment sitting idle, and care that is delayed until the patient returns sicker. At a family practice residency clinic, failed appointments meant a revenue shortfall of 3% to 14% of total clinic income over a year (Moore et al., Family Medicine, 2001; older than 2021, one clinic). Different setting, different cost structure, but the same lesson: the dollar figure above is a floor. That is also why this page never uses a national "cost per no-show": the only per-visit number that means anything is your own slot value.
| Study | Setting | Finding |
|---|---|---|
| Berg et al., 2013 | Outpatient endoscopy suite, 24 patients booked per day | At an 18% no-show rate, an expected loss of $725.42 a day, 16.4% of expected net gain; $472.14 to $1,019.29 at 12% to 24% |
| Moore et al., 2001 | Family practice residency clinic (older than 2021) | Revenue shortfall from failed appointments of 3% to 14% of total clinic income over a year |
The loss also compounds. MGMA's 2024 single-specialty data showed only 27.40% of canceled visits rescheduled within 30 days (MGMA, 2026). A patient who misses and never rebooks is follow-up revenue gone, not just one visit. Catch them with a recall list that actually runs, worked weekly by chart number.
Staff time is the other hidden line. Suppose, as a round example, each no-show costs 10 minutes of front-desk time to call, rebook, and document. At 598 missed visits a year that is about 100 hours, two and a half weeks of a full-time person, spent on appointments that produced nothing. Add your own loaded hourly cost, using the current wage data in the medical receptionist salary guide as a check, and the floor rises again.
How much can same-day refills recover?
A good share, but rarely all of it: at a family practice residency clinic studied over 20 business days and 4,055 visits (a 2001 paper, so read it as direction, not a benchmark), walk-in patients replaced 61.0% of failed appointments but used only 42.4% of the time blocked for them (Moore et al., Family Medicine, 2001). That gap is why the calculator treats the refill rate as its own input instead of assuming every empty slot is lost or every one is saved. Set it from your own log: empty slots refilled, divided by all empty slots, over at least a month.
Overbooking is the other lever, and it suits some schedules better than others. In a simulation of an outpatient endoscopy suite with an 18% no-show rate, booking 9 extra patients a day offset the expected loss entirely, while interventions to reduce no-shows cut the daily loss by $166.61 to $463.09 (Berg et al., Medical Decision Making, 2013). A clinic of short visits can absorb an extra patient; a procedure block usually cannot, so model it on your own visit lengths first.
Reminders help, within limits. A meta-analysis of randomized studies found that text notifications lowered the no-show rate from 21% to 15%, and that multiple notifications beat a single one (Robotham et al., BMJ Open, 2016). A centralized phone reminder at the VA moved the rate only from 16.3% to 15.8% (Kheirkhah et al., 2016). Reminders shrink the rate; the refill list recovers what is left.
Run it by provider and visit type
The practice-wide number tells you the size of the leak. The segmented number tells you where it is. Run the calculator separately for each provider, for new versus returning patients, and for long versus short visit types. A new-patient slot booked three weeks out and missed costs more, and happens more, than a routine follow-up. Review the rate weekly at the daily huddle, and put the annual dollar figure on the owner dashboard, where a physician-owner will actually look at it.
| Segment | No-show rate | What it points to |
|---|---|---|
| Returning patients, booked within 2 weeks | 4% | Working well; keep the reminder cadence |
| Returning patients, booked 4+ weeks out | 9% | Lead time: add a confirmation call |
| New patients | 12% | Highest cost slot: live call two days ahead |
| Friday afternoon, any type | 10% | Backfill list worked Friday morning |
The illustrative pattern above is common: the average hides a few segments doing most of the damage. Fix the worst segment first and the practice-wide rate follows.
What to do with the number
One recommendation: fix the refill rate first. Build a same-day list of patients who want to be seen sooner, give it one front-desk owner, and work it every time a slot opens. It needs no software and no change in patient behavior. Then attack the rate itself with the three workflow fixes: an answerable reminder cadence, shorter booking lead times, and that same-day list. Back them with a written policy the patient signs at intake, so the front desk has a rule to point to: a late arrival policy and, if you charge missed-appointment fees, a card on file policy that says when the fee applies. MGMA suggests asking for 24 to 48 hours of notice before a fee applies and offering hardship or one-time courtesy waivers (MGMA, 2025). Apply the same policy and the same amount to every patient. In a January 2025 MGMA poll, 42% of groups charged a no-show fee, and groups with a fee were more likely to report improved no-show rates in 2024, 25% versus 16% (MGMA, 2025). The practice manager owns all three, and with them in place, nothing slips on their watch.
No-shows are the most visible front door leak, but not the only one: unanswered calls, slow callbacks and patients who cancel and never rebook empty the same slots. The other systems that sit around the schedule are in the medical practice operations library. If you would rather have the whole front door measured on your own phones and schedule, that is the Practice Diagnostic, and what it costs is published.
- Pull 90 days of scheduled visits and no-shows from your scheduling report and compute your real no-show rate.
- Divide collections by completed visits for the same 90 days, and put both numbers into the calculator above.
- Ask the front desk how many empty slots were refilled last week. If nobody knows, that is the first number to start tracking.
- Start a same-day list with one named owner: patients who want an earlier slot, logged by chart number.
A same-day list that holds chart numbers and appointment dates holds HIPAA identifiers (45 CFR 164.514(b)(2)(i)). Keep it in the scheduling system or on your own secure systems, use a cloud tool only under a signed business associate agreement, or use random reference codes whose key stays in the EHR, and confirm the setup with your privacy or compliance officer.
- MGMA Stat, About 1 in 3 medical groups see higher no-shows in 2026, Aug 12, 2026. mgma.com
- MGMA Stat, No-show fees in medical practices on the rise, Jan 8, 2025. mgma.com
- Dantas LF et al., No-shows in appointment scheduling: a systematic literature review, Health Policy, 2018. pubmed.ncbi.nlm.nih.gov
- Kheirkhah P et al., Prevalence, predictors and economic consequences of no-shows, BMC Health Services Research, 2016. pubmed.ncbi.nlm.nih.gov
- Berg BP et al., Estimating the cost of no-shows and evaluating the effects of mitigation strategies, Medical Decision Making, 2013. pubmed.ncbi.nlm.nih.gov
- Moore CG et al., Time and money: effects of no-shows at a family practice residency clinic, Family Medicine, 2001. pubmed.ncbi.nlm.nih.gov
- Robotham D et al., Using digital notifications to improve attendance in clinic, BMJ Open, 2016. pubmed.ncbi.nlm.nih.gov
- eCFR, 45 CFR 164.514, HIPAA identifiers and re-identification codes. ecfr.gov
Put your own number on the empty slots
Score your front door in three minutes, or book a free 20-minute Chaos Audit and we will run this math on your own schedule, refill rate and slot value. You leave with the one fix to run first.
Frequently asked questions
How do you calculate the cost of no-shows?
Multiply scheduled visits per year by your no-show rate to get missed visits, subtract the share you refill the same day, then multiply by your average collected revenue per visit. Scheduled visits per year equal visits per provider per day, times providers, times clinic days. The result is revenue lost to empty slots.
What is a normal no-show rate for a medical practice?
For single-specialty medical groups reporting to MGMA, about 5% to 7%: 7% in 2019, 5% in 2021 and 2022, and 6.81% in 2023 (MGMA, 2025). Studies in other settings report more, such as 18.8% at a VA medical center and about 23% on average across 105 studies worldwide (Dantas et al., 2018). Compare against your own trend first and the benchmark second.
How do you calculate a no-show rate?
Divide no-shows by scheduled appointments for the same period, then multiply by 100. Pull at least 90 days, and decide once whether late cancellations count as no-shows, because published benchmarks vary by that definition (MGMA, 2026).
How much does a no-show cost a medical practice?
Your own slot value times the visits you lose: average collected revenue per visit, multiplied by missed visits that were not refilled. National per-visit figures that circulate online are not a reliable guide. One older study found failed appointments cost a family practice residency clinic 3% to 14% of total clinic income over a year (Moore et al., 2001).
What revenue per visit should I use?
Your own average collected revenue per visit: total collections for a period divided by total completed visits in the same period, from your practice management system. Use collections, not charges, because charges overstate what an empty slot actually costs.
Do appointment reminders reduce no-shows?
Yes, modestly. A meta-analysis of randomized studies found text reminders lowered the no-show rate from 21% to 15%, with multiple reminders working better than one (Robotham et al., 2016). A centralized phone reminder at a VA center moved it only from 16.3% to 15.8% (Kheirkhah et al., 2016).
Should a practice charge a no-show fee?
Many do: 42% of medical groups charged one in a January 2025 MGMA poll, and 25% of them reported improved no-show rates in 2024 against 16% without a fee (MGMA, 2025). That is self-reported, so pair any fee with reminders and a same-day refill list. Give 24 to 48 hours of notice, apply one policy to every patient, and allow hardship waivers.
Does the calculator store my data?
No. The calculation runs entirely in your browser. Nothing you type is sent, saved, or tracked, and no patient information is involved: the inputs are schedule totals and averages only.