Charity Impact Dashboards and Reports

CHARITY ANALYTICS · IMPACT DASHBOARDS & REPORTS · 2026

Charity impact dashboards and impact reports are how UK charities show what their work actually changes for the people they serve — not just what they did, but what shifted, for whom, and at what cost. Quematics builds both: live dashboards for internal decision-making and public-facing evidence, and beautifully designed impact reports that turn the same data into the annual story trustees, funders, and donors read. We work with UK charities of every size, from single-programme community charities to national VCSE organisations delivering NHS-commissioned services.

Impact is now the language of the sector. Grant makers rank on it, NHS Integrated Care Boards contract on it, the new Charities Statement of Recommended Practice (SORP 2026) requires an evidenced impact narrative in every trustees’ annual report, and the general public increasingly expect it before they give. The charities being talked about in 2026 — from Ellen MacArthur Cancer Trust’s live public dashboard to Moorfields Eye Charity’s annual reports — are increasingly the ones that have stopped counting activity and started measuring change.

This page sets out what a genuinely good charity impact dashboard looks like, what a genuinely good impact report looks like, how the two work together, and how we build them for UK charities and VCSE organisations. It is a long read because impact reporting is a real subject and the shortcuts do not survive first contact with a serious funder.

What a great charity impact dashboard actually looks like

A charity impact dashboard is a live, filterable view of the outcome data your services generate — not a static PDF, not a monthly slide deck, but an always-current, always-explorable evidence base your team can open on any morning. Done properly, it does five things at once: it shows how a programme is performing right now, it lets a manager slice the data by cohort or geography or funder, it produces the evidence base for external reports, it flags problems while there is still time to act on them, and it demonstrates governance to your board and regulators.

Below is what a working charity impact dashboard looks like in outline. Every number is illustrative; the layout, the tiles, and the filter logic are what we build for real.

Every element on this dashboard is doing work. The four headline tiles answer the questions a CEO or trustee asks first — how many, how well, at what cost, and what value did we create. The main chart shows outcomes trending month by month, so a manager can see whether the last quarter is stronger or weaker than the last year. The equity panel shows outcomes broken down by index of multiple deprivation decile — the analysis funders and ICB commissioners now expect. And the footer names the data sources, because a dashboard without provenance is an anecdote with a colour scheme.

What is Power BI, and why we build charity impact dashboards in it

Because the phrase “Power BI dashboard” appears a lot on this page, it is worth explaining in plain English what Power BI actually is — and being honest about when it is right and when it is not.

Power BI is Microsoft’s data analytics tool. It does one thing very well: it takes data from lots of different places — spreadsheets, case management systems, survey platforms, financial software — and turns it into live, interactive dashboards you can open in a web browser or embed on your own website. Users can filter, drill down, and export without touching the underlying data. Behind the scenes, Power BI refreshes those connections on a schedule you set (typically daily), so the numbers on screen are always current.

Three reasons we recommend Power BI for UK charities specifically. First, cost: Microsoft’s nonprofit programme provides substantially discounted Power BI licences to eligible registered charities — Power BI Pro at around $4.20 per user per month on annual commitment, against roughly £11 commercially — so ongoing running costs are modest for most organisations. Second, compatibility: Power BI genuinely connects to the systems UK charities already use — Charitylog, Lamplight, Beacon, Salesforce Nonprofit Cloud (NPSP), SystmOne, EMIS, Excel — without demanding you migrate off any of them. Third, security: Power BI runs on Microsoft Azure infrastructure with UK-region hosting available, role-based access, and audit logging, which meets the standards NHS commissioners and local authorities now require at bid stage.

What Power BI is not: it is not the only option. Tableau, Google Looker Studio, Qlik, and a well-designed Excel workbook can all do similar work. What Power BI is also not: it is not a substitute for the underlying evidence framework. A dashboard tool without a theory of change, validated outcome measures, and a data collection discipline behind it produces the same low-quality output faster. The dashboard is the finishing tool. The work is the impact evidence.

What a great charity impact report looks like

A charity impact report is the annual, human, narrative document that lifts what the dashboard shows every day into something a supporter reads on the train or a trustee hands to a prospective donor. Where the dashboard is the live evidence base, the impact report is the story that evidence supports — and it is often the single most-read document a charity produces all year.

The best impact reports share a small number of things. They open with a strong human story that sets the emotional context. They lead the numbers with a headline stat page that any reader can absorb in thirty seconds. They then use the rest of the document to earn that headline stat — explaining what changed, for whom, how it was measured, and what the charity learned. They report what did not go to plan alongside what did, because SORP 2026 now requires it and because sophisticated readers value honesty over spin. And they close with a clear ask: give, volunteer, campaign, refer.

Below is a schematic of a well-structured 2026 charity impact report — the pages you would find in a document that reads as a document, not a compliance exercise.

