play icon for videos
← Academy
SOPACT ACADEMY · CONNECTED DATA INTELLIGENCE · PROVE

How Do You Write an Impact Narrative for a Funder?

A funder-ready narrative pairs every figure with a verbatim quote. Here is the prompt that grades each claim green, amber, or red so nothing unsupported ships.

This chapter resolves check 08 Reliable of the eight checks.

The annual report is due Friday. Three hundred and forty participants finished the endline survey, and 71 per cent of them reported more confidence than at baseline. The programme officer needs a voice to sit beside that figure, so she opens the open-ended column, sorts it by length, and reads the twenty longest answers. One is four hundred words, beautifully structured, and genuinely moving. It goes into the report directly under the 71 per cent. Illustrative example.

Nothing in that is dishonest. But the number came from 340 people and the story came from one, and she found that one by sorting for length. Two claims now sit side by side on the page looking like they came from the same place, and they did not.

Why do the stories in funder reports feel unrepresentative?

Because your number describes everyone and your story describes whoever writes well. The statistic is computed across the whole cohort. The quote is chosen — and it is chosen for how it reads. Length, fluency, emotional force and a satisfying arc are what make a response quotable, and none of them has anything to do with how many people share that experience. The reader cannot see the difference, so the mismatch never gets challenged. It just leaves a faint sense that the stories in impact reports are a bit too good.

Four things get a response quoted. None of them is representativeness.

Selection is happening, and it is happening at the moment of reading rather than in the analysis, which is why it escapes review. Sampling gets scrutinised. Quote-picking does not.

What actually decides which participant appears in your report
LengthLong answers contain more usable sentences, so they get read first and quoted most. Length mostly measures time and willingness to write, not depth of experience.
Fluency in your languageThe report is written in one language, so responses already in that language, written confidently, need no handling. Everyone else is a translation problem to be dealt with later.
Emotional registerA response that names a hardship and a turnaround reads as a story. A response that says the course was useful and the bus was expensive reads as a comment, even when it is the more common experience.
Being known to staffThe participants who talk to programme staff are the ones staff remember when a quote is needed. They are also, systematically, the most engaged people in the cohort.

Put those four together and you have a filter that reliably selects the most articulate, most engaged, most comfortable participants in the programme — the people least like the ones you were funded to reach.

Quote for the theme's weight, not for its wording

The fix is a change in the order of operations. Today the sequence is: write the finding, then go looking for a quote that supports it. Reverse it. Theme the responses first, count how many responses sit in each theme, and let the counts decide which themes get a voice in the report at all. Then, inside the chosen theme, pick the response that states it most plainly — not the one that states it best.

And then say the quiet part out loud on the page. A quote with a count beside it is a different kind of evidence from a quote alone:

Unpaired

71% of participants reported increased confidence.

"Before this programme I could not look a stranger in the eye. I now chair a committee of eleven people and last month I spoke in front of the district council…"

Paired

Of the 340 participants who completed the endline, 71% reported more confidence than at baseline. Asked what changed, 96 of them described speaking up in a group. One wrote:

"I can talk in the meeting now. Before I just sat."

The second version is less stirring and much harder to argue with. The quote is doing a specific job: it is showing what those 96 responses sound like. It has stopped being decoration and started being a sample.

How to do this without any particular software

This is a discipline before it is a feature, and it is worth running by hand once so you can see what it costs.

  1. Theme before you quote. Read the responses, group them, and write down how many responses fall in each theme. You now have a ranked list of what participants actually said, independent of how well they said it.
  2. Decide which themes get space based on those counts, not on which ones you already have a good quote for. If a theme with 96 responses has no memorable quote and a theme with 4 has a superb one, the 96 still goes in the report and the 4 does not lead it.
  3. Inside each theme, pick the median response, not the best one. Sort the theme's responses by length and take one from the middle. Read it. If it says the thing plainly, use it, misspellings and all.
  4. Write the count next to the quote. "One of 96 responses describing this" is a sentence anyone can write, and it converts an anecdote into an illustration of a measured group.
  5. Keep a quote log across reports. One row per quote: participant identifier, report, date, theme. Quote nobody twice in one report, and check the log before the next one. Three years of the same four eloquent people is a pattern you will only notice if you are recording it.
  6. Name the themes you are not quoting, with counts. A short line — "two further themes, 31 and 12 responses, are not illustrated here" — tells the reader the selection was bounded rather than free.

