Budget Variance Analyst
Actuals vs budget by category with the narrative behind every variance — ready before the monthly review.
Month-end reviews stall when the variance story has to be reverse-engineered from a spreadsheet the morning of. This recipe pulls the period's actuals from the Stripe ledger, reads the budget definitions from your docs or spreadsheet, and buckets spend against the budget categories with the mappings normalized once and remembered. It computes variance per category with the named drivers behind each mover, and projects run-rate to period end so categories on track to blow through budget are flagged before they do, not after. The output is a variance brief — table, three narratives for the biggest movers, corrective asks per material variance — written to your docs only after you approve the draft. Idempotent per budget + period window: reruns update the brief in place, never duplicate a row or restate a period already briefed.
How it runs
Multi-agent orchestration — here's the flow, step by step.
Resolve the budget definition and period window, load prior category mappings from memory, and dedupe against any brief already issued for the period.
workflow orchestratorLoad the budget set from the documents or spreadsheet connection and normalize category mappings to the actuals taxonomy.
data analystPull the period's actuals from the Stripe ledger, keyed to the normalized categories.
payment scannerBucket actual spend against budget categories, compute variance % per category, and name the top drivers behind each mover.
data analystProject run-rate to period end and flag categories on track to blow through budget before they do.
forecast modelerDraft the variance brief: the variance table, three narratives for the biggest movers, and a corrective ask per material variance.
document writerStage the brief for one-click approval; on approval, write it to the documents connection, stage the Slack heads-up, and return receipts.
distributorAssemble the summary: categories over and under, projected breaches, and the in-hub footer when connections are missing.
report formatterRequired Agents
7- workflow-orchestrator
- payment-scanner
- data-analyst
- forecast-modeler
- document-writer
- distributor
- report-formatter
Connections
Required
Optional
What it does
- Actuals pulled from the payment ledger for exactly the budget period
- Budget set read from your docs or spreadsheet, category mappings normalized and remembered
- Variance % per category with the named drivers behind each mover
- Run-rate projection to period end flags categories on track to blow through budget
- Variance brief drafted: table, three narratives, corrective asks per material variance
- Brief written to your docs only after you approve the draft
- Slack heads-up staged for the review meeting when connected
- Idempotent per budget + period window — reruns update in place, never duplicate
Example prompt
It's month-end — compare last month's actuals against our operating budget and draft the variance brief for the review on Friday.
Ready to deploy Budget Variance Analyst?
Start free. One click, full agent orchestration.
Get Started Free →