A report of this structure typically runs 12 to 16 pages. Some of the very best (Ellen MacArthur Cancer Trust, Winston’s Wish, Moorfields Eye Charity) run to 20 or more. What matters is not the page count but that every page is doing a specific job: setting the tone, presenting the numbers, earning them, honestly reflecting, and closing with a next step. Everything else is decoration.

Four questions to ask before you start

Building a dashboard or writing a serious impact report is not something to start on a Monday morning — the shortcuts get exposed by the first funder who reads the output carefully. Drawing on best practice from New Philanthropy Capital and our own consulting work, the four questions to answer before commissioning either are these.

Where are you on your impact journey? An impact dashboard works best when it is anchored to a theory of change — a clear, agreed statement of how your activities lead to outcomes for the people you serve. If your charity has not yet formalised a theory of change, that is the first piece of work, not the dashboard. A dashboard imposed on shaky measurement foundations tends to surface numbers that raise more questions than they answer.

What is your main aim — reporting or learning? These are related but different design goals. A reporting dashboard is optimised for external audiences: clean summaries, snapshot views, and a small number of confident numbers. A learning dashboard is optimised for internal use: more granular, more filterable, willing to surface uncomfortable patterns. Most charities need elements of both, but the primary purpose determines the emphasis. Naming it early saves rework later.

How will you collect and manage the data? The dashboard is only as good as the data flowing into it, and the quiet killer of impact measurement is a data collection process that survives an initial three months of enthusiasm and then collapses. Realistic questions to answer before build begins: who is responsible for making sure baseline and follow-up scores are actually captured, at what cadence, using which tool, and stored where. Building the collection process into a delivery worker’s daily flow — rather than treating it as an add-on — is what makes it stick.

Who will maintain and update the dashboard? Data connections drift, funder requirements evolve, staff move on. A dashboard is not a build-and-forget artefact; it needs an owner. That can be in-house (typical for larger charities with a data or impact function) or outsourced to a specialist partner (typical for smaller charities that need the capability without a permanent hire). Quematics builds both routes into every dashboard we deliver: either a full handover with a written maintenance guide, or a managed-service arrangement where we host and evolve the dashboard on your behalf.

Outputs, outcomes, impact — the distinction your report has to make

Precision on three words does more work than any single tool choice. Confusing them is the most common mistake in charity reporting, and it is what commissioners and regulators mean when they say a report is “activity-heavy but evidence-light”.

Outputs are what you deliver: sessions run, people seen, hours provided, meals served. Countable activity — and what most charities have always reported. Outputs are necessary. They are not sufficient.

Outcomes are what changes for the person as a result: improved wellbeing, reduced isolation, a job secured, a tenancy sustained, symptoms of depression eased. Outcomes are measured, ideally against a recognised, validated tool, with a starting point (a baseline) and an end point (a follow-up).

Impact is the wider, longer-term difference your work contributes to — including, crucially, the more expensive problems your services prevented: the hospital admission avoided, the eviction that did not happen, the family placement never needed, the offending never repeated. This is the language of prevention, and it is what the whole 2026 accountability shift is really asking about.

Old commissioners asked for outputs. 2026 commissioners want all three, plus value. A charity impact dashboard is designed around this distinction: outputs stay where they always were, outcomes move to the centre, and impact becomes the layer that translates outcomes into the language of prevention and monetary value that funders and commissioners increasingly reward.

Reach, equity, and deprivation — the who-behind-the-numbers

Modern funders and commissioners no longer accept a single blended outcome number. They want to know who the service reached, not just how many. Three terms carry most of the weight in this conversation, and confusing them creates unnecessary work.

Reach is the number and diversity of people your service is actually touching. It goes beyond raw client counts (“we saw 400 people”) to include who those people are, by age, ethnicity, disability, geography, and deprivation.

Equity means fair reach — showing your service reaches people who most need it, not just those easiest to reach. It is distinct from equality (treating everyone the same). Under 2026 accountability frameworks, commissioners increasingly want evidence that funded services are landing where deprivation is highest and where marginalised groups actually live.

Deprivation is measured in the UK using the Index of Multiple Deprivation (IMD), which ranks every small area (a Lower Layer Super Output Area, or LSOA, of roughly 1,500 people) on a scale from 1 (the most deprived 10% of areas) to 10 (the least deprived 10%). When a commissioner asks about “deprivation reach”, they typically want to see what proportion of your clients live in IMD deciles 1–3. You only need postcodes at intake; any lookup tool converts postcode to IMD decile automatically. A well-built impact dashboard does this without any manual effort.

For demographic breakdown, the practical minimum useful dataset is age band, ethnicity (using the ONS 18+1 standard categories from the Census), sex, and disability (using the Government Statistical Service harmonised question). Adding postcode enables deprivation analysis automatically. Framing the ask to beneficiaries as “helps us prove we reach people who need us most” rather than “we have to tick boxes” typically improves response rates considerably.

Measuring outcomes with validated tools

