Donor Management

1. About This Tool

Most small nonprofits manage donor information in spreadsheets that grow organically into chaos. Three-year-old contacts, duplicates, inconsistent address formats, no record of last communication, no segmentation. As the donor base grows past 50-100 contacts, the spreadsheet stops being useful and starts being a liability — you can't find gift history when stewarding a major donor, you miss renewal cycles, you accidentally email someone who opted out.

Enterprise alternatives — Bloomerang, DonorPerfect, Salesforce NPSP, Little Green Light — cost $50-$300+/month and require staff to configure and maintain. For a nonprofit with under 500 donors and a $500K budget, that's overkill.

The Donor Management app is the middle ground: a structured tool with the workflows of a real CRM (donor records, gift tracking, segmentation, stewardship pipelines, reports) without the configuration complexity or monthly subscription. Your data stays in your browser; you own it; you can export it any time.

2. Getting Started

Who this is for

• Executive Directors at organizations without dedicated development staff
• Development Directors at small nonprofits where a full enterprise CRM is overkill
• Founders moving past the "donor list in Excel" stage
• Board treasurers who want visibility into giving patterns
• Volunteer development committees needing a shared view of donor relationships

What you'll need to begin

• Your current donor list (Excel, Google Sheets, exported from another CRM, or hand-collected)
• Historical gift records if available (at least last 12-24 months)
• Any existing donor segmentation (major donors, monthly givers, board, etc.)
• Your gift acceptance policy if one exists
• Privacy notice expectations — what donors were told about data use

How long it takes

Initial donor import: 30-60 min for under 200 donors. Configuration of segments and pipelines: 30 min. Ongoing: 5-15 min per gift; 30-60 min weekly for stewardship and pipeline review.

3. Adding & Managing Donors

Donor record fields

Each donor record captures core contact info plus the relational and giving context:

• Identity: Name (separate first/last), salutation, organization, gender pronouns if disclosed
• Contact: Email, phone, mailing address, social media handles
• Relationship: Source (how acquired), date acquired, relationship owner, household linkage
• Preferences: Communication channel, mail frequency, list opt-outs
• Designation: Donor segment, major donor status, board affiliation, employer matching eligibility
• Notes: Free-text record of interactions, interests, history

Adding donors

1. Single entry — manually add one donor
2. Bulk import — paste a CSV with column headers; automatic field mapping
3. Demo data — load sample donors to practice before importing real data

Maintaining donor records

Records grow stale quickly. Industry data suggests 5-10% of donor contact info changes every year. Build maintenance into your workflow:

• Update contact info immediately when bounces happen
• Review records over 24 months without engagement quarterly
• Honor every opt-out request immediately
• Append notes after every meaningful interaction

4. Recording Gifts

Gift record fields

• Amount · Date · Type (cash/check/online/stock/in-kind/recurring)
• Designation (unrestricted/restricted/capital/memorial/endowment)
• Campaign (annual appeal, event, capital campaign, monthly, major gift, year-end)
• Acknowledgment (status and date) · Tax receipt (status)
• Pledge tracking for multi-year commitments (track installments separately)

Gift acknowledgment best practice

Acknowledge every gift within 48 hours. The IRS requires written acknowledgment for any gift of $250+ for the donor to claim a deduction. Beyond IRS requirements, the speed and quality of acknowledgment is the single most-cited factor in donor retention research.

Recurring gifts

Track as a single donor commitment with individual transaction records. When a recurring gift fails (card expired, bank changed), reach out within 7 days — most failures are technical, not intentional.

5. Reports & Exports

Standard reports

• Donor list — sortable by name, last gift, total lifetime giving
• Gift history — filterable by date range, campaign, designation, segment
• Stewardship status — pending acknowledgments, owed thanks, pending tax receipts
• Pipeline view — active major-gift cultivation by stage
• Lapsed donor list — no gift in last 12/18/24 months
• Top donors — ranked by lifetime, by year, by recency
• Annual giving summary — totals by category for the Annual Report

Exports

• CSV — for Excel/Sheets analysis or import to another tool
• Word (.docx) — acknowledgment letters, board reports, printable donor lists
• PDF — donor stewardship one-pagers

6. Why a Donor CRM Matters

Donor relationships are the single biggest determinant of long-term nonprofit sustainability — bigger than program quality, bigger than board strength, bigger than ED talent. A nonprofit with strong donor relationships survives executive transitions, recessions, and strategic pivots. A nonprofit with weak donor relationships dies the moment its largest funder pulls out.

What a CRM enables

• Continuity through staff turnover: donor knowledge stays with the organization, not the individual
• Personalized stewardship at scale: a 200-donor base is too large to remember everything
• Renewal discipline: most donors lapse not because they're dissatisfied but because no one asked them at the right moment
• Major gift cultivation: cultivation cycles span 12-36 months; without tracking, gifts get lost in the cracks
• Data-driven appeals: knowing who gives when and at what level lets you target campaigns instead of mass-emailing
• Board engagement: a board treasurer with visibility into giving trends provides better oversight

