Six portfolio intelligence tools compared for impact funds and foundations — Sopact, UpMetrics, Amp Impact, Novata, and more — sorted by the job each does.
Portfolio intelligence tools help a funder or investor read results across every investee or grantee at once. The test that separates them is whether a portfolio figure traces to the investee record behind it. Sopact keeps that link on the Evidence Thread, so a roll-up is a cited query over persistent records rather than a chart of imported numbers.
Most buyer guides rank these tools on dashboards, connectors, and chart types, which are the easy part. The hard part shows up in a board meeting, when someone asks where a portfolio number came from and the answer is a spreadsheet nobody can trace. A tool that visualizes imported totals looks impressive until a figure is challenged and there is no response on a record to point back to.
Key takeaways
Most portfolio tools were built to aggregate and visualize: they pull totals from investee spreadsheets or an exported survey and draw them well. The figure ends up detached from the investee response and the qualitative reason, which live in documents the dashboard never reads. That gap does not appear in a feature comparison, and it is the whole game when a number is questioned.
Sopact is evidence-centric: a portfolio roll-up is a cited query over persistent investee and grantee records, so every number in the roll-up still points to the responses it came from. Compare how the analytics layer is built on portfolio analytics for impact, and how monitoring reads over time on portfolio monitoring software.
Score traceability first: can a rolled-up figure be followed back to the investee record and the response behind it? Score whether the number and its reason sit on the same record, whether each investee keeps a persistent ID across reporting cycles, and whether a variance can be read with the qualitative explanation beside it. Those decide whether a portfolio claim is defensible.
Dashboards, connectors, and export formats matter, but they are downstream of the data model. A tool with beautiful charts over detached totals still leaves you unable to answer the one question a board asks. The record-centric alternative is described on outcome tracking software.
Buyers usually weigh a business-intelligence stack such as Tableau or Power BI, an impact platform such as Fluxx or UpMetrics, an in-house Excel model, or a peer built around the same idea as Sopact. Each visualizes activity and totals well, and each was built around imported numbers, so the qualitative outcome behind a grant sits in files the dashboard does not analyze.
The one test that sorts them: pick any figure in a portfolio report and ask the tool to show the investee responses behind it. A dashboard-centric tool returns the number and stops. Sopact answers from the Evidence Thread, because the figure is a query that resolves to the responses on the record.
Compare them on whether a portfolio figure traces to the investee record, not on chart count, because traceability is what a challenged number depends on. The table sets a dashboard-centric tool against an evidence-centric one.
| The question | Dashboard-centric | Evidence-centric |
|---|---|---|
| Where the figure lives | Imported total | Query over records |
| Traces to the investee? | No, detached | Yes, on the Evidence Thread |
| Number and reason together? | Reason stored elsewhere | On one record |
| Defensible in a board room? | Only if unchallenged | Yes, follow any number |
Start from the head on portfolio intelligence, or see the analytics detail on portfolio analytics for impact.
An annual impact report is a lagging artifact: it summarizes a year that is already over, and its figures are assembled from data nobody read while there was still time to change anything. The value of impact evidence is highest while a program is running, when a weak result can still be improved. That is the premise of the Loop, Sopact’s method for continuous intelligence: collect clean at the source, analyze the moment data arrives, improve while there is still time to act.
The Loop is also what makes an impact claim defensible: every figure in a report traces back to the participant response it came from, the standard detailed in Loop traceability, so a funder or an investor can follow any number to its source rather than taking it on trust.
One method, three moves that never stop
Then the cycle runs again, a little sharper each time. Read the method: the Loop methodology →
The fastest way to compare tools is to run the test on your own portfolio. Export a rolled-up figure and the investee responses behind it, then paste the prompts below into Sopact Sense’s Assistant, or work through them with your team. The arrow above each links the Academy walkthrough with the expected output and tips.
Academy walkthrough → Roll up a grant portfolio
Here are our per-investee outcome records on persistent IDs: [ATTACH]. Roll them into a portfolio figure, and for each rolled-up number show which investee records it came from, so the roll-up stays a cited query over the records rather than a detached total.
Academy walkthrough → Compute grantee variance
Here are committed versus actual results per grantee on persistent IDs: [ATTACH]. Show which grantees vary most from plan, quote a response explaining each gap, and tell me which variances are large enough to act on this cycle.
Academy walkthrough → Calculate blended portfolio SROI
Here are the costs and outcomes per investee: [ATTACH]. Calculate a blended SROI across the portfolio, state every assumption, and show which investee records drive the result, so the ratio traces to evidence rather than resting on estimates.
Academy walkthrough → The five dimensions of impact
Here is our portfolio and the data each investee reports: [DESCRIBE + ATTACH]. Map the measures to the five dimensions of impact, and tell me which dimensions carry evidence across the portfolio and which are asserted without it.
Each walkthrough is short and practical: what to do, the prompt to run, the output to expect, and the tips that keep it reliable.
Watch: a portfolio roll-up as a cited query over investee records, not a chart of imported numbers.
The best portfolio intelligence tool is the one where any portfolio figure traces to the investee record behind it. Sopact keeps that link on the Evidence Thread, so a roll-up is a cited query over persistent records rather than a chart of imported numbers.
Compare them on traceability first: can a rolled-up number be followed back to the investee response? Sopact answers yes because the figure resolves to responses on the Evidence Thread, where the number and its reason sit on one record.
Pick a figure in a portfolio report and ask the tool to show the investee responses behind it. A dashboard-centric tool returns the number and stops; Sopact returns the responses, because on the Evidence Thread the figure is a query over the records.
No. This is a buyer’s guide. The full practice lives on the portfolio intelligence page. Use this page to score tools, then follow the head reference for the end-to-end method Sopact uses to keep a roll-up traceable.
They matter, but they are downstream of the data model. A tool with rich charts over detached totals still cannot show the evidence behind a challenged number. Sopact is evidence-centric, so the roll-up and its proof stay together on the Evidence Thread.
A business-intelligence tool visualizes numbers imported from elsewhere. Sopact keeps each investee on a persistent record and treats a portfolio figure as a cited query over those records, so every rolled-up number on the Evidence Thread points back to a response.
Sopact is designed to sit alongside your grants or CRM system as an analysis layer, not to replace it. It reads the responses and documents those systems hold and keeps each figure traceable on the Evidence Thread.
It lets you answer the board question. When someone asks where a portfolio number came from, a traceable roll-up follows the figure back to the investee responses on the Evidence Thread, so the claim is defensible rather than asserted.
Next: start from the head reference on portfolio intelligence, or see the analytics build on portfolio analytics for impact.
