Accounting for charities and not-for-profits

AccountsIQ helps global charity, Lepra gain rapid multi-dimensional reporting and reduce processing time by 80% by moving to the Cloud.

Lepra are a charity leading the global fight for the eradication of Leprosy. Each day over 600 people worldwide are either diagnosed with Leprosy or are starting treatment for Leprosy. More than 8% of these are children.

Based in the UK but supporting operations on a global level, like many charities, Lepra have complex revenue generation. Their revenue comes from various sources and must be consolidated into one system for accounting and compliance purposes. Recognising the need for a cloud solution which can automate their manual processes and consolidate their revenue, the Lepra team engaged ION, a financial transformation specialist, to help find the right solution for them. The support ION offer enables a point of contact for the finance team should any issues arise – whether they are knowledge or training issues, or problems in simple transacting to complex reporting.

Requirements and Challenges

Lepra’s current accounting system was not giving them the reporting breakdown that they needed, meaning it was taking too long to pull together information which advised critical business decisions. In addition, the need to manage all their revenue in one place and have access to real-time data would not only save time but also give everyone in the team more access to information.

Like many businesses, Lepra’s current system was not well connected to their CRM system, Advantage, and this meant a lot of manual processing was needed to align the two systems. As with a lot of manual processes, this was time consuming, allowed for human error and often meant the process wasn’t followed exactly as required. Through the discovery phase, their implementation partner, ION, identified a lot of functionality and improvements that Lepra wanted to implement in the future, therefore the need to have a system which could be flexible and grow with the charity was important.

The final major requirement for the team was that the implementation could be quick and seamless. With a lot of disruption to the business already and with many team members working from home, they needed a solution which could be quick and easy to get everyone on board with.

Quick-to-Implement Solution

Taking all these things into consideration, AccountsIQ was identified as a good solution for Lepra. A flexible and user-friendly cloud accounting solution, AccountsIQ could address all of their requirements and open up many other benefits.

Nick Avery, Director of Resources, Lepra

“AccountsIQ was the only solution we found that combined the ease of use of cloud based accounting systems and the multi-dimensional analysis that is needed for charity accounting at a cost that we liked!” Nick Avery, Director of Resources, Lepra.

A concern for the team was the time it takes to switch over to a new system and how this would disrupt their processes. However with ION’s quick start implementation framework and our user-friendly interface, the transition was managed with ease. The implementation was completed in a matter of weeks, and the transfer of data to AccountsIQ was seamless.

Outcomes

Like many clients, within weeks, Lepra were finding many benefits to operating within a new system. The ease of use of AccountsIQ has made the adoption across the Lepra team much easier, meaning they can see the benefits of the system straight away. Several key areas have been improved:

• Process efficiency: manual processes have been drastically reduced, with some processes now 80% quicker than before.
• CRM data connectivity: the import of data from Lepra’s CRM system, Advantage has been simplified. Removing the need for additional Excel sheets and manual intervention to import and export data sets several times is helping to save the team a lot of time and undoubtedly removing opportunities for error.
• Remote access and usability: the usability of the AccountsIQ system has been praised by the Lepra team and means that the business has more active users getting the most of the system. With many teams still working remotely, having user-friendly cloud systems has minimised training requirements and empowered decision-making across the team.
• Expenses management: switching from paper methods to a digital system, expenses are submitted to the relevant manager directly, with the employee given full traceability to monitor the status of their expense claim.
• Scalability: the integration paves the way for scalability of the system in the future. Built on a solid cloud accounting system, the team can plan for additional modules and reporting functionality when the business requirements dictate.
• Maintenance: often with new software integrations, IT teams are typically concerned about the impact that a project implementation will have on their workload, but with the right system, maintenance for internal teams should be reduced. For Lepra, they have found that the system is much easier to maintain than their previous software.

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.  

AccountsIQ and Enclude enable the Archdiocese of Dublin to go fully digital

The Archdiocese of Dublin is the largest Diocese in Ireland, with 197 parishes and funds under management that require reporting under new charity SORP regulations. The Archdiocese required an accounting solution that would meet their complex reporting needs whilst also providing a user-friendly system that parishes could easily adopt. This allowed a step-change away from paper, spreadsheet and bookkeeping systems. It was an ambitious project primarily due to the number of parishes and users and offering a good user experience was crucial in getting all the parishes digital and consistent in their processes.

