← Workshop Home Branch Module AI for Finance & Reporting
0%
Branch Module · Finance & Reporting

Numbers are easy.
Explaining them isn't.

The hardest part of financial reporting isn't the maths — it's the narrative. Turning a spreadsheet into a clear story for your board, your funders, or your stakeholders is where most people get stuck. AI can't do your accounts. But it can help you explain them.


📊 Finance & Reporting · ~40 minutes

📐 What AI can (and can't) do with numbers

Let's be clear before we start: AI is not your accountant. Do not ask AI to calculate your GST, prepare financial statements, or give you tax advice. It can make mistakes with arithmetic and knows nothing about your specific numbers unless you tell it.

What AI is excellent at is the communication layer around financial data:

AI is strong at: Turning numbers into plain-language summaries. Explaining what a financial result means for non-finance audiences. Structuring financial narratives for board papers. Drafting funder reports from bullet-point data you provide. Writing budget justifications and variation explanations.

AI is NOT for: Calculating figures (use a spreadsheet). Preparing accounts (use an accountant). Tax advice (use a tax advisor). Any calculation you haven't verified yourself.

With that clear — here's where AI saves significant time for the people who manage money in organisations that aren't large enough to have a dedicated finance team.

📝 Turning numbers into plain language

Board members, funders, and community stakeholders rarely have a finance background. The monthly financials that make complete sense to you can be impenetrable to them. AI can translate your data into language people can act on.

Example: raw data you give AI
Revenue: $142,000 (budget $135,000, +5.2%) Programme costs: $89,000 (budget $95,000, under by 6.3%) Admin costs: $28,000 (budget $25,000, over by 12%) Net surplus: $25,000 (budget $15,000) Key reason for admin overage: unexpected IT upgrade $4,200
AI output (after running the "board summary" prompt)
Plain language board summary
The organisation finished the quarter in a strong position, with a surplus of $25,000 — $10,000 ahead of budget. Revenue came in 5.2% above forecast, reflecting stronger-than-expected programme uptake. Programme costs were well-managed, coming in under budget by $6,000. The one area to note is administration, which ran $3,000 over budget due to an IT upgrade that wasn't anticipated when the budget was set. This was a one-off cost and is not expected to recur. Excluding this item, administration would have been on budget. Overall, the financial position is healthy and management does not anticipate any material changes to the full-year outlook.
Board / trustee financial summary
Write a plain-language financial summary for a board of trustees. Audience: non-finance people who need to understand the key messages, not the detail. Based on this data: [paste your key financial figures — revenue, costs, surplus/deficit, variances, any unusual items] Structure: (1) headline result in one sentence, (2) 3-4 bullet points on key movements, (3) one sentence on outlook. Under 200 words. Professional but accessible.
Key: You provide the numbers. AI writes the narrative. Always verify the narrative against your actual figures before circulating.
Explain a budget variance
Write a brief explanation for a funder/board about why [expense category] came in [over/under] budget by [amount or %]. The reason is: [your explanation in plain notes]. Write it in 2-3 sentences — honest, clear, and without sounding defensive. This is for inclusion in a financial report.
Use this for: Any line item that needs context in a report — especially overages that might raise questions.
Cash flow narrative (small business)
Write a short plain-language summary of the following cash flow situation for [business name]. I need to explain this to [my accountant / bank manager / business partner / myself]. Current bank balance: $[X] Money expected in next 30 days: $[X] from [sources] Bills due in next 30 days: $[X] including [big items] Biggest pressure points: [list] Give me: (1) a one-sentence status, (2) 2-3 things to watch, (3) one action I should consider. Plain English.
Not financial advice: AI gives you a framework for thinking — your accountant or bank makes the calls.
Exercise F.1
Write your next board / funder financial summary
Take a set of financial figures you have from the current or most recent period. Don't worry about making them look neat — rough numbers in bullet points are fine. Run them through the "board summary" prompt. What did AI get right? What needed correcting?
  • 1Grab a recent P&L, cash summary, or any financial data you have
  • 2Write the key figures as bullet points (revenue, costs, result, any big variances)
  • 3Run the board summary prompt — paste your bullets in the [data] section
  • 4Read critically: is every number accurate? Is the narrative fair to the actual situation?
  • 5Edit what needs fixing. That's your first draft done.

📋 Funder reports that don't take all day

Grant reporting is the tax return of the NGO world — necessary, time-consuming, and dreaded by most people who have to do it. The structure is usually fixed by the funder, but the writing is yours.

AI can draft the narrative sections of a funder report in minutes, given the right inputs. The key is giving it enough specific information that the output is actually about your project, not a generic template.

Grant progress / acquittal report
Write the narrative section of a grant report to [funder name]. Funding amount: $[X]. Purpose of grant: [brief description]. Reporting period: [dates]. What we achieved: - [achievement 1] - [achievement 2] - [achievement 3] Challenges and how we addressed them: - [challenge 1 + response] Financial summary: [spent $X of $Y, brief note on any variance] Write this as a clear, honest, appreciative narrative. Under 400 words. Demonstrate accountability and impact — show the funder their investment made a difference.
Provide real specifics: Numbers served, events run, outcomes measured. Generic outputs come from generic inputs.
Impact statement for renewal application
Write a compelling impact statement for a funding renewal application for [programme name] at [organisation]. We're applying to [funder] for $[amount] to [purpose]. Evidence of impact from last year: - [statistic or outcome 1] - [statistic or outcome 2] - [quote or story if you have one] Why continued funding matters: [your key argument] Write this as 2-3 punchy paragraphs that would make a funder say yes. Lead with impact, not process.
Funder rule: Funders fund impact, not activity. "We ran 12 workshops" is activity. "47 participants reported increased confidence, 8 found employment" is impact.
Budget justification
Write a budget justification for the following line items in a grant application to [funder]. For each item, explain why it's necessary for the project and how the amount was calculated. Items: - [item 1]: $[amount] - [item 2]: $[amount] - [item 3]: $[amount] Audience: a funding assessor who will scrutinise whether costs are reasonable and necessary. Be specific about methodology and reasoning. No padding.
Tip: Funders want to see how you arrived at figures, not just what they are. "Facilitator fees: $1,200 (3 sessions × $400/session, market rate for professional facilitation)" is better than "$1,200 for facilitation."

📖 Annual reports people actually read

An annual report is both a legal requirement and a relationship document. Done well, it builds trust with your community, funders, and stakeholders. Done badly, it's a compliance exercise that sits unread in a PDF.

AI can help you move from "compliance exercise" to "genuine communication" without tripling the time it takes to produce.

Year in review narrative
Write a "year in review" narrative for [organisation name]'s annual report. Reporting year: [year]. Audience: community members, funders, and stakeholders who care about our work but don't need the full detail. Key highlights of the year: - [highlight 1] - [highlight 2] - [highlight 3] Challenges we navigated: - [challenge 1] What we're looking forward to next year: - [plan or goal] Tone: warm, honest, grounded in the community we serve. Under 350 words. This should sound like the organisation speaking to people it cares about, not a press release.
Voice: Add a line like "Our organisation speaks like [description — e.g. 'a local community group, not a corporate']" to shape the output's register.
CEO / chair message
Draft a chair's/CE's message for [organisation name]'s annual report from [name, role]. The key themes for this year are: [theme 1], [theme 2]. Significant achievements: [list]. Honest acknowledgement of: [challenge or difficult moment]. Looking ahead: [priority or goal]. Tone: personal, direct, and genuine — not corporate. Should sound like a real person, not a statement. Under 300 words.
Then personalise: Add one specific anecdote or moment from the year that only you would know. That's what makes it a real message, not a template.

The "facts first, writing second" workflow: Before using AI for any report, write your key facts and outcomes as rough bullet points. Don't try to polish them first. Paste those bullet points into AI. Let it do the structuring and writing. You then edit for accuracy and voice. This is consistently faster than trying to write polished prose from scratch.

🔒 Financial data and AI — the hard rules

🚫
Never put real financial data with identifying information into free AI tools
Your actual account numbers, bank details, client financial information, or commercially sensitive projections should not go into ChatGPT's free tier. For sensitive financial work: use a paid enterprise plan with privacy guarantees, use a local model, or anonymise all figures first (e.g. round to the nearest $1,000, remove account details).
⚠️
AI does not do arithmetic reliably
Large language models predict text — they don't calculate. An AI can and will get simple arithmetic wrong with confidence. Never trust a number that AI calculated. Only trust numbers that AI repeated from data you gave it — and even then, verify them.
✓
What's always safe
Anonymised financial summaries (rounded figures, no names or account details), narrative drafting based on bullet points you provide, structural help with how to present financial information, plain-language explanations of financial concepts.
Exercise F.2
Draft your next funder report section
Pick any upcoming reporting obligation — a grant acquittal, a board financial summary, a donor update. Use the "facts first" workflow: write your key points as rough bullets, then run them through the relevant prompt above. Time yourself. How long did the draft take?
  • 1Pick a real upcoming report or the most recent one you had to write
  • 2Write your key facts/outcomes as 5-8 bullet points (2 minutes max)
  • 3Choose the appropriate prompt and run it with your bullet points
  • 4Read the output: is it accurate? Does it represent the situation fairly?
  • 5Note how long the draft took vs your normal process
📊

Finance & Reporting complete

You now have AI-assisted workflows for board summaries, funder reports, impact statements, budget justifications, and annual reports.

⚖️ Ethics 💰 Economics 🎨 Creative Tools 🔬 Google AI Studio ⚡ Automation 🐙 Git & GitHub 💻 Claude Code 🎙️ Voice Agents 🛡️ Security 🔗 MCP & RAG 🗂️ Admin & Ops 👥 HR & Comms 💬 Customer Service 📊 Finance ← you are here 🍎 Education 🔥 Prompt Engineering 🏠 Workshop Home