Nonprofit KPI Dashboard Template

For ongoing use, update the monthly figures at the end of each month — or, for organizations on a grant-cycle calendar, after each reporting period closes. The Fundraising & Development sheet is most useful when updated after each major campaign: enter the total raised and total fundraising costs for the appeal or event, and it calculates your cost-per-dollar and campaign ROI immediately. If your organization tracks program-level actuals in a separate accounting system, you can copy monthly totals from your accounting export directly into the Program Performance sheet.

The metrics that matter most in the nonprofit sector are well-established. Program expense ratio — the share of total expenses going directly to mission-related programs — should generally sit at 65% or above, with many watchdog organizations using 75% as their threshold for top ratings. Fundraising efficiency, measured as the cost to raise one dollar, should be $0.25 or less for most established organizations, though newer nonprofits and capital campaigns often run higher. Operating reserve months — how long you can operate at current expense levels without new revenue — should be three to six months minimum, and boards of larger organizations often target twelve. Donor retention rate, which the sector tracks at around 43% nationally, is one of the highest-leverage metrics for sustainable growth: retaining 10% more donors has a larger long-term impact on revenue than acquiring the same number of new donors.