Next steps after our call
Example Advice Service (fictional)
What you told us
Every quarter, someone spends several days pulling figures out of the case system and two spreadsheets for the funder report. The figures are checked by hand, and the method changes depending on who does it.
The job, before and after
Today
- Export the case list
- Filter and count by hand
- Cross-check outcomes against notes
- Copy figures into the report
- Hope nothing was missed
Suggested
- Figures drawn from the case system, with the records each came from
- Draft report paragraph prepared
- Service manager checks and approves
- Every question and approval logged
Who does what
| Step | AI prepares | A person decides |
|---|---|---|
| Count cases and outcomes | Yes, from approved fields only | Checks the totals |
| Write the report paragraph | First draft | Edits and approves |
| Send to the funder | No | Always a person |
Data and boundaries
- Only the fields the report needs are read. Names and addresses are masked before any AI model sees them.
- Data stays in the UK.
- Nothing is sent outside the organisation without a person’s approval.
Risks we talked about
- Outcome codes are used differently by different staff. These need agreeing first, or the figures will be wrong however they’re produced.
- Case notes include health information, so a data protection impact assessment comes before anything is built.
Suggested first step
Agree the outcome codes with the team, then test one quarter’s figures against last quarter’s hand-made report. If they don’t match, find out why before going further.
What we’d need from you
- An hour with whoever does the report today.
- A copy of last quarter’s report, with personal details removed.
- A yes from your data protection lead before any real records are used.
What we’d advise against
Pasting case notes into a public chat tool to speed up the report. It’s quicker this quarter and a problem forever.