Find Unscheduled Treatment and Close High-Value Cases

Find unscheduled treatment with a short daily report

Start every day with one focused question: where are the planned procedures that don’t have appointments booked? To find unscheduled treatment, run a short report that returns all planned procedures with no scheduled appointment, sorted by expected recovery value and case age. The goal of the report is not completeness — it is prioritization: which cases to act on today to recover missed production and fill provider time.

What the daily report should return and why

Keep the report tight. Include these columns so the team can triage quickly: patient name, patient phone and preferred contact method, provider, procedure code(s), estimated patient portion, estimated insurance portion, estimated total value, planned date (if any), date treatment was planned, days open, last contact date, and provider availability windows. Sorting by estimated patient portion or expected recovery value surfaces where outreach will move more revenue per minute of effort.

SQL/report filters to find likely-to-book, high-value cases

Use these filters in the report or SQL extract. They prioritize likelihood and value so the team does the right work first: procedure status = planned/unaccepted; appointment ID = null (no appointment); days since planned > 3 (or > 1 for urgent pre-authorizations); estimated recovery value > practice threshold (example: $250, illustrative); last contact date > 7 days, or never contacted; provider assigned. Add insurance pending flag for cases needing pre-authorization follow-up. Adjust thresholds to match practice volume and provider schedules.

Triage after you find unscheduled treatment: three action buckets

You want a quick, repeatable decision rule that assigns every case to one of three buckets. Use objective criteria so the front desk and the treatment coordinator make consistent choices during the morning huddle.

• Call now — High value, high likelihood: expected recovery value above threshold, patient answered within last contact window historically, or case age > X days and provider has same-week openings. Owner: front desk or treatment coordinator; goal: book within 24–48 hours.
• Email/soft touch — Medium value, moderate likelihood: estimated recovery between thresholds, patient prefers email or has recent contact, or case requires insurance estimate before scheduling. Owner: front desk or designated recall coordinator; goal: confirm interest and book within 7–14 days.
• Future follow-up — Low immediate ROI: small-dollar cases, low likelihood, or recently contacted and declined. Owner: automated follow-up sequence or recall list; goal: re-evaluate in 30–90 days.

Assign owners and set time-boxed targets in the morning huddle

In the morning huddle, assign each triaged bucket to a named owner. Say: “Jo calls the five Call-Now cases and reports results by 11 a.m.; Priya sends the three Email/soft-touch messages and logs replies by end of day.” Attach time-boxed targets: number of calls, dollars to book, and days-to-book target. Track these on a simple board or dashboard so action and accountability are visible.

Scripts and steps that convert — short, specific, and role-based

Use short, role-specific scripts that reduce hesitation and get to the decision. Scripts should include a one-line reminder of reason, a clear next step, and a closed-ended question. Examples below are operational; adapt tone to the practice.

• Call-Now script (front desk/treatment coordinator): “Hi, this is [Name] at [Practice]. We have [procedure] recommended for you. We have an opening this Thursday morning with Dr. [X]. Would you prefer Thursday or Friday?”
• Email/soft-touch script (front desk): Subject: “Estimate and scheduling options for your [procedure]” Body: Brief statement of planned procedure, estimated patient portion, two available windows, and a CTA to reply with preferred day/time or request a callback.
• Future-follow-up template (automated or manual): Short message that confirms interest, explains next step (pre-auth or financial estimate), and offers an opt-in to be contacted in X weeks if they’re not ready now.

Metrics to watch daily and how to report them

Track a short set of daily metrics and report them in the huddle. Recommended metrics: number of unscheduled cases reviewed, number of Call-Now calls completed, dollars booked from those calls, call-to-book conversion rate, average days-to-book, and remaining unassigned cases. These metrics show whether outreach is recovering revenue and whether the process is keeping up with incoming planned cases.

Handle insurance and authorization steps in the same workflow

Many unscheduled cases stall on insurance verification or pre-authorization. Include an insurance status column in your report and create a quick parallel workflow: cases needing authorizations go to the insurance owner; cases needing eligibility checks get a verification task. If authorization will take longer than booking windows, mark the case as 'waiting' and set a follow-up date so it doesn't disappear from future reports.

Use automation to detect, score, and create tasks (optional)

Automation can reduce the manual work of scanning records. As an option, automation can flag new planned procedures with no appointment, score them by expected recovery value and likelihood to book, and create owner tasks with the correct outreach template attached. Teams still make the calls and own the follow-up; automation should only queue work and surface priorities, not replace human outreach or financial conversations.

How to iterate the workflow week over week

Run this process daily for two weeks and then review results weekly. Ask: which outreach converted, which providers had the most recovered bookings, which scripts needed tweaking, and where did cases age out? Use those answers to adjust thresholds, reassign owners, or change messaging. If conversion is low on a specific procedure code, escalate to the clinical lead for a workflow or scheduling barrier review (not treatment advice).

When to escalate an unscheduled case

Escalate when a high-value case is more than 30–60 days old with multiple failed contacts, or when insurance pre-authorization issues block booking and require a benefits negotiation. Escalation steps: reattempt contact with a treatment coordinator call, document every attempt in the chart, and set a final follow-up date. If still unresolved, move the case into a monitored recall list rather than letting it fall into administrative blind spots.

Link this workflow to other daily checks

This daily unscheduled-treatment workflow should sit alongside other short daily audits: the daily schedule gap audit, posted production reconciliation, and priority insurance follow-ups. Running these together closes multiple missed-revenue pathways: unbooked planned cases, last-minute schedule gaps, unbilled work, and aged claims. See the related playbooks for details and templates: monthly-production-variance-analysis-identify-top-3-drivers, prioritize-unscheduled-treatment-outreach-expected-recovery-value, and prioritize-daily-unscheduled-outreach-urgency-lapse.

Small test to run this week

Pick one provider and one day to pilot. Run the unscheduled-treatment report for that provider only, triage the top 10 cases, assign owners, and track bookings and dollars recovered over seven days. Use the results to set a realistic daily target (for example, X calls and $Y booked) before scaling to the whole office.