Fundraising dashboard: gifts, donors and campaign goals

A fundraising dashboard shows how much support a nonprofit received, which donors returned, and how far each campaign has progressed toward its goal. The useful version connects those measures to the same gift records and reporting cutoff, so a development director can choose an action and finance can prove the totals.

Define the measures before counting gifts

Use a received-gift basis for this example: gifts received during the calendar year, before processing fees, excluding outstanding pledges and noncash gifts. This is an operating measure; finance must separately reconcile it to the organization's accounting basis and contribution revenue.

Track dollars and donors separately. GivingTuesday's Fundraising Effectiveness Project reports dollars, donors and retention as distinct fundraising measures. A large gift can improve campaign progress without bringing back any donor from the prior year.

Campaign progress = Received gifts assigned to the campaign / Campaign goal

Donor retention = Prior-year donors who also gave this year / Prior-year donors

Count each donor once in retention, even when that donor gives repeatedly. Decide whether a household, company or individual is the reporting unit, then keep that definition across both years. A new donor is someone with no earlier recorded gift; someone absent last year but present in an older year is reactivated, not new.

Start with the gift export

Prairie Learning Alliance is a hypothetical US nonprofit reviewing its completed 2025 campaigns. Its export contains the following received gifts. All amounts are USD, and every row has a different gift ID.

In a real export, also retain payment status, refund references, restriction codes and the settlement batch. Count only the agreed payment statuses, and apply refunds as reversals. Do not infer that a contribution is available for general operations from its campaign name.

Keep cash and noncash categories distinguishable. The IRS Form 990 instructions separately address noncash contributions; mixing donated property with received money would make a cash fundraising view harder to reconcile. The broader nonprofit dashboard connects funding to program spending and operating cash.

Work the campaign results from those rows

The approved goal register supplies the targets below. Sum the gross gift column by campaign, count gift IDs, then divide the amount by its goal. Percentages throughout this example are rounded to one decimal place after calculation.

Spring receipts are 10,000 + 6,000 + 3,000 = 19,000. Fall receipts are 5,000 + 4,000 + 12,000 + 5,000 = 26,000. The combined result is 45,000 / 65,000 = 69.2%; do not average the campaign percentages because the goals differ.

The remaining-goal check is 6,000 + 14,000 = 20,000, which also equals 65,000 minus 45,000. Fall has the larger dollar gap. Whether that requires intervention depends on its campaign calendar and the expected timing of gifts, not just its completion percentage. A tabular dashboard keeps goals, actuals and exceptions on the same row.

Prove the donor count and retention

The prior-year export contains five distinct donors. The table checks each of them against the current gift rows; the contribution column is derived from those rows.

Three of the five prior-year donors returned: retention is 3 / 5 = 60.0%. Current-year donors are D01 through D05, a count of five. D04 and D05 have no earlier gifts in this example's complete history, so they are the two new donors.

The donor bridge is three retained plus two new equals five current donors. Their dollars also reconcile: retained donors gave $25,000, while D04 and D05 gave 12,000 + 3,000 + 5,000 = $20,000. Together they account for the $45,000 gift total. Repeated gifts from D01 and D05 explain why seven gifts do not mean seven donors.

Change one input: a prior donor returns

Hold every original record and campaign goal constant. Add a received Fall gift of $5,000 from D06, who was in the prior-year donor list.

This gift improves retention because D06 belonged to the prior cohort. The same amount from an existing current-year donor would improve campaign dollars while leaving retention unchanged. That distinction tells the director whether the next conversation concerns renewal outreach or gift size.

Reconcile before assigning actions

For the original case, gross gifts less fees equal 45,000 - 900 = $44,100. The settlement report and bank deposits should total $44,100 if every listed gift settled within the period and there are no other adjustments. Any difference needs a list of refunds, unsettled payments or timing items, rather than an unexplained balancing amount.

Keep supporting gift records alongside the operating export. The IRS's written acknowledgment guidance distinguishes cash amounts, descriptions of noncash gifts, and goods or services provided in return. A dashboard total does not replace those records.

The development director owns campaign follow-up; finance owns the reconciliation and the revenue-basis explanation. Put any corrective work into an accountability dashboard with an owner and due date.

Where it goes wrong

• Gift counts used as donor counts. Deduplicate stable donor IDs; names and email addresses can change.
• Mismatched retention periods. Compare complete calendar years here, or equivalent year-to-date windows elsewhere. State the cutoff.
• Pledges added to their payments. Choose a received or committed basis and keep the other measure separate.
• Gross gifts compared directly with net deposits. Show fees and settlement timing in a bridge so the difference is explained.

Do this on your own file in Covirage

Bring a gift export, prior-period donor records and campaign goals: Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See self-service analytics for the supporting approach to working from business files.