A fundraising total can tell you that revenue changed. It cannot tell you whether the change came from broader donor participation, stronger existing relationships, one exceptional gift, or preventable donor loss.
A fundraising revenue variance analysis solves that problem by reconciling the difference between two comparable periods into mutually exclusive donor movements. The most useful version is a revenue driver bridge: start with prior-period revenue, add or subtract the contribution from new, reactivated, retained, and lapsed donors, and arrive exactly at current-period revenue.
The word exactly matters. If the bridge does not add back to the reported total, it is commentary, not reconciliation.
What is a fundraising revenue driver bridge?
A fundraising revenue driver bridge is a report that explains the change in fundraising revenue between two periods by assigning every donor to one movement state. It shows not only whether revenue rose or fell, but which donor behaviors created that movement.
Use these six states:
- New: gave in the current period and had never given before the start of that period.
- Reactivated: gave in the current period, did not give in the comparison period, but gave before it.
- Retained, increased: gave in both periods and contributed more in the current period.
- Retained, stable: gave in both periods and contributed the same amount, or remained within a documented tolerance.
- Retained, decreased: gave in both periods and contributed less in the current period.
- Lapsed: gave in the comparison period but not in the current period.
These states are mutually exclusive. A donor can appear in only one state for a given comparison. That rule keeps the bridge auditable and prevents the same dollar from being described as both “new donor growth” and “channel growth.”
Start with a comparison that deserves an explanation
Before calculating drivers, make the two totals comparable. Define:
- the exact start and end dates for both periods;
- whether the analysis uses cash received, booked gifts, or another revenue basis;
- which campaigns, designations, entities, and gift types are included;
- how refunds, chargebacks, soft credits, matching gifts, and reversals are treated;
- whether anonymous, householded, and unmatched gifts can be tied to a stable donor identity; and
- whether an unusual event or appeal shifted between the two periods.
This scope belongs at the top of the report. If one period includes a gala and the other does not, or one total is cash while the other includes open pledges, the bridge will produce a mathematically correct answer to the wrong question.
For a stronger release process, use a fundraising report preflight checklist before sharing the comparison. If late refunds or reclassifications are still changing prior results, reconcile them through a gift adjustment audit first.
How to calculate the revenue bridge
Build one donor-period table with prior-period revenue and current-period revenue. Then assign the donor state and calculate the contribution to the variance.
| Donor state | Bridge contribution |
|---|---|
| New | Current-period revenue |
| Reactivated | Current-period revenue |
| Retained, increased | Current revenue minus prior revenue |
| Retained, stable | Current revenue minus prior revenue, normally zero or immaterial |
| Retained, decreased | Current revenue minus prior revenue, shown as a negative amount |
| Lapsed | Prior-period revenue multiplied by negative one |
The control formula is:
Prior-period revenue + sum of all bridge contributions = current-period revenue
If the formula does not balance, investigate unmatched identities, scope differences, duplicate records, currency treatment, or gift adjustments before interpreting the drivers.
A worked fundraising revenue variance example
Suppose a nonprofit compares the same year-to-date window in two years. Fundraising revenue increased from $500,000 to $545,000, a gain of $45,000. The bridge looks like this:
| Bridge component | Revenue effect | What it means |
|---|---|---|
| Prior-period revenue | $500,000 | Starting point |
| New donors | +$70,000 | Revenue from first-time donors |
| Reactivated donors | +$35,000 | Revenue from donors returning after a gap |
| Retained donors who increased | +$55,000 | Additional revenue above their prior-period giving |
| Retained donors who decreased | -$40,000 | Revenue lost among donors who still gave |
| Lapsed donors | -$75,000 | Prior-period revenue not renewed |
| Current-period revenue | $545,000 | The bridge reconciles |
The headline says revenue grew 9%. The bridge says something more useful: $160,000 of positive movement had to overcome $115,000 of contraction. That distinction changes the management conversation. Acquisition and reactivation worked, but lapsed and declining donors still represent a large recovery opportunity.
Report the starting value, ending value, dollar change, and rate change together. When presenting rate movement elsewhere in the dashboard, follow a consistent standard for percentage points versus percent change.
Separate additive drivers from diagnostic lenses
Donor movement states form the additive bridge. Channel, campaign, source, gift band, designation, and geography are diagnostic lenses applied after the bridge balances.
That order prevents double-counting. For example, a first-time donor acquired through paid social belongs in the new state. Paid social can explain where that new-donor revenue came from, but it is not an additional bridge component.
Useful follow-up views include:
- new and reactivated revenue by acquisition source;
- retained increases and decreases by relationship owner or portfolio;
- lapsed revenue by prior gift band;
- every state by campaign, channel, designation, or region;
- donor counts, revenue, and average revenue per donor within each state; and
- the largest individual contributions to each positive and negative movement.
If giving levels are central to the question, pair this analysis with a gift-band movement view. If the concern is whether a favorable result will survive beyond the current period, add a durability measure instead of treating all growth as equally repeatable.
Flag timing and exceptional gifts without rewriting the bridge
A bridge can balance perfectly and still invite the wrong conclusion. A large gift may have arrived earlier than it did last year. A campaign may have shifted across the cutoff. One exceptional gift may account for most of the new-donor increase.
Keep those dollars in their correct donor states, then add transparent flags:
- Timing flag: likely shifted across the comparison boundary.
- Exceptional-gift flag: exceeds a documented organization-specific threshold.
- Adjustment flag: includes a refund, reversal, write-off, or reclassification.
- Identity-confidence flag: donor matching is incomplete or uncertain.
Then show the reported bridge and, when decision-useful, a normalized view that removes named timing or exceptional items. Do not silently exclude them. Leaders should be able to see both the actual result and the analytical adjustment.
This matters because sector research can be easy to overgeneralize. For example, Blackbaud’s 2026 UK fundraising preview identifies exceptional gifts as the most frequently cited income-growth driver in its sample, while also noting that the sample skews toward organizations with more than £1 million in revenue. The practical lesson is not that every nonprofit should expect the same pattern. It is that reports should reveal when an unusual gift is carrying the result. Review the source and sample caveat.
Turn each driver into a decision
A good variance analysis ends with action, not a waterfall chart. Use the dominant driver to choose the next investigation:
- New-donor revenue is up: inspect source quality, first-year handoff, second-gift movement, and acquisition cost before scaling.
- Reactivation is up: identify which lapse windows, messages, and channels produced the return, then test whether the pattern repeats.
- Retained increases lead growth: review stewardship, upgrades, recurring changes, and portfolio activity without assuming causation from the nearest touchpoint.
- Retained decreases are the main drag: segment the decline by gift band, tenure, designation, and relationship ownership.
- Lapsed revenue dominates: prioritize the donors and segments with the largest recoverable value rather than treating lapse as one undifferentiated count.
- Exceptional or timing items carry the result: label the result as less repeatable and avoid turning it into an automatic budget assumption.
For planning, carry the observed bridge into the forecast and test whether current assumptions still support the expected finish. The bridge explains what changed; the forecast tests what is likely to happen next. When the larger concern is whether growth is durable or concentrated, compare the movement with a donor mix stability report.
Build the first version in seven steps
- Name the decision. Decide whether the report will guide budget, campaign, portfolio, retention, or board discussion.
- Lock the comparison scope. Use equivalent dates, revenue rules, entities, and gift types.
- Create stable donor identities. Resolve duplicates and document how households, anonymous gifts, and unmatched records are handled.
- Aggregate revenue by donor and period. Keep gift-level detail available for audit.
- Assign one movement state. Apply the six-state logic consistently.
- Run the control formula. Do not publish a bridge that fails to reconcile.
- Add diagnostic lenses and owners. Show where each material movement came from, what the team will investigate, and when it will review the result.
Start with one important comparison, such as year-to-date individual giving versus the same dates last year. A smaller bridge that reconciles is more useful than a complex model that mixes donor movement, channel attribution, timing, and forecast assumptions into one unexplained number.
Make the change explainable
Fundraising leaders should not have to choose between a clean headline and a defensible explanation. A revenue driver bridge provides both. It preserves the reported total, exposes the donor movements underneath it, and gives the team a clear route from variance to action.
ReportWerks can bring donor, gift, campaign, source, and adjustment data into a connected reporting workflow so teams can move from “revenue changed” to “here is why, how confident we are, and what we will do next.” Begin with one reconciled comparison and keep every rule visible.
