Free TEMPLATE · Built for NPO’s
Board Reporting Template for NPOs
Stop rebuilding the board report from five different systems every quarter. A ready-made workbook for membership, revenue, impact and risk — plus a slide deck that pulls the headline numbers straight through.
Two files, one reporting cycle.
One person usually builds the numbers and someone else presents them. The download covers both jobs.
Excel workbook – 7 tabs
Where the numbers get built
Fill in the yellow cells; everything else calculates. Each tab has a commentary box, because the numbers say what happened and the commentary says why.
- Membership health, with this period against last
- Revenue summary with invoice aging
- Mission impact and risk register
- A History tab that drives the trend charts
PowerPoint – 4 slides
What you present
A short, on-brand deck built around the same figures — cover, headline KPIs, the membership trend, and impact and risks.
- Editable placeholders for your organisation’s name
- A native, editable trend chart
- Prompts for the one ask you want from the board
- Designed to be read in a meeting, not a document
What’s inside.
Built around the sections most NPO boards expect to see, in the order they expect to see them.
- Membership health – New, lapsed, net growth, growth rate, churn and renewal rate — each against the previous period.
- Revenue against target – Membership fees, donations and other income, with variance against target on every line.
- Mission impact – Campaigns, advocacy milestones and a narrative box for the line a board member can repeat elsewhere.
- Trend charts – Membership over time and revenue against target, drawn automatically from the History tab.
- Segmentation snapshot – Break the total down by region, membership type or engagement level, with percentages calculated for you.
- Invoice aging – Outstanding invoices split 0–30, 31–60, 61–90 and over 90 days — the view finance leads get asked for.
- Risks and compliance – GDPR and data hosting status, plus a risk register with severity, owner and target date.
- Board-ready summary – Six headline figures pulled from the other tabs — project it directly or copy it into the deck.
Why it’s built this way.
Most board reporting pain isn’t the writing. It’s pulling numbers from several systems, then being unsure they’re right.
Direction, not just numbers
Every metric sits next to the previous period. Boards rarely ask what the renewal rate is — they ask whether it’s improving.
One structure, every cycle
Log each period in the History tab and the trends build themselves. The second report takes a fraction of the time the first one did.
Works with what you have
No integration, no migration. Type the figures in from whatever systems you’re on today and the calculations follow.
One thing worth being clear about: this is a membership, revenue and mission report. It’s designed to sit alongside your formal accounts rather than replace them — there’s no expense, balance sheet or cash-flow reporting here, and your finance lead’s statements remain the authoritative financial record.
Download the template
Get the workbook and the slide deck together — free, no meeting required.
✓ 7-tab Excel workbook, formulas built in
✓ 4-slide PowerPoint deck to present from
✓ Available in English, Finnish and Swedish
"*" indicates required fields