A fundraising data checklist for clearer reporting
Improve fundraising reporting with consistent donor records, clear gift and pledge definitions, campaign attribution and a repeatable reconciliation process.
Summary
Reliable reporting starts before a dashboard. Agree on definitions, keep donor and gift records consistent and review exceptions with finance on a regular schedule.
Key takeaways
- Keep gifts, pledges and pledge payments distinct.
- Agree on campaign codes before an appeal launches.
- Resolve duplicate records and reconcile totals before reporting.
Agree on what each number means
A pledge, a received gift and a payment against a pledge describe different events. If one report counts intentions and another counts received payments, their totals will differ even when both are working as designed.
Write down which date drives each report, whether refunds are included and how restricted gifts are identified. Agree on those definitions with finance before publishing a total. This is an operational checklist, not an accounting standard.
Review the fields that affect decisions
Start with a small shared set of fields and validate them consistently. Add fields only when they support a specific decision or workflow.
- Donor identity and a stable internal record identifier.
- Gift amount, currency, received date and payment reference.
- Gift purpose, restriction and acknowledgment status.
- Campaign or appeal code and attribution rule.
- Links between a pledge and its payments, where applicable.
- Refunds, adjustments and duplicate records needing review.
Make reconciliation a routine, not an emergency
Set a review schedule with finance. Compare gift records with the relevant payment and accounting records, then investigate differences rather than changing totals to make them match.
Document corrections, who approved them and how the change affects prior reports. Review a small sample of records as well as headline totals: an accurate total can still hide incorrect attribution.
Protect the information behind the report
Collect what you need, limit access and avoid placing donor details in broadly shared exports. Check recognition and contact preferences before using a report to create an outreach list.
AFP's Donor Bill of Rights provides an ethical reference for confidentiality and the intended use of gifts. Apply your organization's policies and applicable privacy obligations to your own reporting process.[1]
Frequently asked questions
Why do fundraising and finance totals differ?
Common causes include different date ranges, pledge versus cash definitions, refunds, processing fees and delayed payment settlement. Compare definitions and reconcile the underlying records before drawing conclusions.
How should we attribute a gift to a campaign?
Define a consistent attribution rule before launch, assign controlled campaign codes and document exceptions. Avoid assigning the same gift in full to multiple campaigns unless the report explicitly accounts for that overlap.
How often should we clean donor data?
Use a schedule appropriate to your volume and review exceptions as they arise. Checking duplicates and missing fields during entry usually creates less work than waiting until a major appeal.
Sources and further reading
- The Donor Bill of Rights Association of Fundraising Professionals