Sports Club Treasurer's Report: A Plain Summary of the Books With AI

A sports club treasurer should build a one-page income and spend table from the ledger, work out the differences first, then give the AI only that table and ask for a plain-English summary, three talking points and likely member questions. Check every figure against the books before it goes out; the AI writes the words, you answer for the numbers.

Blank report forms give you boxes to fill. Committees need a story. A table with thirty lines tells them nothing they can act on, while "pitch hire is 57% of our spending and rose by nearly a fifth" does. The danger with AI is the reverse: a fluent paragraph that treats a restricted grant as free cash, or says an underspend was an overspend. The method below is built to stop that.

Follow me on Instagram@sagnikteaches

The one-page table the report stands on

A committee report isn't a copy of the ledger. It is one page with four columns: this year, budget, last year and the difference from budget. Group the ledger into the six to ten lines per side that the committee already argues about. Put restricted money, such as a grant for one purpose, on its own row. Under the table add three facts: opening and closing bank balance, any restricted money still unspent, and notes on anything unusual, such as fees paid early for next season. Here is an illustrative table for a community football club with 120 members and four teams:

Connect on LinkedInSagnik Bhattacharya

The notes under the table carry what the columns can't: the bank balance rose from $5,400 to $9,220; the junior equipment grant of $1,500 can only be spent on junior equipment, and $800 has been spent, leaving $700; membership grew from 108 to 120 and the fee rose from $75 to $80. This table is small enough to read in two minutes, and every figure on it can be traced to a ledger line. If your constitution requires a particular format for the formal report, produce that as well; the plain summary is an addition, not a replacement.

Subscribe on YouTube@sagnikteaches

Money received early is the usual trap in club books. In a different year, suppose ten members had paid next season's $80 fee in the last week of the financial year. That is $800 of this year's cash but next year's income, so the surplus would flatter the year by $800. Either leave early payments out of the table or footnote them and tell the AI in the notes, otherwise the draft will congratulate the club on money it hasn't yet earned. The same goes for bills received but not yet paid, which belong in a note too.

Let the spreadsheet do the sums

Everything the report will quote should exist in the sheet before the AI is involved, including differences, percentages and direction words. Two reasons: AI makes arithmetic slips, and a figure you computed is a figure you can defend. Check the table against the ledger first. Total income minus total spending must equal the surplus, and the opening balance plus the surplus must equal the closing balance (assuming a simple cash-based ledger). If the closing figure doesn't match the bank statement, find out why before anything else. If your bank export is messy, the tutorial on cleaning messy data in Excel covers the built-in tools for duplicates, blanks and inconsistent text.

Put the direction in words in the sheet. A model asked to describe "-300" on a spending line can guess wrongly whether that's good, bad or an overspend. These formulas remove the guesswork (assuming This year is in column B and Budget in column C), and the Against budget column in the table above simply joins the difference and the direction word:

Difference:   =B2-C2
Percentage:   =IF(C2=0,"n/a",(B2-C2)/C2)
Direction:    =IF(B2>C2,"more",IF(B2<C2,"less","on budget"))

Add a few derived figures to the notes, each computed in the sheet: the surplus split into restricted and general (here $700 and $3,120), the general balance at the bank ($9,220 less $700 is $8,520), spending per member ($12,630 divided by 120, about $105), and the share of spending going on the biggest line (pitch hire is $7,200 of $12,630, 57%). The change in subscriptions is also worth splitting: of the $1,500 rise, $540 comes from the $5 fee increase on 108 members and $960 from 12 extra members. The tutorial on explaining monthly variances against budget with AI goes deeper into this step.

The prompt: summary, talking points and member questions

The prompt does four jobs: it limits the model to your table, it forces plain wording, it demands a visible marker where it lacks a fact, and it asks for three outputs in one go. Replace the bracketed parts with your own table and notes.

You are helping a volunteer sports club treasurer write a plain-English summary
of the club's accounts for a committee meeting. Use ONLY the table and notes
below.

RULES
1. Every number must appear in the table or notes. Copy numbers exactly. Do not
   calculate, round or convert anything.
2. Write for volunteers with no accounting background. The first time you use
   "surplus" or "restricted", explain it in a short clause. Avoid all other jargon.
3. Say which way each difference goes, using the "Against budget" wording in the table.
4. Do not explain why a number changed unless the notes say why. Where the reason
   is missing, write [TREASURER TO ADD REASON].
5. Keep restricted money separate from general money in the headline.
6. Produce: (a) a summary of no more than 120 words; (b) three talking points
   for the meeting, each with one number and one question for the committee;
   (c) eight questions members are likely to ask, with answers that use only
   these figures. If the figures can't answer a question, write [TREASURER TO
   CHECK] instead of guessing.

TABLE
[paste the one-page table as plain text, with the Against budget column]

NOTES
- 120 members (108 last year); fee $80 (was $75, a $5 rise). Subscriptions
  rose $1,500: $540 from the fee rise, $960 from 12 extra members.
- Junior equipment grant $1,500 is restricted to junior equipment; $800 spent,
  $700 unspent.
