SAMPLE REPORT — The Lantern Trust is a fictitious charity. Every finding is a real pattern from Thread Audits, anonymised. Book your own audit →
Processes & AI Audit · Sample Report

The Lantern Trust

Where your week is leaking hours, how to get them back, and exactly what to do first — using tools you already pay for wherever possible.

"We know exactly what needs doing better. We just never get a clear week to do it."

— Trust director, discovery call
Prepared by Thread Fundraising · Sample — fictitious charity
Executive summary

Half a day to a full day back, every week

We spent an hour inside how The Lantern Trust actually runs — a three-person team supporting 140 young carers across the county, with a CRM, an accounts package, a donation platform and an email tool that don't talk to each other. The service is in great shape. The admin around it is quietly taxing the team: five quick wins would hand back half a day to a full day every week, take the pain out of funder reporting, and put supporter relationships on a system instead of in three people's heads.

5quick wins, all doable inside 90 days
250–380staff hours per year recovered
≈ 1 day/wkequivalent capacity freed for young carers
£0–£15/monew software cost across four of the five wins

A note on the numbers: these are deliberately conservative ranges, built from what the team told us about frequency and duration. We'd rather you beat them than doubt them.

What we heard

A strong charity running to stand still

Before the fixes, the mirror. Two things stood out: how much is already right, and how much time goes into work a system should be doing.

Already working

The referral relationship with local schools is genuinely strong, the CRM was a good choice and the team use it daily, and the trustees are engaged. The team's instinct to phone and thank funders personally is exactly right — the evidence behind personal stewardship is overwhelming.

The finance headache

"The donation platform pays out in lumps, and matching those lumps back to actual donors at year end took us most of a fortnight." The CRM and the accounts package hold different versions of income, restricted funds are tracked in a side spreadsheet, and the independent examiner had questions.

Reporting by hand

Every funder wants outcomes in a different format. The data exists — session counts, school engagement, wellbeing scores — but each report means manually recounting a spreadsheet. "Quarter ends are just lost weeks."

Relationships on memory

New donors get a thank-you if someone remembers. There's no welcome journey, no tiers, and the email list hasn't been segmented since it was set up. Meanwhile volunteer DBS renewals and training are chased one email at a time.

Ease & impact

What to do, in what order

Everything we found, plotted. Top-right is the good stuff: big impact, easy to do. Tap any dot to jump to the detail.

do first plan carefully nice to have not now Easier to do → Bigger impact → 1 CRM ↔ accounts 2 Stewardship system 3 Funder reporting 4 Compliance chasing 5 Claude + AI policy 6 Planner 7 Story capture 8 Volunteer system

What we checked and didn't find: safeguarding record-keeping (already well handled through the schools' frameworks — a good result, not a gap), HR processes (right-sized for a team of three), and website replatforming (not worth the disruption yet). We tell you what's fine as plainly as what isn't.

The quick wins

Five fixes, each with a do-it-yourself route

Every fix comes two ways: a guide to do it yourselves, and what it looks like if Thread builds it with you at a fixed price. No obligation either way — the plan works whichever routes you pick.

1

One version of the financial truth

≈ 2–3 hrs/week backYear-end fortnight removedData & ethics: green

The leak

The CRM and the accounts package disagree about income. Donation-platform payouts arrive as lump sums that someone unpicks by hand, restricted funds live in a side spreadsheet, and year-end reconciliation ate most of a fortnight plus examiner queries.

The fix

Your CRM has a built-in integration with your accounts package — this is configuration, not new software. We align one coding structure across both systems, switch the integration on so gifts flow through coded, set up a payout-reconciliation routine for the donation platform, and mark restricted/unrestricted at the point each gift is entered. "How much of our reserves are restricted?" becomes a report, not an archaeology project.

Data & ethics — Green. Organisational financial data only; both systems UK/EU-hosted with standard agreements; no beneficiary data involved.
🔧 Do it yourselves — the guide
  1. Agree the code list on paper first: one row per income stream, each marked restricted or unrestricted. Treasurer + one staff member, one hour.
  2. Rebuild the accounts package's tracking categories to match that list exactly.
  3. Mirror the same list in the CRM as funds/campaigns with restricted flags.
  4. Switch on the CRM's accounts integration and map payments to the codes.
  5. For platform payouts: one reconciled batch per payout, coded to the right campaign, so each bank line matches a CRM batch 1:1.
  6. Run one month in parallel with the old routine, then retire it.
