November is when a charity data team’s calendar fills up with jobs that come round every year. The Christmas appeal is landing. Finance wants the next Gift Aid claim. Someone needs last year’s performance figures for a board paper, and the targets for 2027 have to be set before January.
None of these jobs is new, and most teams have a way of getting them done. Often that way involves a spreadsheet, a set of steps one person knows by heart, and a few hours that could have gone on something else.
Over the past year we’ve been building small, focused tools for exactly these jobs, and testing them with the charities we work with. Here are four that are now available, starting with one that’s free.
PRISM: how did last year actually go?
Pulling together a clear picture of last year’s fundraising usually means exports, pivot tables and a lot of checking before anyone trusts the numbers. Just when you need those figures most, for planning and reforecasting, is usually when you have the least time to build them.
PRISM is our free reporting tool for working out how your fundraising performed over the last year. It gives you something solid to bring to a planning meeting or a board paper, without starting from a blank spreadsheet.
Because it costs nothing to use, it’s also a good way to see how our tools work before you commit to anything.
Gift Aid Transformer: from donation export to HMRC schedule
Gift Aid is money your charity is entitled to, but claiming it online means getting your donation data into the format HMRC’s Gift Aid Donations Schedule expects. For many finance teams that means exporting from the CRM, reshaping the columns by hand, and checking names, postcodes and dates line by line before anything can be uploaded.
Gift Aid Transformer helps charity finance teams turn their donation exports into that schedule, ready for an online claim. The reshaping is done for you, so the time goes on checking the claim rather than building it.
Data Quality: tidy up before you move or import
Before a CRM migration, a large import or a new reporting project, it pays to know what state your data is in. Duplicates, inconsistent formats and gaps are far easier to sort out before they’re copied somewhere new than after.
The Data Quality app helps you tidy your data before you start, so the new project begins on a cleaner footing. If a system change is in next year’s plans, this is a good one to look at early, while there’s still time to act on what it finds.
Targets: planning for 2027
It’s that time of year again: you’re either in the thick of Christmas or starting to reforecast and plan for 2027, and quite often both at once. Setting targets usually means working back through past years’ income, agreeing assumptions, and rebuilding much the same spreadsheet as last year.
Targets is built for that job. Here’s what one charity fundraiser said about it:
“This is going to save me so much time, and it’s exactly the right moment, because I’m about to start working out [next year’s targets].”
Where to start
You don’t need all four. Most teams have one job that comes round every year and takes longer than anyone would like. Start with whichever tool matches the job taking up most of your time this winter. If you’re not sure, PRISM is free and a gentle first step.
We are also offering early bird and bundle discounts for charities signing up before the end of the year.
If you’d like to find out more get in touch with the ADA team to book a free, no-obligation call. We’re always happy to help you work out where to start.