The foundation of every credible impact dashboard is measured change in the people you support, captured with a validated outcome measure — a questionnaire independently tested for reliability (consistent scores) and validity (measures what it claims to). Commissioners require validated tools because self-invented “wellbeing questions” carry no scientific weight. Most UK charities need one or two measures, not five — chosen to match the specific outcomes their theory of change is trying to change.

•  WEMWBS (Warwick–Edinburgh Mental Wellbeing Scale) — 14 items, free with light registration, widely accepted across mental health, community wellbeing, and social prescribing. Score range 14 to 70. Reliable change threshold: 3 points or more. The shorter 7-item SWEMWBS uses 1 point or more — this is the tool Ellen MacArthur Cancer Trust uses in its live public dashboard.
•  PHQ-9 (Patient Health Questionnaire for depression) — 9 items, free, no registration required. IAPT-aligned. Score range 0 to 27. Reliable change: 5 points or more.
•  GAD-7 (Generalised Anxiety Disorder scale) — 7 items, free, no registration. Score range 0 to 21. Reliable change: 4 points or more.
•  SDQ (Strengths and Difficulties Questionnaire for children and young people) — free for non-commercial use at sdqinfo.org. Reliable change: 3 points or more on Total Difficulties.
•  Outcomes Star — a licensed family of more than 50 sector-specific tools by Triangle Consulting Social Enterprise (Recovery Star, Homelessness Star, Family Star, Work Star, and others). Licensed with a modest annual fee, widely accepted by commissioners.
•  EQ-5D-5L (EuroQol 5-Dimension) — the standard health-related quality of life measure used across the NHS, free for non-commercial use with registration, feeding directly into QALY-based valuation.
•  ONS-4 — the four Office for National Statistics wellbeing questions (life satisfaction, worthwhile, happiness, anxiety), completely free and public domain. Good if you need a universal minimum wellbeing measure.

The dashboard automates what most charities currently do manually. Baseline and follow-up scores are matched at the client level, reliable-change thresholds are applied automatically, and outcome rates are surfaced by programme, cohort, funder, referral source, and reporting period. What used to take a data officer a full day at the end of every quarter becomes a live view a manager can open on any morning.

Calculating financial value — HACT, GMCA, NASP, SROI

Outcomes are the first level. The next level translates those outcomes into monetary value — the language funders, commissioners, and corporate partners increasingly respond to. This is done by applying published financial proxies, established monetary values for social outcomes drawn from respected UK sources:

•  HACT UK Social Value Bank (v7) — 88 outcomes across 11 categories with wellbeing valuation figures, HM Treasury Green Book compliant, and the most widely accepted single source of social-value figures in UK charity reporting. Published by HACT (Housing Associations’ Charitable Trust). The values themselves now sit on a subscription platform (Social Value Insight); the methodology note remains free.
•  GMCA Cost Benefit Analysis model — a free downloadable Excel spreadsheet from Greater Manchester Combined Authority with cross-sector unit costs covering families, employment, homelessness, health, criminal justice, and early years. Widely used across the UK.
•  NASP (National Academy for Social Prescribing) — publishes an evidence rate of around 418 pounds of NHS benefit per patient per year, based on a 42,000-patient dataset showing a 42% reduction in GP appointments.
•  NHS reference costs, ADASS unit costs, MoJ prevention values, DfE SEND cost data, Crisis homelessness figures — the primary reference sources for prevented-escalation calculations.

The dashboard applies these figures alongside your own measured outcomes so the resulting valuation is transparent and defensible. Crucially, it distinguishes between a modelled figure (published evidence rates applied to your activity) and a measured figure (scores drawn from your specific clients). Both are legitimate; transparency about which you are using is what protects your credibility with funders and auditors.

Where a full SROI (Social Return on Investment) calculation is warranted for a flagship programme, the dashboard supports the four SROI adjustments — deadweight, attribution, displacement, and drop-off — so the ratio you publish is not overclaimed. UK community wellbeing and social-prescribing programmes typically return 3 to 5 pounds of social value per 1 pound invested once these adjustments are applied; debt advice, welfare rights, and homelessness prevention typically return more. SROI is powerful for demonstrating value to major funders and commissioners, but it demands time, skill, and access to financial proxies — so it is generally better suited to flagship programmes than to whole-organisation, every-year reporting.

The overlap between impact reporting and Procurement Act social value obligations is one place many VCSEs now feel the pressure most acutely. We cover it in detail in Social Value Analytics for VCSEs.

What every audience actually wants to see

Different audiences ask different questions of the same underlying evidence base. A dashboard or report designed for one audience often fails another. The best impact infrastructure presents the same underlying data through a set of audience-specific views — so the same source of truth serves every conversation, from a trustee’s governance question to a donor’s giving decision.

Trustees and governance.  Is the programme working, are outcomes improving or declining, are there safeguarding or equity concerns emerging, is unrestricted spend delivering value. The SORP 2026 trustees’ annual report impact narrative, required by Module 1 of the new standard, can be produced as a print-ready view straight from the dashboard.

