The giving tracker
Rees Calder · 22 April 2026 · 6 min read
A 2023 Fidelity Charitable survey asked donors to estimate their total giving for the previous year and then compared the estimates against actual bank and tax records. The median donor was off by 42%. Most overestimated. Some underestimated by a factor of two.
This matters more than it sounds. If you don't know what you gave, you can't know whether it worked. You can't compare year to year. You can't spot the pattern of giving reactively (after a disaster, after a fundraiser, after a guilt trigger) vs. giving deliberately. The gap between what you think you gave and what you actually gave is the gap between a giving strategy and a giving vibe.
A tracker closes that gap. Here's how to build one that takes less than 10 minutes per month.
What to track (and what not to)
Seven fields are enough. More than seven creates friction that kills adoption.
Date. When the donation happened. Day-level precision is fine.
Amount. What you actually gave, in your local currency. If payroll giving, record the gross amount (what the charity received), not the net cost to you.
Recipient. The charity or cause. Full name, not abbreviations.
Channel. How you gave: direct donation, payroll giving, workplace match, sponsorship, GoFundMe, mutual aid, etc. This matters because channels have different overhead profiles and different tax implications.
Trigger. Why you gave this specific time. Options: planned (it was in the budget), reactive (saw something that moved you), social (someone asked), recurring (standing order). Be honest. Most people's trigger mix is 70%+ reactive. Knowing that is the first step to changing it.
Pillar. Which of your giving priorities does this support? If you've set explicit focus areas (global health, local community, climate), tag each donation. If you haven't, the tracker will reveal your implicit priorities, which is equally useful.
Tax status. Did you Gift Aid it (UK) or will you itemise it (US)? Simple yes/no. Over a year, the aggregate answer tells you how much free money you're leaving on the table.
That's seven columns. A spreadsheet, a Notion database, or a notes app with a template. The medium doesn't matter. Consistency does.
What not to track
Don't track volunteering hours here. Volunteering is valuable but it's a different category. Mixing time and money in one tracker creates noise. If you want to track volunteering, use a separate sheet.
Don't track impact per donation. You can't meaningfully assess the impact of individual small donations in real time. Impact assessment is an annual exercise, not a per-transaction one. Trying to calculate "lives saved per line item" will paralyse you.
Don't track your friends' giving. Social comparison is a real motivator but it's a terrible data source. Your tracker is for you.
The monthly ritual
Once per month. 10 minutes. Three steps.
Step one: reconcile. Go through your bank statements for the month. Find every charitable transaction. Enter any that aren't already in the tracker. Most people find 1-3 donations they'd forgotten about.
Step two: tag. Fill in any missing fields. Especially the trigger column. If you can't remember why you gave, that itself is information.
Step three: running total. Add a running total row. Compare against your annual target if you have one. If you don't have an annual target, the running total will naturally prompt you to set one. This is the behavioural design at work: seeing the number creates the goal.
The Psychology of Money author Morgan Housel makes a related point about net worth tracking. The act of writing down a number changes your relationship to the number. It stops being abstract and starts being a thing you manage. The same principle applies to giving.
The annual review (linking to The Tally)
At year end, your tracker produces a dataset. Use it.
Total given. Compare to your target, your income, and last year.
Trigger mix. What percentage was planned vs. reactive? The research on effective giving (GiveWell, Giving What We Can) consistently shows that planned giving is 3-8x more cost-effective per pound than reactive giving, because planned giving goes to evaluated, high-impact charities while reactive giving goes to whatever was in the news.
Pillar distribution. Did your actual giving match your stated priorities? For most people, the answer is no. The tracker makes the gap visible.
Tax efficiency. How much Gift Aid or deduction did you capture? How much did you leave unclaimed? If the answer is "I don't know," that's the thing to fix first.
Cause concentration vs. spread. Did you give to 3 charities or 30? The evidence on concentration (GiveWell's recommendation to give to fewer, higher-impact charities) suggests that 3-5 is usually the sweet spot. More than 10 almost always means you're spreading too thin.
The tools that work
You don't need special software. A Google Sheet with seven columns and a monthly calendar reminder is the highest-reliability option. Spreadsheets don't get acquired, don't change their API, and don't require accounts.
If you want something more structured: the Giving What We Can pledge tracker, the CAF Charities Aid Foundation giving record tool, or the YNAB (You Need A Budget) charity category all work. The key feature is not sophistication but persistence.
The people who successfully track giving for more than a year almost always use the simplest tool available. This matches the broader habit-formation literature (BJ Fogg's "Tiny Habits" research at Stanford, 2019): the easier the behaviour, the more likely it sticks. A spreadsheet with seven columns is easy. An app with 30 fields and integrations is not.
The meta-insight
The point of tracking giving is not to optimise for maximum efficiency. It's to make giving a conscious, deliberate practice rather than a series of impulses.
Impulse giving feels generous and often is. But impulse giving, on average, goes to causes with higher visibility and lower cost-effectiveness. Planned giving, informed by a year of tracking data, goes to causes you've actually evaluated.
The tracker doesn't replace generosity. It gives generosity a memory.
One sentence
Track what you give, why you gave it, and whether it matched your priorities. Ten minutes a month is enough to turn scattered generosity into a system.
Sources used: Fidelity Charitable Giving Report (2023), GiveWell Cost-Effectiveness Research (2024), Giving What We Can pledge tracking data and methodology (2024), CAF UK Giving Report (2024), BJ Fogg Tiny Habits research Stanford Behaviour Design Lab (2019), Morgan Housel The Psychology of Money (Harriman House, 2020), YNAB charitable budgeting category methodology documentation (2024). Full links in the planning doc.