Done carefully on a few hundred responses, this works. There is nothing proprietary in it.

Where it breaks

It breaks in three places, and they all break the same way — quietly, under deadline.

The count and the quote come from different places. The 71 per cent lives in a survey export. The quotes live in a document somebody made while reading. Nothing joins them, so nobody can check whether the person quoted is even inside the group the number describes. By the time the report is designed, the two are separate objects on a page and the link exists only in one person's memory.

Length bias returns whenever time is short. The method above assumes someone reads the whole theme. In the last week before a board deadline, they read the top of the sorted column, exactly as before.

The quote pool ossifies. Without a log, the same handful of participants supply the human voice of the organisation year after year. Their outcomes drift away from the cohort's — they are the engaged ones — and the reports get steadily more optimistic than the data, with no single decision anywhere responsible for it.

The narrow thing a system does here: because every response stays attached to the participant record it came from, a theme in Sopact Sense carries its own count and its own citations, so a quote can be pulled with the number of responses it represents already attached, and the original wording is preserved so what appears in the report is what the participant typed. Which theme matters, which quote reads honestly, and what the finding means are still your judgements to make.

How to test this on a real report

Use: Your last published report. Take every participant quote in it and try to answer two questions for each: how many responses shared that theme, and is the quoted person inside the group the neighbouring statistic describes.

Pass: Every quote has a theme count you can recover from the data, every quoted participant sits inside the denominator of the claim beside it, and no participant is quoted more than once.

Fail: You cannot tell how many people a quote stands for. Or the two most powerful quotes turn out to be the same two people you used last year.

Do this on a report that has already gone out. Testing it on the one you are still writing lets you fix the quotes instead of seeing the pattern.

Frequently asked questions

Isn't a longer, more detailed answer simply a better answer?

It is a richer one, and it tells you more about that person. It does not tell you that more people feel the same way. Length correlates with education, free time, comfort writing in the survey's language and confidence that the response will be read — all of which vary systematically across a cohort in ways your programme probably cares about.

Can we really quote someone who expresses it badly?

Yes, and you should when theirs is the typical response. A plainly worded quote in a report signals that the selection was not made on style. Quote it exactly as written; do not tidy the grammar to make it presentable, because the moment you rewrite it you are quoting yourself.

What number belongs next to a quote?

The size of the group the quote is representing — how many responses fall in that theme — and the base it came from. "96 of 340 endline responses described this" is enough. Avoid attaching a quote to a statistic it has no relationship with, which is the most common version of this error.

What if the most typical response is not quotable at all?

Then say so and give the count without a quote. "The most common single response to this question was some version of 'the bus cost too much' — 96 responses" is a legitimate and rather strong sentence. A theme does not need a voice to be reported; it needs a number.

Do we have to stop using the one extraordinary story?

No. Use it, and label it as what it is: one person's account, not an illustration of the cohort. The damage is not caused by publishing a remarkable story. It is caused by placing it under a whole-population statistic so the reader reads it as the typical case.

Is it acceptable to build a composite quote from several responses?

No. A composite is a sentence no participant said, presented in quotation marks. If you need to convey a shared experience in one line, write it in your own voice as a summary with a count, and quote one real response beneath it. The distinction is small on the page and total in terms of what the report can be held to.

How does translation affect this?

It concentrates the bias, because responses in the report's language need no work and everything else does. Keep the original text with the translation attached to it, quote the original alongside, and check whether your quotes are drawn from the language distribution of the responses or just the convenient part of it.

There is a useful side effect to keeping the quote log. After two or three reporting cycles it stops being an admin file and becomes a small dataset about your own organisation: whose words get carried to funders, boards and websites, and whose never do. If the same six people keep appearing, that is not a writing habit. It is a description of whose voice your systems can reach — and it is measuring something no survey in your programme was designed to ask about.

Next: Now pick your record shape

Ready to try it for yourself?

ChatGPT, Claude, and Gemini are fine for a quick test — but not for an answer you'll put in front of a funder or board. When it has to hold up, run it in Sopact Sense.

