play icon for videos
← Academy
Analyze · Other

How to Build a Relationship Record

Relationship intelligence should be a record, not a mailbox of interactions. Here is how to join every touch, document, and number onto one Contact ID, code it to a codebook, and read a whole relationship into a single cited brief.

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> *{box-sizing:border-box} body{margin:0;font-family:'Hanken Grotesk',-apple-system,BlinkMacSystemFont,sans-serif;background:#F7F4EC;padding:24px;display:flex;justify-content:center} .card{width:600px;max-width:100%;background:#FFFFFF;border:1px solid #ECE4D4;border-radius:20px;box-shadow:0 24px 60px -34px rgba(60,40,20,.34),0 2px 4px rgba(60,40,20,.05);overflow:hidden} .hdr{display:flex;align-items:center;gap:11px;padding:16px 20px;border-bottom:1px solid #F0E9DB;background:#F7F4EC} .hdr .n{font-family:'Inter',Georgia,serif;font-weight:600;font-size:16px;color:#2A2118;letter-spacing:-.2px;line-height:1.25;min-width:0} .hdr .pill{margin-left:auto;display:inline-flex;align-items:center;gap:6px;font-size:11.5px;font-weight:700;color:#C05B3F;background:#F6E7E1;padding:5px 11px;border-radius:20px;white-space:nowrap;flex-shrink:0} .hdr .pill .d{width:6px;height:6px;border-radius:50%;background:#C05B3F} .tabs{display:flex;gap:0;padding:12px 14px 0;background:#F7F4EC;flex-wrap:wrap} .tab{flex:1;min-width:76px;display:flex;flex-direction:column;align-items:center;gap:5px;cursor:pointer;font-family:inherit;font-size:11px;font-weight:700;color:#8A7B66;background:transparent;border:none;border-bottom:2px solid transparent;padding:8px 4px 10px} .tab .lbl{line-height:1.2;text-align:center} .tab.on{font-weight:800;color:#C05B3F;border-bottom-color:#C05B3F} .tab .num{display:inline-flex;width:20px;height:20px;align-items:center;justify-content:center;border-radius:50%;font-size:11px;font-weight:800;color:#8A7B66;background:#F0E9DB} .tab.on .num{color:#fff;background:#C05B3F} .divider{height:1px;background:#F0E9DB} .body{padding:20px} .what{font-size:13.5px;line-height:1.55;color:#4A4030;margin:0 0 14px} .promptlbl{font-size:10px;font-weight:800;letter-spacing:1px;text-transform:uppercase;color:#B0A48D;margin-bottom:7px} .bubble{position:relative;font-family:ui-monospace,'SF Mono',Menlo,monospace;font-size:11.5px;line-height:1.55;color:#2A2118;background:#F7F4EC;border:1px solid #ECE4D4;border-left:3px solid #C05B3F;border-radius:12px;padding:13px 14px;white-space:pre-wrap;word-break:break-word} .actions{display:flex;align-items:center;gap:14px;margin-top:13px;flex-wrap:wrap} .copy{font-family:inherit;font-size:12px;font-weight:700;color:#C05B3F;background:#F6E7E1;border:1px solid #EFD5CC;border-radius:9px;padding:8px 14px;cursor:pointer} .copy.done{color:#15884F;background:#E4F1EA;border-color:#CBE6D6} .demo{font-size:12.5px;font-weight:700;color:#C05B3F;text-decoration:none} .demo:hover{text-decoration:underline} </style> </head> <body> <div class="card"> <div class="hdr"> <div class="n">How to build a relationship record</div> <span class="pill"><span class="d"></span>Sopact Sense</span> </div> <div class="tabs" id="tabs"></div> <div class="divider"></div> <div class="body"> <p class="what" id="what"></p> <div class="promptlbl">Copy-paste Sopact Assistant prompt</div> <div class="bubble" id="prompt"></div> <div class="actions"> <button type="button" class="copy" id="copyBtn">Copy prompt</button> <a class="demo" href="https://www.sopact.com/request-demo" target="_blank" rel="noopener">Request a demo &rarr;</a> </div> </div> </div> <script> (function(){ var D = {"title":"How to build a relationship record","pill":"Sopact Sense","steps":[{"n":1,"tab":"One record","what":"Bring every interaction — survey, document, meeting note, check-in — onto the same stakeholder Contact ID instead of scattered threads.","prompt":"Attach every interaction for this stakeholder — surveys, documents, meeting notes, check-ins — to their single persistent Contact ID [ID]. List anything currently living in a separate thread or spreadsheet that needs to be joined to the record."},{"n":2,"tab":"Code to codebook","what":"Map the qualitative signal to your codebook so a score and the sentence behind it live together on the record.","prompt":"Code the qualitative signal in this stakeholder's record [RECORD] against our codebook. For each theme, return the score and the exact source sentence behind it, so the number and its evidence stay together."},{"n":3,"tab":"One-page brief","what":"Synthesize the whole record into a single relationship brief — everything cited, nothing inferred.","prompt":"Synthesize this stakeholder's full record [RECORD] into a one-page relationship brief: current status, key needs or commitments with the source sentence, open flags, and what changed since the last touch — everything cited to the record, nothing inferred."},{"n":4,"tab":"Keep it safe","what":"Keep the record first-party and reproducible — exclude sensitive fields from AI and run on anonymized IDs where needed.","prompt":"Re-run this synthesis excluding the sensitive fields [FIELD LIST] and using anonymized IDs. Confirm the output is reproducible from the record and flag any line that could not be traced to a source sentence."}]}; var tabsEl = document.getElementById('tabs'); var whatEl = document.getElementById('what'); var promptEl = document.getElementById('prompt'); var copyEl = document.getElementById('copyBtn'); var cur = 0; function renderTabs(){ tabsEl.innerHTML=''; D.steps.forEach(function(st,i){ var b=document.createElement('button'); b.type='button'; b.className='tab'+(i===cur?' on':''); b.innerHTML='<span class="num">'+st.n+'</span><span class="lbl">'+st.tab+'</span>'; b.addEventListener('click',function(){cur=i;render();}); tabsEl.appendChild(b); }); } function render(){ renderTabs(); var st=D.steps[cur]; whatEl.textContent=st.what; promptEl.textContent=st.prompt; copyEl.textContent='Copy prompt'; copyEl.classList.remove('done'); } copyEl.addEventListener('click',function(){ var txt=D.steps[cur].prompt; function ok(){copyEl.textContent='Copied ✓';copyEl.classList.add('done');} if(navigator.clipboard&&navigator.clipboard.writeText){ navigator.clipboard.writeText(txt).then(ok,function(){fallback(txt,ok);}); }else{fallback(txt,ok);} }); function fallback(txt,ok){ var ta=document.createElement('textarea'); ta.value=txt;ta.style.position='fixed';ta.style.opacity='0'; document.body.appendChild(ta);ta.focus();ta.select(); try{document.execCommand('copy');ok();}catch(e){} document.body.removeChild(ta); } render(); })(); </script> </body> </html>

In short: Build a relationship record by attaching every interaction — survey, document, meeting note, check-in — to one persistent Contact ID, coding the qualitative signal against a codebook so a score and its source sentence live together, and synthesizing the whole record into a single cited brief. Keep it first-party and reproducible rather than a fresh guess each run. In Sopact Sense relationship intelligence becomes a record you can trace, not a mailbox of interactions you re-read from memory.

1 · Bring every interaction onto one Contact ID

A relationship without a record forgets what was said. The first move is to stop treating a stakeholder as a set of scattered threads — an email chain here, a meeting note there, a survey in a separate tool — and attach every interaction to the same persistent Contact ID. In Sopact Sense that ID is assigned at first contact and carried forward, so surveys, uploaded documents, meeting notes, and check-ins all land on one record instead of four disconnected places you have to reassemble by hand.

Attach every interaction for this stakeholder — surveys, documents, meeting notes, check-ins — to their single persistent Contact ID [ID]. List anything currently living in a separate thread or spreadsheet that needs to be joined to the record.

2 · Code the qualitative signal to a codebook

Once the interactions live on one record, the qualitative signal — what the stakeholder actually said — has to be coded consistently, or the record is just a longer pile of text. Map each open response and note to your codebook so the score and the exact sentence behind it stay together. That pairing is what makes the record defensible: every rating points back to the words that produced it. The codebook itself is worth building deliberately — see how to build a data dictionary.

Code the qualitative signal in this stakeholder's record [RECORD] against our codebook. For each theme, return the score and the exact source sentence behind it, so the number and its evidence stay together.

Expected output. A themed table for the stakeholder: each code with its score and the source sentence that justifies it, so a reviewer can trace every number to the record. Input: the coded interactions on the Contact ID plus your codebook. Output: a score-plus-evidence table per theme.

3 · Synthesize the whole record into one brief

With the record joined and coded, read one stakeholder's entire history into a single relationship brief — the Intelligent Row view of that person or organization. The brief states current status, key needs or commitments with the source sentence, open flags, and what changed since the last touch. Everything is cited to the record; nothing is inferred.

Synthesize this stakeholder's full record [RECORD] into a one-page relationship brief: current status, key needs or commitments with the source sentence, open flags, and what changed since the last touch — everything cited to the record, nothing inferred.

Expected output. A one-page brief with four blocks — status, needs and commitments, open flags, and change-since-last-touch — each line carrying the source sentence it came from. Input: the coded record on the Contact ID. Output: a cited one-page relationship brief.

GRADE: green | status + change-since-last-touch | every line cited to the record; amber | needs/commitments | coded but not yet verified with the stakeholder; red | open flags | inferred rather than drawn from a source sentence

Green is a brief where status and what-changed are each backed by a source sentence on the record. Amber is a coded need or commitment that has not yet been confirmed with the stakeholder. Red is any flag the model inferred without a sentence behind it — those get removed or traced before the brief is used.

4 · Keep the record first-party and reproducible

The record is only an asset if it can be trusted twice. Exclude sensitive fields from AI processing and run synthesis on anonymized IDs where the work requires it, and require every line of a brief to trace to a source sentence so the same run returns the same cited result rather than a fresh guess.

Re-run this synthesis excluding the sensitive fields [FIELD LIST] and using anonymized IDs. Confirm the output is reproducible from the record and flag any line that could not be traced to a source sentence.

Tricks, tips, and troubleshooting

A relationship without a record forgets what was said. The value is not any single interaction — it is the connected history on one ID. If you find yourself re-reading old threads to remember where a relationship stands, the record has not actually been built yet.

Keep score and sentence together. A theme score with no source sentence is an opinion; a source sentence with no code is unstructured text. The record earns its keep only when every number carries the words behind it.

Exclude sensitive fields and run on anonymized IDs. Where a record holds personal or protected information, keep those fields out of AI processing and synthesize on anonymized IDs, so the brief stays useful without exposing what should not be exposed.

Improve your synthesis accuracy with your own language. Point the Assistant at your program page or brief so it uses your framework and terms, not generic labels, when it codes and summarizes the record.

Read our program page [URL] and re-run the record synthesis using our own outcome and indicator language, so the brief speaks in our framework rather than generic terms.

Frequently asked questions

How do you build a relationship record?

Build a relationship record by attaching every interaction — survey, document, meeting note, check-in — to one persistent Contact ID for the stakeholder, instead of leaving them scattered across threads and spreadsheets. Map the qualitative signal to a codebook so a score and the source sentence behind it live together, then synthesize the whole record into a single one-page brief that cites everything to the record and infers nothing. In Sopact Sense the record is first-party and reproducible, so relationship intelligence is a durable asset rather than a mailbox of interactions you re-read from memory each time.

What is the difference between relationship intelligence and a CRM inbox?

A CRM inbox stores interactions as separate threads — emails here, meeting notes there, a survey somewhere else — so understanding a relationship means re-reading and re-remembering every time. Relationship intelligence joins all of it onto one Contact ID and codes the qualitative signal against a codebook, so the current status, open commitments, and what changed since the last touch can be read from one record with the evidence attached. The record remembers what was said; an inbox only holds where it was said.

How do you keep a relationship record safe and reproducible?

Keep a relationship record safe by excluding sensitive fields from AI processing and running synthesis on anonymized IDs where needed, and keep it reproducible by ensuring every line of a brief traces to a source sentence in the record rather than to an inference. Because Sopact Sense works over a first-party record, the same synthesis run twice returns the same cited result — so a relationship brief can be defended, not just generated.

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
Treating everything a stakeholder touches — applications, surveys, notes, follow-ups — as one connected record, analyzed the moment it arrives, so you can prove whether their situation improved.
Workforce & training · Youth & mentoring · Case management · Scholarships · Accelerators · Education · Nonprofit programs
What Is Grant Intelligence?
What Is Grant Intelligence?
what-is-grant-intelligence
Grant
Foundation
1
Scoring every submission on arrival and reading every grantee report the moment it lands — across qual, quant, financial, and social — so risk surfaces mid-grant and compliance is a by-product.
Foundations & grantmakers · Accelerators · Scholarships & fellowships · Nonprofit programs
What Is Portfolio Intelligence?
What Is Portfolio Intelligence?
what-is-portfolio-intelligence
Portfolio
Strategy
1
Rolling impact up live from every investee's own record — comparable, blended, and honest about thin data — so an aggregate portfolio figure is defensible on any given day.
Impact funds & investors · Foundations · DFIs & blended-finance vehicles
What Is Connected Data Intelligence?
What Is Connected Data Intelligence?
connected-data-intelligence
Feedback
Map
1
Connect evidence across forms, spreadsheets, CRMs, documents, notes, sites, languages, and reporting periods so quant, qual, and longitudinal data can be used together.
Multi-site programs, membership and chapter networks, nonprofits, funders, and impact teams with evidence scattered across systems
What Is Embedded Impact Measurement?
What Is Embedded Impact Measurement?
embedded-impact-measurement
Reporting
Align
1
Build impact measurement into Case, Grant, Portfolio, and Connected Data workflows—aligning organization outcomes, funder context, definitions, evidence, and decisions.
Program, impact, grant, MEL, and portfolio teams that need measurement to support learning and funding decisions
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 Do You Collect Feedback Offline and in the Field?
Collect Feedback Offline & in the Field
collect-feedback-offline
Feedback
Connect
2
Capturing stakeholder feedback where there's no connectivity and syncing each answer to one clean, identified 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 to Design a Fair Application and Selection Process
Design an Application Process
how-to-design-an-application-process
Grant
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 to Clean Open-Ended Survey Responses
Clean Open-Ended Responses at the Source
clean-open-ended-survey-responses
Feedback
Clean
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.
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 Analyze Multilingual Feedback?
Analyze Multilingual Feedback
analyze-multilingual-feedback
Feedback
Clean
4
Cleaning and theming multilingual open-ended feedback across languages on one 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 Handle Attrition in Longitudinal Studies?
Survey Attrition — Who Dropped Off
survey-attrition-longitudinal-studies
Feedback
Read
5
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 to Analyze Pre and Post Survey Data
Analyze Pre / Mid / Post Data
analyze-pre-mid-post-survey-data
Feedback
Read
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 Connect Quantitative and Qualitative Data?
Connect Quantitative & Qualitative Data
connect-quantitative-qualitative-survey-data
Feedback
Read
7
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 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 Analyze Longitudinal Survey Data?
Track One Person’s Change Across Years
analyze-longitudinal-survey-data
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 Long Do Program Outcomes Last?
Measure Drop-Off & Duration
measure-outcome-duration-drop-off
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 Do You Write an Impact Narrative for a Funder?
Write a Cited Impact Narrative
impact-narrative-funder-report-cited
Feedback
Prove
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 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 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
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 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 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 and Benchmark Investees?
Compare & Benchmark Investees
compare-benchmark-investees
Portfolio
Chapters
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
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