Smarter Week

How to automate it

How to automate “write grant reports and funder updates”

Here are 2 ways to spend less time on this, best first. Each comes with steps you can follow today and, for AI fixes, a prompt to copy.

180 min
typically, once a month
55%
of the time can be automated
Some setup
to set up

Fix 1 of 2

AIBest fix

Have AI draft the grant report from your data and the original proposal

Give AI the funder's report questions, what you promised in the proposal and this period's numbers and notes. It drafts each answer against the promised outcomes, which you check and add stories to.

Typically saves about 45% of the time10 min to set up
  1. 1Gather the report template or questions, the original proposal's outcomes and this period's data.
  2. 2Remove client names and identifying details.
  3. 3Use the prompt below in your organization's approved AI tool.
  4. 4Check every number against your records and add one real (consented, anonymized) story.
Prompt to copy
Draft answers to this funder's report questions: [PASTE QUESTIONS]. What we promised in the proposal: [PASTE OUTCOMES AND TARGETS]. What happened this period: [PASTE NUMBERS AND NOTES]. For each question, answer in the funder's word limit, compare results with the target, explain any gap honestly with what we are doing about it, and keep a warm, factual tone. Do not invent numbers or stories; mark anything missing as [MISSING].

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot · Grantable or Instrumentl AI

Fix 2 of 2

Software feature

Track outcomes in one system so reports pull themselves

When attendance, services and outcomes are recorded in one case management or outcomes system, funder and board reports become a saved report you run, not a month-end spreadsheet hunt.

Typically saves about 50% of the time4 h to set up
  1. 1List the numbers every funder asks for (people served, sessions, outcomes, demographics).
  2. 2Make sure each one is a field in your case management or program system, not a side spreadsheet.
  3. 3Build a saved report or dashboard for each funder.
  4. 4Schedule it to run monthly and spend your time on the story, not the counting.

Tools: Your case management system (Bonterra Apricot, CaseWorthy, Penelope, Salesforce or similar) · Salesforce for nonprofits · Airtable · Power BI or Google Data Studio

Quick wins

Have you tried…

Have you had AI draft a grant report from your data and the original proposal?
You paste the funder's questions, what you promised and this period's numbers. AI drafts each answer for you to check and add a real story to.

Who does this task

Roles in our library that list this as one of their common tasks. Each guide covers the rest of that role’s week.

HourLeak · the 8-minute work audit

How many hours does this cost you?

The free 8-minute check works out where your week goes and gives you your top fixes. The team scan does the same for everyone and adds it up, so you know which leaks to fix first.

Answers are anonymous. Leaders only see team totals.

Other common tasks for Program managers / coordinators