Try it in Sopact →
The Loop
The Loop — the method in one read
the-loop
Loop
The method
0
One continuous method for reliable, traceable AI reporting across case, application, grant, and program workflows: collect clean, analyze on arrival, and improve in time.
Teams running cases, applications, grants, or programs that need AI-assisted reporting they can reproduce, trace to source evidence, and act on before the cycle ends.
What Is Case Intelligence?
What Is Case Intelligence?
what-is-case-intelligence
Case
Foundation
1
One current, traceable record for each person—connecting intake, services, notes, surveys, documents, outcomes, decisions, and follow-up.
Workforce and training · Youth and mentoring · Case management · Scholarships · Accelerators · Education · Nonprofit programs
What Is Grant Intelligence?
What Is Grant Intelligence?
what-is-grant-intelligence
Grant
Foundation
1
One connected evidence record from application and committee review through the awarded grant, grantee reporting, renewal, and board accountability.
Foundations and grantmakers · Public grant programs · Scholarships and fellowships · Accelerators
What Is Portfolio Intelligence?
What Is Portfolio Intelligence?
what-is-portfolio-intelligence
Portfolio
Strategy
1
A source-linked portfolio view that connects each investee or grantee's agreed plan, reporting cadence, evidence, risks, and results.
Impact funds and investors · Foundations with grant portfolios · Family offices · Blended-finance vehicles
What Is Connected Data Intelligence?
What Is Connected Data Intelligence?
connected-data-intelligence
Feedback
Foundation
1
Keep evidence from surveys, files, notes, documents, systems, sites, and reporting periods connected to one continuing record.
Multi-program nonprofits · Member and chapter networks · Research associations · Training and coaching teams · Organizations with scattered evidence
What Is Impact Measurement and Reporting?
What Is Impact Measurement and Reporting?
embedded-impact-measurement
Reporting
Align
1
Define intended change, align organization and funder context, govern measures, interpret evidence, and produce traceable reports for decisions.
Program and impact teams · MEL leads · Funders and donors · Foundations · Impact funds · Organizations building rigorous impact reports
The Loop Methodology
Methodology — continuous, not annual
loop-methodology
Loop
The method
1
The continuous collect–analyze–improve cycle, adopted as an experiment: start with the step that already pays and add one data-collection step at a time.
Teams tired of rebuilding spreadsheets and forms who want a measurement system that compounds instead of resetting.
How to Build a Theory of Change with AI: Prompts, Workflow & Examples
Build a Theory of Change You Can Test
how-to-build-a-theory-of-change
Reporting
Align
2
How Do You Onboard a Portfolio and Track Results?
Onboard a Portfolio & Lock the Impact Agreement
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Data Dictionary
2
The Loop: Reliability
Reliability — the same answer twice
loop-reliability
Loop
The method
2
Determinism as a feature: the same question over the same data returns the same answer every run — the opposite of a generic AI chat that drifts.
Anyone who has watched a general AI tool give two different numbers for the same question and needs results they can stand behind.
How to Design a Fair Application and Selection Process
Design an Application Process
how-to-design-an-application-process
Grant
Foundation
2
Which Shape Is Your Data?
Which shape is your data?
which-shape-is-your-data
Feedback
Foundation
2
How Do You Build a Logic Model?
Build a Logic Model You Can Use
how-to-build-a-logic-model
Reporting
Align
3
How Do You Onboard a Grant or RFP Program?
Onboard a Grant or RFP Program
how-to-onboard-a-grant-rfp-program
Grant
Foundation
3
Theory of Change to Data Collection: A Four-Step Workflow
Turn a Theory of Change into a Data-Collection Workflow
theory-of-change-to-data-collection-workflow
Case
Foundation
3
How Do You Map Portfolio Data to IRIS+, GRI, and ESRS?
One Data Dictionary & Standards Mapping (IRIS+ / GRI / ESRS / CSRD)
portfolio-data-dictionary-standards-mapping
Portfolio
Chapters
3
The Loop: Traceability & Transparency
Traceability & Transparency
loop-traceability
Loop
The method
3
Every figure links back to the exact response, note, or document it came from — a full audit trail from headline result to raw evidence.
Teams whose numbers get scrutinized — by funders, boards, auditors, or standards — and who need to answer where did this come from on the spot.
How Do You Change a Question Without Breaking the Record?
Change questions without breaking the record
change-questions-without-breaking-the-record
Feedback
Control
3
Versioning questions and rules so a programme team can improve the instrument mid-cycle without silently breaking the trend line.
Programme & MEL leads · Teams whose questionnaire has ossified · Anyone evaluating a platform where configuration is a purchased service
What Are the IMP Five Dimensions of Impact?
Use the Five Dimensions to Test the Evidence
five-dimensions-of-impact
Reporting
Align
4
How Do You Design a Grant Rubric and Eligibility Rules?
Design Your Rubric & Eligibility Rules
grant-rubric-eligibility-rules
Grant
Foundation
4
How Do You Frame Portfolio Outcomes Over Outputs?
Frame Outcomes Over Outputs at Portfolio Level
frame-outcomes-portfolio-level
Portfolio
Chapters
4
The Loop: Flexibility
Flexibility — one method, four workflows
loop-flexibility
Loop
The method
4
The same collect–analyze–improve cycle, shaped to four kinds of impact work — case, grant, portfolio, and feedback — each shown end to end.
Anyone deciding where the Loop fits their work, who wants to see the full path from messy input to a report they can defend.
How Do You Collect Feedback Offline and in the Field?
Collect Feedback Offline & in the Field
collect-feedback-offline
Feedback
Connect
4
Capturing stakeholder feedback where there's no connectivity and syncing each answer to one continuing record — so field and multi-site programs keep a single identity from intake to endline.
Field & multi-site programs · Low-connectivity contexts · Nonprofits collecting in person
How Do You Design an Intake Form for a Baseline?
Design an Intake Form That Captures a Usable Baseline
intake-form-usable-baseline
Case
Nonprofit Track
5
What's the Difference Between Outcomes and Outputs?
Outcomes vs Outputs
frame-outcomes-over-outputs
Grant
Foundation
5
How Do You Do Pre-Investment Due Diligence?
Pre-Investment Due Diligence & Screening
pre-investment-due-diligence-screening
Portfolio
Chapters
5
The Loop Guarantee
The Guarantee — first workflow in 2 months
loop-guarantee
Loop
The method
5
How Do You Build an Organization Evidence Model?
Build the Organization Evidence Model
build-organization-evidence-model
Reporting
Align
5
How Do You Use Documents as Evidence?
Read documents as evidence
read-documents-as-evidence
Feedback
Connect
5
How to Clean Open-Ended Survey Responses
Clean Open-Ended Responses at the Source
clean-open-ended-survey-responses
Feedback
Clean
6
How Do You Spot At-Risk Participants Mid-Program?
Spot At-Risk Participants Mid-Program
spot-at-risk-participants-mid-program
Case
Nonprofit Track
6
How to Write a Nonprofit Grant Application: Template and Example
Grant Application for Nonprofits
grant-application-for-nonprofit-organizations
Grant
Foundation
6
How Do You Collect Investee Reporting Without Burden?
Collect Standardized Reporting from Every Investee, Without Burden
collect-investee-reporting-without-burden
Portfolio
Chapters
6
How Do You Build a Funder Context Profile?
Build a Sourced Funder Context Profile
build-funder-context-profile
Reporting
Align
6
How Do You Measure Change at Exit?
Measure Change at Exit (Not Just Completion)
measure-change-at-exit
Case
Nonprofit Track
7
How Do You Collect Applications Clean at the Source?
Collect Applications Clean at the Source
collect-applications-clean-at-source
Grant
Collect
7
How Do You Chase Missing Investee Data?
Chase Missing Investee Data — Automatically
chase-missing-investee-data
Portfolio
Chapters
7
How Do You Analyze Multilingual Feedback?
Analyze Multilingual Feedback
analyze-multilingual-feedback
Feedback
Clean
7
Cleaning and theming multilingual open-ended feedback across languages on one continuing record — every theme cited to the person's own words, with no manual translate-then-code step.
Multi-country programs · Multilingual survey data · Global networks & chapters
How Do You Define Measures the Organization and Funder Can Both Use?
Define Measures the Organization and Funder Can Both Use
define-impact-metrics-funders-want
Reporting
Align
7
How Do You Find Who Is Missing Survey Waves?
Survey attrition — who is missing waves
survey-attrition-longitudinal-studies
Feedback
Read
8
How to Catch At-Risk Participants Early with Mentor Notes
Catch At-Risk Participants Early with Mentor Notes
mentor-notes-early-warning
Case
Nonprofit Track
8
How Do You Reduce Applicant Burden?
Reduce Applicant Burden
reduce-applicant-burden-auto-clarification
Grant
Collect
8
How Do You Analyze Investee Reports?
Read Investee Reports Across Qual + Quant + Financial + Social
read-investee-reports-multi-signal
Portfolio
Chapters
8
How Do You Define an Impact Metric So Everyone Counts It the Same Way?
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
8
How Do You Connect Quantitative and Qualitative Data?
Connect Quantitative & Qualitative Data
connect-quantitative-qualitative-survey-data
Feedback
Read
9
How Do You Calculate SROI Live?
Calculate SROI — Live, Sourced, and Honest
calculate-sroi-live
Case
Nonprofit Track
9
How Do You Collect Grantee Reports Without Burden?
Collect Grantee Reports Without Burden
collect-grantee-reporting-without-burden
Grant
Collect
9
How Do You Track Investees Against the Impact Agreement?
Track Investees Against the Impact Agreement (Variance)
track-investees-impact-agreement-variance
Portfolio
Chapters
9
How Do You Turn Reporting Requirements Into Evidence You Can Collect?
Turn Requirements Into Collectable Evidence
turn-reporting-requirements-into-evidence
Reporting
Define
9
How to Analyze Pre and Post Survey Data
Analyze Pre / Mid / Post Data
analyze-pre-mid-post-survey-data
Feedback
Read
10
How to Report a Job-Training Program to Grant Funders
Turn a Cohort into a Funder Impact Report
job-training-grant-impact-report
Case
Nonprofit Track
10
How Do You Chase Missing Grantee Data?
Chase Missing Grantee Data
chase-missing-grantee-data
Grant
Collect
10
How Do You Monitor Portfolio Risk in Real Time?
Portfolio Risk Monitoring & Early-Warning Alerts
portfolio-risk-monitoring-alerts
Portfolio
Chapters
10
How Do You Collect Clean Evidence Inside the Workflow?
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
How Do You Analyze Longitudinal Survey Data?
Track One Person’s Change Across Years
analyze-longitudinal-survey-data
Feedback
Read
11
How Do You Turn a Job Description Into a Checklist?
Turn a Job Description into a Requirements Checklist
job-description-requirements-checklist
Case
Social Enterprise Track
11
How Do You Review Applications Without Reviewer Bias?
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
Ask Your Whole Portfolio Anything (Claude + MCP)
Ask Your Whole Portfolio Anything (Claude + MCP)
ask-your-portfolio-anything
Portfolio
Chapters
11
How Do You Get Stable Results From Governed Data?
Get Stable Results From Governed Data
same-numbers-every-time
Reporting
Read
11
How Do You Analyze a Batch of Grant Applications?
Analyze a Whole Round
how-to-analyze-a-batch-of-grant-applications
Grant
Analyze
12
How Long Do Program Outcomes Last?
Measure how long outcomes last
measure-outcome-duration-drop-off
Feedback
Read
12
How Do You Score Candidate-Role Matches Without Bias?
Score Candidate–Role Matches Without Bias
score-candidate-role-matches-without-bias
Case
Social Enterprise Track
12
How Do You Trace Every Result Back to Its Evidence?
Trace Every Result Back to Its Evidence
where-every-number-came-from
Reporting
Read
12
How Do You Roll Up a Grant Portfolio?
Aggregate Outcomes Across the Portfolio
how-to-roll-up-a-grant-portfolio
Portfolio
Communicate
13
How to Report Job Placements to Impact Investors
Turn a Cohort into a Social-Enterprise Investor Report
job-placement-investor-impact-report
Case
Social Enterprise Track
13
How Do You Track Reviewer Conflicts of Interest?
Track Reviewer Conflicts of Interest
track-conflicts-of-interest-audit
Grant
Analyze
13
How Do You Write a Donor Report?
Design a Report for a Real Funding Decision
donor-report-funders-trust
Reporting
Decide
13
A practical, step-by-step track for building a donor or grant report funders trust — from the funder's decision back through metrics, clean data, and traceable numbers.
Program & grant managers who report to funders
What Should AI Be Allowed to See in Your Stakeholder Data?
What the assistant may see
what-the-assistant-may-see
Feedback
Prove
13
How Do You Write an Impact Narrative for a Funder?
Write a Cited Impact Narrative
impact-narrative-funder-report-cited
Feedback
Prove
14
How Do You Read a Grantee Report?
Read a Grantee Report
read-grantee-report-multi-signal
Grant
Analyze
14
How Do You Monetize Impact with SROI?
Monetize Impact with SROI Across Levels
monetize-impact-sroi-across-levels
Portfolio
Chapters
14
How Do You Get AI to Write a Funder Report?
Generate the Audience-Specific Report From Evidence
assistant-writes-the-funder-report
Reporting
Decide
14
How Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
How Do You Put a Dollar Value on Impact?
Add a Credible Dollar Value With SROI
credible-dollar-value-on-impact
Reporting
Optional method
15
How Do You Set Up a Study That Follows People for Years?
One person, followed for years
one-person-followed-for-years
Feedback
Shapes
15
How Do You Build an SROI Value Map?
Build an SROI Value Map
how-to-build-an-sroi-value-map
Reporting
Optional method
16
How Do You Track Budget and Actual Spend?
Track Budget vs Actual Spend
how-to-track-budget-invoices-actual-spend
Grant
Analyze
16
How Do You Collect Feedback From Several People About One Person?
Several people describing one person
several-people-describing-one-person
Feedback
Shapes
16
How Do You Pick a Financial Proxy for SROI?
Pick a Defensible Financial Proxy
how-to-pick-a-financial-proxy-for-sroi
Reporting
Optional method
17
How Do You Analyze Grantee Reporting Longitudinally?
Analyze Grantee Reporting Over Time
analyze-grantee-reporting-longitudinal
Grant
Analyze
17
How Do You Compare Investees When Each One Defines Its Metrics Differently?
Compare & Benchmark Investees
compare-benchmark-investees
Portfolio
Chapters
17
How Do You Report Across Programs That Were Designed Separately?
Many programs, one picture
many-programs-one-picture
Feedback
Shapes
17
How Do You Calculate the SROI Ratio?
Calculate the SROI Ratio With a Range
how-to-calculate-the-sroi-ratio
Reporting
Optional method
18
How Do You Read a 990 for Compliance?
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
How Do You Build Dashboards and Compliance Reports?
Portfolio Dashboards & Geographic Mapping
dashboards-sroi-compliance-reports
Portfolio
Communicate
18
How Do You Run a Survey Across a Member Network?
A network where each member sees their own part
member-network-survey
Feedback
Shapes
18
Ask Your Whole Grant Round Anything (Assistant + MCP)
Ask Your Whole Grant Round Anything
ask-your-grant-round-anything
Grant
Analyze
19
How Do You Produce an LP and Board Impact Report?
Produce the LP / Board Impact Report — Live, Not Annual
portfolio-lp-board-impact-report
Portfolio
Chapters
19
How Do You Build a Grant Audit Trail?
Build a Grant Audit Trail
grant-audit-compliance-trail
Grant
Communicate
20
How Do You Connect Your Stack Without Lock-In?
Connect Your Stack Without Lock-In (Microsoft Dynamics, Power BI, Affinity, MCP)
portfolio-connect-your-stack
Portfolio
Chapters
20
How Do You Produce Grant Compliance Reports?
Produce Compliance Reports
grant-compliance-regulatory-reports
Grant
Communicate
21
How Do You Roll Grantees Into a Board Report?
Roll Grantees Into a Board Report
roll-grantees-funder-board-report
Grant
Communicate
22
How Do You Build Grant Dashboards and Maps?
Grant Dashboards & Maps
grant-dashboards-geographic-mapping
Grant
Communicate
23