How to find out why a clinic's revenue or appointments dropped

When a clinic sees revenue or appointments fall, the first step is to check whether actual results changed or only the way they are recorded. Only then does it make sense to look for where the change came from.

Verify the period, the source and the definition

Compare periods of equal length, and account for holidays, vacations and changes in office hours. Check for delayed imports, and distinguish procedures billed from payments received.

Break the change into specific parts

Analyze results by procedure type, period, location or provider, as long as the data is complete and comparable. Also check the number of appointments and their available statuses.

• Confirm that the data is complete and the periods are comparable.
• Find the categories that contribute most to the decline.
• Test your hypothesis with the operations team and the source system.

Tell fewer visits apart from lower-value procedures

If appointments are falling, find out whether fewer slots were booked, more were canceled, or the available statuses changed. If the number of procedures stayed about the same but revenue fell, check the procedure mix, price changes and the gap between the amount billed and the amount paid. A breakdown like this tells you which data to request next.

Check the calendar too. Did the clinic see patients on the same number of days? Did the number of providers, office hours or the way slots are labeled change? Without this context, the difference may come from planned vacations or a change in record-keeping rather than a drop in patient demand. For each hypothesis, write down what evidence would confirm it and which source holds that evidence.

Turn your conclusion into a verifiable next step

If the analysis shows the deviation is concentrated in a specific group of appointments, agree with the operations team on a process review. After the change, track the same metric over a comparable period. Don't treat a single month as proof of success when the number of observations is small or the periods have a different mix.

The analysis should produce a short written record: what changed, in which source, which explanations are confirmed and what still needs checking. Show healthcare and personal data only to the extent the task requires. An operational report helps organize the work. It does not replace a professional assessment of care or an individual clinical decision.

Build a repeatable review process

Record the value, period, source and definition of the metric that changed. Then compare the same weeks or months and split the difference by appointment type, procedure or location, if the data is complete. Check that the totals of the individual groups add up to the whole, and that record-keeping did not change in any period.

For each possible explanation, decide who can verify it and in which system. A change in available slots can be checked in the calendar, a change in the billed value in the record-keeping rules, and an incomplete import in the refresh log. Keep findings separate from hypotheses. At the next review, return to the same metric and a comparable time window to see whether the deviation repeats.

Watch for the lag between a procedure and its payment

A procedure and its payment may be recorded in different systems or in different periods. When you compare them, check whether the number of procedures performed, the billed value or the time to receive payment is changing. If only one month's total payments changed, it may be a timing shift rather than a drop in activity. When you interpret the results, state which date the report is sorted by. For financial decisions, confirm the result with the person responsible for accounting records.

Log operational changes

Whenever there is a significant difference, note any change in office hours, staffing or the booking process. A short operations log makes later comparisons easier by explaining why a metric moved, and it keeps a planned change from being treated as an unexplained problem.