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.”

When Dan Garrigan, Finance Director with Merchant Taylors’ Company, decided it was time to upgrade from Sage 200, he knew their new finance system had to be in the Cloud.

"Sage 200 was coming to its end-of-life and the reporting was clunky. If we were going to change finance system we definitely wanted it to be Cloud-based, rather than incurring server costs."

Dan undertook a broad search of the accounting software marketplace. He looked at both large ERP systems, such as NetSuite and Sage Intacct, and smaller out-of-the-box software, such as Xero.

 AccountsIQ ticks all the boxes

"We fell between two stalls. Our finance needs are more complex than the functionality we found in the out-of-the-box systems, like Xero. But it was hard to justify the cost of something like Netsuite."

After joining a couple of AccountsIQ’s webinars and demos, Dan thought: ‘that ticks all the boxes’.

 A painless change   

Dan and his team found switching to AccountsIQ painless. Here’s his advice if you’re thinking of embarking on a similar project:

1) Allow time for pre-implementation work

Dan’s team thought ahead about the design of their Chart of Accounts. They then refined this with the AccountsIQ team who shared their experience of what had worked with other customers. As Dan says:

“The design of your Chart of Accounts is the big thing to get right. Everything else then follows. The time spent on this really paid off for us. We’ve got a design we’re happy with and meets all our needs.”

Watch our ‘How healthy is your Chart of Accounts?’ webinar.

2) Be flexible

The ideas you have at the start of your project might not carry through to implementation. That’s not a problem. As Dan explains:

With AccountsIQ, you get Sandbox test entities. This is great because you can play around with the software before you go-live and see what things look like and how it all works.

3) Invest in team training

Dan strongly recommends training your team, both in the run up to implementation and in the first two months post go-live. As he says:

"AccountsIQ are extremely good at this. We used the AIQ Academy and we had bespoke online training sessions with Daryl. They were all invaluable. We’ve kept the recordings and the team refer back when they need a refresher on features they don’t use regularly."

Find out more about how AccountsIQ can help your finance team

AccountsIQ’s charity accounting software is trusted by over 100 charity and not-for-profit finance teams. You can read their stories here.

To find out more talk to one of our accounting experts.  

Anne Somerville, Financial Controller & Company Secretary at American Chamber of Commerce Ireland started looking for accounting software in late 2016 to replace their TAS system, now part of Sage.

The organisation is a not for profit membership organisation representing both US companies in Ireland and Irish companies with businesses in the US.

They wanted to find an efficiently priced, user friendly and intuitive system that could help them conduct their business transactions and develop their reporting structures and were delighted when they found AccountsIQ.

The challenge

Anne knew her organisation needed an accounting system suitable for charities that was easy to use, efficient and effective, giving them the custom reporting functionality they required. As her team was not always sitting at a desk, Anne was interested in what a cloud solution could offer.

The problem with their old system was that it was clunky to use and was time consuming in the reporting functionality. It was cumbersome to extract the data or get the level of reporting required, even though the transaction volumes were not large.  They would spend a lot of time downloading data into Excel and ‘playing with it’ to get the information in the format they needed.

The solution

After evaluating four charity accounting software products, AccountsIQ was selected, because of its clear, simple and intuitive way of working.

Originally Anne felt they should complete their year end reporting and audit before looking to implement the new system.  However, 4 months into their search for a new accounting system, AccountsIQ was implemented and ready to use for their new financial year starting January 1^st, six months ahead of their expectations.

Key benefits

AccountsIQ has been in use for 7 months now and Anne has found month end reporting a vast improvement:

AccountsIQ is really excellent. It’s intuitive, simple to use and the implementation was outstanding. Now we have complete transparency and visibility of our financials. We can easily drill down to individual transactions and even down to items on an individual invoice without having to pull out any invoices or back-ups.

AccountsIQ’s implementation team helped design and create a set of customised reports for Anne, which she adds:

The reporting is high quality, AccountsIQ has created a set of custom reports for us and it’s very simple now to extract the information we need. It’s a vast improvement on what we had before and I can see the long-term benefits of the system being invaluable for our organisation.

Another key benefit of AccountsIQ is that it has been integrated with their bank accounts, which enables them to manage all payments and receipts online directly with the bank and download all bank transaction data directly and post automatically to AccountsIQ and complete bank reconciliations seamlessly.

The plan is now to implement the AccountsIQ Approval Workflow module to automate approval of purchase orders and invoices.  The final phase is to integrate with the organisation’s CRM system, which will enable the team to look up customer details, see balances etc from within the CRM, without having to log into the finance system.