In short

A quarterly funder report should come from the case records you already keep, not from a week of copying figures into a template. The improved process pulls the agreed figures from the case system, drafts the narrative from approved notes, flags anything odd, and leaves the service manager to check each figure against its source before anything is sent.

AI helps with the drafting. It never decides a number, and nothing goes to the funder until a named person has approved it.

  • Sector Advice charities
  • Role Service manager
  • Job Quarterly funder report

The job today

Every quarter, the service manager exports cases from the case management system into a spreadsheet, filters them by the funder's categories, counts outcomes by hand and copies the totals into the funder's template. Then they write two or three pages of narrative, usually by searching notes for good examples. Different funders want the same work counted in different ways, so the same records get re-sliced several times.

Where it breaks

  • The funder's definitions ("client", "case", "outcome achieved") don't quite match the fields in the system, so each report involves judgement calls that nobody wrote down last time.
  • Figures are typed between files, and one wrong filter can change a headline number.
  • Good case examples are hard to find, and quotes have to be anonymised by hand.
  • The work lands on one person, often at the busiest time of the quarter.

The improved process, step by step

  1. Agree the report definitionsWrite down, once, how each funder figure maps to fields and statuses in your case records. This becomes the rulebook for every future quarter.
  2. Pull the figures from the recordsA saved query produces each figure for the period, with a link to the list of records behind it. No retyping.
  3. Draft the narrative AI preparesAn assistant drafts the narrative from approved, anonymised notes and last quarter's report, in your charity's voice. It marks every claim with the records it came from.
  4. Flag gaps and odd figuresAnything that moved sharply since last quarter, or a figure with too few records behind it, is flagged for a closer look.
  5. The manager checks and signs off A person approvesThe service manager checks each figure against its source list, edits the narrative and approves the report. Nothing is sent before this step.
  6. Send and keep the evidence packThe approved report is sent and an evidence pack (queries, record lists, approvals) is filed for audit.
Quarterly funder reporting at an advice charity: process diagramSteps: 1. Agree the report definitions; 2. Pull the figures from the records; 3. Draft the narrative (AI prepares); 4. Flag gaps and odd figures; 5. The manager checks and signs off (a person approves); 6. Send and keep the evidence pack 01 Agree the report definitions 02 RULES CHECK Pull the figures from the records 03 AI PREPARES Draft the narrative 04 RULES CHECK Flag gaps and odd figures 05 A PERSON APPROVES The manager checks and signs off 06 Send and keep the evidence pack
The process at a glance. Teal steps are prepared with AI help; the amber step is where a person approves.

Where a person must approve

A person approves

The service manager approves the whole report before it goes to the funder, and checks each figure against the records behind it.

Any case example or quote is checked for anonymity by a person, even if the draft has already removed names.

The data boundary

  • The assistant reads only the fields and notes needed for this report, and only for the reporting period.
  • Names, addresses and other identifying details are removed before any drafting step.
  • Special category information (for example health) is excluded unless the funder genuinely needs it and you have a lawful basis.
  • Drafts and prompts stay in a system the charity controls, with a log of what was asked and produced.

Checklist before you start

  • We have the funder's definitions in writing for each figure.
  • Each figure maps to named fields and statuses in our case records.
  • We know who signs off the report, and who covers when they are away.
  • We have agreed which notes may be used for case examples, and how they are anonymised.
  • Last quarter's report is available as a reference for tone and format.
  • We know where the evidence pack will be stored and for how long.

This is an illustrative walkthrough of a common pattern. It is not a client case study, and the details will differ in your organisation.