How to Set Up a Simple Donor Database (No Expensive Software Needed)

Short answer: a well-kept record of your donors is one of the most powerful and least glamorous tools a charity can own, and it does not need expensive software - a single, tidy spreadsheet will do. What matters is not the system but the habit: writing down who gave, what they gave, and when you last spoke, and keeping it clean enough to trust. Do that, and you can thank people quickly, ask them thoughtfully, and make every supporter feel remembered. This is a friendly, practical guide to setting up a simple donor database and looking after it, so that the eighty kind people who answered your last appeal are never again scattered across a bank statement, an old email, and a scrap of paper by the kettle.

Why good records beat fancy software

It is tempting to think good donor management is about buying the right system, but the truth is simpler and cheaper: what matters is not the software but the habit of writing things down and keeping them tidy. A charity with a humble, well-kept spreadsheet that everyone updates will run rings around one that bought an expensive database and never filled it in. Your records are your memory, and a charity that remembers its supporters - who they are, what they gave, when you last spoke - can thank them properly, ask them thoughtfully, and make them feel known. So take the pressure off: you do not need to buy anything to begin. A single spreadsheet, one row per donor and a column for each thing worth remembering, is a completely respectable database, and it is how many charities run happily for years. Give it one clear home in a shared, backed-up drive so a lost laptop never means a lost list, and resist the urge to make it clever - just clean columns and honest rows anyone could understand in a minute. When you outgrow it you will know, because moving clean data into a proper system is easy while rescuing a mess is not. Start plainly, and start today.

The fields worth tracking

The heart of your database is the columns you choose, so pick them with thought. At the very least you want each person's name and how to reach them, a note of how and when they have given, and the amounts, so you can see their history at a glance. Add a column for their contact preferences - how they are happy to hear from you, and whether they have consented to be contacted at all - because this both respects them and keeps you on the right side of the rules. Then leave yourself a notes column, because that humble field is where the gold lives: the walk they did, the person they lost to the cause, the reason they first gave. Do not go overboard. A database with fifty columns nobody fills in is worse than one with eight that are always current, so track only what you will genuinely use to thank people and to ask them well, and leave the rest.

Keep it clean from the very first row

A database is only as good as it is trustworthy, and nothing erodes trust like a messy list - so keep it clean from the very first row, because bad habits are far harder to fix later than to avoid now. Agree one format for everything - how you write dates, record amounts, and enter a name - and stick to it, so the whole team enters data the same way. Never let the same person creep in twice: check before you add someone new, and merge duplicates the moment you spot them. When something changes, a new address or surname, update the existing row rather than piling a fresh one on top. And fix errors the instant you see them, because a wrong email caught today is a thank-you delivered next month. A clean list is a calm list, and a calm list is one you will actually trust and use.

Look after people's data

When you keep records of real people, you take on a real responsibility, so handle their information with the care you would want for your own. The simplest rule is to hold only what you genuinely need, because every extra detail is one more thing to protect and one more thing that could go wrong. Keep the file secure: limit who can open it, use a password, and never email the whole list around casually. Honour the consent people gave you - if someone agreed to hear about your newsletter but not your phone appeals, your records should say so and you should respect it. Make it easy for anyone to see what you hold about them, to correct it, or to be removed entirely. Data-protection rules vary from place to place and change over time, so learn the ones that apply to you; but the spirit is always the same - treat people's information as something they have trusted you with, not something you own.

Record every gift and every conversation while it is fresh

A database earns its keep when it is current, and the secret is recording things while they are fresh. When a gift arrives, log it the same day if you can - the amount, the date, and how it came in - before it slips your mind and vanishes into a bank statement. Just as valuable, note your conversations: if a donor calls, emails, or stops you at an event, jot down what was said, so the next person who speaks to them picks up where you left off rather than starting cold. This is what turns a list of names into a living relationship, because a supporter who mentioned last spring that they were retiring should not be asked, a year later, as though you never spoke. It takes a few seconds in the moment and saves you awkwardness and lost opportunities down the line. Make same-day recording a gentle habit, and your database will always tell you the truth.

Use it to say thank you, fast

Here is where all that tidy record-keeping pays off: in the simple, powerful act of saying thank you quickly and personally. A donor who is thanked promptly and warmly is far more likely to give again than one who hears nothing, and your database is what makes fast, personal thanks possible even when you are busy. The moment a gift is logged, let it prompt a thank-you - ideally within days - that uses the person's name and, where you can, refers to what their gift will do. Then record that you thanked them, so nobody double-thanks or, worse, forgets entirely. This is not about grand gestures; a warm, timely, human note beats a lavish one that arrives three months late. Your records let you do this reliably, for every giver, and that quiet consistency is exactly what underwrites donor retention and turns a one-time donor into a lasting supporter.

Segment gently, and win back those who drifted away

Once your records are in good shape, they let you treat different supporters differently, in the best sense. This is called segmenting: grouping your donors so that what you say to each group actually fits them. A first-time giver needs a warm welcome, not an urgent appeal. A faithful monthly supporter deserves to be thanked and updated, not pestered as though you have forgotten them. Someone who once gave a large gift merits a personal call rather than a mass email. A single column marking whether someone is new, regular, major, or lapsed lets you sort your list and speak to each group appropriately. That same column is how you find the supporters who gave once or twice and then quietly drifted away. Most lapsed donors did not fall out with you - life simply moved on - and many would happily give again if you reached out warmly, reminded them why they cared, and showed them the good their past support achieved. Winning back a lapsed friend is very often easier and cheaper than finding a brand-new one, and it starts with simply knowing who they are and when they last gave.

Simple habits that keep it alive

A donor database is not a thing you build once; it is a thing you keep, and the difference between a treasure and a graveyard is a few small habits. Update it as you go, in the moment, rather than promising yourself a big catch-up that never comes. Set aside a little time each month to tidy it - scan for duplicates, fix anything odd, and add what has slipped through. Decide who owns it, one person who makes sure it stays healthy, because a database that is everyone's job is quickly nobody's. And back it up, so a spilt coffee or a failed laptop is a shrug rather than a disaster. None of this is hard; it is just consistent, and consistency is the whole game. There is something rather lovely hidden in this administrative-sounding advice: keeping good records is, at heart, an act of respect - every row is a real person who chose to trust you - and it is within reach of the very smallest charity, starting this week.

Frequently asked questions