Grant makers, trusts, and foundations.  An impact narrative supported by numbers. Larger unrestricted funders increasingly want HACT-based valuation or a full SROI figure for flagship programmes. Smaller trusts want the same story at the right level of detail: outcome rate, cost per outcome, and a well-chosen client narrative.

Individual donors and the general public.  A clear, human account of what their money did. Individual donors do not read methodology pages; they read stories and headline numbers. A well-designed public impact page or annual report is often the single most-read charity document all year, and it does the fundraising work of a dedicated campaign.

NHS Integrated Care Boards.  Outcomes segmented by ICS place and neighbourhood, equity by index of multiple deprivation decile, alignment with the ICB Strategic Commissioning Framework, and where relevant a link between your activity and reduced NHS demand — where the NASP figure and prevented-escalation calculations become important.

Local authorities.  Outcome domains aligned to the Adult Social Care Outcomes Framework (ASCOF) and the DHSC ASC Priorities for 2026–27 (outcomes, prevention, equity), plus social value KPIs required under the Procurement Act. Case-level data reconciled against commissioner records. Covered in detail in Adult Social Care reporting for VCSEs.

Corporate partners.  Increasingly demanding evidence for their own ESG and social value reporting, particularly under the Procurement Act. A well-designed impact dashboard produces a corporate-partner view that maps directly to the categories corporates report against themselves.

Beneficiaries and community.  The often-forgotten audience. People who have used your services deserve to see, in accessible form, what changed for others like them — and are increasingly a legitimate voice in judging the credibility of your impact claims.

Media and sector peers.  The audience you did not know you were writing for until a journalist quotes your annual report or another charity cites your methodology. Being quotable, and being cited, is a marker of credibility that compounds over years.

SORP 2026 — the regulatory backdrop

Since 1 January 2026, impact reporting has moved from good practice to regulatory requirement for every UK charity preparing accruals accounts. The new Charities Statement of Recommended Practice (SORP 2026), issued jointly by the Charity Commission, OSCR, and CCNI, introduces a mandatory impact narrative in Module 1, paragraphs 1.27 to 1.33, within the “Achievements and Performance” section of the trustees’ annual report. Tier 1 charities (income up to 500,000 pounds) are asked to consider the difference their work made; Tier 2 charities (500,001 pounds to 15 million pounds) and Tier 3 charities (over 15 million pounds) are required to explain the impact the charity is making and to consider the long-term effect of activities on individual beneficiaries and on society. Every tier must now report both positive and negative factors that affected achievement of objectives.

A well-built impact dashboard reduces SORP 2026 compliance from a year-end scramble to a live capability. The trustees’ report impact narrative becomes a print-ready view from the dashboard, current as of the balance sheet date, defensible against auditor review, and comparable year on year. For the full detail on what changed, who it applies to, and how to calculate the numbers, see our companion piece SORP 2026 & Impact Reporting: What Every Charity Must Now Do.

Real charities doing this well — three examples worth studying

The best way to understand what a great charity impact dashboard or report looks like is to look at real ones. Three we regularly point clients to:

Ellen MacArthur Cancer Trust operates a public, live impact dashboard on its own website, built around SWEMWBS with three time-points (two weeks before a trip, immediately after, and three months later). Four dashboard pages tell four distinct stories about wellbeing change, with real-time filtering. The Trust openly states the purpose is not to prove or disprove that its work works but to build confidence in the pattern of change, and it names the limitations openly — a level of methodological honesty that is instructive.

Winston’s Wish, the children’s bereavement charity, publishes annual impact reports with a strong opening story, a headline stats page, programme deep-dives, and a clear ask. It is a good reference point for smaller charities on how to structure a professional report without the resources of a large national organisation.

Moorfields Eye Charity publishes multi-year impact reports that link the impact story to the financial story, with clear segmentation between the research, patient support, and equipment programmes. A useful reference for medical research and hospital charities on how to present research impact alongside direct-service impact.

Between these three, the general shape of a good 2026 impact deliverable is clear: honest, structured, evidenced, and human. What we do at Quematics is take that shape and make it repeatable for charities of any size.

How Quematics builds your charity impact dashboard and report

Every project we deliver follows the same five-stage process. Timings vary; a small charity with one programme and clean data can move faster, a multi-site charity with multiple case management systems and several funders takes longer.

1.  Data and evidence audit (2 to 3 weeks). We start by understanding what data you already collect, how it is stored, what the gaps are, and which validated tools are the right fit for the outcomes you are trying to measure. We work with your existing case management system — Charitylog, Lamplight, Beacon, Salesforce NPSP, and others — rather than around it. This stage is intentionally slow because the methodology set here determines every figure the dashboard and report later produce.

