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.

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, and imports directly into Endearist if you want it to live locally on your own device.

Download CSV

Opens in Excel, Google Sheets, Numbers — or imports straight into Endearist.

See all templates →

What each column means

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

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-06-10

When the spreadsheet gets too small.

Endearist imports this CSV directly — and reminds you before contacts go quiet. Free up to 25 contacts.

Start free