- Surplus $3,820: $700 restricted (the unspent grant), $3,120 general.
- Bank balance $5,400 at the start, $9,220 at the end; $8,520 is general funds.
- Spending per member is about $105. Pitch hire is 57% of spending and
  $1,100 (18%) more than last year.
- What-if, not a forecast: if pitch hire rose by another $1,100 and membership
  stayed at 120, the $3,120 general surplus would fall to about $2,020.

Every figure in those notes was worked out in the sheet, including the what-if. Rule 1 forbids the model from calculating, so anything the report needs, such as the $1,100 rise in pitch hire, has to be in the notes before you run the prompt.

What the first draft got wrong, and the fix

Even a good prompt rarely returns a clean report the first time, and the mistakes are instructive. Suppose the notes had left out the restricted grant, because the treasurer thought of the whole $3,820 as one pot. The first summary would then read like this (illustrative):

The club had a healthy surplus of $3,820 this year, which the committee can now invest in new facilities. Coaching courses came in $300 over budget, while pitch hire cost $7,200, up because of rising energy costs.

Three things are wrong, and none is obvious on a quick read. The "$3,820 free to invest" ignores that $700 of it can only be spent on junior equipment. "$300 over budget" gets the direction of the courses line backwards, since the table shows it $300 less than budget. And "rising energy costs" is invented: nothing in the table or notes gives a reason for the pitch hire increase. The fixes are the ones built into the prompt. Put the restricted amount in the notes, quote the Against budget wording, and let the model write [TREASURER TO ADD REASON] when it has no source. The corrected summary becomes:

This year the club took in $16,450 and spent $12,630, leaving a surplus (money left over) of $3,820. Of that, $700 is restricted, which means it comes from a grant that can only be spent on junior equipment, so the money we can spend freely is $3,120. The bank balance rose from $5,400 to $9,220. Income was $2,450 more than budget, helped by $600 more in subscriptions, $400 more from fundraising and the $1,500 grant. Spending was $780 more than budget; the biggest single difference was pitch hire at $7,200, which was $600 more than budgeted and $1,100 more than last year.

It is plain, every figure is in the table or the notes, and it reads aloud in under a minute. The reason for the pitch hire increase is still missing, which is correct: only you can add it from the hire invoices.

Three talking points that lead to a decision

Committees remember three things. Choose them by rule rather than mood: first the result and the cash, always; then the biggest line or biggest difference; then the one thing the committee must decide. Each point carries one number and one question, so the discussion has somewhere to go. For the example club (illustrative):

1. Where we stand. A surplus of $3,820, of which $700 is restricted to junior equipment, and $9,220 in the bank. Question: do we agree what the $700 of junior equipment will be, and by when?
2. Pitch hire is the cost to watch. It is $7,200, 57% of all spending, up $1,100 (18%) on last year and $600 over budget. [Treasurer adds the reason from the invoices.] Question: can sessions be shared across teams, or should we talk to the venue?
3. Next season's fee. Subscriptions rose by $1,500 because we added 12 members and raised the fee by $5. If pitch hire rises by the same $1,100 and membership stays at 120, the $3,120 free surplus would fall to about $2,020. That is a what-if, not a forecast. Question: do we hold the fee at $80 or raise it?

The what-if in point three is arithmetic from the sheet ($3,120 less $1,100), added to the notes in advance. The AI must never produce its own projection. Once the committee has agreed the points, ask for a spoken version of 200 words or so, which a comfortable speaker delivers in about 90 seconds at roughly 130 words a minute. Time yourself on the real script, and cut anything you stumble over.

Member questions the table invites, and the ones it can't answer

Members rarely ask about the table itself. They ask what it means for them. Asking the AI for the likely questions in advance saves you being caught out at the meeting, provided each answer is built from the figures and anything else is flagged. The prompt above produces something like this (illustrative, shortened):

The two flagged rows are the most valuable part. They mark exactly where the books end and the club's decisions begin, and a treasurer who says "I'll check and reply by Friday" gets more trust than one who bluffs. If your club works with a local sports shop on a credit scheme, that credit is one more income line to explain; the tutorial on club deals and season launches from a shop's side shows how those schemes work. And if a funder gave the restricted grant, the tutorial on what funders expect in a sports club grant application is a useful companion for the report you will owe them.

Checking every figure before the report leaves your hands

This step is yours, and it is not optional. A report with one wrong figure damages every right one. Work down this list with the table printed beside the draft and a highlighter in hand:

1. Totals. Do the lines add up to each total, and does income less spending equal the surplus?
2. Bank. Does the closing balance match the bank statement, and is the general and restricted split right?
3. Every number in the draft. Highlight each one on the printout and tick it against the table or notes. Any figure you can't tick is deleted or recomputed.
4. Every direction word. More, less, up and down must match the Against budget column. This is where backwards slips hide.
5. Every explanation. Anything containing "because", "due to" or "as a result" needs a source. If it has none, delete it or add the real reason.
6. Every marker. Search for "TREASURER" and resolve each one. None may remain in the version you send.
7. A second reader. Ask another committee member to read it and tell you which sentence they'd have to ask about. In Word, Home > Editor > Document stats shows readability scores on up-to-date Microsoft 365 installs (older versions put them elsewhere). Aim for a reading ease of 60 to 70 and a grade level of about 7 to 8, the range Microsoft suggests for most documents.

