Measure nonprofit marketing ROI from campaign receipts, refunds and direct fundraising costs while preserving donor restrictions. Work through a spreadsheet example, reconcile the cash totals and report mission outcomes alongside the financial result.
Nonprofit marketing ROI compares the financial contribution from campaign receipts with the cost of raising them. Calculate receipts after refunds, subtract the included fundraising costs, and divide by those costs. Keep donor restrictions and mission outcomes beside the ratio so a strong fundraising result does not become a claim about unrestricted cash or program impact.
Decide whether the report is about cash received, contribution revenue recognized or longer-term donor value. The worked example uses cash received for a fixed campaign cohort through a stated cutoff. Unpaid pledges, promised matching gifts and expected renewals stay outside the receipt total until collected.
Keep a separate report for recognized contribution revenue if finance needs it. A payment against an existing pledge should not appear again as newly generated support merely because the bank deposit arrived during another appeal.
The commercial marketing ROI versus ROAS comparison helps distinguish revenue ratios from contribution measures. For a nonprofit, however, retained campaign receipts are not sales profit. Some resources may be restricted to a purpose or period, and program delivery still requires spending after fundraising ends.
Choose a campaign label and credit rule before matching gifts. A gift carrying both an appeal code and an event code needs one approved allocation of credit. Retain unattributed receipts separately. Supplied campaign attribution shows assigned credit, not proof that the appeal caused an otherwise absent gift.
Use anonymous campaign-level aggregates from the donation register, refund report, payment settlement report and general ledger. Do not bring donor names, contact details or individual gift histories into this worksheet. Include these columns:
| Column | Meaning |
|---|---|
| Campaign | Stable appeal label used in both summaries |
| Restriction category | Without donor restrictions or the specific restricted purpose |
| Gross cash receipts | Received gifts before refunds and processing fees |
| Refunds | Returned gifts assigned to the same cohort |
| Processing fees | Fees withheld or paid for receiving those gifts |
| Other direct campaign costs | Creative, mailing, media and assigned fundraising labor |
| Cost funding source | Funds that actually bear the campaign costs |
The IRS Form 990 instructions distinguish net assets with and without donor restrictions and describe fundraising expenses, including allocable overhead. This worksheet is a management view of direct campaign costs; it does not replace the organization's accounting classifications or complete functional-expense allocation.
Keep gross receipts and costs separate even when a payment processor deposits a net amount. Otherwise, the bank deposit can hide a fundraising cost, or the fee can be deducted twice when the settlement report is joined to the ledger.
An illustrative US community nonprofit compares three appeals through September 30, 2026. All matching amounts in the receipt column have actually arrived. The program and matching appeals carry purpose restrictions; the general appeal does not.
| Campaign | Restriction | Receipts (USD) | Refunds (USD) | Processing fees (USD) | Other direct costs (USD) |
|---|---|---|---|---|---|
| General appeal | None | 80,000 | 2,000 | 3,000 | 15,000 |
| Program appeal | Program purpose | 60,000 | 1,000 | 2,000 | 12,000 |
| Matching appeal | Program purpose | 40,000 | 1,000 | 1,000 | 8,000 |
| Total | 180,000 | 4,000 | 6,000 | 35,000 |
Put these headings in row 1, with campaign in A and restriction in B. In Excel, enter the formulas below in G2 through J2 and fill down:
G2 = C2-D2
H2 = E2+F2
I2 = G2-H2
J2 = IF(H2=0,"",I2/H2)
G is net cash receipts after refunds. H is direct campaign cost, including processing fees. I is the financial contribution after those costs. J is the return on the included costs, formatted as a percentage.
| Campaign | Net receipts (USD) | Direct costs (USD) | Contribution after direct costs (USD) | Return on direct costs |
|---|---|---|---|---|
| General appeal | 78,000 | 18,000 | 60,000 | 333.3% |
| Program appeal | 59,000 | 14,000 | 45,000 | 321.4% |
| Matching appeal | 39,000 | 9,000 | 30,000 | 333.3% |
| Total | 176,000 | 41,000 | 135,000 | 329.3% |
Percentages are rounded to one decimal place. The total formula is:
=SUM(I2:I4)/SUM(H2:H4)
That divides $135,000 by $41,000. For a longer classified summary, Microsoft documents SUMIFS for summing values that meet multiple criteria. To sum net receipts by campaign and restriction, use:
=SUMIFS(G2:G100,A2:A100,L2,B2:B100,M2)
L2 holds the campaign and M2 its restriction category. Covirage is not affiliated with Microsoft.
The campaign rows allocate costs for performance measurement. They do not authorize charging those costs against restricted gifts. In this example, the organization pays all $41,000 of fundraising costs from unrestricted funds and has not yet spent any of these receipts on programs.
| Resource category | Net receipts (USD) | Fundraising costs paid (USD) | Remaining resources (USD) |
|---|---|---|---|
| Without donor restrictions | 78,000 | 41,000 | 37,000 |
| With program restrictions | 98,000 | 0 | 98,000 |
| Total | 176,000 | 41,000 | 135,000 |
The restricted receipt total is 59,000 + 39,000 = 98,000. The proof is 180,000 - 4,000 - 6,000 - 35,000 = 135,000, which also equals 37,000 + 98,000. The organization has $135,000 of additional resources after the included fundraising costs, of which $98,000 retains the stated restrictions. Calling the full amount unrestricted surplus would misstate what the table shows.
Reconcile gross receipts and refunds to the donation register, processor settlements to cash received, and campaign costs to the ledger. Keep timing differences in a reconciliation schedule. Finance owns the restriction classification and funding check; development owns appeal coding and the cost allocation proposal.
Add a separate program view with the outcome definition, reporting period, source and accountable owner. Depending on the mission, that might be services completed, participants served or an independently measured change in outcomes. Distinguish activity from outcomes, and do not divide fundraising costs by participants when the relevant program costs are absent.
Use direct marketing ROI for the channel-specific matching workflow and improving marketing ROI for budget changes. An average marketing ROI is a weak comparator when restriction mix, fundraising cost boundaries or donor cohorts differ.
Bring an anonymous campaign summary with receipts, refunds, restriction categories, direct costs and the cost funding source. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for spreadsheet analysis for the supporting workflow.
Include received restricted gifts in a clearly labeled campaign-receipts measure, while keeping the restriction category visible. Do not describe the combined result as unrestricted funding. The finance owner should determine how the gift terms affect permitted spending and how fundraising costs will be funded.
A cash-receipts analysis includes amounts received by its cutoff, with unpaid pledges shown separately. An accounting revenue analysis may use a different recognition basis. Keep those views distinct, and never count a pledge and its later payment as two campaign results.
No. A financial ratio measures resources raised relative to included costs. Mission impact requires program evidence, such as services delivered and changes in outcomes. Show the program measures with their own definitions, periods and sources rather than treating donation dollars as the outcome.