Most budgets start with last year’s numbers plus or minus a percentage. It is quick, but it tells you very little about why the numbers move, and it falls apart the moment something changes. Driver-based planning takes a different approach: instead of planning the financial outcome directly, you plan the business activity that creates it. In this guide we explain what driver-based planning is, how it works, give a simple worked example and show how to get started.
What is driver-based planning?
Driver-based planning is a method of budgeting and forecasting that links financial results to the operational factors that cause them. These factors are called drivers. Examples include sales volumes, average prices, headcount, salary rates, hours worked, store numbers, conversion rates or units produced.
Rather than typing a revenue figure into a spreadsheet, you plan the drivers (for example, units sold and price per unit) and let the model calculate revenue. Change a driver and the effect flows through the P&L, balance sheet and cash flow automatically.
Why finance teams use driver-based planning
- Faster re-forecasting. Update a handful of drivers instead of hundreds of line items.
- Better scenarios. Ask “what if volumes fall 10%?” and see the answer in minutes. It is the foundation of good scenario planning.
- A shared language with the business. Operational managers think in volumes, heads and hours, not general ledger codes. Drivers let them plan in terms they understand.
- Clearer accountability. When results differ from plan, you can see which driver moved and who owns it.
- More useful rolling forecasts. Rolling forecasts are only practical when updating them is quick, and drivers make that possible.
A simple worked example
Imagine a business with three hotels. Instead of budgeting room revenue as a single number, the finance team plans it from three drivers:
| Driver | Hotel A | Hotel B | Hotel C |
|---|---|---|---|
| Rooms available per night | 120 | 80 | 60 |
| Occupancy | 78% | 72% | 81% |
| Average room rate | £110 | £95 | £130 |
| Room revenue (365 nights) | £3.76m | £2.00m | £2.31m |
Now suppose a new competitor opens near Hotel B and occupancy is expected to fall to 65%. The team changes one driver and the model immediately recalculates revenue, linked costs such as housekeeping hours and commissions, profit and cash. No one has to rebuild a spreadsheet.
Hospitality groups such as Malmaison & Hotel du Vin and Harbour Hotels use Jedox to plan and report across multiple sites in this way.
How to choose the right drivers
The art of driver-based planning is choosing a small number of drivers that genuinely explain your results. Too few and the model is not useful; too many and it becomes as hard to maintain as the spreadsheet it replaced.
- Start with the P&L. Identify the biggest revenue and cost lines. These are where drivers add most value.
- Ask what causes each line to move. Revenue might be volume times price; payroll might be heads times average cost.
- Check the data exists. A driver is only useful if you can measure the actuals to compare against plan.
- Agree ownership. Each driver should have a named owner in the business who is responsible for planning it.
- Keep the rest simple. Smaller lines can stay as simple inputs or percentages.
Common pitfalls
- Building hundreds of drivers that nobody maintains.
- Choosing drivers that cannot be measured from actual data.
- Keeping drivers in disconnected spreadsheets, so the links between them break.
- Forgetting cash: drivers should flow through to working capital and the cash flow, not just profit.
Can you do driver-based planning in Excel?
You can, and many teams start there. The problems come with scale. Once several people need to enter drivers, multiple scenarios are needed and actuals must be loaded every month, Excel becomes slow and error-prone. Our article on why Excel fails for financial planning explains why. Dedicated driver-based planning software such as Jedox keeps drivers, calculations and actuals in one central model, with workflow so each owner can enter their own drivers.
Getting started
Start small. Pick one area, often revenue or payroll, build a driver-based model for it and run it alongside your current process for one cycle. Once the business trusts it, extend it. If you are considering software to support the process, our guide to budgeting and forecasting software is a good next read.
Frequently asked questions
What is driver-based planning?
Driver-based planning is a budgeting and forecasting method that links financial results to the operational drivers that cause them, such as volumes, prices, headcount and rates. You plan the drivers and the model calculates the financial outcome.
What are examples of planning drivers?
Common drivers include units sold, average selling price, headcount, salary rates, hours worked, number of stores or sites, occupancy, conversion rates and production volumes.
How many drivers should a model have?
As few as possible to explain your main revenue and cost lines. Most organisations find a small set of key drivers per business area works better than hundreds of detailed ones.
What is the difference between driver-based planning and traditional budgeting?
Traditional budgeting usually adjusts last year’s figures line by line. Driver-based planning models the activity behind the numbers, so plans are easier to update and explain.
Does driver-based planning work with rolling forecasts?
Yes. Because only a few drivers need updating each period, driver-based models make rolling forecasts quick and practical.
About Kybos
Kybos is a dedicated UK & Ireland Jedox Platinum partner. We build planning and analysis solutions that deliver value fast using accountancy qualified consultants. Whether you want a fully customised application or to build upon an existing solution, Kybos consultants are here to help.