ColurianCOLURIAN
← All articles

Nonprofit CRM: what to track for donors, grants and volunteers

A practical guide for small nonprofits: the donor, grant, program and volunteer records worth keeping, the reports boards ask for, and what to automate first.

Colurian team · · 4 min read
nonprofitfundraising

Small nonprofits often run on a patchwork: a donation platform's export, a grants spreadsheet, a volunteer sign-up tool, and an executive director who remembers who gave what. It holds together until the year-end appeal, a grant report deadline, or a board member asking, "How many of last year's donors gave again?"

This guide covers what a small nonprofit should track, the reports that matter, and the automations that save the most time.

What to track

Donors and gifts

Every donor is a contact (or an organization, for foundations and companies), and every gift is its own record: date, amount, payment method, fund, campaign or appeal, and whether the donor received anything in return. From the gift history you can work out each donor's status:

  • New: first gift this year
  • Retained: gave last year and again this year
  • LYBUNT: gave last year but unfortunately not this year
  • SYBUNT: gave some year but unfortunately not this year

LYBUNT and SYBUNT lists are the most valuable fundraising lists you have. These people already said yes once.

Pledges and recurring gifts

Track commitments separately from payments: the pledge or monthly gift is the promise, each payment is a gift. That way you can see what's still owed and spot a failed recurring payment the day it happens.

Funds and soft credits

Record which fund or restriction each gift supports, so restricted money is never reported as general support. Use soft credits to recognize the board member who brought in a donor or the spouse on a joint gift, without double-counting the money.

Grants

One record per grant: funder, amount, dates, status (prospect, applied, awarded, declined) and, most importantly, the deliverables: interim and final reports, budgets and site visits, each with a due date and an owner.

Programs and the people you serve

Programs, enrollments and service deliveries let you report outcomes (people served, sessions delivered) straight from your records instead of rebuilding the numbers for every grant report.

Volunteers

Shifts and hours, linked to the volunteer's contact record. Logged hours can be valued for reports and grant applications, and a volunteer who also gives is a supporter to treat as one person, not two.

Memberships, events and registrations

Membership levels and renewal dates, event registrations and attendance, and the state charitable registrations many states require before you solicit donations there.

Get acknowledgments right

For any single contribution of $250 or more, a donor needs a written acknowledgment from you to claim the deduction. It must state the amount (or describe non-cash property) and whether you provided any goods or services in return, with a good-faith estimate of their value if you did. If a donor pays more than $75 and receives something in return, like a gala ticket, you also owe them a disclosure of the deductible portion.

Generating these from your gift records, with the right wording for each case, is one of the clearest time savings a CRM gives a small team.

Automate these first

  1. Thank-you tasks and emails. A thank-you within 48 hours of every gift, and a call task for first-time and major donors.
  2. Acknowledgments. Send the right acknowledgment automatically when a qualifying gift is recorded.
  3. Failed recurring payments. Create a task to reach out the same week, before the donor lapses.
  4. Grant deliverable reminders. Tasks 30 and 7 days before each report is due.
  5. LYBUNT outreach. A list, refreshed automatically, of last year's donors who haven't given yet, ahead of your year-end appeal.

Reports the board will ask for

  • Donor retention: retained donors as a share of last year's donors
  • Giving by fund and campaign, restricted and unrestricted
  • Pipeline of grants and upcoming deliverables
  • Program outcomes: people served and services delivered
  • Volunteer hours and their value
  • LYBUNT and SYBUNT totals with last gift amounts

How Colurian handles it

Colurian ships a Nonprofit edition you switch on from Setup. It adds Gifts, Gift Commitments, Funds, Soft Credits, Grants, Grant Deliverables, Programs, Program Enrollments, Service Deliveries, Volunteer Shifts, Volunteer Hours, Memberships, Event Registrations and State Registrations. Donor status (New, Retained, LYBUNT, SYBUNT) and membership status roll up onto contacts and accounts, and appeal and event results roll up onto campaigns.

It includes IRS-ready gift acknowledgments and automations for recurring gifts, failed payments, thank-you calls and deadlines, shipped switched off so you can review them first. Sales objects a nonprofit doesn't use, like leads, products and price books, are hidden. It's the full CRM underneath at $39 per user per month.

A first month that works

  1. Turn on the Nonprofit edition and set up your funds and campaigns.
  2. Import donors, then at least two years of gift history so donor status is accurate.
  3. Add active grants with their deliverables.
  4. Review and switch on the thank-you, acknowledgment and failed-payment automations.
  5. Pull your first LYBUNT list and build the year-end appeal from it.

Book a 30-minute demo and bring a donation export. We'll show you your own retention numbers on the call.