Accounting for charities and not-for-profits

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.

Enclude helps charities bridge the digital divide by implementing AccountsIQ

IT charity consultancy Enclude was formed with the aim of helping other charities adopt technology to improve their data management, communications, CRM and financial management processes. Sylvester Murphy is Enclude’s CEO and also implementer of cloud-based financial management system AccountsIQ, Enclude’s preferred accounting platform for its charity clients.

Describing his reasons for selecting AccountsIQ, Sylvester says, “We undertook research a number of years ago in conjunction with a group of charities including the Irish Charities Tax Reform Group. The purpose of that exercise was to assess the impact of emerging legislation and SORP requirements and try to identify a suitable charity accounting software package for the sector. AccountsIQ, a web-based accounts system, emerged as a great candidate from this research. We approached them and they were delighted to assist in structuring an offering for the sector.”

Meeting a range of needs with one accounting solution

Over 1,000 charities are registered with Dublin-based Enclude all of whom are seeking to improve their digital capabilities and enhance their IT systems and business solutions.

The requirements for financial management systems can vary across charity sectors and over time. In choosing a financial system, Boards and management teams are seeking solutions that are accessible, affordable and scalable. Increasingly, organisations are seeking systems that will also offer the potential for integration with other systems such as a CRM and Payroll systems.

Smaller charities can realise the benefits of improved management and controls by moving from spreadsheets to fully fledged accounting databases. For charities with incomes in excess of €500,000 with higher transaction volumes, automated processes such as bank reconciliations will save a significant amount of time. Charities in the €1-5M bracket might need to map payroll data and other expenses across different programmes and cost centres, requiring more complex coding structures. Larger charities in the €5M or greater bracket will also benefit from workflow automation and the capability to handle multi-entity organisations with groupwide data consolidation and reporting.

Sylvester adds, “We find AccountsIQ unique in that it can meet the needs of both small and very large charities. We have been able to become proficient in implementing one financial software system which, although it is often adapted differently, fundamentally suits the needs of the widest range of charities.

Helping charities achieve compliance

The Charities Act of 2009 represented a significant milestone for the charity sector in Ireland. It reformed the law relating to charities in order to ensure greater accountability and a Regulator was introduced. It triggered an ongoing narrative across the sector around transparency, governance and the need for improved systems to better manage reporting and compliance. One way in which charities could enhance public trust and confidence was through improved reports: financial reporting had to become more sophisticated, requiring charities to review their accounting models so that they could report across a variety of operating categories. Sylvester adds,

One challenge our Irish charities had in complying with the 2009 legislation was in moving away from very ‘flat’ accounting structures and introducing multi-layered reporting on income and expenditure by SORP heading and cost centre such as programmes, projects and branch location. AccountsIQ’s flexible coding structure and GL structure allows charities to classify their programme expenses with little extra effort.

In addition to the sector’s specific reporting requirements, AccountsIQ holds many standard, template reports within the system itself. It is also possible for information to be manipulated in Excel should charities need to create particular reports for specific stakeholders.

In addition to complying with the 2009 Irish Charities Act, many of Enclude’s clients also have entities based in different jurisdictions which need to comply locally as well as centrally. These accounts need to be consolidated in a consistent manner (and currency) for group reporting, all of which is handled within AccountsIQ’s integrated consolidation module. Sylvester adds, “Prior to using AccountsIQ for consolidation, the work done in spreadsheets by our multi-entity charities was hugely complex and time-consuming.”

Charity cloud accounting supporting flexible working structures

Non-profit organisations are often structured and resourced with staff and volunteers which may be part-time and working remotely. Commenting on the suitability of cloud apps in these scenarios, Sylvester says,

Cloud-based business apps like AccountsIQ give charities robust tools coupled with tremendous flexibility in how services are delivered and managed. You can access the software anytime and from any device. Also, the system allows you to define user profiles which means that you have very strict controls over who can access the system and to what degree. Providing remote access to people like external accountants or auditors can also help charities negotiate lower fees.

An implementation model which makes the most of the Cloud

Over the years, Enclude has developed a tried and tested implementation model supported by the customer success team at AccountsIQ. A phased implementation approach usually works well, allowing the charity to make steady progress at a manageable pace and to spread the costs over time.

The initial phase includes defining the data structure and chart of accounts so that data from previous systems or spreadsheets can be imported and correlated. “This ensures that fundamental reporting requirements will be met. With AIQ in place we then tend to look at potential for further enhancements such as integration with the organisation’s CRM solution.”