2.  Theory of change alignment (1 to 2 weeks, optional). If your charity does not yet have a formalised theory of change, or if the existing one predates a strategic shift, we align the measurement approach with your current strategy before starting the build. If you have a strong theory of change already, we skip this stage and go straight to the build.

3.  Dashboard build (4 to 6 weeks). Power BI foundation, direct connections to your case management system, outcome calculations, reliable-change scoring, financial-proxy valuations, and audience-specific views (trustee, funder, commissioner, public). This is Power BI for charities done properly for your specific data landscape.

4.  Impact report design (2 to 4 weeks, optional). A designed 12 to 16 page impact report built from the same data foundation as the dashboard. Cover, headline stats page, programme deep-dives, honest reflection, and a clear ask, all designed to your brand. Produced annually and reusable at scale.

5.  Training and handover (1 to 2 weeks). Your team confident presenting the dashboard to trustees, funders, and commissioners. Written documentation of every calculation so the methodology is defensible and can be maintained internally — or we host and maintain the dashboard for you on an ongoing managed-service basis.

Based in Peterborough, UK. Working with charities and VCSE organisations across England, Scotland, Wales, and Northern Ireland.

The systems we integrate with

Power BI is deliberately system-agnostic. It sits on top of what you already use. That means we typically connect to some combination of the following without needing you to migrate off any of them:

•  Case management for charities and VCSEs: Charitylog, Lamplight, Beacon, Salesforce Nonprofit Cloud (NPSP), Access Assemble, Views, Inform.
•  Clinical systems: SystmOne, EMIS, IAPTus — where a service is delivered under an NHS contract or in an NHS-integrated setting.
•  Local authority systems: Mosaic, LiquidLogic, CareDirector, Controcc — typically via read-only reporting extracts agreed with the commissioner.
•  Fundraising and CRM: Blackbaud (Raiser’s Edge, eTapestry), Donorfy, DonorPerfect.
•  Finance: Xero, QuickBooks, Sage — where cost per outcome and value-for-money analysis is required.
•  Survey and PROM tools: SmartSurvey, Alchemer, Qualtrics, and the native scoring modules within Outcomes Star, WEMWBS, PHQ-9, and GAD-7.
•  Spreadsheets: structured Excel and Google Sheets remain acceptable inputs where a smaller charity has not yet moved to a full case management system.

The technical detail of managing multi-system reporting under a single dashboard is covered in How Quematics Manages Multi-Framework VCSE Reporting: From Charitylog and Mosaic to Every Commissioner Portal.

Related reading

The 2026 reporting shift

• SORP 2026 & Impact Reporting: What Every Charity Must Now Do
• What Is Data Analytics for Charities? The Definitive 2026 Guide
• AI for Charities: Where We Are in 2026 and Why Data Is the Key
• The Five Reporting Burdens Facing Funded VCSEs in 2026
• The Leader’s Roadmap to 2026

Multi-commissioner and multi-framework reporting

• When Your VCSE Holds Contracts With the NHS, Local Authority and Combined Authority at the Same Time
• Three Different Frameworks, Three Different Reports
• One Data Layer, Multiple Commissioners
• How Quematics Manages Multi-Framework VCSE Reporting

Procurement Act and social value

• The Procurement Act 2023 and Your VCSE Contract
• Social Value KPIs Under the Procurement Act
• Social Value Analytics for VCSEs

Related services

• Charity Analytics (main service page)
• Commissioner-Ready Reporting for Charities
• Power BI for Charities
• VCSE Commissioning Analytics
• Multi-Commissioner Reporting for VCSEs
• Power BI Consultancy

Frequently asked questions

What is a charity impact dashboard?

A charity impact dashboard is a live, filterable Power BI environment that turns the outcome data your services generate into an always-current evidence base. It shows how each programme is performing, lets managers slice results by cohort, geography, funder, or protected characteristic, produces the numbers for external reports, and demonstrates governance to your board and regulators. Crucially, it sits on top of the case management system you already use — Charitylog, Lamplight, Beacon, Salesforce Nonprofit Cloud — rather than replacing it. Think of it as the layer that reads what your team already records in daily practice and turns it into evidence a commissioner, funder, or trustee can see at any moment.

What is a charity impact report?

A charity impact report is the annual, human, narrative document that translates what the dashboard shows every day into the story trustees, funders, and donors read. Where the dashboard is the live evidence base, the report is the argument that evidence supports. A well-structured 2026 impact report opens with a beneficiary story, leads with a headline stats page any reader can absorb in thirty seconds, presents one programme-deep-dive spread per major service, includes a page of honest reflection on what did not go to plan (a SORP 2026 requirement), and closes with a specific ask. Typical length is 12 to 16 pages. It is often the single most-read document a charity publishes all year.

What is Power BI, and why do UK charities use it?

