Constellation Trust found "exceptional" value in Dimensions for Academies (and Hoge 100)

Chemistry Class

Constellation Trust's story

As academy trusts grow, system challenges are common. What worked then can hinder your productivity now. This conundrum led The Constellation Trust to consider a brave step. Could they move from an enterprise financial management system and find what they needed elsewhere?

We spoke to Robert Kennington, CFO at The Constellation Trust. He explained the challenges they had and how they determined their next move. He also told us what their financial management system looks like today.

A 10-school trust in Hull

First formed in 2009, The Constellation Trust now serves 5,000 pupils across ten sites. Two secondaries, seven primaries, and a pupil referral unit. Within five miles of each other, 1,600 pupils remain eligible for free school meals.

"We serve a really disadvantaged area," said Robert.

"Hull is traditionally seen as a bit of an outpost at the end of the M62 and our challenges include attracting and retaining quality staff. Yet, we're focused on giving our students the best possible deal. We have a central services team covering operations, finance and business, HR, and improvement teams for both primary and secondary. I joined the trust in 2017 having been a business manager for two of our primary schools," he added.

"Not fit for purpose"

When a MAT first forms, it can inherit old systems that don't work well together. The Constellation Trust was no stranger to this frustration.

"Back in 2017 there wasn't an effective finance system strategy in place. We hadn't identified what might need to change in advance of expansion. And as further schools joined, our system quicky became unfit for purpose. One or two schools, yes, but not a ten-strong MAT. Our disjointed system became archaic. We were running four separate databases and several bank accounts. You had to consolidate everything in Excel. It simply wasn't a good way to run a £40 million turnover MAT," said Robert.

As their financial management became harder to control, Robert knew it was time for a change. He explained their service issues too:

"With an enterprise system, we were a tiny cog in a massive wheel. If we reported an issue, it would be a week before we had any response. And if our niggle wasn't considered important to others, nothing further happened. There was no desire to work closely with us.

Coupled with this, it was an expensive option. And that's difficult to justify when it's also not fitting your needs. A product is only 'top level' when you use it exactly as intended." Robert was convinced. He must find a financial management system that would meet the trust's current and future needs.

Ask The FD Forum

Robert decided to shortlist three providers. He would give the existing provider an opportunity, plus another big name, due to its integrated budget management system. That left space for a third contender. Looking for an unbiased viewpoint from like-minded people, Robert engaged with The FD Forum.

"People will tell you how it is on The FD Forum. They don't have an agenda. And when it came to Hoge 100 and Dimensions for Academies, I couldn't find any negative comments about them. That's rare.

From the forum, I learnt Hoge 100 were a smaller company who had already developed Chart of Accounts automation with the DfE. I also learnt about their positive customer service. That was important to me.

During their initial presentation, Hoge 100 said they didn't want to expand massively, preferring to maintain their level of quality instead. That shone through straight away. Other providers have been taken over by bigger players or expanded too quickly. In my opinion, both outcomes have a detrimental impact on quality. I wanted to find a partner who would give me what I expected.

I wanted them to be at the other end of the phone, understanding what I was talking about. I wasn't interested in working with the biggest provider," explained Robert.

Getting from here to there smoothly

Many MATs worry about how they'd make the transition to a new system provider. How much work would it involve, and would they have the support they needed? Robert explained why the process was so smooth with Hoge 100:

"I have to say, Liz [at Hoge 100] provided unbelievable support. I couldn't have asked for more. She led on everything, and Hoge did much of the work for us. We just had to fill in the gaps.

Having completed many conversions from our current provider, Hoge immediately understood the technical requirements. They also worked closely with our IT managed service provider, RM Education, to remotely access required files.

Liz built a historical database to hold our previous years' transactions. This is a massive cost-saving, and I don't think any other provider offers it. We now avoid spending thousands on an archive licence. I feel massively reassured I'll have the information I need in the future.

Liz also compiled our opening balances from previous years using data extracted from the old system. When I did my end-of-year consolidations, the balance sheet was 100% correct. The entire process went much more smoothly than I'd expected."

Feeling more in control

Hoge's system offers three integrated portals to complement the core accounts. The Constellation Trust initially opted for Finance Portal. Cloud-based, this provides important visibility and functionality to the central finance team and site-based budget holders. Robert explained how the trust's move to the system (including Finance Portal) had helped:

"It's made a massive difference to us all. We now have one database. We've also moved to one bank account, one electronic supplier form, and central reporting. To me, it feels much more in control, which is important when you have ten sites.

I'm now saving weeks producing the management accounts. Live data from the core accounts feeds into my budget system so I'm doing far less manual work. I'm also more confident about my figures as there's less risk involved.

We've even had positive feedback from our auditors. They don't have to wait for me now and can remotely log into one system to get data for the entire trust. Plus, they can review it many ways - by school, period, year, whatever.

Finance Portal is more than a purchase order portal, too. You can easily search for further information at a nominal level and have greater visibility. There's also a whole suite of reports to pull off. All our sites use Finance Portal to raise their own orders and invoices now - it's making a bigger difference than I first imagined."

Getting more from your financial system

The Constellation Trust has made huge strides since 2021. And so far, so good. Following a feedback session with Liz and Eve at Hoge 100, Robert can see further opportunities to improve his processes and gain further efficiencies from Dimensions for Academies.

"One next step is to submit our annual Chart of Accounts return automatically. We didn't do it in our first year because I wanted to have time to look at it properly. So, this year, we'll use the automatic process built by Hoge and save the auditor's fee. It should become just a few clicks.

We also recently highlighted further potential development areas. They've now been done - which I find astounding. If Hoge feel an enhancement adds value to everyone they just do it. Of course, they developed their own software and I find them incredibly agile in their approach,"he said.

If you're part of a MAT finance team, wondering about changing your financial management system, Robert had a final piece of advice to offer:

"Just post 'What is your view of Hoge 100?' on The FD Forum. I'd be highly surprised if you got anything but positive responses. And that speaks for itself as it's from people like me who are currently using the system daily."