Where charities have implemented a cloud based CRM solution to manage their client service programmes, donor management and fundraising activities, he says it is possible to achieve further levels of efficiencies and control by integrating data feeds between the CRM system and AccountsIQ. “We have worked with a number of Charites, who have automated the processing of their donations from their web site into their CRM and onwards into their AccountsIQ financial management system.“

Enclude’s clients which use AccountsIQ are supported in the first instance by Enclude. More complex issues requiring level 2 support are escalated to Enclude’s customer success manager at AccountsIQ.

On the quality of support, he receives from the AccountsIQ’s team, Sylvester says,

The services team and support at AccountsIQ is very good and that is particularly important in the charity sector as we seek to transition the digital divide and build trust and competence in cloud solutions. The entire support process is managed within the system itself and there is a range of “How To” guides and online Help tools.”

AccountsIQ’s CEO Tony Connolly says, “It is great to see the Cloud making such a positive impact in the Charity sector. It is a pleasure to work with the team at Enclude which finds ways to make digital transformation achievable for other charities by providing experience, skills and resource.”

AccountsIQ provides a flexible and easy to use accounting infrastructure that easily adapts to the needs of this rapidly growing business

When EPIC The Irish Emigration Museum, part of the CHQ group, first opened in May 2016, its founder Neville Isdell had a vision to create a “local museum that could connect with people globally”. Since then, the museum’s innovative use of digital displays and interactive galleries has fostered year on year increases in visitors from both Ireland and overseas. In 2019, EPIC was voted Europe’s Leading Tourist Attraction at the World Travel Awards, further cementing the museum’s growth potential.

EPIC required a flexible accounting system that could easily evolve and adapt to the needs of a growing museum and EPIC’s Head of Finance, Aoife Smith, relies on AccountsIQ’s financial management software to provide this foundation for growth.

Efficiency through adaptability and integration

EPIC is part of the CHQ group, who use AccountsIQ for consolidation. EPIC has three legal entities using AccountsIQ: the asset company, the museum, and the retail store. The company’s main sources of revenue are from ticketing and sales in the gift store, where EPIC uses Access Gamma’s visitor management software for ticketing and retail purchases. AccountsIQ integrates with Access Gamma, which effectively shortcuts much of the manual data entry work, that would otherwise be required, by creating automated reports via the integration.

Aoife also makes use of AccountsIQ’s Purchase Order processing module for further efficiencies.  She says,

Prior to AccountsIQ, purchase orders were cumbersome involving emails and handwritten requests. With the PO module we’ve been able to automate all of this, removing overheads, and even tailoring invoices for specific customers. It’s user-friendly and we’re very happy with it.”

Innovation as priority

Innovation has been key to EPIC’s success since its opening. As a 100% digital museum, it must demonstrate technological savviness through both its public displays as well as through its own back-end infrastructure. With AccountsIQ, EPIC can leverage Cloud-based technologies to streamline its processes through automation, anywhere access, and integration with existing systems. All of this combines to increase efficiency so that resources can be spent on facilitating growth. Aoife says,

AccountsIQ has really helped us maximise efficiencies by being so user-friendly and versatile, with some really useful tools. I especially like that we can adapt much of the system ourselves, which is work that previously required the input of an accounts support team to complete. My favourite tool is the GL Explorer, which allows us to review both live and retrospective P&L and balance sheets instantly, as well as drill down to a transactional level. Also, the automated bank reconciliation is very efficient.”

Building for growth

One of the key benefits of AccountsIQ's charity accounting software is the ability to scale easily as EPIC grows. Aoife Smith anticipates that consolidation will soon be on the agenda:

Having had such great results from AccountsIQ’s core features, we are now looking forward to utilising the consolidation module which will help us go further in laying the foundation for our growing museum, and will enable us to provide quarterly consolidated accounts to the Board across the two main entities. We also have three other entities currently using a different accounts package, which we plan to migrate to AccountsIQ before the end of the year.”

Aoife sums up AccountsIQ’s role in laying the foundation for the future:

To grow the museum we need an infrastructure that is flexible and easy to use. We are still growing and will hopefully continue to grow over the next few years. We are confident that AccountsIQ can fulfil our needs as our company grows. It is working really well for us and we don’t anticipate any issues in the future.”