English captions available · Read the transcript
Watch on YouTubeEpisode 01 · 7 minutes
From spreadsheets to CRM
Is it time for your charity to make the move?
When one report takes all day.
Donations in one spreadsheet. Supporter details in another database. The latest update in someone’s inbox. Which figures can you trust?
This episode follows that familiar monthly report to explain what a CRM does, how shared records work, and where searching, filtering and dashboards can help.
A CRM can connect the information. Your team still needs to keep it accurate.
Read the full transcriptStart at the question that matters to you.
- Is it time to move to a CRM?
- When spreadsheets get difficult
- What is a CRM?
- Six ways CRM can help your charity
- Finding, filtering and sorting data
- Dashboards and summary reporting
- Recap and next steps
English captions available · Full transcript below
Episode 1: read the transcript
Opening
You’ve got a report to finish. How much did your organisation raise last month? It should be a simple question. But your figures are spread over four spreadsheets, an office database, and an updated file somewhere in your emails. Which figures do you trust? And how long will it take to find out? If that sounds familiar, a CRM could help. But what is a CRM? What can it do that a traditional spreadsheet cannot? And is CRM software a right move for your charity?
When spreadsheets get difficult
Spreadsheets are useful when you start. There aren’t many donations and it’s easy to manage the thank you process. The difficulty arises as you grow. Information gets scattered across multiple files and it’s hard to know what is the source of truth? Donations get saved in one spreadsheet. Supporter details get recorded in a different database. Reports need to end up in a Word document, but the latest edits are in someone else’s inbox! Then someone updates a copy! Now you’ve got several different versions, and the same supporter may appear under slightly different names. To finish your report, you need to know how many supporters have given this month and that each donation has been counted just once. The report’s finally finished. But it took all day and depends on you to fit all those pieces together.
What a CRM is
So what is a CRM and how can it help to solve these issues? CRM stands for Customer Relationship Management. For a charity, those relationships might be with donors, volunteers, trusts or the people you support. CRM software offers a central and secure place to store this information. It links contact details, donations and conversations to the people they belong to, giving your team a shared view of each relationship in one place. You still need to check what goes in. For example, Pat Morgan and P. Morgan should only be brought together once you’ve confirmed they’re the same person. Then Pat’s record can show his giving history and thank-you letters sent all on one screen. A colleague can also pick up where you left off. CRM software is accessible to all authorised colleagues via the ‘cloud’, which in this case simply means the Internet. When someone saves an update, the team can automatically see those edits on their laptops, computers, and phones. And, as a CRM has one central database, you no longer need to email spreadsheets! So when Pat phones, you can search for his name to view his donation history, contact details, and activities, not to mention related records. That shared history is the foundation of CRM software. Now let’s explore exactly what it offers to assist your organisation.
Six ways CRM can help
CRMs can help in multiple areas. First is constituent management. Constituents are the people and organisations connected with your charity: supporters, volunteers, staff and others. CRMs link their details and relationships so they’re easy to find and edit. You can add custom fields to match your exact requirements; turning a generic system into something that’s unique to how your organisation works. A fundraising module acts as the financial engine of a CRM, but goes far beyond simply logging income. It tracks the complete journey of a donation, from a supporter’s initial spark of interest to the final bank reconciliation and tax claim. CRMs can also help to manage your appeals and campaigns, grant applications, legacies, and major donor pipelines. Donation processing is usually handled by a CRM and enables you to receive online payments, including recurring gifts. You can often link payments with your finance software or at the very least, export the data easily. In the UK, it can also help to manage Gift Aid declarations and claims for eligible donations. You can add donation forms to your website and offer them as standalone links. Payments are processed securely and the gift and donor details get added into the CRM immediately. Supporter journeys and automation enable you to send emails and other online communications and track responses. For example, a first donation could trigger a thank-you, followed later by a welcome message, once you’ve set up the rules. If you host online or in-person events, then many CRMs offer an Event management module. You can promote and sell event tickets and track attendance, linking the results back to the people involved. But what good is all of this information if you cannot analyse it? Analytics and reporting help you track donors, donations and marketing results. For example, you can get your CRM to compare what an appeal raised with what it cost to calculate your return on investment. And, the best part is, you can generate reports in a fraction of the time than if data was spread over multiple files!
Finding and filtering information
CRMs are flexible enough to store lots of different types of information. But how can you filter that data to find the content that you need? You can use filters or queries to retrieve the data recorded in your CRM, and save them for later use. For example, you can search for gifts made in the current financial year donated via bank transfer. Or find all donors who have given in the past five years but have no incoming contact recorded. Some systems have an AI assistant that you can simply ask for the information you want, and it will build a filter for you. Results usually appear in a spreadsheet-style list, with columns you can sort by. One of the most useful features of a CRM is its ability to search for content quickly. Searching lets you type a constituent’s name or part of a name and see a list of matches. Systems such as Beacon CRM let you combine filters with search to find just the information you need. You can also export information, usually as a CSV or spreadsheet file. Some systems also offer PDF exports.
Dashboards and reporting
Many CRMs offer dashboards: summary screens that bring key figures together, so you can see how your charity is doing. Remember that monthly report from the start? A dashboard could show the total donated and the number of supporters who gave, filtered to last month. Charts help you spot patterns. You could compare income month by month, or see which appeals brought in the most donations. You can also track progress towards a fundraising goal, showing how much you’ve raised and how much is left to go. Share dashboards with authorised colleagues so your team can review progress together and decide what needs attention. Just keep the underlying records up to date: the summary depends on the information recorded.
Recap and next steps
Spreadsheets were a great start to managing your organisation, but CRM software can help your team connect information, manage relationships and see the bigger picture. For help exploring CRM options, costs and a practical migration plan, please contact us through our website.
Screens, names and figures are illustrative. This episode uses animation and AI-generated narration.