🧵 Where Thread can help

We design the coding structure with your treasurer, configure both systems, set up the payout routine and hand over a one-page monthly checklist (automated reconciliation setup — £750 fixed fee, 48–72 hour turnaround). Optional phase two: a board reporting template & dashboard so trustee papers draft themselves (£350 fixed fee, 3-day turnaround).

2

A stewardship system — so no thank-you relies on memory

Income lever≈ 1–2 hrs/week backData & ethics: amber — managed

The leak

New donors get thanked if someone remembers. No welcome journey, no donor tiers, an unsegmented email list — and the personal calls the team already makes (rightly) depend on whoever's least busy that week.

The fix

Three moves. Tiers in the CRM — first-gift, repeat, regular giver, major — with thresholds you choose. A stewardship dashboard: a live "people to thank this week" list, with calls and cards logged as tasks. And an automatic three-email welcome journey for new supporters, with higher-tier donors flagged for the personal touch instead. Donation forms move onto purpose-built pages that run on your own Stripe account, so giving is seamless and every gift lands in the CRM tagged and ready to steward.

Data & ethics — Amber, managed. Donor names and emails flow to the email platform under standard safeguards; existing consent flags are respected before anyone enters a marketing journey; thank-you emails sit comfortably under legitimate interest.
🔧 Do it yourselves — the guide
  1. Define four tiers and the trigger for each, on one page.
  2. Add a "stewardship tier" field in the CRM; backfill the top 100 supporters first.
  3. Build the dashboard: last 7 days' gifts not yet thanked; tasks due; regular givers approaching their anniversary.
  4. Write the three welcome emails once (what their gift does → one young carer's story, consented → what's coming up); switch on the automation.
  5. Keep the weekly hour of calls and cards — the dashboard just decides who.
🧵 Where Thread can help

Stewardship is Thread's home ground. We build the welcome journey properly (automated email welcome journey — £500 fixed fee, 48-hour turnaround) and the donor stewardship sequence with tiers and dashboard (£350 fixed fee, 48–72 hour turnaround), drawing on what measurably works in individual giving. You approve every word before anything sends.

3

Funder reporting that does the maths itself

≈ 50–80 hrs/year backData & ethics: green

The leak

The outcomes data exists — sessions delivered, school engagement, wellbeing scores — but every funder wants it cut differently, so every quarter end means manual recounting. Quarter ends are just lost weeks.

The fix

Same spreadsheet, upgraded: a summary tab that calculates totals and percentages automatically, and a funder-view tab where you pick a funder's categories from a dropdown and the numbers recut themselves. Feedback and session forms feed the workbook directly instead of being re-typed. Your headline stats — "89% of young carers say Lantern gives them a break they get nowhere else" — are always one glance away, for reports and fundraising alike.

Data & ethics — Green. The reporting layer uses anonymised, aggregated data only; individual young carers' records stay where they are, untouched.
🔧 Do it yourselves — the guide
  1. Add a summary tab of COUNTIFS formulas per school, per session type, per outcome measure.
  2. Add a funder-view tab: enter any funder's categories in a column and let formulas recut totals against them; save each funder's bands for next time.
  3. Move session and feedback forms to Microsoft Forms (already in your 365 subscription), feeding one linked spreadsheet.
  4. Put the two best headline stats on your donation page and grant applications.
🧵 Where Thread can help

We rebuild the workbook, wire up the forms, and pre-load your current funders' formats so the next quarterly report is minutes, not days (reporting dashboard built from your sources — £750 fixed fee, 3–5 day turnaround).

4

Compliance chasing on autopilot

≈ 3–5 hrs/month backData & ethics: amber — managed

The leak

DBS renewals and safeguarding training for staff and volunteers are chased one email at a time, from a spreadsheet, by whoever notices. The chasing is the leak — not the compliance itself — and the risk of something slipping grows with every new volunteer.

The fix

