Way 1: without AI (the manual way)
Honest cost: 3-4 hours every month-end.
- Pull budget vs actual per account.
- Hunt the ledger and invoices for what moved.
- Write the explanation paragraph per line, with sources.
Writing variance commentary means hunting the ledger for what moved and then phrasing it for a non-finance reader. The method below runs it with an assistant: feed the rows, get a drafted explanation per line over your threshold with the source noted, and mark anything unexplained as a question - never a story.
Pros of doing it manually
- Free except your time - no tools, no accounts.
- You learn the job deeply and control every detail.
- No data leaves your hands.
Cons of doing it manually
- 3-4 hours every month-end - every single time the job runs.
- Quality depends on your energy that day.
- More volume just means more hours; it does not scale.
Way 2: with AI, but without AI Agent Skills (DIY prompting)
A chat assistant genuinely helps here. The catch is that you become the workflow designer. What you have to figure out yourself:
- You must paste the context yourself - without it the model writes confident fiction.
- You must force it to flag unexplained lines instead of smoothing them over.
- You must keep your budget format stable in the prompt each month.
Here is a starter prompt that works - copy it and bring the inputs listed:
Explain this month's budget variances: [paste account, budget, actual rows]. For each line: the variance and an explanation using only this context: [paste what you know]. If the context does not explain a line, mark it NEEDS SOURCE - do not invent a reason.More on this prompt: the free budget variance analysis prompt page.
Pros of DIY prompting
- Free, or nearly - any chat assistant works.
- A first draft in minutes instead of hours.
- Fully flexible: tweak the prompt for any edge case.
Cons of DIY prompting
- You become the workflow designer: prompts, test data and output rules are yours to write, test and maintain.
- Output drifts between sessions unless you re-paste the rules every run.
- Nothing is saved for you - sheets, structure and context are rebuilt each time.
Way 3: with AI Agent Skills (free, Free)
The Budget & Variance Agent is this job already designed: fixed evidence rules, output contract, test fixtures and stop points. You ask once:
Hello, explain this month’s budget variances
And a finished, review-ready artifact lands in your own Drive:
| Account | Budget | Actual | Variance | Source | Explanation |
|---|---|---|---|---|---|
| Infra & hosting | $1,200 | $2,100 | +$900 (75% over) | AWS invoice Aug | Traffic spike from launch week; may recur |
| Contractors | $6,000 | $5,400 | -$600 (10% under) | Bank feed Aug | One contractor invoice arrived late, lands in Sep |
Sample data shown. Your workspace fills with your real work.
Setup takes about 10 minutes: download, hand the Included files to the assistant you already use (Instinct, ChatGPT, Claude, Gemini or any other assistant that reads files), approve the fictional-data test. Then it runs on a standing cycle or a one-line ask, and stops at every human gate. Full method.
Pros of the ready-made agent
- About 10 minutes to a tested setup, not an afternoon of prompt tuning.
- The same output shape every run - evidence rules and stop points are already designed.
- Runs on a standing cycle or a one-line ask; files land in your own Drive.
Cons of the ready-made agent
- Costs free, where DIY prompting is free.
- The output format is opinionated - you adapt the template rather than rebuild it.
- It still stops and waits for your approval at decision points; it is not zero-touch.
The honest comparison
| Way 1: manual | Way 2: DIY AI | Way 3: free agent | |
|---|---|---|---|
| Time to first result | 3-4 hours every month-end | An afternoon of prompt tuning | About 10 minutes, tested setup |
| Every run after | Same hours, every time | Re-paste the rules, sheet and context each run | One short ask, or a standing cycle |
| Consistency | Depends on the day | Drifts between sessions | Same output shape every run |
| Cost | Your hours | Free, plus your time | Free, files kept forever |
The manual way teaches you the job. DIY prompting is fine for a one-off. The agent wins when the job repeats every week.
More: the Budget & Variance Agent product page · the budget variance analysis guide · AI agents for finance teams
Questions people ask
What is the fastest way to explain budget variances?
The free ready-made agent: about 10 minutes of setup, then one short ask per run. Manual takes 3-4 hours every month-end; DIY prompting takes an afternoon of tuning plus upkeep.
Can I explain budget variances without AI?
Yes - the manual steps are on this page. Expect 3-4 hours every month-end each time the job runs.
Is the free agent worth it over DIY prompting?
If the job repeats weekly, yes: you stop rebuilding prompts and re-pasting context every run. For a one-off, DIY prompting is fine and free.
Last updated 13 September 2026 · Reviewed by the AI Agent Skills team.