AI for School Business Managers: Budgets, Quotes and HR Letters

A school business manager can use AI to turn budget variances into plain-English commentary, lay three supplier quotes side by side, and draft HR letter templates, provided nothing identifiable goes in. Paste category totals and anonymised quote text, use placeholders for names and dates, check every figure yourself, and let your HR adviser approve the wording.

The three jobs share one rule: AI writes and formats, you calculate and decide. A school finance office is audited, answers to governors or trustees, and holds data about children and staff. That shapes every step below, from what you paste to how you keep a record of what you did.

Follow me on Instagram@sagnikteaches

Budget variance commentary that matches the spreadsheet

Monthly reports to a finance committee need two things: the numbers and a few sentences explaining them. The sentences take the time. AI is good at turning a table of variances into readable paragraphs, as long as you give it the figures and the reasons and it adds neither.

Connect on LinkedInSagnik Bhattacharya

Start in the spreadsheet. Calculate budget, actual to date, forecast to year-end and variance for each category. Do the sums in Excel, not in the chat. Then copy only the category-level table. Here is an illustrative table for a mid-sized school, in thousands of dollars to keep it generic:

Subscribe on YouTube@sagnikteaches

The net is -15.5 + 7.8 - 1.1 + 3.6 - 1.1 = -6.3, an overspend of $6.3 thousand to date on these five lines. (Income variances read the opposite way in some templates, so the net of cost and income lines needs care. Say which sign convention you use.) Now the prompt:

You are helping a school business manager write the budget commentary for a finance
committee. Below is a table of variances. Sign convention: negative means worse than budget.
Write one short paragraph per category with a material variance (more than $5,000 or more
than 10 per cent), using ONLY the reasons I have given. Do not suggest causes, and do not
forecast. Then write a three-sentence summary of the overall position. Quote each figure
exactly as shown. Flag any line where my reason does not seem to explain the size of the
variance.
[paste category table]

Illustrative output for the first line: "Supply cover is $15.5k over budget to date ($57.5k against $42.0k). Three long-term absences were covered by agency staff." Good. Check how it handled the last instruction. A well-behaved reply might add: "The reason given explains a pattern but not whether the cost will continue; consider adding a forecast." That is the assistant asking for a fact, which is useful, and you decide whether to supply it.

What to fix every time

• Direction errors: "underspend" written for a negative variance on a cost line. Read each sentence against the table.
• Invented causes: "likely due to rising energy prices". If you did not say it, strike it out.
• Rounded numbers that no longer reconcile. Ask for exact figures and compare.
• Tone: committees want neutral. Remove "unfortunately" and similar.

Time saved is modest per month, perhaps 30 to 45 minutes on a report with six to eight narrative lines, but it also makes the wording consistent from month to month. If you want the reverse check, ask the assistant to read your own commentary against the table and list any sentence the figures do not support.

Three quotes into one comparison table

Procurement policies usually require several quotes above a threshold, and the paperwork is where the time goes: each supplier lays out its quote differently, some include delivery, some exclude installation, some hide the annual licence fee in a footnote. A comparison table is the job AI does well, because it is extraction and layout.

Before you paste anything, decide your evaluation criteria and weightings and write them down. That is your protection: you set them before you saw the quotes, not after. Then remove or ignore anything you should not share, such as the supplier's commercially confidential rate card if your terms say so, and paste the text of each quote.

I am comparing three supplier quotes for the same item: classroom interactive displays
for 12 classrooms. Extract from each quote into one table: supplier (call them A, B and C),
unit price, quantity, delivery, installation, warranty length, annual support or licence
cost, payment terms, quote validity date, and anything excluded. Add a column for total
cost over 5 years, showing the calculation. If a field is not stated, write NOT STATED, do
not guess. Do not recommend a supplier.

Say the output reads: Supplier A $1,450 per unit, delivery included, installation $120 per unit, 3-year warranty, support $0, 5-year cost = 12 x (1,450 + 120) = $18,840. Supplier B $1,290 per unit, delivery $400, installation NOT STATED, 5-year warranty, support $90 per unit per year from year 2, 5-year cost = 12 x 1,290 + 400 + 12 x 90 x 4 = 15,480 + 400 + 4,320 = $20,200 plus installation. Supplier C $1,380 per unit, everything included, 2-year warranty, support $60 per unit from year 3, so 12 x 1,380 + 12 x 60 x 3 = 16,560 + 2,160 = $18,720.

What to fix: Supplier B has the lowest unit price, yet on these figures it is already the most expensive over five years because of the support fee, and its installation cost is still missing, so the gap can only widen. A unit-price comparison hides both points, which is why the five-year column earns its place. Write to Supplier B for a written figure and give all suppliers the same opportunity to clarify. Also check the arithmetic: assistants are normally accurate on multiplication of this size, but add the totals yourself.

Keep the scoring yours

Take the table and score it against your weighted criteria in the spreadsheet: price 40 per cent, quality and warranty 30, support 20, delivery 10, for example. Record who scored, when, and the evidence. If you ask AI to suggest a supplier, you invite the problem of an unreasoned recommendation going into the file. Ask instead for questions to put to each supplier, which is safe and often valuable:

