Accounting for charities and not-for-profits

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

Innovative approach to multi-dimensional reporting killer AccountsIQ feature for Arts charity, Artichoke Trust

Artichoke Trust is a charitable organisation which works with artists to create large-scale public art events across the UK. Artichoke’s ambitious outdoor art projects include the Lumiere light festivals and Antony Gormley’s One & Other Fourth Plinth commission. As a charity managing multiple projects at once, each with varying budgets and funding sources, Artichoke Trust has unique accounting requirements when it comes to project accounting which need to be SORP compliant. In particular, it requires a granular level of detail to ensure accurate recording of core project costs as well as the ability to record project costs against phases.

Neil Goulder, Director of Finance & Operations at Artichoke Trust, had been using Sage Financials as his accounting tool but admits it had a “number of serious shortcomings”. When he learned of Sage’s plan to withdraw the product, it was an opportunity to look around for alternatives which might better fit his particular requirements in Project Accounting and provide the structure he needs for SORP compliance. Neil says,

I started to look for a good Cloud-based replacement that is strong on dimensional reporting and analysis codes. Among a dozen candidates was AccountsIQ. I took a peek at a demo system and really liked it. Great, scalable product, with an innovative approach to multi-dimensional coding.

‘Conditional’ dimensions for accurate posting

Strong dimensional analysis is key for Neil. AccountsIQ allows for up to six customisable dimensions linked to a unique BI code, plus an infinite number of codes that can be assigned to each dimension. Reporting is possible across all dimensions and codes. AccountsIQ’s key strength is that only valid permutations of Analysis Codes can be used when data is input, which significantly reduces the risk of human error when it comes to tracking costs. Neil explains,

Dimensions are really important to us. We looked at Sage 50, but that only had two dimensions. We needed at least four, covering cost centres; projects; project phases; and individual light installations. There are some very expensive systems which can do it but there aren’t many affordable systems which offer this level of flexibility. That was an absolute ‘must’ from our point of view. AccountsIQ is the only product I’ve seen that allows you to create these ‘conditional’ dimensions.

Greater efficiency through automation and streamlined workflow

AccountsIQ features an automated bank reconciliation functionality that has helped Neil speed up the period end reconciliation process.

I really like the way the Bank Rec module works. The system with Sage Financials was so overcomplicated we never used it and worked in spreadsheets instead. AccountsIQ is very straightforward. I like the way it recognises past transactions and fills in as much of the information as it can, which really speeds up the process.

Neil is able to upload paperwork against transactions which makes it much easier to provide information to auditors and also facilitate a mostly paperless environment. Ultimately, AccountsIQ enables Neil to keep all of his data in one place, largely automated, without the need for other spreadsheets or manual processes.

With smart use of the dimensions coding structure, I can get every piece of information needed into AccountsIQ so that I don’t have to maintain control accounts manually in Excel. It saves us a huge amount of time.

Ease of access to data for SORP reporting

AccountsIQ’s Excel Add-in offers further efficiencies for Neil, allowing him to use a real-time data link from AccountsIQ to create tables in Excel which are fed into the SORP compliant statutory accounts prepared in Word. This means updates are refreshed instantly as changes are made to Statutory accounts.

AccountsIQ is brilliant at accommodating the structure needed for the SORP. We pull the information into our format live from AccountsIQ through Excel. It’s an incredibly quick and efficient process.

Lightning-fast implementation

Having initially set an ambitious release target of two weeks, Neil was able to implement AccountsIQ at Artichoke Trust in a record-breaking two days. This was in large part due to Neil’s own tenacity in getting to grips with the BI codes and how they could best be mapped to his needs. AccountsIQ’s development team gave Neil access to a test system so he could model the BI codes before going live. He had also exported and cleaned the static data from his old accounting system such as customer information, bank account details, and the nominal ledger structure. This level of preparation allowed Neil to go live with AccountsIQ so quickly. He says,

I hoped we might break all records and implement it in a fortnight as our new accounting year started on the First of April. I signed a contract Wednesday morning and we went live at 4:30 the next day.

Summing up his experience

The elements that have really made a difference are AccountsIQ’s innovative implementation of analysis codes, the attaching of invoices, and the bank reconciliation module. These are things I didn’t have before, and they work beautifully. These features have made the biggest difference to the way I work, giving me the information I need. Of all of these, BI codes are the absolute killer feature that puts AccountsIQ head and shoulders above the competition.

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