University Finance Teams Revolutionise their Financial Planning Models

Good integrated financial planning is a must have for all universities. Many are still using spreadsheets. This article reviews the reasons to modernise financial planning.

Having spent years helping universities untangle financial planning and forecasting processes, the same pattern appears time and again. The ERP is doing its job perfectly. It is faithfully recording the final budget, forecast, and actuals. The biggest problem is the model feeding it.

The truth is simple. If the planning model feeding the ERP is fragile, everything built on top of it becomes fragile too.

A complicated web

For most higher education institutions the planning model is a complicated web of spreadsheets, offline assumptions and manual workarounds that only a handful of people truly understand. Finance teams, working to very tight margins are making miracles happen and are operating on a wing and prayer. 

Every university tells us about the same thing at the start of a project: “We only have a few spreadsheets.”

This is almost never true.

Once we look under the hood, we find a recruitment model in one place, estates costs in another, research income assumptions on someone’s desktop, headcount modelling in HR, and course viability spreadsheets owned by individual faculties. Then there are the one-off models no one remembers building.

Everyone is planning. No one is planning together.

These models frequently contradict each other, yet all of them influence the numbers that end up in the ERP. Its why the planning models are so crucially important.

The deeper issue is that most of these spreadsheets also miss the operational drivers that actually shape financial performance. Student numbers, teaching load, exams, staffing, research activity and estates usage all sit in separate systems and rarely make it into the models. Without those drivers, planning becomes guesswork or gut feel. You can adjust income number forever, but if you cannot see the staffing, space or workload impact, the model will always be incomplete.

New Course launches Are the Biggest Blind Spot

Every university wants to launch new programmes to grow income or diversify the portfolio. But new programmes almost always start with loss-making years. Many universities build sophisticated spreadsheet models to support their decision making. But the process of forecasting involves pulling in numbers from a variety of sources and ultimately involves a lot of precious time copy pasting information from all over the place.

The ERP accepts it without question and is one of the biggest causes of long-term budget drift.

Long-Range Planning Cannot Sit in a Three-Year Tool

Universities make decisions today that affect the next twenty years:

• student halls
• research buildings
• estates refurbishments
• large capital projects
• long-term borrowing

But many are still using planning tools built for a three-year forecast window.

You cannot model a twenty-year property strategy using a spreadsheet that struggles to handle year three.

And yet, this is surprisingly common.

Spreadsheets Don’t Fail Often – But When They Do, They Fail Spectacularly

My favourite example: A long-term plan was ready to go to board approval. On the final day, the model displayed catastrophic results. Nothing added up. It implied the business was no longer viable. Panic set in. Millions were cut from future years.

Hours later, the spreadsheet refreshed and everything corrected itself.
The model had simply stopped calculating.

The strategy was fine.
The tool was not.

What Happens When You Bring It All Together

When universities move beyond Excel/ Spreadsheets to a connected planning and forecasting tool, several things change immediately:

The guesswork disappears – You change one assumption and the model updates across income, cost, workforce and estates.

Faculties trust the numbers – Because they can see how their inputs drive the outputs.

Finance stops firefighting – Less time maintaining models, more time understanding performance.

Long-range planning becomes real – You can actually see how a decision today plays out five, ten or twenty years ahead.

The ERP becomes more valuable – It finally receives numbers that have been tested, not just prepared.

If you only remember one thing, it should be this: Your ERP is only as reliable as the planning model you feed it.

Fix the model, and everything upstream and downstream becomes clearer:

✓ forecasting
✓ reporting
✓ budgeting
✓ scenario planning
✓ estates
✓ cash visibility
✓ programme viability
✓ conversations with the board
✓ conversations with lenders

A strong planning model does not replace the ERP. It makes the ERP worth far more.

Ready to Strengthen Your Planning Model?

If you would like to understand how a dedicated planning and forecasting solution can improve confidence in your numbers and make long-range decisions easier to manage, we are here to help.

Speak with our Higher Education planning specialists
We can walk you through real examples, discuss your planning challenges and explore what a stronger model could look like for your university.

Talk to us ®