A compliance register with expiry dates per person, plus an automated workflow that sends escalating reminders (60, 30, 7 days, then a copy to the coordinator), records completions, and shows a live red/amber/green dashboard with a one-click summary for trustees. Humans only handle genuine exceptions. Built in the Microsoft 365 tools you already pay for.

Data & ethics — Amber, managed. The register stores status and dates only — never DBS certificate contents. Access limited to the coordinator; leaver records cleared on a schedule.
🔧 Do it yourselves — the guide
  1. Build the register as a Microsoft List: one row per person per requirement, with an expiry date. Status and dates only.
  2. Add a Power Automate flow: reminder at 60/30/7 days, coordinator copied after that.
  3. Format the List view as the RAG dashboard; screenshot it for board papers.
  4. Retire the spreadsheet once one renewal cycle has run cleanly.
🧵 Where Thread can help

We build the register, the escalating reminder flow and the trustee dashboard in your own Microsoft 365 (system integration / automation — £500 fixed fee, 48–72 hour turnaround), and hand it over working, with the first cycle monitored.

5

A Claude pilot — with an AI policy so it's done right

Multiplier on everything aboveData & ethics: green, with guardrails

The leak

Not a leak — an opportunity, and a fair worry. The team asked the right question: where does the data go? On business plans, your data isn't used to train the models and stays yours. The risk isn't the tool; it's using it without agreed boundaries.

The fix

A two-month Claude pilot at charity pricing (roughly £18/month for three people) pointed at the unglamorous work: recutting funder stats, first drafts of grant reports in each funder's format, policy tidying, spreadsheet formulas on demand. Alongside it, a one-page AI policy naming what you'll happily use AI for, what you never will (nothing identifying a young carer goes anywhere near it — that's line one), and what's still being decided. The board sees it, everyone relaxes, and you innovate inside clear lines.

Data & ethics — Green with guardrails. No beneficiary or safeguarding data in AI tools, ever — policy line one. Anonymised statistics and your own drafting are fine. Business plans exclude your data from training.
🔧 Do it yourselves — the guide
  1. Adopt an AI policy (we provide a draft as part of every audit) and take it to the next board meeting.
  2. Start the pilot with three real tasks in week one: a funder-format recut of your (anonymised) stats, a first-draft progress report against a finished grant application, and one spreadsheet formula you've been avoiding.
  3. Keep a shared note of what worked; decide with evidence after two months.
🧵 Where Thread can help

The AI policy draft is included in your audit. Beyond that, a hands-on session getting the whole team working with Claude on your real tasks — scoped and quoted at the review call.

Worth doing, not first

On the radar

6 · Microsoft Planner — for everything outside the CRM universe

Free inside your Microsoft 365. One board per event, one for the board cycle (papers, meetings, action points tracked instead of lost in minutes), and ready-made task lists for volunteers. Rule of thumb: supporters live in the CRM; everything else that needs doing lives in Planner.

7 · Story capture

A two-minute form any staff member can use to log a young carer's story idea, with consent tracked from the start — so when a grant application or appeal needs a story, it's there, cleared, and current. Consent rules for young people make this one worth designing carefully; we'd sequence it after the quick wins.

8 · Volunteer management system — later, deliberately

At this size, CRM forms plus the compliance register cover it. The trigger to revisit: volunteer numbers doubling, or shift scheduling becoming a weekly headache. Until then, skip the software — we'd rather you spent the money on young carers.

The route map

Your first 90 days

WhenWhatRoute
Week 1Agree the income code list on paper · adopt the AI policy draftDIY
Weeks 2–4Quick win 1: coding structure, CRM↔accounts integration, payout reconciliation — run one month in parallelDIY or with Thread
Weeks 3–4Quick win 5: Claude pilot starts · policy to the boardDIY
Weeks 5–7Quick win 2: tiers + dashboard + welcome journey liveDIY or with Thread
Weeks 6–8Quick win 3: reporting workbook + forms rewiredDIY or with Thread
Weeks 8–10Quick win 4: compliance register + reminder flow liveDIY or with Thread
Weeks 10–1290-day check-in with Thread: what actually saved time?with Thread
Next steps

What happens now