What happens without one

• Donor data lives in the development director's head, the ED's email, and 4 different spreadsheets
• 50%+ of donors lapse without ever being asked to renew
• Stewardship is reactive (thank only when reminded), not systematic
• Major gift opportunities die because cultivation conversations weren't tracked
• Tax acknowledgments are sent late or not at all, exposing the organization
• When the development director leaves, institutional donor knowledge walks out the door

7. What Donor Data to Capture

More data isn't always better. Capture what you'll actually use.

Essential (capture for every donor)

• Full name (separate first/last for proper salutations)
• Preferred salutation
• Mailing address (if you send physical mail)
• Email · Phone
• How they were acquired (source) · Date first added
• Communication preferences (channel and frequency)

Useful (capture when relevant)

• Spouse/partner name (if you address mail jointly)
• Employer (for matching gift eligibility)
• Profession (for ask sizing)
• Birthday or anniversary (for relationship touches)
• Connection to organization (alumni, parent of beneficiary, beneficiary, volunteer)

Major donor specific

• Cultivation stage (Identification / Cultivation / Solicitation / Stewardship)
• Relationship owner (who at the org owns this relationship)
• Wealth indicators (foundation directorships, business ownership)
• Connections (who introduced; who else they know)
• Programs of interest · Capacity estimate

Don't capture unless legally required or specifically requested

• Social Security numbers · Credit card details (use a processor)
• Race/ethnicity unless donor explicitly volunteered for a specific program purpose
• Detailed health information · Political or religious affiliation

8. Donor Segments & Pipelines

Common segments

Major gift cultivation pipeline

1. Identification: prospect identified through research, referral, or pattern
2. Cultivation: building relationship through engagement before any ask (6-18 months)
3. Solicitation: the ask itself, ideally in person, ideally by someone with peer relationship
4. Stewardship: post-gift relationship maintenance; sets up the next gift conversation

Most major gift losses happen because donors get stuck in Cultivation (never asked) or rushed straight from Identification to Solicitation (asked too soon). The pipeline view surfaces stuck prospects.

9. Stewardship Best Practices

Stewardship is everything you do between gifts to maintain the relationship. Most donor lapse research shows the lapse trigger isn't dissatisfaction — it's that the donor never heard from you between gifts.

The minimum cadence

• Gift acknowledgment — within 48 hours of receipt
• Tax receipt — by January 31 for prior year gifts $250+
• Year-end donor letter or annual report — once per year, customized to giving level
• Mid-year touch — non-asking impact update (story, outcome, photo)
• Renewal ask — aligned to giving anniversary or year-end

For major donors, add

• Quarterly personal touchpoints with no ask
• Site visits or program observations 1-2x per year
• Custom impact reports showing how their specific gift was used
• Invitations to small leadership events
• Personal involvement from ED or Board Chair

Stewardship documentation in the CRM

Every meaningful interaction should be logged: date, channel, summary, follow-up needed. Creates institutional memory.

10. Major Gifts Cultivation Cycle

Major gifts (top 5-20% of donors by capacity) generate most of your revenue. They also require the most relational discipline.

Phase 1 — Identification (1-2 months)

• Giving pattern analysis (5+ years; recent upward trend; capacity exceeded current giving)
• Referrals from board members or current major donors
• Wealth screening tools (DonorSearch, iWave) for larger orgs
• Public records (foundation directorships, recent business sales)
• Community connections (alumni networks, professional associations)

Phase 2 — Cultivation (6-18 months)

• Plan a series of engagements appropriate to interest level
• Small-group events (briefings, behind-the-scenes tours)
• One-on-one meetings with ED or Board Chair
• Custom impact reporting on issues the prospect cares about
• Strategic asks: advisory role, peer introductions, expertise requests (before money)

Phase 3 — Solicitation (single event, well-prepared)

• In person whenever possible
• By a peer or someone with the right relationship
• Specific ask amount based on capacity and engagement
• Specific purpose, specific timeline
• Avoid vague "consider supporting us"

Phase 4 — Stewardship (immediate + ongoing)

• Personal thank-you within 24 hours (separate from formal acknowledgment)
• Custom impact report on use of the gift within 90 days
• Continued engagement (events, updates, peer introductions)
• Re-cultivation cycle begins for the next gift

11. Data Hygiene Discipline

CRM data degrades constantly. Without active hygiene, even well-set-up systems become useless within 2-3 years.

Daily/weekly hygiene