The key requirements identified from the strategic review were:

• A highly secure cloud system with inclusive disaster recovery, upgrades and support in one service [SaaS]
• A finance system that is clear for Diocesan and Parish users to set up and easily adopt across the Diocese
• Consolidation of all 197 Parishes into a single reporting charity number was key which also facilitates a simplified internal and external auditing process
• Integration with a custom pastoral management system using API integration
• Extensive budgeting and reporting by department, fund, parish and project through a Business Intelligence layer [BI Layer]
• Systems integration capability to facilitate invoice capture, expense management, banking and approval workflow.

Following the strategic review and tendering process, the Archdiocese appointed AccountsIQ, partnered with Enclude, a non-profit technology consultancy firm, to implement a digital system to integrate pastoral management with accounting and provide consistent, consolidated reporting. 

Collaborative and personalised implementation

One of the challenges was the scale of the project. This meant the team getting to know all the people involved and creating a community-based approach to the project given the number of stakeholders involved. Ide Finnegan, Head of Finance and project director for the Archdiocese of Dublin explains:

Implementing AccountsIQ across all our parishes was a very significant project for the Archdiocese. There were challenges along the way, but we received great support from AccountsIQ throughout the process. It particularly helped that the implementation manager was also an accountant who understood what we were trying to do. This made the process much smoother.”

An integrated Salesforce solution

A seamless interface with the Archdiocese’s pastoral management system built in Salesforce was provided along with a custom cash collection form, built and deployed to allow parishes to easily lodge collections automatically into AccountsIQ with built in coding in accordance with SORP.  This allows a central view to manage funds for the assets of the various registered charities and the trustees to whom they report.  Essentially a simple capture method for the user, allowing complex reporting to be made more efficient.

Simplified consolidation across numerous entities

The Archdiocese required a consolidated financial reporting software across its 197 parishes and trusts. With numerous entities and a high volume of transactions, the consolidation requirements were complex. AccountsIQ’s simple to use, but sophisticated consolidation engine, enabled the Archdiocese to simplify the process by automating much of the consolidation and reducing manual inputs. It also simplified reporting for auditors through consolidated debtor and creditor reports. The Archdiocese is now looking to implement AccountsIQ’s automated accounts payable using OCR technology, the expense capture app and fixed asset register modules to further consolidate their processes.

Meeting the needs of multiple users

The Archdiocese of Dublin has 197 parishes and trusts each with its own Parish Finance Committee and unique user requirements. AccountsIQ understood the requirement for a flexible system that could meet the needs of a wide and varied range of users. AccountsIQ’s user-friendly features facilitated user adoption amongst parishes, particularly amongst users with less experience of Cloud accounting software. In this way, AccountsIQ offers a clear user experience at the front end, while enabling complex accounting solutions on the back end.

We realised early on that we had to offer an accounting solution to parishes that was more than a compliance exercise. With AccountsIQ we could offer them something more, an easy to use template for accounting that cut back on paperwork and saved time on manual processes. This efficiency has positively impacted uptake within parishes,” explains Ide.

A Cloud-led paperless approach to accounting

Cloud technology was a major factor for the Archdiocese in choosing AccountsIQ and Enclude. Previously they had used an on-site system (installed on PCs) which was impractical to roll out to each parish. The finance team recognised that the Cloud would dramatically simplify implementation and provide ongoing benefits for reporting and auditing.

AccountsIQ and Salesforce integrate seamlessly in the Cloud and use secure API technology to transfer data between both systems. This naturally provides an audit trail for donations and the ability to automate direct debit calls, auto-reconcile banks and prepare tax refunds for donations above €250 per annum from generous donors. The bespoke consolidated reports are all accessible through pinned electronic documents, thus cutting back on tedious paperwork.  This automated and paperless process also makes life much more efficient for the charity’s auditors.

The Future

AccountsIQ’s ongoing development and commitment to R&D means that the system is constantly evolving making it an accounting solution for the future. The Archdiocese anticipates that it will explore more opportunities to benefit from AccountIQ’s evolving suite of tools, particularly the expense module, accounts payable capture and approval, fixed asset register and open banking.

Ide explains:

One of the good aspects of AccountsIQ is that it’s constantly improving. The system we started with on day one has evolved significantly. AccountsIQ has delivered the best possible solution to the Diocese and Parishes and continues to release new features and functionality that make our systems efficient and compliant.”