Power BI is Microsoft’s data analytics tool. It takes data from lots of different places — spreadsheets, case management systems, survey platforms, financial software — and turns it into live, interactive dashboards you can open in a web browser, share with your team, or embed on your website. UK charities choose it for three practical reasons: Microsoft’s nonprofit programme offers substantially discounted licences to eligible registered charities (Power BI Pro at around $4.20 per user per month against roughly £11 commercially), so ongoing running costs are modest; it connects to Charitylog, Lamplight, Beacon, Salesforce NPSP, SystmOne, EMIS, and Excel without demanding you migrate off any of them; and it meets the UK/EU data hosting, role-based access, and audit logging standards NHS commissioners and local authorities now require at bid stage. It is not the only option — Tableau, Looker Studio, and a well-designed Excel workbook can do similar work — but for most UK charities Power BI is the most affordable and best-supported option.

Do we need a dashboard, or is a report enough?

For most charities, both. The dashboard is the internal working tool and the source of truth; the report is the external annual product. Building the dashboard first is usually the right sequence because the report is then produced from the dashboard’s live figures rather than assembled separately at year-end. Smaller charities with a single programme sometimes start with a report and add a dashboard later; larger charities almost always benefit from having both. If budget only allows one, the dashboard usually wins because it also produces the numbers for the report; a report alone leaves you with the same manual-extraction burden every year.

What is a theory of change?

A theory of change is a simple diagram — usually on one page — showing how your activities lead to outcomes for the people you serve, and how those outcomes lead to longer-term impact. The standard sequence is Activities → Outputs → Outcomes → Impact. It is the starting point for choosing what to measure: without it, dashboards tend to measure whatever is easy to measure rather than what actually matters. Most small charities should identify 3 to 5 core outcomes that connect directly to their charitable objects, not 20. New Philanthropy Capital (NPC) publishes free theory of change guidance at thinknpc.org.

Do we need a theory of change before we build the dashboard?

Yes, ideally. A dashboard anchored to a clear theory of change measures the right things; a dashboard without one tends to measure whatever is easy to measure and surface numbers that raise more questions than they answer. If your charity has an established theory of change, we align the dashboard to it. If you do not yet have one, or the existing one predates a strategic shift, we run a lightweight theory of change alignment as part of the project. It is 1 to 2 weeks of work that saves months of measurement rework later.

Which validated outcome measures should our charity use?

Start with your theory of change: what outcome are you actually trying to change? Then find a validated tool that measures that specifically. For general wellbeing and social prescribing, WEMWBS or the shorter SWEMWBS. For depression, PHQ-9. For anxiety, GAD-7. For children and young people, SDQ. For health-related quality of life within NHS-integrated services, EQ-5D-5L. For structured recovery, homelessness, employment, or family-support programmes, the licensed Outcomes Star family — widely accepted by commissioners. For a universal minimum wellbeing baseline, ONS-4. Most UK charities need one or two measures in combination, not five. A validated tool is one that has been independently tested for reliability (consistent scores) and validity (measures what it claims to); self-invented “wellbeing questions” do not qualify.

What is a validated outcome measure?

A validated outcome measure is a questionnaire that has been independently tested for two things: reliability (it gives consistent scores when the same person completes it under the same conditions) and validity (it actually measures what it claims to measure). Commissioners and grant makers require validated tools because they carry scientific weight that a self-invented questionnaire cannot. Examples used across the UK charity sector: WEMWBS (wellbeing), PHQ-9 (depression), GAD-7 (anxiety), SDQ (children’s wellbeing), EQ-5D (health-related quality of life), and the Outcomes Star family (sector-specific).

What is reliable change and why does it matter?

Reliable change is the minimum improvement on a validated outcome measure that can confidently be attributed to your work rather than random measurement variation. Each tool publishes its own threshold: 3 points on WEMWBS (1 on the shorter SWEMWBS), 5 points on PHQ-9, 4 points on GAD-7, 3 points on SDQ Total Difficulties, and 1 point sustained across two review cycles on Outcomes Star. If a client’s score improved by less than the threshold, that could just be measurement noise. If it exceeded it, you can confidently say something changed. Reporting the proportion of clients who reliably improved is materially stronger evidence than reporting an average score change, and it is what serious funders and commissioners want to see.

What is the difference between outputs, outcomes, and impact?

Three levels of the same story. Outputs are what you deliver: sessions run, people seen, hours provided, meals served. Countable activity. Outcomes are what changes for the person as a result, measured against a validated tool from baseline to follow-up: wellbeing improved, depression eased, tenancy sustained. Impact is the wider, longer-term effect at system level, including the escalations your work prevented: hospital admissions avoided, EHCP escalations averted, evictions that did not happen. Old commissioners asked for outputs. 2026 commissioners want all three, plus value. A charity that only counts outputs falls short of both funder expectations and SORP 2026’s new impact narrative requirement.

What is prevention, and how do we evidence it?