• Process bounces immediately (don't leave invalid emails in the system)
• Update contact info when notified of changes
• Honor every opt-out the same day
• Log interactions while they're fresh

Monthly hygiene

• Process pending acknowledgments (none over 14 days old)
• Review recurring gift failures
• Run duplicate detection (merge as appropriate)
• Update stewardship records for major donors

Quarterly hygiene

• Review records over 24 months without engagement: re-engage or mark inactive
• Verify mailing addresses for major donors (USPS NCOA service)
• Run pipeline review — surface stuck major gift prospects
• Reconcile gift records against accounting system

Annual hygiene

• Full duplicate detection and merge
• Honor communications-preferences changes
• Archive deceased donors (with respect — don't continue mailing)
• Renew data backup procedures

12. Donor Privacy & Data Protection

Donor data is sensitive personal information. Mishandling creates legal exposure, reputational risk, and donor trust erosion.

Legal frameworks that may apply

• CCPA (California): applies if you have California donors and meet revenue thresholds
• GDPR: applies if you have European donors
• State breach notification laws: all 50 states have requirements
• PCI DSS: applies if you handle credit card data directly (use a payment processor)
• FERPA: if donors are students or include student information

Operational privacy practices

• Privacy notice: give donors a written notice at the point of collection
• Honor opt-outs immediately: a "do not contact" request applies the same day, all channels
• Limit access: only people who need donor data should have it
• Don't share/sell: never sell, rent, or trade donor lists without explicit consent
• Acknowledgment confidentiality: don't publicize names without permission
• Data minimization: don't capture fields you don't need
• Secure storage: don't store credit cards; use processors; restrict access to sensitive fields
• Breach response plan: written procedures for what happens if data is compromised

13. Common Pitfalls

Treating the CRM as a contact list

A CRM with just contact info plus gift history misses the relational dimension. Without notes on conversations, stewardship history, cultivation stage, and relationship owner, the CRM is just a fancy spreadsheet.

Inconsistent data entry

Two people entering donors differently produces a CRM where searches don't return everything. Adopt simple standards: name format, address format, source conventions. Document them. Train new users.

Acknowledgments at scale, not personalized

Form letters for small donors are fine. Form letters for major donors are insulting. Tier the acknowledgment process: form for under $250, semi-customized for $250-$1,000, personally signed for over $1,000.

No designated relationship owner

For major donors, "everyone's responsibility" means no one's responsibility. Assign each major donor a specific relationship owner (ED, Board Chair, Development Director). Track it in the CRM.

Tax acknowledgment failures

IRS-compliant tax acknowledgment letters require specific language: amount, date, whether goods or services were received. Missing language can disqualify the donor's deduction. Use a template; don't free-form these.

Treating recurring gift failures as cancellations

Most recurring gift failures are technical (card expired, billing address changed), not intentional. Reach out within 7 days, fix the technical issue, retain the donor.

Letting opt-outs slip

A donor who opts out and then receives another mailing is gone forever — and may complain publicly. Honor opt-outs immediately, all channels. Audit periodically.

Skipping stewardship between gifts

If the donor only hears from you when you want money, you've trained them to expect that. Mid-year impact updates with no ask, anniversary notes, occasional personal outreach — these build the relationship that makes the next ask easier.

Administrator Access

The Donor Management app supports an Administrator role with elevated permissions for managing user accounts and application data.

First-Time Setup

From the sign-in screen, click Administrator Access in the side links. On first use, set an admin password. Stored as a hash in your browser's local storage.

Subsequent Sign-In

After setup, the Administrator Access link prompts for the password and grants administrative permissions.

Forgot the Admin Password?

The password is browser-local and cannot be recovered. Use Reset All Data on the Admin Settings page. Export work first.

Contact & Support

This Donor Management app is part of Build Your Club Academy — a growing library of self-service apps for small nonprofit organizations.

The Fundraising & Development Suite

This app pairs with three others as part of the Fundraising & Development Suite ($149 lifetime, all 4 apps):

• Fundraising & Development — annual plan, campaign management, board fundraising training
• Grant Writing — grant pipeline, LOI and proposal templates, funder research
• Annual Report — build the annual report donors expect; integrates donor data from this app

Related Build Your Club tools

• Document Retention & Security Policy Generator — produces the Privacy Notice and Data Breach Response Plan referenced in donor privacy practices
• Nonprofit Employment & HR Policy Generator — relevant if you have paid development staff
• Risk Management & Insurance Audit — cyber liability coverage protects against donor data breaches
• Form 990 Preparation Assistant — donor data feeds Schedule B and Schedule M reporting
• All Build Your Club apps

Questions, suggestions, bug reports

Reach us through the contact form on buildyourclubacademy.org.

Important disclaimers

This tool helps organize donor information and gift records. It is not legal, tax, or financial advice. Tax acknowledgment requirements, privacy law compliance, and IRS reporting obligations should be confirmed with a qualified CPA or attorney.

↑ Back to top