Mevia Solutions

Home › Guides › Rolling forecast

GUIDE · CONTROLLING

Rolling forecast: from looking back to steering ahead.

Monthly reports tell you what happened. A rolling forecast tells you where the year is heading – early enough to change course.

As of November 20265 min readBy Sebastian Grossmann and Dávid Szandtner

AT A GLANCE

  • A rolling forecast combines actual results to date with a realistic estimate for the rest of the year.
  • It works best when built on a few drivers: doctor hours, gross profit per doctor hour and fixed costs.
  • The gap between forecast and target shows how much needs to change – and by when.
  • Update it every month, straight after your KPI review.

Why a budget alone is not enough

Most practices have an annual plan – if at all – made once in January. By spring it is out of date, and from then on the figures are only compared with last year. That tells you what has happened, but not whether you will reach your target.

A rolling forecast keeps the target and updates the path to it every month. Whatever has happened is replaced with actuals; the remaining months are re-estimated on the basis of what you now know.

The three drivers

Instead of forecasting dozens of accounts, focus on the few figures that move profit:

  1. Doctor hours that will actually be booked in the remaining months.
  2. Gross profit per doctor hour – see gross profit per doctor hour.
  3. Fixed costs for the remaining months.

Profit for the rest of the year = doctor hours × gross profit per doctor hour − fixed costs.

Sample calculation: the forecast in July

A practice aims for €300,000 profit before tax this year. After six months, actual profit is €130,000.

ASSUMPTIONSForecast for the second half-year

SAMPLE CALCULATION

Actual profit, January to June€130,000
Booked doctor hours, July to December700
× gross profit per doctor hour €400€280,000
− fixed costs, July to December−€180,000
Forecast profit, second half€100,000
Forecast for the year€230,000 (target: €300,000)

Sample calculation with assumed values, not client data.

All figures in euros. The logic works in any currency.

The gap is €70,000. Now the forecast becomes useful, because each lever can be priced:

LeverEffect in the second half
Prices reviewed: +€50 gross profit per doctor hour+€35,000
Gaps filled: +60 booked doctor hours+€24,000
Remaining gap€11,000

With two realistic levers, the practice gets close. The remaining €11,000 is a deliberate decision: a cost saving, a further lever – or an honest adjustment of the target. Either way, it is decided in July, not discovered in December.

How to keep it alive

  • Monthly, after the KPI review: replace last month’s forecast with actuals, re-estimate the rest. See the practice cockpit.
  • Be cautious, not hopeful: forecast booked hours on the basis of the last three months, not the best month of the year.
  • Write down assumptions: one line each for hours, gross profit per hour and costs.
  • Price every lever before you decide on it.

This page explains the business and financial context. It is not a substitute for tax, legal or medical-regulatory advice in your country.

FREQUENTLY ASKED QUESTIONS

In brief.

What is a rolling forecast?

A forecast that combines actual results to date with an updated estimate for the remaining months and is refreshed every month. It shows whether you are on course for your annual target.

How is it different from a budget?

A budget is set once and then compared against. A rolling forecast is updated regularly and focuses on where the year will end and what is needed to reach the target.

How much effort does it take?

With a driver-based model – doctor hours, gross profit per doctor hour, fixed costs – about 30 minutes a month once it has been set up.

How does Mevia help?

As part of the controlling setup we build your forecast model, link it to your monthly figures and show you how to use it to decide on levers.

Will your practice reach its target this year?

In the free initial consultation we look at where your year is heading and which levers you have.

Free initial consultation

READ ON