Thanking and reporting to donors without burning days

Note: general recommendations only, not professional advice. You are responsible for checking before use. For receipts, tax credits and financial reporting, consult an accountant or tax adviser. The full text is at the end.

Who this is for

For a nonprofit director, a development coordinator or a volunteer in charge of donor relations. No technical background needed. You need a donor sheet (Google Sheets or Excel is enough), a Claude or ChatGPT account, and the email or WhatsApp you send from.

The problem in three lines

A thank-you to a donor gets pushed to "the end of the week", and then to the end of the month. When you do write, everyone gets the same email, and the donor who has given for five years feels like a number. And the annual report is written once a year, under pressure, from scratch, with no stories and no data collected along the way.

The method in 7 steps

Step 1: A simple donor segmentation

What to do: Split your donors into four groups. No more. Each group gets different treatment.

How: Add a column called "Group" to the donor sheet:

Three more columns worth adding: "Why they gave" (a program, an event, in memory of someone), "Preferred channel" (email, WhatsApp, phone), and "Last thank-you" (date).

Common mistake: Building ten groups by exact amounts. A month later nobody updates them. Four groups are enough for every donor to feel remembered.

Step 2: A fixed schedule

What to do: Decide in advance when each group hears from you. That way the thank-you doesn't depend on the mood of the week.

How: A schedule we recommend starting from, which you can adjust:

• Within two days of a gift: a receipt, and a short thank-you. For a new donor and a major donor, a personal thank-you.
• Within a week of a major gift: a short phone call. Not an ask, just thanks.
• About six weeks after a first gift: a first update: what happened in the program they gave to.
• Once a quarter: a short update to all donors, with one story and one figure.
• Once a year: an annual report, and a personal annual thank-you to regular donors.

Put the schedule in the calendar as recurring events, with the name of whoever is responsible.

Common mistake: Sending the first update together with a request for another gift. The first update is only an update.

Step 3: Base templates for every group

What to do: Write one template for each type of message, once. From then on, every message is a small adjustment, not writing from scratch.

How: The templates are in the "Templates" section below. Rules for writing them:

• Short. A thank-you email of up to 120 words.
• The donor at the center, not the nonprofit. "Because of you" before "we".
• One concrete detail: what the gift makes possible, in people's words, not report words.
• No further ask in a thank-you message.
• Signed by a real person, with name and role.

Common mistake: Writing "your donation will help us continue our important work". That's true of every nonprofit in the world, so it tells the donor nothing.

Step 4: Personalizing with AI, without putting in sensitive details

What to do: Once a week, go over the new gifts, and give the AI the template plus two or three details about each donor. It returns a draft, and you read and send.

How:

1. Filter the sheet for the past week's gifts.
2. For each donor prepare a short line: first name, group, why they gave, and one thing you know (has given for three years, came to the event).
3. Paste the template and the lines into prompt 2. Don't paste ID numbers, addresses, card details or exact amounts if they aren't needed.
4. Read every draft. Fix whatever doesn't sound like you.
5. Send, and update "Last thank-you" in the sheet.

Common mistake: Letting the AI send on its own, or copying without reading. One wrong name or invented detail is enough to damage a donor's trust.

Step 5: Reporting gathered throughout the year

What to do: Instead of writing the annual report from scratch, gather material every month into one document.

How: Open a document called "Reporting material" with three parts:

• Stories: one short story every month, approved by whoever appears in it. No identifying details without consent.
• Figures: only from your own records: how many participants, how many sessions, how many hours. Next to every figure: where it's from.
• Photos: only ones you have permission to use.

From this document the AI writes a draft of the quarterly update and the annual report (prompts 3 and 4). It doesn't add figures that aren't in the document.

Common mistake: Letting the AI "rephrase" a figure, and getting "hundreds of families" when there were 140. Every number in the report is checked against the records.

Step 6: Receipts and tax

What to do: Make sure every donor gets a correct receipt, on time, and that the wording of the thank-you doesn't contradict it.

How:

• If your nonprofit holds an approval under Section 46 of the Israeli Income Tax Ordinance, donors can get a tax credit on gifts. Mention this on the receipt only in wording the accountant approved.
• Check the requirements for issuing receipts, reporting donations and keeping documents with the nonprofit's accountant. They change from time to time.
• A thank-you is not a receipt. Don't write amounts, receipt numbers or tax commitments in it.
• Gifts from foundations and companies sometimes come with reporting terms. Record them in the sheet next to the donor.

Common mistake: Promising in a thank-you email that "the donation is tax-deductible" without checking that the approval is valid and the gift meets the conditions.