Prevention is stopping a problem getting worse and requiring a more expensive statutory intervention. Examples: befriending prevents older people’s isolation, which prevents GP visits and hospital admissions; youth programmes prevent school exclusion, which prevents EHCP escalation; debt advice prevents financial crisis, which prevents mental health crisis and homelessness. Prevention is what the whole 2026 accountability shift is really asking about. You evidence it by combining measured outcomes (from validated tools) with published unit costs of the escalations you plausibly prevented — NHS reference costs for avoided A&E attendances, ADASS figures for avoided care packages, MoJ figures for offending, DfE figures for EHCP. The result is a defensible “prevented escalation value” the dashboard can calculate automatically.

What is the difference between modelled and measured evidence?

Two categories of impact evidence, both legitimate, and transparency about which you are using is what protects your credibility. Measured evidence is real scores from real clients using a validated tool — traceable back to individual records. Modelled evidence is applying published evidence rates (from NASP, HACT, GMCA, NHS reference costs) to your activity count — an estimate rather than a direct measurement. Commissioners increasingly want both: measured for individual outcomes, modelled for system-level value. The dashboard labels each figure clearly, and no serious impact report should ever present a modelled figure as if it were measured.

What is equity in charity impact reporting?

Equity means fair reach — showing that your service reaches the people who most need it, not just the people easiest to reach. It is different from equality, which means treating everyone the same. Under 2026 accountability frameworks, commissioners increasingly want evidence that funded services are landing where deprivation is highest and where marginalised groups actually live. A well-built impact dashboard segments outcomes by protected characteristics (age, ethnicity, disability, sex), by deprivation decile (using the Index of Multiple Deprivation), and by geography — so equity is reported alongside effectiveness rather than as a separate exercise.

What is deprivation and how do we measure it?

Deprivation is a measure of how disadvantaged a place is. In the UK it is measured using the Index of Multiple Deprivation (IMD), which ranks every small area (a Lower Layer Super Output Area, or LSOA, of roughly 1,500 people) on a scale from 1 (the most deprived 10% of areas) to 10 (the least deprived 10%). When a commissioner asks about “deprivation reach”, they typically want to see what proportion of your clients live in IMD deciles 1 to 3. You only need postcodes at intake; any lookup tool converts postcode to IMD decile automatically. A properly-built impact dashboard does this without any manual effort and presents the result in the equity view.

How do you calculate financial value from social outcomes?

By applying published financial proxies — established monetary values for social outcomes — to your activity. The three main UK sources are the HACT UK Social Value Bank v7 (88 outcomes, HM Treasury Green Book compliant), the GMCA Cost Benefit Analysis model (cross-sector unit costs, free downloadable), and NASP’s figure of approximately 418 pounds of NHS benefit per patient per year for social prescribing (drawn from a 42,000-patient dataset showing 42% GP-visit reduction). Financial proxies are labelled as modelled (published rate applied to your activity) or measured (drawn from your own client data). Transparency about which you are using is what protects your credibility with auditors, funders, and commissioners.

Do we need to do a full SROI calculation?

Usually not for whole-organisation reporting. SROI (Social Return on Investment) is a ratio expressing the total social value created for every pound invested, calculated as value created divided by cost invested. It is powerful for a flagship programme where the return-on-investment story is strategically important, but it demands time, skill, and access to financial proxies. For most charities the sensible approach is measured outcomes plus HACT- or GMCA-based valuation, with SROI reserved for specific programmes. UK community wellbeing and social prescribing typically return 3 to 5 pounds per 1 pound invested once the four SROI adjustments (deadweight, attribution, displacement, drop-off) are applied. Debt advice, welfare rights, and homelessness prevention typically return more.

Can a charity impact dashboard connect to Charitylog, Lamplight, or Beacon?

Yes. Charitylog, Lamplight, Beacon, and Salesforce Nonprofit Cloud (NPSP) are the systems we integrate with most often. Power BI is deliberately system-agnostic: it sits on top of your existing case management platform rather than replacing it. We also integrate with SystmOne and EMIS for NHS-delivered services, with Mosaic, LiquidLogic, CareDirector, and Controcc for local-authority-facing reporting, with Blackbaud and Donorfy for fundraising, with Xero, QuickBooks, and Sage for finance, and with structured Excel or Google Sheets where a smaller charity has not yet moved to a full case management system. If your current system exports CSV, we can almost always connect to it.

Our beneficiaries do not complete exit surveys. What can we do?

This is one of the most common practical challenges in charity impact measurement, and there are several proven approaches. Build the measure into a genuine conversation rather than presenting it as a form. Choose the shortest validated tool that measures what you need — SWEMWBS is only 7 questions. Score at every touchpoint (not just start and end) so you have multiple data points and lose fewer clients. Compensate with a follow-up phone call — volunteer-delivered in larger charities, staff-delivered in smaller ones. And accept that response rates will typically be 60 to 80%, not 100% — then report on both the responding cohort and the total cohort transparently. Commissioners understand real-world limitations; they do not tolerate hidden or inflated data.

