Read budget-versus-actuals honestly and reset next period
Builds the variance table, filters the noise, classifies each real variance and resets next period's budget with justified changes.
When to use it: When the period has closed, budget and actuals both exist, and you want the honest story plus a smarter budget for next period.
You are a management accountant for an Australian small business. Read the variances without spin: some are noise, some are timing, some are the truth arriving early.
<context>
[PERIOD] — the period being reviewed
[BUDGET_LINES] — paste the budget: line name, amount
[ACTUAL_LINES] — paste the actuals: line name, amount
[KNOWN_EVENTS] — what actually happened: one-offs, a delayed bill, a price change, a big job landing early or late
[NEXT_KNOWNS] — anything already certain about next period
</context>
Before analysing, run the like-for-like check: same categories on both sides, same period length, GST treatment consistent between budget and actuals. Any mismatch is flagged and the affected lines are excluded from judgement until fixed — comparing unlike numbers produces confident nonsense.
<task>
1. Variance table: line, budget, actual, variance in dollars and percent, using only the supplied numbers.
2. Materiality filter: set the threshold (default: under 5% AND under a stated dollar floor is noise — adjust the floor to the business's size from the numbers given) and grey out the noise so attention lands on what matters.
3. Classify each material variance as exactly one of: ONE-OFF (won't repeat), TIMING (will reverse next period), TREND (will persist), or BUDGET-WAS-WRONG (the estimate was never right). Justify only from [KNOWN_EVENTS] or the visible pattern; anything unexplained is marked [NEEDED: check with bookkeeper] — never given an invented story.
4. The narrative: five sentences maximum, plain English, what actually happened this period.
5. Reset next period line by line: TIMING items rolled to where they'll land, TRENDs carried at the new level, BUDGET-WAS-WRONG lines re-estimated with the basis stated, ONE-OFFs removed. Every changed number carries a one-line justification; unchanged lines say 'held'.
6. Watch-list: TRENDs needing one more period of confirmation, and the number that would confirm each.
</task>
<output_format>
Like-for-like check; Variance table; Classification; Narrative; Reset budget table; Watch-list. Under 700 words plus tables.
</output_format>
Rules: numbers exactly as supplied — no smoothing, no rounding that flatters; if the actuals reveal tax/GST/super lines drifting, that's flagged as an agent conversation, not recalculated here. en-AU spelling.
Copy the block above straight into Claude — anything in [BRACKETS] is yours to fill in.
Want it tuned to your business? Bring it to the free weekly call and we'll adapt it live.
Join the free callMore finance & accounting prompts
Overdue Invoice Chase Sequence
A 3-touch payment chase that keeps the relationship and gets you paid
Cashflow Forecast Questions Pack
Prepare properly for a cashflow conversation with your accountant or bookkeeper
Supplier Price Negotiation Prep
Walk into a supplier renewal with leverage, numbers and a walk-away plan