Merchant Taylors' Company
What advice would an historic City of London Livery Company give to finance teams looking to implement new accounting software? The best: it’s all about planning ahead and design thinking.
Overcome the NFP sector’s unique challenges and streamline the way your accounting team, fundraisers and volunteers work. AccountsIQ allows you to achieve transparency, consistency and SORP compliance with slick, digital processes and low cost of ownership.
Gain full transparency with detailed expenses tracking, linked to funds and easily segregate income streams. Work with our platform experts to create your unique, multi-dimensional coding framework and set up the exact reporting you need.
Swap costly upgrades, expensive hardware and heavy implementation costs for one single affordable monthly subscription. Built in the cloud, AccountsIQ integrates seamlessly with other apps, allowing you to streamline processes, reduce errors and save time.
Transform the way you work with AccountsIQ’s automated processes. Spend more time on strategic work and less on repetitive administrative tasks. Go digital with approvals, expenses, bank feeds, reconciliation, document storage, FX, consolidation and more.
This multi-dimensional reporting is perfect for our setting. It has revolutionised our potential to do our job here in the centre. That is to stand over these charitable funds and know exactly what’s going on with the funds of each charity.
”
What advice would an historic City of London Livery Company give to finance teams looking to implement new accounting software? The best: it’s all about planning ahead and design thinking.
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.
"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’.
Dan and his team found switching to AccountsIQ painless. Here’s his advice if you’re thinking of embarking on a similar project:
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.
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.
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."
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 is Enclude’s preferred accounting platform for its charity clients. IT charity consultancy Enclude was formed with the aim of helping other charities adopt technology to improve their financial management processes.
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.”
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.
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.”
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.
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.”
After evaluating four charity accounting software products, AccountsIQ was selected for American Chamber of Commerce, because of its clear, simple and intuitive way of working.
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.
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.
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 1st, six months ahead of their expectations.
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.