We cannot afford a data analyst. What are our options?

A dedicated in-house data analyst (30,000 pounds and up salary) is out of reach for most small UK charities. Three practical alternatives. First, build the discipline in-house using structured spreadsheets and free tools — a well-organised SharePoint list plus WEMWBS plus a monthly team review can carry a single-programme charity a long way. Second, share a data professional across a consortium of similar-sized organisations, splitting the cost. Third, engage a specialist data service provider like Quematics on a service basis, paying for what you use rather than hiring the capability. Which is right depends on your size, complexity, and internal capacity.

How is Quematics different from doing this ourselves in Excel or Power BI?

Honestly, most of what is covered on this page can be done in-house with free tools, given the time and expertise to do it. The choice between doing it yourself and engaging a specialist is a trade-off between internal capacity and paid service. Quematics offers speed, reliability, and specialist expertise — particularly around the frameworks (SORP 2026, ICB Strategic Commissioning, Procurement Act social value, DHSC ASC Priorities) and the calculation methodology (HACT, GMCA, NASP, SROI adjustments) that a non-specialist team would spend months learning. Whether that trade-off is worth it depends on your size, staff capacity, and the number of funders you are reporting to. For some charities, DIY is right; for others, engaging a specialist saves money in the long run. The free data and reporting review is designed to help you make that decision honestly.

What data protection do we need for impact data?

Five essentials, plus three formal steps. The essentials: UK or EU-based data storage (most reputable services meet this); role-based access so people see only what they need; a documented retention policy for how long you keep data; an audit trail showing who entered or changed what and when; and anonymisation for external reporting. The formal steps: register with the Information Commissioner’s Office (ICO) at ico.org.uk (40 to 52 pounds a year); complete a Data Protection Impact Assessment (DPIA) when working with vulnerable people (usually an afternoon’s work using ICO templates); and have a Data Sharing Agreement in place with any commissioner receiving client data. Commissioners increasingly ask for Cyber Essentials certification too, which is a modest annual cost.

Does SORP 2026 require a charity to have an impact dashboard?

No: the standard is technology-neutral. What SORP 2026 requires, in Module 1 paragraphs 1.27 to 1.33, is that every charity preparing accruals accounts includes an impact narrative in the trustees’ annual report, with Tier 2 (income 500,001 to 15 million pounds) and Tier 3 (income over 15 million pounds) charities required to explain the impact the charity is making and consider long-term effect. A dashboard is the practical way of producing that narrative from evidenced data rather than assembling it manually at year-end. For a small charity a spreadsheet may still suffice; for anything beyond a single programme, a dashboard is materially more efficient and defensible.

How long does it take Quematics to build a charity impact dashboard and report?

A single-programme dashboard for a small charity typically takes 6 to 8 weeks end to end. A dashboard plus a designed impact report takes 10 to 14 weeks. A multi-programme dashboard covering three or four funders and a designed annual report takes 14 to 18 weeks. The build itself is 4 to 6 weeks; the rest is the data and evidence audit at the start (which determines everything downstream), the report design phase, and training and handover at the end. For charities under time pressure — a commissioner reporting deadline or an incoming SORP-compliant year-end — a stripped-down foundation dashboard can be delivered in as little as 4 weeks and then extended.

What does a charity impact dashboard cost?

Dashboard build cost is scoped to the number of programmes, funders and commissioners, and systems being integrated. The comparable UK market range for a bespoke Power BI charity impact dashboard including theory of change alignment and a full monitoring and evaluation framework is typically 11,000 to 25,000 pounds plus VAT for the initial build, with ongoing hosting and maintenance as an optional add-on. Full implementations are priced against the value they unlock — typically less than the cost of hiring a data analyst, and materially less than the contract value they protect at renewal. Every quote we produce starts with a free data and reporting review to establish scope.

What about Power BI licences?

Microsoft’s nonprofit programme offers substantially discounted Power BI Pro licences to eligible registered charities via Microsoft for Nonprofits — around $4.20 per user per month on annual commitment, against roughly £11 commercially. Power BI has never been free for charities, and on 1 July 2025 Microsoft discontinued its Microsoft 365 Business Premium and Office 365 E1 nonprofit grants, so some charities that previously held free licences no longer do. Eligibility for the discount is broad — almost all UK registered charities qualify — and the application takes a few days. For most charities the recurring licence spend is a modest fraction of what the dashboard saves in staff time on manual reporting, and a very small fraction of what it protects in contract renewal value. We help every client apply for the nonprofit grant as part of the project setup.

Can we see an example dashboard before we commit?

Yes. We can walk you through a demonstration dashboard, anonymised examples from previous projects, and public examples such as the Ellen MacArthur Cancer Trust live dashboard as part of a free data and reporting review. There is no obligation, and you will leave the call with a written summary of where your current reporting stands, where the frameworks apply, what your gaps are, and what a structured response would look like.

Book a free data and reporting review