Budget vs actuals that department heads actually read

Department heads are accountable for budgets they rarely see in a usable form. Finance exports a spreadsheet, nobody opens it, and questions arrive at quarter end. A focused internal tool can deliver each leader their own numbers, explain the drivers, and answer follow-up questions from the underlying transactions.

01the problem and who owns it

After close, finance produces budget versus actuals by department, often a large spreadsheet. Department heads either skim it or ask finance to explain line items one by one. Finance spends days answering why software spend is over, which is usually a handful of renewals or one new tool someone bought on a card.

FP&A owns the reporting and the forecast; department heads own the spending decisions. When leaders cannot see their numbers clearly, overspending is discovered late and reforecasts are guesswork.

02what the AI does, step by step

1. Pull closed actuals and budgetAfter close is final, the tool loads actuals by account and cost center from the ledger, plus budget and the latest forecast from the planning model, mapped to the same reporting lines.
2. Find what movedFor each department, lines over or under budget beyond a set threshold are selected. The tool then finds the transactions and vendors responsible, including new vendors, one-time items, and accruals that will reverse.
3. Write a short briefEach leader gets a one-page view: total versus budget, year-to-date position, and three or four plain-language explanations naming the vendor, invoice, or headcount change behind each variance.
4. Answer questions from the dataLeaders can ask questions such as what did we pay that contractor this quarter. The tool answers by querying the ledger and returns the transactions, limited to the cost centers that person is permitted to see.
5. Collect forecast inputLeaders are prompted to confirm or adjust the remaining-year forecast for flagged lines, with a reason, and their inputs are written back for FP&A to review.
6. Summarize for financeFP&A receives a roll-up: departments trending over, open questions, and forecast changes submitted, ready for the leadership review.

03systems it connects to

• General ledger. NetSuite, Sage Intacct, QuickBooks, Xero, or Dynamics for closed actuals.
• Planning model. Excel or Google Sheets, or a planning tool such as Adaptive Planning, Cube, or Pigment.
• Identity and permissions. Single sign-on and a mapping of people to the cost centers they own.
• Delivery. Email or chat with a link to a simple web view.

04human checkpoints

• FP&A reviews before release. Briefs go out only after finance checks the explanations for that period.
• Forecast changes approved. Leader adjustments are proposals until FP&A accepts them into the official forecast.
• Access review. Finance confirms quarterly that each person can see only the cost centers they own.

05what to measure

• Leader engagement. Share of department heads opening their brief and asking at least one question.
• Finance question load. Ad hoc spend questions finance answers by hand, compared with before.
• Forecast accuracy by department. Whether leader inputs improve the remaining-year forecast.
• Explanation corrections. How often FP&A edits a drafted variance explanation.

06risks and guardrails

• Permission leaks. Salary data lives in many ledgers. A question-answering tool must enforce cost center and account permissions in the query layer, and payroll detail may need to be excluded entirely.
• Answers from bad mappings. If budget and actuals map to different line definitions, every explanation is wrong. Fix the mapping before adding narrative.
• Number hallucination. Figures must come from queries, not from the model's text. Display numbers directly from the data and let the model only describe them.

07build vs buy

FP&A platforms such as Adaptive Planning, Cube, Pigment, and Vena provide budget versus actuals reporting and departmental views, and some add AI commentary. If you are ready to move planning onto one, that solves reporting at the same time.

A custom internal tool fits companies that want to keep their spreadsheet model but give leaders a clear, permissioned view and a way to ask questions of the ledger, without licensing a full planning platform for every department head.

08related playbooks

Browse every finance and accounting playbook or the full library.