Free template
Donor Tracker Template
Small organizations rarely lose donors through bad work — they lose them through silence between appeals. Someone who only hears from you when you need money starts to feel like an account, not a member of a cause. This template is built for small nonprofits, grassroots groups, and solo fundraisers who don't need an expensive fundraising system yet: per person, it records when and how much they last gave, why this human gives at all, how often you reach out without an ask — and, in its own column, what you should not bring up. That last column is delicate: notes like these don't belong in a freely shared cloud sheet. The CSV works offline in any spreadsheet app. Endearist is being built to keep data like this locally on your own device, but it is not released yet, and whether this CSV imports into it has not been checked.
App file import is planned for v1. Approval of file import would not establish that every column in this website template transfers directly. That mapping has not been verified.
A CSV file with no sign-up. Import the columns as text using the instructions below. Downloading alone does not import anything.
UTF-8 with BOM · comma delimiter · header, fictional example row and one empty row. This CSV contains no formulas or automatic reminders.
What the CSV columns mean
| Column | How to use it | Example |
|---|---|---|
| Donor | One row per person or household — volunteers and small-gift donors belong here too. | Ruth and Allen Marsh |
| Last gift date | ISO date of the most recent gift — sortable, so nobody slides quietly into lapsed status. | 2026-04-14 |
| Last gift amount | The latest amount, with pattern if any ("$50 monthly since 2023") — it calibrates the next appropriate ask. | $250 (annual, year-end appeal) |
| Why they give | Their personal connection to the cause, in their words — the heart of every future conversation. | Their daughter received the scholarship in 2019 |
| Thank-before-ask cadence | How many no-ask touches you owe between two appeals — and which ones. | 3 : 1 — thank-you note, project update, invite |
| Next touchpoint | What happens next, with a date — the column you sort by each week. | 2026-07-03 — send summer-event photos |
| Event attendance | Which events they have attended — showing up is often the most honest signal of interest. | Gala 2025, volunteer day 2026-03 |
| Do not … | Sensitivities and hard limits: no phone calls, recent bereavement, no name in the annual report. Treat as confidential. | Don't bring up the memorial gift unprompted; no phone calls |
Import the CSV as text
Excel: Data → From Text/CSV. Choose UTF-8 and comma, then Transform Data. Disable automatic type detection or remove the Changed Type step. Select every column and set its data type to Text before loading.
Google Sheets: File → Import → Upload. Choose comma and turn off “Convert text to numbers, dates, and formulas” before importing. If that option is missing, use an importer with text-column controls. This uploads the file to Google; you can use Excel for a local file.
How to use this template
- Thank within 48 hours of every gift
The automated receipt is bookkeeping, not gratitude. A personal sentence within two days — by email, card, or call, depending on the do_not column — measurably decides whether someone gives a second time. Log the gift, write the thanks, set the next touchpoint: one motion, three effects.
- Hold the 3-to-1 ratio
Three no-ask touches for every ask: a thank-you, an impact report ("here's what your gift did"), an invitation. The thank_before_ask column makes the ratio visible per person. Hold it, and you can ask with a clear conscience — the appeal becomes the natural fourth beat of a relationship instead of its only content.
- Capture the why after every conversation
At the summer event someone tells you why the cause matters to them — and three months later it's gone. Make it a rule: after every real conversation, one sentence goes into the why_they_give column. Later, thank-you letters and appeals nearly write themselves from those sentences, because they address the person instead of the segment.
- Check the do-not column before every campaign
Before any mail merge or call list goes out: filter the sheet by do_not and review every flagged row by hand. Calling someone who explicitly asked not to be called, or sending a cheerful blast into a bereavement, costs more trust than ten campaigns can build. Five minutes of filtering prevents the worst mistake in fundraising.
- Sort by last gift date monthly
Once a month, sort by last_gift_date and scroll to the bottom: anyone who hasn't given in over a year isn't lost, just unaddressed. A personal note that references this person's why recovers far more than any new-donor campaign — win-back is the most underrated channel in fundraising.
Mistakes to avoid
- Only reaching out when money is needed
The most common pattern in small organizations: silence between two appeals, so every message is effectively an invoice with letterhead. Donors feel it — and drift away without ever saying so. The touchpoint and cadence columns exist for exactly this reason: they force you to schedule gratitude and impact, not just asks.
- Sensitive notes in openly shared sheets
Bereavements, health issues, financial circumstances, "never call" — notes like these are gold for the relationship and poison in a cloud sheet that half the board plus former volunteers can open. That's a data-protection problem, not just a tact problem. Restrict access hard, or keep this column local — for instance in a local-first tool.
- Putting every donor on the same cadence
The monthly major donor and the one-time $20 giver don't need the same rhythm — one deserves personal calls and invitations, the other would find them odd. A one-size cadence smothers some donors and neglects the rest. That's why this template puts the cadence on each row, not on the list.
- Tracking amounts but forgetting reasons
A sheet full of sums and dates tells you who gives — but not why, and therefore not how to thank well or ask again. The why_they_give column is the most important one in this entire template: an appeal that connects to someone's personal story beats any generic campaign, at every gift size.
Frequently asked questions
- How often should I contact donors without asking for money?
- A proven rule of thumb is the 3-to-1 ratio: three no-ask touches — a thank-you, an impact update, an invitation — for every appeal. With four to six contacts a year, that means one or two asks. The exact number matters less than the order: gratitude always comes first, and nobody should ever receive only appeals from you.
- What donor data should a small nonprofit track?
- The minimum: last gift with date and amount, the personal connection to the cause, the next planned touchpoint, and explicit preferences or hard limits. Skip everything you don't need — every extra piece of sensitive information increases your responsibility under privacy law. Eight well-kept columns beat forty half-maintained ones in every respect.
- Is a spreadsheet even compliant for donor data?
- It can be — what matters is access and content, not the file format. It gets risky when sensitive notes sit in a cloud sheet that many people can open and nobody ever prunes. Limit access to those who need it, delete data of lapsed donors who ask, and keep the most delicate notes local rather than shared.
- How is this different from fundraising software?
- Fundraising platforms bundle donation forms, receipts, mail merges, and reporting — worthwhile from a few hundred active donors upward. Below that, they mostly generate maintenance and cost. This tracker covers the core everything else depends on: who gives, why, and when you'll be in touch next. If the organization grows, the CSV simply comes along.
Last updated: 2026-09-30
Endearist is in development.
Join the launch list: one email when it opens. Platforms, plans and capabilities need their own approval; signup creates no app access or purchase.
Join the launch list