Development dashboard template

This dashboard fits on one page, builds in any spreadsheet, and takes thirty minutes a month to run once set up. Its job is to make the five predictive numbers visible with their trends, so you manage the program by them instead of by the odometer of total-raised. Build it once; update it monthly on the same day.

The layout (one page, five rows)

Across the top: columns for this month, year-to-date, same point last year, and trend (up / flat / down: an arrow beats a decimal for the board). Down the side: the five numbers, each with the plain formula beside it so anyone can verify it.

*Pipeline value (major-gift shops) or net revenue per donor (annual shops): pick one, keep it consistent.

Below the table, three context lines: total raised YTD vs. plan (the number the board wants, kept in its place beneath the predictive five), thank-you speed (% within 48 hours: the cheapest retention lever), and one sentence of plain-language read.

How to calculate each (no data team required)

Retention rate. Of the donors who gave in the prior completed year, the share who have also given in the current year. Pull two lists (last year's donors, this year's donors), count how many names appear in both, divide by last year's count. If your database has a retention report, verify it once by hand so you trust it; if not, this is two exports and a lookup formula.

Active donors. Distinct donors with at least one gift in the trailing 12 months. Count distinct people, not gifts, and exclude the inactive-tagged records (the hygiene module's cleanup makes this number honest).

Average gift. Total individual giving in the period divided by the number of gifts (or by donors, if you want average per donor: label which, and keep it consistent). Watch it monthly; judge it over quarters, because one month is noisy.

Gifts per donor per year. Total number of gifts in the trailing 12 months divided by active donors. A file at 1.3 is mostly one-and-done givers; a file climbing toward 2.0 has a working rhythm and a sustainer base beneath it.

The forward number. If pipeline: sum the dollar value of relationships at INVITE-READY and INVITED on the moves pages (weight by probability if you want the honest version). If net revenue per donor: total raised minus total fundraising cost, divided by active donors: the number that quietly flags a channel costing more than it returns.

The monthly rhythm

• Same day each month ([e.g., the 5th]), 30 minutes, owner named.
• Pull the numbers, update the trends, write the one-sentence

read ("retention up two points; average gift soft in new-donor segment; pipeline covers 2.1x of remaining goal").

• Flag one action if a trend warrants it, with an owner.
• The same page feeds the board report (next lesson) and the

forecast (the lesson after): build it once, use it three ways.

Two cautions

Do not add a sixth number without removing one. Dashboards die of bloat: the discipline is the short list, and every metric you add is one you must maintain and one that dilutes the board's attention. If a new number earns its place, retire a weaker one.

Trends over absolutes. A retention rate of 54% means little in isolation and everything as a trajectory: 48 to 54 is a program getting healthier; 61 to 54 is an alarm. Always show last year's same-point figure beside today's, because the direction is the management information, not the level.

Built this way, the dashboard turns the monthly numbers hour from an act of archaeology into a thirty-minute read of exactly the five things that predict your year, in a form your board can follow and you can act on. The next lesson makes it board-ready without letting it become spin.

Evidence and adaptation note

This is a working tool, not a universal benchmark. Replace every bracketed field and example number with your organization's facts. Composite cases are labeled; their figures illustrate the method and should not be cited as sector results. Check legal, tax, privacy, employment, and accounting language against current guidance and your jurisdiction before adoption.

Primary references for review

Use these as verification starting points. The named reviewer still owns the final interpretation and must confirm that each source is current.

• Association of Fundraising Professionals, Fundraising Effectiveness Project reports: https://afpglobal.org/fepnews
• M+R Benchmarks 2026, fundraising: https://mrbenchmarks.com/fundraising/