Greentree’s Excel integration provided the perfect solution for this UK charity when its funding livelihood became increasingly entangled in a spreadsheet web.
CORD is a registered UK charity focused on peace building work in some of the world’s most hostile environments. Before Kerry Bosworth took over her role as Finance Director, the UK headquarters and its outlier offices were being run on Excel spreadsheets. Struggling to manage £3 million of funding on spreadsheets had effectively created a hostile environment of the electronic kind. Kerry says, “auditing of our finances had raised a few eyebrows since changes and deletions could easily be made to ‘live’ open spreadsheets.”
Kerry explains that it’s imperative that CORD meets its compliance obligations under UK law (Charities Standard Recommended Practice) and if it couldn’t satisfactorily report to donors about their contributions, funding would dry-up. Management at the time made a ‘no-brainer’ decision to implement Greentree since its Excel integration and reporting ensured it could make sense of CORD’s spreadsheet business and reporting requirements.
“Greentree enables us to access organisational information and meet our compliance obligations, faster and more efficiently than we ever have before. Without it, we simply couldn’t attract, manage or retain the level of donor funding we have today.”
Access integration improves aim of campaigns
Greentree also enables CORD to get more consistent and usable information out of its MS Access supporter database, which Kerry says has positively impacted its fund raising efforts. “Donors are our lifeblood and Greentree has enabled us to glean valuable insights into the frequency and amount of donations so we can use this information to improve the success rate of our campaigns.” The ‘Toilet Twinning’ campaign is a successful example of being able to provide the marketing team with timely information about donations, which has resulted in better targeting of the marketing effort.
Audits completed 3 months early due to slick reporting
CORD gets funding from several different sources and from both individual and organisational donors. Many donors require specific information to be presented in a pre-specified report format. This presented another administrative challenge involving lots of time and manipulation of spreadsheets and cashbooks so that figures could be presented in customised reports.
“The really fantastic thing about Greentree reporting is that we can automatically import all the foreign currency information and display it alongside the converted UK figures – there’s no need to cut and paste the figures from country office spreadsheets anymore. each report is tailored exactly to each donor’s needs and circulated within a month, not the 2 months it used to take.” With the faster and more efficient consolidation of its finances, CORD now completes its annual audits 3 months earlier than was previously possible.
International customers get fast local support
Greentree has over 10,000 users worldwide supported by an experienced network of multi-country partners. This effectively eliminates any of the support, local expertise and time zone considerations many organisations factor into a system evaluation. Kerry has great confidence in local Greentree Business Partner Prerogative’s experience and expert product knowledge and is reassured by the fact that help is close at hand.
Excel link reduces I & E consolidation from days to hours
Each month the country offices send CORD UK an income & expense spreadsheet in foreign currency. previously, all the figures then had to be converted into UK Pounds and included in a single CORD spreadsheet. Since this was such a “time-consuming logistical nightmare”, consolidation of all the figures only happened annually. Kerry’s certain that the manual nature of the process made it vulnerable to errors and omissions.
“The Excel link and Foreign Currency module meant that each country office could continue sending its spreadsheet but instead of manually converting and extracting the figures, we now automatically import these. This now takes just a few hours each month, whereas it used to take days and wasn’t accurate. We can now produce a fully consolidated set of figures in just a few days instead of annually. Greentree is now our definitive, accurate and up-to-the-minute database of all our transactions.” Kerry was delighted that Greentree could be implemented with the least amount of disruption to the way the country offices handled the accounting function.
Auditable compliance secures future funding
Kerry is in no doubt CORD could not function as it does today without Greentree. Its ability to significantly speed-up and improve data accessibility allows much greater visibility and control of income and expenses against budget. With information at her fingertips, Kerry can more efficiently manage cash flows whilst customised reporting enables her to comply with UK standards. CORD now has peace-of-mind confidence that the organisation is well placed to retain & attract the funding so vital to continuing its invaluable work in some of the world’s most unstable regions.
- Income & expense accounts are now done in a few hours instead of a few days with no disruption to how the country offices submit their figures
- Greentree improves accessibility to donor data. This enables more effective insights to better target marketing efforts resulting in more successful fundraising efforts.
- Customised reports presented within 1 month instead of 2, resulting in audits being completed 3 months earlier than previously possible