play icon for videos
← Academy
Sopact Academy · Measurement & reporting · Chapter 13

How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments

Someone has asked for a social return on investment figure, and you have decided a dollar value is worth the effort. The ratio is one division at the end; almost all the work, and all the trust, sits in the steps before it.

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> @keyframes pulseDot{0%,100%{opacity:1}50%{opacity:.35}} *{box-sizing:border-box} body{margin:0;font-family:'Hanken Grotesk',-apple-system,BlinkMacSystemFont,sans-serif;background:#EEF2F9;padding:26px;display:flex;justify-content:center} .card{width:600px;max-width:100%;background:#FFFFFF;border:1px solid #E3E9F4;border-radius:20px;box-shadow:0 26px 64px -32px rgba(15,30,70,.34),0 2px 4px rgba(15,30,70,.05);overflow:hidden} .hdr{display:flex;align-items:center;gap:11px;padding:16px 20px;border-bottom:1px solid #EEF1F7;background:#F5F8FE} .hdr .ic{display:inline-flex;width:30px;height:30px;align-items:center;justify-content:center;border:2px solid #155DFC;border-radius:50%;color:#155DFC;font-size:15px;font-weight:800;flex-shrink:0} .hdr .t{min-width:0} .hdr .t .n{font-weight:800;font-size:14.5px;color:#0F172A;letter-spacing:-.2px} .hdr .t .s{font-size:12px;color:#64748B} .hdr .pill{margin-left:auto;display:inline-flex;align-items:center;gap:6px;font-size:11.5px;font-weight:700;color:#155DFC;background:#E6EEFF;padding:5px 10px;border-radius:20px;white-space:nowrap} .hdr .pill .d{width:6px;height:6px;border-radius:50%;background:#155DFC;animation:pulseDot 2s infinite} .tabs{display:flex;gap:0;padding:12px 16px 0;background:#F5F8FE} .tab{flex:1;display:flex;flex-direction:column;align-items:center;gap:5px;cursor:pointer;font-family:inherit;font-size:11.5px;font-weight:700;color:#64748B;background:transparent;border:none;border-bottom:2px solid transparent;padding:8px 4px 10px} .tab.on{font-weight:800;color:#155DFC;border-bottom-color:#155DFC} .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:#64748B;background:#EEF1F7} .tab.on .num{color:#fff;background:#155DFC} .divider{height:1px;background:#EEF1F7} .body{padding:20px} .eyebrow{font-size:10.5px;font-weight:800;letter-spacing:1.2px;text-transform:uppercase;color:#155DFC;margin-bottom:5px} .eyebrow.g{color:#15884F} .headline{font-family:'Inter',Georgia,serif;font-size:18.5px;font-weight:600;line-height:1.25;color:#0F172A;margin-bottom:12px} .lede{font-size:12.5px;line-height:1.55;color:#475569;margin:0 0 14px} .rows{display:flex;flex-direction:column;gap:8px;margin-bottom:14px} .row{display:flex;align-items:center;gap:11px;background:#F5F8FE;border:1px solid #EEF1F7;border-radius:11px;padding:11px 13px} .row .emoji{font-size:17px} .row .rt{flex:1;min-width:0} .row .rt .n{font-size:13px;font-weight:700;color:#0F172A} .row .rt .s{font-size:12px;color:#64748B} .pillsm{font-size:11px;font-weight:800;color:#155DFC;background:#E6EEFF;padding:4px 9px;border-radius:6px;flex-shrink:0} .pillsm.gray{font-weight:700;color:#64748B;background:#EEF1F7} /* chain / timeline */ .chainwrap{position:relative;padding-left:26px} .chainline{position:absolute;left:8px;top:8px;bottom:8px;width:2px;background:#E3E9F4} .cnode{position:relative;margin-bottom:14px} .cdot{position:absolute;left:-26px;top:4px;width:16px;height:16px;border-radius:50%;background:#fff;border:3px solid #94A3B8} .clabel{font-size:9.5px;font-weight:800;letter-spacing:.5px;text-transform:uppercase;color:#64748B;margin-bottom:4px} .cbox{background:#F5F8FE;border:1px solid #EEF1F7;border-radius:11px;padding:10px 12px;font-size:12px;line-height:1.5;color:#334155} .cbox.graded{display:flex;align-items:flex-start;gap:9px;border-left-width:3px;border-left-style:solid} .cnote{margin:0 0 14px 4px;font-size:11px;line-height:1.5} .cnote .plus{display:inline-flex;width:16px;height:16px;align-items:center;justify-content:center;background:#155DFC;color:#fff;border-radius:4px;font-size:10px;font-weight:800;flex-shrink:0;margin-right:6px} .csummary{display:flex;align-items:center;gap:12px;background:#0A1B3D;border-radius:13px;padding:11px 15px;margin-top:4px} .csummary .t{flex:1;font-size:11.5px;color:#CBD8F5} .csummary .t b{color:#F1F5FF} /* matrix */ .mxwrap{border:1px solid #EEF1F7;border-radius:12px;overflow:hidden;margin-bottom:10px} .mxhead{display:grid;grid-template-columns:118px 1fr 1fr;background:#F5F8FE;border-bottom:1px solid #EEF1F7} .mxhead div{font-size:9px;font-weight:800;letter-spacing:.5px;text-transform:uppercase;color:#64748B;padding:7px 9px} .mxrow{display:grid;grid-template-columns:118px 1fr 1fr;border-bottom:1px solid #EEF1F7} .mxrow:last-child{border-bottom:none} .mxrow>div{padding:9px;font-size:11.5px;line-height:1.4;color:#334155;display:flex;align-items:center;flex-wrap:wrap;gap:5px} .mxrow .mxlabel{font-weight:700;color:#0F172A;background:#FAFBFE} .mxchip{font-size:9px;font-weight:800;letter-spacing:.3px;text-transform:uppercase;padding:3px 6px;border-radius:5px;white-space:nowrap} .promptwrap{padding:0 20px 18px} .promptlbl{font-size:10px;font-weight:800;letter-spacing:1px;text-transform:uppercase;color:#94A3B8;margin-bottom:7px} .prompt{display:flex;align-items:flex-start;gap:9px;font-family:ui-monospace,'SF Mono',Menlo,monospace;font-size:11px;line-height:1.5;color:#1E293B;background:#F5F8FE;border:1px solid #EEF1F7;border-left:3px solid #155DFC;border-radius:9px;padding:11px 12px} .prompt .car{color:#155DFC;font-weight:800;flex-shrink:0} .flagrow{display:flex;align-items:flex-start;gap:10px;background:#F5F8FE;border:1px solid #EEF1F7;border-radius:11px;padding:10px 12px;border-left-width:3px;border-left-style:solid;margin-bottom:8px} .flagtag{font-size:9.5px;font-weight:800;letter-spacing:.4px;text-transform:uppercase;padding:4px 8px;border-radius:5px;white-space:nowrap;flex-shrink:0} .flagtxt{font-size:12px;line-height:1.45;color:#334155} .lp{display:flex;align-items:center;gap:12px;background:#0A1B3D;border-radius:13px;padding:14px 16px;margin-top:6px} .lp .ic{display:inline-flex;width:34px;height:34px;align-items:center;justify-content:center;background:#14295C;border:1px solid #26407A;border-radius:9px;color:#7FA8FF;font-size:16px;flex-shrink:0} .lp .rt{flex:1;min-width:0} .lp .rt .n{font-size:13px;font-weight:800;color:#F1F5FF} .lp .rt .s{font-size:11.5px;color:#9DB2D9} .lp .open{font-size:11px;font-weight:800;color:#0A1B3D;background:#7FA8FF;padding:6px 11px;border-radius:7px;white-space:nowrap} </style> </head> <body> <div class="card"> <div class="hdr"> <span class="ic">&#128202;</span> <div class="t"> <div class="n">Investee SROI · SROI Ratio &amp; NPV</div> <div class="s">DEMO-07 · Sopact Sense · SROI Investee</div> </div> <span class="pill"><span class="d"></span>Calculating</span> </div> <div class="tabs" id="tabs"></div> <div class="divider"></div> <div class="body" id="body"></div> <div class="promptwrap"> <div class="promptlbl">The prompt behind this step</div> <div class="prompt"><span class="car">&gt;</span><span id="promptTxt"></span></div> </div> </div> <script> (function(){ var TABS = ["Setup", "Calculate", "Fix", "Report"]; var CONTENT = [{"eyebrow": "Step 1 · Load the dataset", "headline": "The input is your Decision Brief, nothing else", "lede": "Clean data with persistent contact IDs, loaded before any ratio gets computed.", "prompt": "You are the Sopact Sense Assistant working over the [DEMO] dataset (clean data + persistent contact IDs). Load my Decision Brief (decision, audience, outcomes, indicators, evidence standard) first, then wait for my task."}, {"eyebrow": "Step 2 · Compute ratio + sensitivity", "headline": "NPV, ratio, and a range — not one number", "lede": "Each line is graded <strong style=\"color:#15884F\">green</strong>, <strong style=\"color:#C9820A\">amber</strong>, <strong style=\"color:#C63E2B\">red</strong> — a single-point ratio without a sensitivity check stays amber.", "prompt": "From the value map for [PROGRAM], discount multi-year net values at [DISCOUNT_RATE], sum to PV, divide by inputs; sensitivity on top two assumptions ±[PCT]%. Grade green/amber/red."}, {"eyebrow": "Step 3 · One-fix follow-up", "headline": "Bound the ratio", "lede": "The lowest-graded element gets one realistic fix — the single edit that moves it toward green.", "prompt": "Take the lowest-graded element above and fix it using only what the program could realistically measure. Show the before → after grade and the single indicator/edit that moves it to green."}, {"eyebrow": "Step 4 · Missing & incomplete report", "headline": "Every gap becomes one named ask", "lede": "Every amber or red item becomes one named ask — the report leads with the decision it informs.", "prompt": "Create a 'missing & incomplete' report from this analysis in Sopact branding [or paste your website URL / brand guideline to apply your own]. List every element graded amber or red, what is missing, and the one input that fixes each. Lead with the decision this report informs."}]; var BODIES = { setup: "<div class=\"row\"><span class=\"emoji\">&#128202;</span><div class=\"rt\"><div class=\"n\">SROI Investee dataset</div><div class=\"s\">DEMO-07 · clean data + persistent contact IDs</div></div><span class=\"pillsm\">Loaded</span></div><div class=\"row\"><span class=\"emoji\">&#128203;</span><div class=\"rt\"><div class=\"n\">Decision Brief</div><div class=\"s\">Decision, audience, outcomes, indicators, evidence standard</div></div><span class=\"pillsm gray\">Structure</span></div><div class=\"row\"><span class=\"emoji\">&#128202;</span><div class=\"rt\"><div class=\"n\">Value map (from prior step)</div><div class=\"s\">REC-1042 — multi-year net values ready to discount</div></div><span class=\"pillsm gray\">Loaded</span></div>", build: "<div class=\"mxwrap\"><div class=\"mxhead\"><div></div><div>Value</div><div>Note</div></div><div class=\"mxrow\"><div class=\"mxlabel\">Present value of value</div><div>$2.1M<span class=\"mxchip\" style=\"background:#15884F;color:#fff\">GREEN</span></div><div>3% discount</div></div><div class=\"mxrow\"><div class=\"mxlabel\">Total inputs</div><div>$0.7M</div><div>incl. in-kind</div></div><div class=\"mxrow\"><div class=\"mxlabel\">SROI ratio</div><div>3.0 : 1<span class=\"mxchip\" style=\"background:#C9820A;color:#fff\">AMBER</span></div><div>range 2.4-3.6 under ±15%</div></div><div class=\"mxrow\"><div class=\"mxlabel\">Beyond year 1</div><div>—<span class=\"mxchip\" style=\"background:#C63E2B;color:#fff\">RED</span></div><div>no duration data</div></div></div>", fix: "<div class=\"mxwrap\"><div class=\"mxhead\"><div></div><div>Value</div><div>Note</div></div><div class=\"mxrow\"><div class=\"mxlabel\">Present value of value</div><div>$2.1M<span class=\"mxchip\" style=\"background:#15884F;color:#fff\">GREEN</span></div><div>3% discount</div></div><div class=\"mxrow\"><div class=\"mxlabel\">Total inputs</div><div>$0.7M</div><div>incl. in-kind</div></div><div class=\"mxrow\"><div class=\"mxlabel\">SROI ratio</div><div>±15% sensitivity run on proxy + attribution<span class=\"mxchip\" style=\"background:#15884F;color:#fff\">GREEN</span></div><div>range 2.4-3.6 under ±15%</div></div><div class=\"mxrow\"><div class=\"mxlabel\">Beyond year 1</div><div>—<span class=\"mxchip\" style=\"background:#C63E2B;color:#fff\">RED</span></div><div>no duration data</div></div></div><div class=\"cnote\" style=\"color:#15884F;margin-left:0\"><span class=\"plus\">+</span><strong>Fix applied:</strong> Run ±15% sensitivity on proxy + attribution</div>", reportFlags: "<div class=\"flagrow\" style=\"border-left-color:#C9820A\"><span class=\"flagtag\" style=\"color:#C9820A;background:#FBF0DA\">AMBER</span><div class=\"flagtxt\">SROI ratio — 3.0:1 is reported as a single point, with no sensitivity range yet run.</div></div><div class=\"flagrow\" style=\"border-left-color:#C63E2B\"><span class=\"flagtag\" style=\"color:#C63E2B;background:#FCE9E7\">RED</span><div class=\"flagtxt\">Beyond year 1 — no duration data exists to value multi-year impact.</div></div>", lpTitle: "Missing & incomplete report · shareable link", lpSub: "Decision-first · Sopact branding · Investee SROI · SROI Ratio & NPV", summaryBefore: "Grade: 1 green &middot; 1 amber &middot; 1 red. A ratio with no range yet.", summaryAfter: "Grade: 2 green &middot; 0 amber &middot; 1 red. A range, not one number." }; var phase = 1; var tabsEl = document.getElementById('tabs'); var bodyEl = document.getElementById('body'); var promptEl = document.getElementById('promptTxt'); function renderTabs(){ tabsEl.innerHTML = ''; TABS.forEach(function(label, i){ var b = document.createElement('button'); b.type = 'button'; b.className = 'tab' + (i === phase ? ' on' : ''); b.innerHTML = '<span class="num">' + (i+1) + '</span><span>' + label + '</span>'; b.addEventListener('click', function(){ phase = i; render(); }); tabsEl.appendChild(b); }); } function renderBody(){ var c = CONTENT[phase]; var eyebrowClass = (phase===2) ? 'eyebrow g' : 'eyebrow'; var out = '<div class="' + eyebrowClass + '">' + c.eyebrow + '</div><div class="headline">' + c.headline + '</div><p class="lede">' + c.lede + '</p>'; if (phase === 0) { out += '<div class="rows">' + BODIES.setup + '</div>'; } else if (phase === 1) { out += BODIES.build; out += '<div class="csummary"><div class="t"><b>' + BODIES.summaryBefore + '</b></div></div>'; } else if (phase === 2) { out += BODIES.fix; out += '<div class="csummary"><div class="t"><b>' + BODIES.summaryAfter + '</b></div></div>'; } else { out += BODIES.reportFlags; out += '<div class="lp"><span class="ic">&#128196;</span><div class="rt"><div class="n">' + BODIES.lpTitle + '</div><div class="s">' + BODIES.lpSub + '</div></div><span class="open">Open &rarr;</span></div>'; } bodyEl.innerHTML = out; promptEl.textContent = c.prompt; } function render(){ renderTabs(); renderBody(); } render(); })(); </script> </body> </html>

Academy / Measurement & reporting

Chapter 13 of 13 · Toolkit, any time · optional · About 20 minutes

How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments

Someone has asked for a social return on investment figure, and you have decided a dollar value is worth the effort. The ratio is one division at the end; almost all the work, and all the trust, sits in the steps before it.

Academy / Measurement & reporting

Course progress and additional readings
Measurement & reporting

You will learn: how to build a value map, choose and record a financial proxy, adjust for deadweight, attribution, displacement and drop-off, discount future years, calculate the SROI ratio and test which assumptions change it.

Who this is for: both roads, and it is optional. Funders or funded partners who have read when a dollar value is worth it and decided it is. Bring your outcomes, the evidence behind them, and what the work cost, including time and goods that were given rather than bought.

What is the SROI ratio, and which number should you report?

In short: the SROI ratio is the present value of adjusted outcomes divided by the present value of inputs. Two related numbers, net present value and the net SROI ratio, measure something different, so name the one you report.

THREE CALCULATIONS · KEEP THEM APART

SROI ratioPresent value of adjusted outcomes ÷ present value of inputs
Net present valuePresent value of adjusted outcomes − present value of inputs
Net SROI ratioNet present value ÷ present value of inputs

Social Value International's Guide to SROI sets out the full sequence, from scope and stakeholders through valuation, adjustments, calculation and reporting. It also separates an evaluation of outcomes that have happened from a forecast of expected ones. Label which you are doing, and never let forecast value appear as an achieved result.

A ratio of 1.48:1 means an estimated 1.48 units of social value for each unit invested, under stated scope and assumptions. It does not mean anyone receives 1.48 in cash.

How do you build an SROI value map?

In short: one row per outcome, linking the stakeholder, the change, its evidence, its value and the adjustments, with the inputs and boundary written above. A row you cannot value yet stays on the map; it is not zero.

The SROI Guide calls this the Impact Map; many teams call it a value map. Start with the boundary: the activity, period, stakeholders, purpose, and the resources put in for that scope. Do not divide a whole program's benefits by one funder's grant.

Write outcomes before you look for any price. "Attended training" is an output; "kept a job for a year" is an outcome. Social Value International's guidance on understanding what changes includes intended and unintended, positive and negative changes, and its principles call for involving stakeholders. Keep a harm on the map even when you cannot price it.

Part of the mapWhat to record
Scope and inputsActivity, period, purpose, stakeholders, resources put in, including non-cash ones
Outcome and evidenceStakeholder, change, indicator, quantity, period, source
ValueFinancial proxy, unit, source, year, why it fits
AdjustmentsDeadweight, attribution, displacement, duration and drop-off, each with a reason
ReviewStatus, owner, open questions, formula, date approved

ONE VALUE MAP ROW · FICTIONAL EXAMPLE

StakeholderPeople placed in a job by Partners A, B and D of the workforce fund
OutcomeHigher earnings from steady work
IndicatorRetained at 12 months; hourly wage gain over wage before enrollment
Quantity100 placed within 90 days; 12-month retention not yet reported
ValueObserved wage gain from the fund's own records, once wage before enrollment is collected
StatusNot yet valued: needs wage before enrollment, hours and retention

Split a row when it mixes stakeholders or units, such as participant earnings and employer hiring costs. Then check whether two rows describe the same change; "less financial stress" and "better wellbeing" may overlap, and adding both counts it twice.

How do you choose a financial proxy?

In short: a financial proxy is a dollar approximation of an outcome's value. Choose one that matches the outcome, stakeholder, unit, place and year, keep the original figure and any conversion, and write down why. If nothing fits, leave the row unvalued.

Start with a one-line specification: "We want to value [change] for [stakeholder], measured in [unit] over [period], for [decision]." Social Value International's guidance on valuing the things that matter puts stakeholders' own view of importance at the center.

Look first at your own before-and-after records, then official statistics, peer-reviewed valuation studies and established resources with open methods. The UK Treasury's Green Book explains market and non-market methods, and its wellbeing guidance covers when wellbeing can be valued. They are UK appraisal references, not a list of proxies to transplant elsewhere.

Proxy recordWhat to check
Outcome and stakeholderThe exact change valued, and whose view it represents
Source and methodOriginal publication, passage, method, limits
Unit and periodPer person, event, hour or year; over what window
ContextPopulation, place, currency, price year
Adjustments and overlapAny conversion and why; what the value already includes
DecisionWhy chosen, alternatives rejected, reviewer, date

Read the units aloud before multiplying. People times a value per person-year is not people times a value per event. And do not replace a missing outcome with a related cost: a lower debt balance is not the value of less financial stress, and a typical annual wage is not the gain your graduates made.

How do deadweight, attribution, displacement and drop-off change the value?

In short: each removes a different part of the gross value that was not caused by the work. Apply them one after another to what remains, write down what each means, and never apply the same one twice.

AdjustmentQuestion it answersWorkforce example
DeadweightWhat would have happened anyway?Some trainees would have found similar work alone
AttributionHow much is due to others?A job center or family also helped
DisplacementDid the outcome push another one out?A graduate filled a job another local jobseeker would have taken
Drop-offHow much does the effect fade each year?Fewer graduates in the same job in year two

Now a teaching calculation. All figures are invented to show the arithmetic; they are not the workforce fund's results or recommended rates. Take 10 outcome units, each valued at 1,000 currency units a year: gross first-year value 10 × 1,000 = 10,000. Assume 20% deadweight, 25% attribution, and zero displacement, stated openly for teaching; zero should never be an automatic setting.

Adjusted year-one value = 10,000 × (1 − 0.20) × (1 − 0.25) = 6,000. The percentages apply one after another to what remains, not as a combined 45% off the original, which would give 5,500.

How do you discount future years and calculate the ratio?

In short: lay out each year's adjusted value, apply drop-off, divide each year by (1 + discount rate) raised to the year number, add them up, and divide by the present value of inputs.

Assume the outcome lasts three years with 10% drop-off after year one: 6,000, then 5,400, then 4,860. Inputs of 10,000 are spent at the start (year zero), and benefits arrive at each year-end. The 5% discount rate is for teaching only; for a real analysis, choose and document the rate your purpose and governing guidance call for.

YearAdjusted valueCalculationPresent value
16,0006,000 ÷ 1.055,714.29
25,4005,400 ÷ 1.05²4,897.96
34,8604,860 ÷ 1.05³4,198.25
Total16,260Sum of unrounded values14,810.50

SROI ratio = 14,810.50 ÷ 10,000 = about 1.48:1. Net present value = 14,810.50 − 10,000 = 4,810.50, so the net SROI ratio is about 0.48:1. Keep full precision in the worksheet and round only what you display.

A sentence a reader can check: "In this three-year model, adjusted outcomes have a present value of about 14,811 against inputs of 10,000, a ratio of 1.48:1 under the stated value, contribution, duration and timing assumptions." Put the assumptions beside it.

A Sopact explainer on the SROI formula and how to read the ratio. Watch for how the numerator and denominator are defined; its figures are illustrations, not proxies to reuse. Watch on YouTube ↗

Which assumptions change the answer?

In short: change one assumption at a time and watch the ratio. The assumption that moves it most is the one that needs the best evidence, and the one to report plainly.

Teaching scenarioChange from the central modelSROI ratio
CentralThree years, original assumptions1.48:1
One yearOnly year one counted0.57:1
Two yearsYears one and two counted1.06:1
Lower proxyValue per unit 25% lower1.11:1
Higher proxyValue per unit 25% higher1.85:1
Higher deadweight40% instead of 20%1.11:1

Here, duration decides whether the ratio is above 1. That raises a practical question, what evidence shows the outcome lasts past year one, and it never justifies stretching duration until the number looks good. For the workforce fund, that evidence is 12-month retention. A low-to-high range of scenarios is not a statistical confidence interval.

Ask a colleague to rebuild the example without seeing your total. They should get 14,810.4956 for the present value of outcomes and about 1.48105 for the ratio. If not, check year numbering, what each percentage means, rounding, and whether an input was subtracted twice.

ASK ANY TOOL, INCLUDING OURS

Paste your value map into any AI tool and ask: "Recalculate each row and the ratio from these inputs, show every step, and tell me which assumption moves the ratio most. Do not fill any blank cell." In Sopact Sense, the outcome counts behind each row come from records that one ID per person keeps connected, and each answer from the AI Assistant links to the records you can open.

What can an SROI ratio not tell you?

In short: a ratio above 1 does not prove cause, savings or good value for money on its own, and a ratio below 1 does not prove the work failed.

The ratio covers only the outcomes you could value, under your assumptions. Harms and outcomes without a fair proxy sit outside it. Report it with the value map, the sensitivity table and a plain list of what was left out, and trace each count to its source.

Try it on your own reporting

  1. Write the boundary: activity, period, stakeholders, purpose and inputs.
  2. List outcomes with the people affected, including any harm, before you look up any value.
  3. For one outcome, fill the proxy record, or mark it "not yet valued".
  4. Apply deadweight, attribution, displacement and drop-off, one after another, with a reason for each.
  5. Discount each year, calculate the ratio, then run the one-year and lower-proxy scenarios.
Check your reasoning

For the fictional workforce fund, the boundary is Partners A, B and D, the 100 people they placed within 90 days, and the fund's grants plus any donated employer time as inputs. The earnings row stays "not yet valued" until wage before enrollment, hours and 12-month retention are collected. Deadweight needs evidence such as earlier cohorts; displacement needs a view of the local job market. The sensitivity test will likely show duration matters most, which points straight back to 12-month retention.

Questions teams ask

What is a good SROI ratio?

There is no benchmark that makes a ratio good in itself. Two analyses with different boundaries, proxies and adjustments cannot be compared by their ratios alone. A ratio is useful when the reader can see the value map and the sensitivity tests behind it, and when it informs a decision within one analysis, such as choosing between two designs valued the same way.

What discount rate should we use?

Use the rate required or recommended by the guidance that governs your decision, such as a government appraisal rule, and record why. The 5% on this page is a teaching figure. Treat prices and inflation consistently, and include the rate in your sensitivity tests if the choice is uncertain.

Can we leave out an outcome we cannot value?

You can leave it out of the ratio, but not out of the report. Keep it on the value map as "not yet valued", describe it with its count and evidence, and say how its absence might change the reading. This matters most for harms: a positive ratio with a known harm left unmentioned misleads.

Should inputs include volunteer time and donated goods?

Where they are part of the scope, yes, with a documented way of valuing them. Counting only the grant while valuing everything the program achieved makes the ratio look better than it is. If inputs arrive in later years, discount them the same way as outcomes.

Put this guide into practice.

Bring your value map. Check each proxy, adjustment and the ratio with a colleague.

Explore Impact Measurement →
Prepare Data Governance Before Using AI
Prepare your data governance
nonprofit-data-governance-before-ai
Feedback
Foundation
Prepare an evidence register and a tested governance baseline before applying AI to program data.
How to Turn Findings into Action and Check What Changes
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.
For growing data collection, connected analysis and recurring reporting
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
Connected Data Intelligence
Understand the approach
connected-data-intelligence
Feedback
Foundation
1
Connect recurring collection, relevant history, AI analysis, and governance in a workflow your team can maintain.
Growing organizations managing recurring data collection without a dedicated data team.
Measurement and Reporting: From Agreement to Evidence-Based Report
Measurement and reporting: from agreement to report
embedded-impact-measurement
Reporting
Start here
1
Turn the onboarding call into a reporting agreement, share one data dictionary, and write reports funders can compare and check.
For funders and the organizations they fund
Connect company context before collecting another return
Connect context
track-investees-impact-agreement-variance
Portfolio
Portfolio intelligence tools
1
Build a repeatable collect, review and improve cycle
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.
Agree the theory of change and core metrics on the onboarding call
Agree measures
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Portfolio intelligence tools
2
Test whether an AI-assisted result is repeatable and correct
Reliability — test repeatability and accuracy
loop-reliability
Loop
The method
2
Test repeatability and accuracy using versioned data, defined calculations, known-answer checks and human review of qualitative interpretation.
Teams that need to check recurring AI-assisted analysis before using it in decisions or reports.
Design an application process around the decision, not the form
Design an Application Process
how-to-design-an-application-process
Grant
Foundation
2
How to Structure Stakeholder Data: Four Common Patterns
Choose your record structure
which-shape-is-your-data
Feedback
Foundation
2
Map the people, observations and relationships your workflow needs before collecting data.
Turn the onboarding call into a reporting agreement
Turn the onboarding call into a reporting agreement
onboarding-call-to-reporting-agreement
Reporting
Agree together
2
How to build a theory of change, then show it as a logic model, logframe or results framework
How to build a theory of change, then show it as a logic model, logframe or results framework
how-to-build-a-theory-of-change
Reporting
Agree together
3
How to Build a Logic Model: Steps, Example and AI Prompt
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
Turn your theory of change into a data-collection plan
Turn a Theory of Change into a Data-Collection Workflow
theory-of-change-to-data-collection-workflow
Case
Foundation
3
Run quarterly collection around each company's dictionary
Collect quarterly
collect-investee-reporting-without-burden
Portfolio
Portfolio intelligence tools
3
Keep a clear trail from a finding to its evidence
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.
Build Context: What Your AI Needs to Know
Build context
build-organization-evidence-model
Feedback
Foundation
3
How to Change Survey Questions Without Losing Comparability
Change questions with a clear history
change-questions-without-breaking-the-record
Feedback
Control
3
Create a question-change log and decide how old and new versions should appear in reports.
Programme & MEL leads · Teams whose questionnaire has ossified · Anyone evaluating a platform where configuration is a purchased service
Five Dimensions of Impact: How to Review Your Evidence
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
Review impact and financial evidence before it reaches the dashboard
Review and approve
read-investee-reports-multi-signal
Portfolio
Portfolio intelligence tools
4
Adapt the learning cycle to your workflow
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 to Collect Feedback Offline and Track the Same People Over Time
Collect offline and reconcile the batch
collect-feedback-offline
Feedback
Connect
4
Build a field protocol and reconcile a test batch across devices, visits and delayed uploads.
Field & multi-site programs · Low-connectivity contexts · Teams 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
Turn a proposed outcome into a reporting definition
Outcomes vs Outputs
frame-outcomes-over-outputs
Grant
Foundation
5
Plan and review your first workflow pilot
Plan and review your first workflow pilot
loop-guarantee
Loop
The method
5
How to Analyze Documents as Evidence: Sources, Context and Review
Read documents as traceable evidence
read-documents-as-evidence
Feedback
Connect
5
Create a document register and reviewed findings with source locations, context and explicit exceptions.
Check each partner report against the agreement
Check each partner report against the agreement
check-partner-reports-against-agreement
Reporting
Funder road
5
Combine compatible metrics and explain every portfolio total
Build rollups
portfolio-impact-rollups
Portfolio
Portfolio intelligence tools
5
How to Clean Open-Ended Survey Responses Without Losing Meaning
Clean responses and define the denominator
clean-open-ended-survey-responses
Feedback
Clean
6
Create a cleaning log, response-status table and reproducible report statement.
How to Review Participant Support Needs 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
Personalize quarterly donor and annual LP reports
Report with evidence
portfolio-lp-board-impact-report
Portfolio
Portfolio intelligence tools
6
How to Build a Funder Context Profile: Research to Reporting
Build a Sourced Funder Context Profile
build-funder-context-profile
Reporting
Align
6
Roll up and benchmark portfolio results
Roll up and benchmark portfolio results
roll-up-and-benchmark-portfolio-results
Reporting
Funder road
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
Turn portfolio findings into action and test the next cycle
Act and improve
portfolio-risk-monitoring-alerts
Portfolio
Portfolio intelligence tools
7
How to Analyze Multilingual Feedback Without Losing Meaning
Analyze and review multilingual feedback
analyze-multilingual-feedback
Feedback
Clean
7
Build a language review sheet and test software on original responses, translations, codes and reporting bases.
Multi-country programs · Multilingual survey data · Global networks & chapters
How to Define Impact Metrics Your Team and Funder Can Use
Define Measures the Organization and Funder Can Both Use
define-impact-metrics-funders-want
Reporting
Align
7
Write the portfolio report for your board or donors
Write the portfolio report for your board or donors
write-the-portfolio-report
Reporting
Funder road
7
Survey Attrition: How to Track Missing Waves in Longitudinal Studies
Track missing waves and matched outcomes
survey-attrition-longitudinal-studies
Feedback
Read
8
Build a wave-status register, compare response groups and report paired change with coverage and limitations.
How to Use Mentor Notes to Review Participant Support
Use mentor notes for support review
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
Impact Metric Definitions: A Practical Worksheet and Example
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
8
Map every funder's ask to one evidence base
Map every funder's ask to one evidence base
turn-reporting-requirements-into-evidence
Reporting
Funded partner road
8
How to Connect Quantitative and Qualitative Survey Data
Connect scores and comments
connect-quantitative-qualitative-survey-data
Feedback
Read
9
Build a linked analysis view and joint display, with clear groups, reporting bases and evidence limits.
How to Calculate SROI as New Evidence Arrives
Calculate SROI — Live, Sourced, and Honest
calculate-sroi-live
Case
Nonprofit Track
9
How to Collect Grantee Reports with Less Burden
Collect Grantee Reports Without Burden
collect-grantee-reporting-without-burden
Grant
Collect
9
Capture each funder's taste, and your own
Capture each funder's taste, and your own
capture-funder-taste
Reporting
Funded partner road
9
How to Analyze Pre, Mid and Post Survey Data
Analyze pre, mid and post surveys
analyze-pre-mid-post-survey-data
Feedback
Read
10
Build a matched pre/mid/post analysis, interpret score movement and retain clear rules for missing waves.
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 to Follow Up on Missing Grantee Data
Chase Missing Grantee Data
chase-missing-grantee-data
Grant
Collect
10
How to Collect Clean Data Inside Your Workflow
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
Write each funder's report with AI, then check it
Write each funder's report with AI, then check it
assistant-writes-the-funder-report
Reporting
Funded partner road
10
Draft from approved sources, check the claims, and save an accountable report version. Bring the brief from the previous lesson.
Program managers, grant leads and reporting teams
How to Analyze Longitudinal Survey Data
Analyze longitudinal survey data
analyze-longitudinal-survey-data
Feedback
Read
11
Build a continuing analysis record with clear time scales, observed trajectories and limits.
How to Turn a Job Description into a Requirements Checklist
Clarify employer requirements
job-description-requirements-checklist
Case
Social Enterprise Track
11
Review applications without reviewer bias: one rubric, read on arrival, people decide
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
How to Keep Impact Reporting Numbers Consistent
Get Stable Results From Governed Data
same-numbers-every-time
Reporting
Read
11
Compare your results with outside data: live queries and public datasets
Compare your results with outside data: live queries and public datasets
compare-with-outside-data
Reporting
Toolkit
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 to Measure Outcome Duration and Drop-Off
Measure outcome duration and drop-off
measure-outcome-duration-drop-off
Feedback
Read
12
Build a dated outcome claim, distinguish missingness from outcome loss and test forecast assumptions.
How to Score Candidate–Role Matches with a Clear Rubric
Review candidate–role evidence
score-candidate-role-matches-without-bias
Case
Social Enterprise Track
12
Make every number in your report match its source
Make every number in your report match its source
where-every-number-came-from
Reporting
Toolkit
12
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 to Write a Donor Report: Format, Evidence and Example
Design a Report for a Real Funding Decision
donor-report-funders-trust
Reporting
Decide
13
Build a report brief and claim-and-evidence table before drafting. Explain delivery, outcomes, spending, limitations and next actions.
Program managers, grant leads and reporting teams
How to put a credible dollar value on your results
How to put a credible dollar value on your results
credible-dollar-value-on-impact
Reporting
Toolkit
13
Prepare a valuation brief. Decide what the evidence supports, what needs more work, and when an outcome account is enough.
Program, evaluation and investment teams considering social-value estimates
AI Data Access Controls: What Your Assistant May See
Control what the assistant can access
what-the-assistant-may-see
Feedback
Prove
13
Define task-specific access, test synthetic records and verify report-sharing boundaries.
How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments
How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments
how-to-calculate-the-sroi-ratio
Reporting
Toolkit
14
Build a reproducible SROI calculation, test its assumptions and explain the result in a reviewed report.
Evaluation and reporting teams reviewing an SROI calculation
How to Write an Evidence-Based Impact Narrative for a Funder Report
Write a cited impact narrative
impact-narrative-funder-report-cited
Feedback
Prove
14
Build and check a report paragraph using a claim-and-source table, appropriate quotations and clear limitations.
How Do You Read a Grantee Report?
Read a Grantee Report
read-grantee-report-multi-signal
Grant
Analyze
14
How Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
Keep a person’s history connected across programs and staff changes
Follow one person over time
one-person-followed-for-years
Feedback
Shapes
15
Build a participant record that preserves episodes, dates, versions and missingness across repeated collection.
How Do You Build an SROI Value Map?
Build an SROI Value Map
how-to-build-an-sroi-value-map
Reporting
Optional method
16
Build a first value map, keep missing evidence visible, and give each unresolved outcome a next action.
Evaluation, program and investment teams preparing an SROI analysis
How do you track budget, invoices and actual spend for a grant?
Track Budget vs Actual Spend
how-to-track-budget-invoices-actual-spend
Grant
Analyze
16
Multi-Rater Feedback: Connect Perspectives and Protect Context
Connect several perspectives on one person
several-people-describing-one-person
Feedback
Shapes
16
Design subject-rater relationships, reporting rules and a tested multi-perspective feedback record.
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
Compare candidate valuation sources and document why one fits your outcome, stakeholder and reporting period.
Evaluation and reporting teams selecting financial proxies
How Do You Analyze Grantee Reporting Longitudinally?
Analyze Grantee Reporting Over Time
analyze-grantee-reporting-longitudinal
Grant
Analyze
17
Cross-Program Reporting: Combine Results Without Losing Meaning
Combine evidence across programs
many-programs-one-picture
Feedback
Shapes
17
Build a defensible cross-program result with comparable measures, correct denominators and documented exclusions.
How to read Form 990 for a grant review
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
Pick One Question. Keep Every System You Have.
Run a member-network survey
member-network-survey
Feedback
Shapes
18
Design and test a member reporting cycle with continuing records, coverage checks and authorized results.
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 build a grant audit trail?
Build a Grant Audit Trail
grant-audit-compliance-trail
Grant
Communicate
20
How do you produce grant compliance and regulatory 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