From the table above, list the clarification questions I should send to each supplier so
that all three quotes are comparable. One list per supplier. Do not rank them.

HR letters: templates with placeholders, never cases

School HR letters are formulaic: invitation to a meeting, acknowledgement of resignation, confirmation of a change to hours, an offer letter, a fixed-term contract end. AI can draft the template in a minute. It should never see the case.

The method is a template with square-bracket fields, which you fill from your HR system afterwards:

Draft a template letter inviting an employee to a meeting to discuss attendance. Use
placeholders in square brackets for every personal detail: [first name], [job title],
[date of meeting], [time], [location], [name of manager], [name of person accompanying
if any]. Tone: calm, factual, supportive. Do not state or imply any outcome. Include a
sentence about the right to be accompanied, with a placeholder [check wording against our
HR policy]. Plain English, under 220 words.

Illustrative output: "Dear [first name], I am writing to invite you to a meeting on [date] at [time] in [location] to talk about your recent absence from work. The meeting is to listen to you and to understand whether we can offer any support. [Name of manager] will lead the meeting. You may bring a colleague or a trade union representative. [Check wording against our HR policy.] If the date is difficult, please let me know and we will arrange another. Yours sincerely, [your name]." What you would fix: remove any sentence promising confidentiality you cannot guarantee, make the right-to-be-accompanied wording match your policy and the law as your HR adviser states it, and check that the tone fits your school.

Then your adviser or HR provider approves the template once. After that you reuse it. This is where the gain lies: not in drafting each letter, but in a small library of approved templates that nobody has to rewrite.

A starter library worth building

• Meeting invitation (attendance, performance, welfare): three tones, same structure.
• Acknowledgement of resignation and last-day confirmation.
• End of fixed-term contract, with a placeholder for the reason.
• Reference request acknowledgement.
• Offer letter with conditions, each condition a placeholder.
• Return-to-work meeting invitation.

Disciplinary and capability letters belong with your HR adviser or provider, whatever tool drafts the first version. Do not let AI draft wording about a named person's conduct, health or performance.

A messy quote, before and after

Quotes rarely arrive as tidy tables. Here is an illustrative extract from a supplier email, as it might land in your inbox, followed by what the extraction step should return.

Before: "Thanks for your enquiry. We can supply 12 x 75 inch displays at 1,290 each plus carriage of 400. Fitting is available on request. Our 5 year warranty covers panel and parts but not labour after year 1. Optional support plan 90 per screen per annum, first year included. This quote is valid for 28 days from the date above and is subject to our standard terms."

After (illustrative): Unit price $1,290; quantity 12; delivery $400; installation NOT STATED (available on request); warranty 5 years, parts and panel, labour only in year 1; support $90 per screen per year from year 2; validity 28 days; exclusions: labour after year 1, installation.

The extraction is useful for one reason above all: it surfaces "NOT STATED". The phrase "labour only in year 1" is easy to miss in a paragraph and expensive to miss in a contract. When you compare three quotes this way, you also see which supplier left the most gaps, which tells you something about how they will behave after the sale. Send the same clarification questions to all three, and put the replies in the file.

Staffing costs without salary data

Staffing is the largest line in most school budgets and the one that most tempts people to paste a payroll extract. Do not. You can still get a useful narrative if you work at the level of totals and drivers and keep individual pay out of the chat.

Give the assistant the budget and forecast total for teaching staff, support staff and cover; the headcount in full-time equivalents at the start and now; and the known drivers (a vacancy filled mid-year, a pay award taking effect in a given month, a long-term absence). Nothing person-level. A prompt that works:

Below are three staffing totals, with FTE and known drivers. Write a short narrative for a
finance committee that explains the forecast variance by driver. Use only the drivers listed.
For each driver, state the approximate effect in dollars if I have supplied it; if I have
not, write [effect to be confirmed]. Do not name or describe any individual.

An illustrative sample: teaching staff forecast $1,214,000 against a budget of $1,190,000, an overspend of $24,000. The drivers are a vacancy filled one term earlier than planned (about $16,000) and a pay award in September budgeted at a lower percentage (about $8,000). The check is simple addition: 16 + 8 = 24. If the assistant writes a sentence with a figure that does not appear in your input, delete it. If the drivers do not add up to the variance, the commentary should say so and you should chase the gap in the spreadsheet, not smooth it over with prose.

Asking the assistant to challenge you

A useful second pass: paste your finished commentary and ask, "What questions would a trustee ask about this paragraph?" The answers are often good (what is the plan if the absences continue? is the supply cover line forecast or actual?). Treat them as a rehearsal for the meeting. You still answer from your own knowledge of the school.

How a sickness note slipped into a committee pack

An illustrative one. A finance officer pasted a full budget export into a chat tool to tidy the commentary. The export had a cost-centre column with staff initials, and a note column that read "supply cover for [initials], long-term sickness". The assistant wrote a neat paragraph that repeated the note. The paragraph went into the committee pack, and the sickness detail reached people who had no need to know it.

