Accounting for charities and not-for-profits

Alongside their commitment to supporting a better life for everyone affected by epilepsy, national charity Epilepsy Action must contend with some complex financial management challenges. Multiple sources of income, stringent controls over spending and restricted fund requirements, to name a few. That’s before we throw the cost-of-living crisis and an increasingly difficult fundraising environment into the mix.

Undaunted by such challenges, Tony Spinks, Director of Corporate Services with Epilepsy Action, decided to re-assess the systems and processes that would enable the charity to thrive no matter what. His #1 priority was the need to improve management reporting. In particular, he wanted real-time data to make better, quicker decisions about how they allocate resources. 

“We need to be absolutely on top of our financial position. We need complete visibility of what income and expenditure we have coming down the line to make the best decisions for the people who rely on our services. We were using Sage50; it was functional but wasn’t giving us the next level of management reporting we needed.”

Epilepsy Action needed a mid-market accounting solution

With lots of options on the market, choosing a new finance system can be mind boggling. As Tony recognised, Sage 50 is good for start-ups. But Epilepsy Action is a medium-sized organisation with around 70 staff, and they needed the next step up. However, when Tony looked at the Microsoft products and NetSuite, he concluded, “we didn’t need anywhere near that.”

When an invite to an AccountsIQ demo webinar landed in Tony’s in-box, he took 30 minutes out of his day to watch.

“I thought ‘this could be the answer to my problem’. I got in touch and started the journey. The more I saw of the system, the more I was convinced AccountsIQ was what we needed.”

Changing finance system is not as scary as many people think

Epilepsy Action went live with AccountsIQ on 1 January 2023. In the run-up to go-live, Tony and his team structured their training around the AIQ Academy online learning platform. To make it more effective and enjoyable, they introduced a practical, team-based approach to the training.

“The Academy videos are great, but we learn best by doing. We sat down as a team for an hour every Friday to put what we’d learnt into practice. For example, we’d watch the video about how to approve purchase invoices and then go and actually do it. AccountsIQ provide a test environment so it doesn’t matter if you make a mistake, you’re not messing with live data, and you can’t break it.”

Once they’d got to grips with the extra coding functionality that AccountsIQ provides, Tony and his team found the rest of the process of changing finance system easy.

“AccountsIQ is easy to use and our implementation consultant, Helen, was great. Her catchphrase was ‘we’ll just get it done!’ I found the whole process really easy. It’s not as scary as people make out.”

Three months down the line and all the transactional processes are running smoothly. The team are already noticing some significant time saving, particularly around the purchasing processes which used to be very manual. Now, they’re looking at where they can make even more efficiency gains.

“Automating processes is already saving us a huge chunk of time but there’s lots more time saving to come. I’ve got the OData connector working and I’m building the reporting templates. It’s this combination of time saving and financial visibility that will allow us to do more data analysis and really add value to our organisation. Everything I wanted is starting to happen.”

Hampshire Cultural Trust Implements AccountsIQ Across Both Trust and Trading Entities

Hampshire Cultural Trust (HCT) was formed when two Councils decentralised Hampshire’s museums and cultural centres.  Previously posting its financial transactions to the Councils’ centralised SAP system, the newly-formed Trust needed to find an affordable solution which could handle its complex accounting needs across 23 locations, consolidate two legal entities and produce sector-compliant and meaningful reports from Head Office.  With the help of advisors BDO, the Trust chose Cloud accounting and consolidation software AccountsIQ to handle accounting across the estate which comprises 23 museums and art centres.

HCT’s Director of Finance and Resources, Charlie Inigo-Jones, joined the Trust in 2016. Charlie says, “In 2015 the Trust needed to set up its own accounting system very quickly.  Under my predecessor, we simply took AccountsIQ out of the box, imported the general ledger and cost centres from the Council’s system, and started to process its own transactions. That was it!  We have since set up monthly accounts reconciliation and reporting processes, and are now beginning to explore the software’s full potential using multi-dimensional coding to meet our reporting needs.”

Working with AccountsIQ’s charity implementation team, Hampshire Cultural Trust’s project consists of two phases: designing and implementing the system infrastructure and reporting across their 23 locations and at Head Office; and completing a number of integration projects with ticketing, EPOS, payroll and other systems which will bring consistency and efficiencies across the group.

Phase I:  Reporting Across the Trust

As well as 23 locations, the Trust has two separate legal entities, and a number of restricted or programme-based funds which need to be separately accounted for and reported.  Each transaction needs to be posted to the correct location, entity, and fund.

AccountsIQ has enormous potential to produce Management Information Reports.  In order for us to create those automated reporting packs and make dashboards meaningful, we have been working with AccountsIQ’s very flexible coding structure to ensure it is optimised for our purposes.  The ability to define user access and create custom reports will allow us to cascade reporting throughout the Trust in a relevant way. Charlie Inigo-Jones 

AccountsIQ is particularly suited to supporting a charity’s need to account for restricted funds.  Charlie says, “AccountsIQ solves the accounting for restricted funds problem by using a third dimension of coding.  The use of project codes make the information easy to grab.  We could actually set up more layers of coding to extract sub-project information if we needed to.”