Step 7: Half an hour a week

What to do: Set a fixed weekly slot, and all the work from the previous steps goes into it.

How: A fixed order for the half hour:

1. Five minutes: filter the new gifts and update the group.
2. Fifteen minutes: thank-you drafts with AI, read and send.
3. Five minutes: check the calendar: who needs a first update, who needs a call.
4. Five minutes: one line in the "Reporting material" document.

Common mistake: Waiting for free time. There is no free time in a nonprofit. A fixed half hour in the calendar beats "when I get to it".

Templates

Replace whatever is in square brackets. These are starting points: adapt them to your nonprofit's voice.

Hi [first name],
Thank you so much for your gift to [nonprofit name].
Because of you, [one concrete detail: what the gift makes possible, in simple words].
In a few weeks we'll send you a short update on what actually happened.
[signer name], [role]

Hi [first name],
You've been with us for [number] years now, and we don't take that for granted.
This year, among other things, [one or two details from the year, from "Reporting material"].
We wanted you to know this happened because of you too. Thank you.
[signer name], [role]

1. Introduction: [name], [role] at [nonprofit name].
2. Thanks for the gift to [program or cause].
3. One detail: what the gift makes possible this year.
4. A question: what matters to you to hear from us, and through which channel?
5. Close: thanks, and we'll update you [when].

Hi [first name],
A short update from [nonprofit name] on [quarter or months].
One story: [three or four sentences, approved by whoever appears in it].
In numbers: [one figure from the records].
What's next: [one sentence].
Thank you for being part of this.
[signer name]

Ready-made prompts

Replace whatever is in square brackets. Don't paste ID numbers, addresses or card details.

Here are the column headers in our donor sheet: [headers].
Suggest how to add a "Group" column with four values: new donor, regular donor, major donor (above [amount]), foundations and companies.
Write a Google Sheets formula that fills the column based on the existing columns, and explain each part of the formula in one sentence.

Here is our thank-you template for [group]: [paste template].
Here are this week's donors, one line each: first name, why they gave, one thing we know: [paste].
Write a message for each donor using the template, up to 120 words. Use only the details I gave. Don't invent details, numbers or stories. Don't add a request for a gift.
If a detail is missing to fill the template, leave [to complete].

Here is the quarter's "Reporting material" document: [paste].
Write an update for donors using the template: [paste template]. Choose one story and one figure from the document.
Don't add figures or descriptions that aren't in the document, and don't round numbers. Up to 180 words.

Here is all of this year's "Reporting material": [paste].
Build a draft annual report for donors: a short opening, three stories, the main figures in a table (each figure with its source), what we learned, and what's planned for next year.
Only what appears in the material. Mark every figure without a source as [to check]. Plain language.

I'm calling to thank a donor who gave to [program]. What we know about them: [general details, no sensitive details].
Write me five talking points for a three-minute call: thanks, one detail about what the gift makes possible, and one question. No request for another gift.

Here is a draft email to a donor: [paste].
Check: is the donor at the center, or the nonprofit? Are there generic sentences that would fit any nonprofit? Is there a hidden ask? Is there a number or detail I didn't give you?
Suggest short fixes only.

One-page checklist

Setup (once)

• "Group" column with four values
• "Why they gave", "Preferred channel", "Last thank-you" columns
• Schedule in the calendar, with an owner
• A template for every type of message
• "Reporting material" document
• Receipt wording checked with the accountant

Every week (30 minutes)

• New gifts filtered and given a group
• Thank-you drafts with AI, each one read before sending
• "Last thank-you" updated
• Calls and first updates according to the calendar
• A new line in "Reporting material"

Every quarter and year

• Quarterly update with one story and one figure
• Annual report from the gathered material
• Every number checked against the records
• Reporting to foundations as agreed with them

How you know it's working

Write down your starting point before you begin, and measure from it:

• Time to thank-you: how many days pass on average from a gift to a thank-you. You can calculate it from the sheet.
• Coverage: how many donors got a thank-you and an update on schedule, out of all of them.
• Working time: how much time a week goes on thanks and reporting, compared with before.
• Replies: how many donors reply to your messages. A reply is a sign the message was read.
• Renewal: how many of last year's donors gave again this year. Measured after a year, not after a month.

Disclaimer

This content is general recommendations only, not professional, legal, accounting or tax advice. Every organization is different. You are responsible for checking that it fits your situation, and for checking the data, templates and prompts before use. For receipts, tax credits, donation reporting and document retention, consult a certified accountant or tax adviser. For questions about using donor data and about mailings, consult a lawyer. Outside tools and terms of service change, so check them at the source.