Don't ask the AI to "tidy" the text after you've checked it. Any rewrite means starting the check again. If you want to change the tone, change the prompt and re-run, then check the new draft in full. If the committee uses terms that need translating, this short table helps you replace the jargon in the table's labels:

A deficit year: the same method with no softening

The method matters most in a bad year, because that is when the temptation to soften is strongest. Take a second illustrative club, a small netball side. Income was $9,800 against a budget of $9,600, and spending was $11,300 against $10,400. That is a deficit (a shortfall) of $1,500, against a planned deficit of $800. The biggest difference was one-off kit spending of $2,300 against $1,400 budgeted. The bank balance fell from $4,100 to $2,600.

Left to its defaults, a model reaches for comfort. A typical first draft says "the club had a small shortfall this year, which is nothing to worry about for a club of our size". Both halves are unsupported: nobody has shown it's small relative to anything, and "nothing to worry about" is a prediction. Add a rule to the prompt, "Do not reassure, soften or predict. State the numbers and the direction", and the summary becomes:

This year the club spent $1,500 more than it took in. We had planned for a shortfall of $800, so we were $700 worse than the plan. The biggest difference was kit, at $2,300 against a budget of $1,400. The bank balance fell from $4,100 to $2,600, which covers about 2.8 months of spending.

The 2.8 months comes from the sheet ($2,600 divided by one-twelfth of $11,300), not from the model. A what-if belongs in the notes too, clearly labelled: if the same $1,500 shortfall repeated each year, the balance would last about 1.7 years. Then the first talking point is honest and the discussion begins in the right place: the committee isn't asked whether to worry, but which of the three levers to pull, whether that is fees, fundraising or cost.

Members' details stay out, and a routine you can repeat

Club accounts often hold personal information: who owes subs, who was refunded, who was paid for what. Keep all of it out. The prompt needs totals and categories only, never member names, individual arrears, bank account numbers, payroll for named people or anything involving safeguarding. Most assistants will take a spreadsheet upload, but pasting the one-page table instead means the AI never sees the ledger lines at all. Consumer ChatGPT and Claude plans have a model-training switch in privacy settings, and business plans don't train on your content by default, but the cleaner habit is to leave sensitive detail out on every plan. If your club has a paid account, use it rather than a personal one, and delete the chat when you've finished.

AI also can't settle questions of duty. Whether your accounts need an independent examination, what your constitution requires in the annual report, how restricted funds must be shown and what tax applies are for your governing body or an accountant. The tutorial on AI bookkeeping for nonprofits and restricted funds covers restricted and unrestricted money, and the one on fixtures, renewals and other committee admin covers the rest of what a club committee handles.

Plan on about 90 minutes the first time: grouping the ledger into lines, building the sheet formulas and writing the prompt. After that a routine report takes roughly 40 minutes: 10 to update the table, 5 to run the prompt, 10 to resolve markers and add reasons, and 15 to run the check. Those are planning figures, not measurements, so time your own. Save the table template, the prompt and a short "plain words" list in one folder, and the next treasurer inherits a process instead of a blank page.

Questions treasurers ask about the plain summary

Does the plain summary replace the formal accounts?

No. Your constitution, funders or governing body may require accounts in a set format, and some clubs need them independently examined or audited. The plain summary sits alongside them so committee members can understand the numbers. Ask your governing body or an accountant what your club must produce, because AI can't decide that.

How do I explain reserves in one sentence?

Divide the bank balance by a month's spending. In the example, $9,220 divided by about $1,052 a month is roughly 8.8 months of costs. Using only the general funds, $8,520, gives about 8.1 months. Say which figure you used, and remember that a few big annual bills, such as pitch hire, make some months far heavier than others.

How should I report a deficit?

Use the same method and say it plainly. Put the size of the shortfall and the cash left in the first talking point, tell the AI not to soften or reassure, and add a line for the committee on what has to change. Make the cause visible: the table's biggest differences usually explain most of it.

Should the report show each team separately?

Only when a decision depends on it. If juniors, seniors and social sides run their own budgets, add a short second table for each, and keep the main one-page table for the whole club. More tables than a committee can read in two minutes usually means fewer people read any of them.

Further reads

• How Accountants Use AI to Explain Tax to Clients in Plain English — How accountants put figures into plain English for clients.
• How to Manage a Community Centre: Where AI Helps and Where It Cannot — Another volunteer-run venue's admin, and where AI should stop.
• How Small Charities Can Use AI With Almost No Budget — Free and cheap AI options for volunteer-run organisations.
• Tennis Club Management Software: Bookings, Memberships and AI Reminders — Which jobs a small tennis club should expect from management software, and which reminder and message jobs AI can take over.
• Sports Club Code of Conduct: Player and Parent Versions With AI — Player and parent versions, a five-step sanctions ladder and a safeguarding link, drafted with AI and approved by your committee.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Microsoft Word help on readability statistics; Claude and ChatGPT privacy-setting and file-upload help pages. All club figures are illustrations built for this tutorial.