A new nonprofit donor database needs only a short list of fields: who the person is, what they gave and when, where the gift came from, how they agreed to be contacted, and which program or grant the money supports. Capture those well from the first gift and almost everything else can wait. The cost of getting this wrong is rarely felt in year one. It shows up two or three years later, when you try to move to a CRM and find the data cannot be trusted.
This guide is a practical checklist. It covers what to record early, the basic IRS records a US charity should be able to produce, how to keep data clean, and what to postpone.
This is general information, not legal or tax advice. The IRS rules here are US federal rules for charities. Check with your accountant or attorney for your situation.
Why the first year of data matters most
Early records set the pattern for everything that follows. Whatever you type in the first 100 rows becomes the template for the next 10,000.
If gifts are entered in free text, with a different spelling of each donor and no note of where the money came from, you can still count the total raised. You cannot answer the questions a board, a funder or an auditor will ask later: how many people gave twice, which campaign worked, how much of a grant has been spent.
You do not need a large system to avoid this. A spreadsheet with disciplined columns is a better start than a CRM with sloppy data. For help deciding which kind of tool fits your stage, see our comparison of nonprofit CRM options.
The short list: fields worth capturing from day one
Think of your records in five groups. Each one answers a question you will be asked eventually.
1. The person or organization
- A unique ID for each donor that never changes and is never reused
- Name, entered the same way every time (see the cleanliness section below)
- Whether the donor is an individual, a household, a business, a foundation or a government body
- A mailing address and an email address
- A "date first added" and a "how did we first meet them" note (event, website, referral, board member)
Avoid collecting more personal detail than you need. Date of birth, income or health details are almost never needed for a donor record. The less sensitive data you hold, the less you have to protect.
2. The gift
- Date the gift was received (not just the date you entered it)
- Amount
- Payment method (card, check, cash, bank transfer, stock, other)
- Whether it is a one-time gift, a pledge or a recurring gift
- The source of the gift: the campaign, appeal, event, online form or person who led to it
- Whether the donor received anything in return, and its good-faith value (see the IRS section)
- A flag for restricted gifts and a note of the restriction
- Whether it was a refund, failed payment or reversal, recorded separately from real gifts
- Who gave it if someone else gets credit, such as a donor-advised fund, employer match or a person who solicited it
If you only add one field beyond the obvious ones, make it the source. It is the hardest thing to rebuild afterward, because nobody remembers six months later why a check arrived.
3. Consent and communication preferences
- Whether the person agreed to receive fundraising emails, and when and how they agreed
- Whether they have unsubscribed, and the date
- Preferred channel (email, mail, phone) and anything they asked you not to send
- Whether they want recognition or prefer to give anonymously
US commercial email falls under the CAN-SPAM Act, which requires you to honor an opt-out request within 10 business days. (FTC: CAN-SPAM compliance guide, checked November 2026) The FTC's guide defines covered messages by their primary purpose, so whether a given nonprofit email counts as commercial is a question for your attorney. Whatever the answer, recording who opted out and honoring it promptly is simple good practice. Text messaging and recipients outside the US are governed by other rules, so ask for advice before you launch those channels.
4. Program and outcome basics
Not every nonprofit needs a program record on day one, but most funders will eventually ask who you served and what changed. Capture the minimum:
- A program or service name from a short, fixed list
- Dates a person or group took part
- A count of people served per program, per period
- One or two outcome measures you actually intend to report, decided in advance
Be careful about linking identifiable people to sensitive services in a donor tool. If you serve people whose information is confidential, keep that data in a system with proper access controls, separate from the fundraising list.
5. Grants
If you take grants, even one, track:
- Funder, grant name and the ID a funder assigns, if any
- Amount requested, amount awarded and the dates of the award period
- Whether the money is restricted, and to what
- Reporting deadlines and what each report must contain
- Payments received and dates
Giving every grant a clear record from the start makes the later question of what has been spent much easier. We cover this in more detail in grant tracking in Salesforce.
What the IRS expects you to be able to show
For US charities, a few record rules are worth designing around from the start.
Acknowledging larger gifts. A donor who deducts a single gift of $250 or more needs a written acknowledgment from the charity. It must state the amount of a cash gift, and whether the charity provided any goods or services in return, with a good-faith estimate of their value if it did. (IRS: Substantiating charitable contributions, checked November 2026) The donor is responsible for getting it, but your records are what let you produce it.
The $75 disclosure. If a donor pays more than $75 and receives goods or services, such as a dinner or a gala ticket, the charity must give a written disclosure. It states that the deductible amount is limited to the excess over the value of what the donor received, with a good-faith estimate of that value. The IRS lists a penalty of $10 per contribution, capped at $5,000 per fundraising event or mailing, unless there was reasonable cause. (IRS: Substantiating charitable contributions, checked November 2026) This is the reason a "value received" field belongs on your gift record from the first event.
General recordkeeping. The IRS says exempt organizations must keep records that support the entries on their returns, including items like deposit slips, receipts and grant documents. The general minimum is three years from the later of the return's due date or filing date, and other laws or your own policies can require longer. (IRS: Recordkeeping requirements for exempt organizations, checked November 2026) In practice, that means keeping gift records and the documents behind them, and not deleting them when you tidy up.
If you want to automate the acknowledgments, our guide to automating donor tax receipts covers the wording and the common pitfalls.
Keeping the data clean from the start
Clean data is mostly habit, not technology. Five habits do most of the work.
- One record per person. Search before you add. If someone gives by card online and by check at an event, they are still one donor.
- Consistent naming. Pick a format for names, organizations and addresses, write it down, and follow it. Decide now whether a couple is one household record or two people.
- Fixed lists, not free text. Use a drop-down list for payment method, campaign, program and gift type. Free text produces five spellings of the same thing.
- Record the source on every gift. No gift is saved without one.
- Never overwrite history. If a donor changes address or name, keep a note of the change instead of silently replacing it. Record a refund as a refund, not by deleting the gift.
Also assign one person to own the data. Without an owner, rules fade within months.
What can wait
Many nonprofits lose time building for a future that has not arrived. These can safely be postponed:
- Wealth screening and giving-capacity scores. You need a donor base before you can prioritize it.
- Detailed relationship maps between donors, boards and companies.
- Complex household and soft-credit rules. Start with a simple rule and refine it when you have real cases.
- Elaborate lifecycle stages and automations. Learn what your supporters actually do first.
- A large custom field set. Every extra field is something to maintain and explain. Add a field when someone has a question it would answer.
- Historical gifts from years ago in full detail. Total by year for old records if the detail is unreliable, and import clean detail from the date you started doing it properly.
- Case-level program data unless a funder requires it.
A useful test is to ask who will read the field and what decision it informs. If nobody can answer, wait.
How this choice affects a later move to a CRM
Most organizations move from a spreadsheet or a basic donation tool to a CRM at some point. The move is straightforward when the data is tidy and painful when it is not.
What makes a migration easier:
- Unique IDs. They let you match records between the old and new systems.
- Clean, separate fields for first name, last name, address parts and so on, instead of one combined cell.
- Source and campaign values that match a fixed list, which map directly to CRM fields.
- Dates in a consistent format.
- A clear difference between a gift, a pledge and a refund.
- Recorded consent and unsubscribes, so that you do not message people who already opted out.
What makes it harder: duplicate people, mixed spellings, notes stuffed into the amount column, and gifts with no source. Most of the time spent on migrations goes into cleaning, not importing.
If you may land on Salesforce, it helps to know the vocabulary. In NPSP, which is still supported, a gift is an Opportunity tied to a Contact and a household. In Agentforce Nonprofit (formerly Nonprofit Cloud), gifts are recorded as Gift Transactions under Gift Commitments. Either way, a gift needs a donor, a date, an amount and a source. For the basics of how Salesforce handles gifts, see our overview of Salesforce donation management.
Frequently asked questions
What is the minimum I should track for each donor?
A unique ID, a name entered consistently, contact details, and for each gift the date, amount, payment method and source. Add consent status for anyone you email.
Do I need a CRM from the beginning?
Not necessarily. A well-structured spreadsheet or a donation platform works for a small organization, provided the columns follow the rules above. A CRM becomes worth it when your volume, your number of staff or your reporting needs outgrow it.
How long should I keep donor and gift records?
The IRS general minimum for records that support a return is three years from the later of the due date or filing date, and other laws or your policy can require longer. Ask your accountant what applies to you, and write a retention policy.
Should I record gifts that come through a donor-advised fund or employer match?
Yes. Record who actually made the payment, and keep a link to the person who advised the gift or whose employer matched it. That keeps the thank-you and the totals accurate.
Does this apply outside the US?
The IRS and CAN-SPAM points are US rules. The data habits apply anywhere, but other countries have their own receipt, retention and privacy requirements.
Set up your data so it carries forward
If you are planning a move to Salesforce, or already use it and suspect the data has drifted, we can review your fields, duplicates and gift records and tell you what to fix first. Book a free Salesforce health check.