Phase II:  Integration and Automation

Many locations across the estate sell entry or event tickets and some incorporate retail outlets and cafes.  HCT has installed two systems on a trial basis which will provide automated ticketing and Electronic Point of Sale (EPOS).

Charlie says, “Introducing ticketing and EPOS systems will help us implement codes at the point of sale, so the system captures what it is we have sold, what for, and the other information we require in order to provide meaningful retail management reporting.  Integration with AccountsIQ will fully automate the process of posting sales from both retail sales systems, and help us to transform our financial and stock control processes.  It will be a massive win when data from each venue can be reconciled to the tills, the bank and amounts received from card payments – all on a daily basis and with clearly defined reporting.”

AccountsIQ is helping WCVA with everything from trustee reports to SORP reporting.

“The more we use AccountsIQ, the more we realise how much it can do.” 

WCVA is the national membership body for voluntary organisations in Wales. It manages funding, training and a range of support services that help charities and non-profits ‘make a bigger difference together’. In the months before the UK’s first lockdown, WCVA’s Finance Director, Tracey Marsh, recognised that they needed better financial reporting and started looking at new finance systems.

Tracey Marsh, Finance Director, WCVA

“We weren’t happy with the reporting capabilities in our existing system, Exchequer,” says Tracey. “Every time we wanted a report that wasn’t standard, such as comparing actuals to budget with variances, we had to pay extra. That was on top of an already high annual fee.”

Lockdown accelerated the need for change

When lockdown happened, this sense of dissatisfaction turned into more urgent and serious issues. As with many other organisations, the transition to home working accelerated the need for digital transformation.

“Our old system was server-based rather than Cloud-based,” explains Tracey.

“It was clunky; dropping all the time. And it just got worse and worse.  In that first lockdown, most of the pain from a finance point of view was because of the system. It meant we were working twice as many hours to do the same amount of work as when we were in the office. We simply couldn’t continue like that.”

AccountsIQ came in at a good price

The WCVA team first heard about AccountsIQ from their Scottish counterparts, the SCVO (Scottish Council for Voluntary Organisations). They were already using AccountsIQ and were happy to vouch for the system’s benefits. Nonetheless, WCVA still did their due diligence and conducted a thorough analysis of AccountsIQ against Sage, Iplicit and Exchequer.

“We chose AccountsIQ partly because of cost,” admits Tracey. “It came in at a reasonable price and we liked that there’s flexibility in the pricing. With so much uncertainty, we didn’t want to commit to a fixed cost that wasn’t linked to the number of users.”

Finance processes are now automated and seamless  

WCVA were also keen to move away from old, manual ways of working to more automated, seamless processes.

“This is something I love about AccountsIQ,” says Tracey. “Everything is self- contained within the system; even our bank reconciliations are now automated. You’re also able to attach documents to transactions; our auditors think this is wonderful.”

Budget holders have more autonomy

One of Tracey’s key objectives was for budget holders to have access to certain parts of the system, so they’d be more self-sufficient. WCVA has around 40 system users. Five are finance team members and the others are set up as light users which enables the wider business to manage approvals and access reports. 

The next step will be to start using AccountsIQ’s automated consolidation features. WCVA has two subsidiaries. One has already moved onto AccountsIQ from Xero and the other will follow in due course.

Multi-dimensional reporting is so much easier

Like many non-profits, WCVA uses AccountsIQ’s BI codes and multi-dimensional reporting to manage their complex accounting and reporting needs.

“One of our dimensions is used to distinguish between restricted and unrestricted funds,” explains Tracey. “Then we have lots of projects to which we allocate salaries and other costs; that’s another list of dimensions.

We’ve also created other dimensions so we can deliver detailed reports to our trustees that show exactly what each project is contributing to the organisation. Once we've closed the accounts, I can just run this multiple KPI report for the trustees. I used to have to do that manually and now AccountsIQ pretty much does it all for me, it’s brilliant.”

AccountsIQ also helps with SORP reporting

WCVA’s finance team created their Chart of Accounts in AccountsIQ to align with their SORP reporting.

“Now, we just run the GL explorer and there's the statutory accounts. Of course, we still have to do the notes ourselves, but the balance sheet is all there. It’s phenomenal!”

AccountsIQ is so easy to use, WCVA are using it more and more

When asked to sum up the single best thing about AccountsIQ, Tracey responds:

“As soon as we had the demo with Ellen at AccountsIQ, I could see it was a user-friendly system with a logical, intuitive layout. It was just lovely to look at.

Also, Ellen was so knowledgeable and helpful, I knew we’d work well together. In fact, we’ve found that the more we use AccountsIQ, the more we learn and realise just how much more it can do for us.”

Learn More

AccountsIQ solves the often complex accounting, productivity and reporting challenges of over 100 charities such as the Archdiocese of Dublin and Lepra. View our customer testimonials.

Find out more about our charity accounting software.