Two controls prevent this. First, build a clean category table in a separate sheet and paste only from that. Never paste from the working sheet. Second, search the final commentary for initials, names and the words "sickness", "capability" and "grievance" before the pack goes out. A thirty-second find is cheaper than any apology.

Wording for the team, ready to adapt

If your school has no AI guidance yet, a one-paragraph rule for the finance office is a good place to start. Illustrative wording to adapt with your data-protection officer:

Finance staff may use the school-approved AI tool to draft narrative, format tables and prepare template letters. They may not enter pupil data, staff names or individual pay, safeguarding or HR case material, or supplier information marked confidential. Every figure and every statement of fact in AI-assisted work must be checked against the source before use. The person who sends the document is responsible for it. Uses are noted in the finance office AI log.

That paragraph is short enough to be read, and specific enough to be followed. When your trust or authority publishes its own policy, replace this with a pointer to it. The tutorial on rolling out an AI policy covers getting staff to follow it.

Smaller jobs worth trying once the three are steady

• Minutes for the finance committee: paste your own typed notes (roles, not names) and ask for action points with owners as roles.
• A summary of a long supplier contract: extract notice periods, renewal dates and exit costs into a table, then read the original clauses yourself.
• Parent-facing wording for a charge or trip cost: draft a short letter explaining a price rise, with placeholders for the amount and date.
• A year-end checklist: ask for a task list built from your own list of deadlines, so nothing slips.

What never leaves the finance office

A written list helps everybody in the office, including a new colleague. Keep out: pupil names and any pupil-level data, safeguarding information, staff names, individual salaries and pay grades tied to a person, health or absence reasons, anything from a disciplinary or grievance file, bank details, supplier contracts marked confidential, and passwords or account numbers. If a task needs an example, invent one and say so.

Next, the account. A personal free account is the wrong place for school work. A school-approved plan with training turned off by default, or a tool your trust or local authority has cleared, is the right one. The vendors' business plans say they do not train on your content by default, but verify the current terms yourself and ask your data-protection officer to confirm they fit your records. For a written policy to point to, see the AI usage policy tutorial, and for the removal method, anonymising data before you paste it.

A one-line record that protects you

Each time you use AI for a report, keep a line in a log: date, task, what went in (category totals only), who checked the output. It takes ten seconds and turns a vague "we use AI sometimes" into a controlled process. If a governor or auditor asks how the commentary was produced, you can answer in one sentence.

A realistic week for a school office

Here is how the three jobs fit into a normal month, in illustrative timings for a school with one business manager and two finance assistants.

Do not read those minutes as promises. The point is where the time goes: the checking stays, and it should. For a wider look at which office jobs are worth automating, see AI automation for education. If your front office is the bigger pain, the school absence-call tutorial covers it. The hub for everything else is the AI guide.

Three numbers to compare after a term

After a term, compare three things: time spent on the monthly report, the number of corrections the finance committee asked for, and whether the quote files are complete and consistent. If corrections rise, the checking step is being skipped. If time does not fall, the prompts are too loose, so tighten them with the fixed sign convention and the "use only my reasons" rule.

Questions school finance teams ask about AI

Can I paste the budget spreadsheet into ChatGPT?

Budget lines are usually fine if they hold no names, pupil data or individual salaries. Remove staff-level pay, then paste category totals only. Check your trust or governing body's AI and data policy first, and use an account type that your school has approved rather than a personal one.

Is it safe to use AI for HR letters?

Only for the template, never the case. Write the letter with placeholders such as [first name] and [date], and fill in the real details in your HR system afterwards. Anything with a name, a health detail or an allegation stays out of the prompt. Your HR adviser signs off the wording.

Will AI pick the best supplier?

No. It can tidy three quotes into a like-for-like table and flag gaps, but the choice follows your procurement policy and the evaluation criteria you set before you opened the quotes. Keep the scoring yours and keep the audit trail.

How do I check the commentary is right?

Recalculate every variance in the spreadsheet yourself first, give the assistant the figures, and tick each sentence against the numbers. Most errors are a wrong direction (overspend written as underspend) or a cause the assistant invented. Remove any cause you did not supply.

Do governors or trustees need to know I use AI?

It is good practice to tell them, and many schools now record it in a data-protection impact assessment or AI policy. Say what you use it for, what goes in, and who checks the output. That record also helps if an auditor asks how a report was produced.

Further reads

• How to Write an AI Policy for a Small Charity — A one-page policy for an organisation with trustees.
• How to Redact Personal Data From Documents With AI Before Sharing — Redacting documents before they go near an AI tool.
• What to Check in an AI Tool's Privacy Policy and Terms — What to read in a vendor's privacy policy and terms.
• AI Acceptable Use Policy for a Small Professional Firm — Acceptable-use wording you can adapt for staff.
• Does a Five-Person Business Really Need an AI Policy? — Why even a small team benefits from a written policy.
• Stationery Shop Marketing Ideas: School and Corporate Orders With AI — A step-by-step plan for winning school and small-office orders: the price sheet, the buyer list, AI-drafted emails, follow-ups, samples and quotes.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: OpenAI business data page and Anthropic privacy centre article on model training (both checked 4 November 2026: business and commercial plans are not used for training by default); the reader's own procurement, finance and HR policies.