FP&A practice
AI Variance Analysis for FP&A: A Worked Budget vs Actual Example
From the budget gap to the business explanation: what AI can prepare, what finance needs to investigate, and what belongs in the finished report.
Revenue is below budget. Direct costs are higher. Before the review meeting, finance needs to explain which business events caused the shortfall, what they mean for the outlook, and what management should do next.
Working with Précis, the analyst starts with the major movements and a quantified breakdown, takes focused questions to the business, then brings validated findings back to prepare the report. This example follows that process from the budget gap to the completed commentary.
Précis includes a built-in variance-analysis skill: guidelines that help structure comparisons, quantify drivers, prioritise investigation and prepare commentary. Drawing on guidance from AFP, ACCA and AICPA & CIMA, the skill helps your team follow a consistent approach. Your team validates the business explanations and owns the conclusions.
What should variance analysis explain?
Variance analysis compares actual performance with a budget, forecast or prior period and investigates the reasons for the difference. A completed analysis should address five questions:
- What changed? Identify the material difference and its effect on the result.
- Where did it happen? Locate the movement in the relevant business unit, customer, project, product or period.
- Why did it happen? Establish the business events behind the financial and operational movements.
- What happens next? Assess whether the effect reverses, continues or changes the forecast.
- What response is needed? Set out the action, accountable owner and timing.
The Association for Financial Professionals’ variance-analysis guidance connects the review to causes, controllability and responsibility for a response. It also calls for investigating significant favourable movements: lower costs can reflect a useful improvement, postponed activity or a problem elsewhere.
Establish the comparison and prioritise the investigation
Start with the actual period, close status, named budget or forecast version, business scope and reporting currency. Keep those choices consistent as the review moves into more detailed figures. The original budget tests performance against the agreed plan; the latest forecast tests the most recent expectations.
Then prioritise the movements that change the business discussion. Use both absolute amounts and percentages, alongside trends, unexpected changes and offsetting movements. Finance sets the thresholds and can elevate a smaller item when it exposes an important risk or assumption.
For costs that vary with activity, compare actual spending with the cost expected for the activity actually delivered. Keep the original budget gap visible as well. Spending less because the business delivered less is a different result from improving cost efficiency.
Also test the planning assumptions. ACCA’s worked discussion of planning and operational variances shows how unrealistic standards can make operating performance appear better or worse than it was. A useful review explains both the operating outcome and what finance needs to learn for the next plan.
Start with the movements that explain the profit gap
The analyst asks Précis to prepare NovaTech’s Q1 2026 statement against budget and identify the main contributions to the EBITDA shortfall. This fictional case uses the same sample figures as the Précis management-reporting example. Currency values are in € thousands; cost rows show positive expense amounts.
| Statement line | Actual | Budget | Actual minus budget | Reading |
|---|---|---|---|---|
| Revenue | 7,420 | 7,650 | −230 | Below budget |
| Direct costs | 4,560 | 4,440 | +120 | Above budget |
| Gross profit | 2,860 | 3,210 | −350 | Below budget |
| Operating costs | 1,240 | 1,280 | −40 | Below budget |
| EBITDA | 1,620 | 1,930 | −310 | Below budget |
| Line / driver | Actual | Budget | Vs budget | Prior year | YoY |
|---|---|---|---|---|---|
| Revenue | 7,420 | 7,650 | −230 | 7,110 | +4.4% |
| Direct costs | (4,560) | (4,440) | −120 | (4,320) | −5.6% |
| Gross profit | 2,860 | 3,210 | −350 | 2,790 | +2.5% |
| Gross margin % | 38.5% | 42.0% | −3.5pp | 39.2% | −0.7pp |
| Operating costs | (1,240) | (1,280) | +40 | (1,180) | −5.1% |
| EBITDA | 1,620 | 1,930 | −310 | 1,610 | +0.6% |
| EBITDA margin % | 21.8% | 25.2% | −3.4pp | 22.6% | −0.8pp |
| Billable hours | 62,840 | 64,200 | −1,360 | 60,910 | +3.2% |
| Realised rate | €118.1 | €119.2 | −€1.1 | €116.7 | +1.2% |
| Utilisation % | 74.8% | 76.0% | −1.2pp | 73.5% | +1.3pp |
| Avg FTEs — billable | 142 | 140 | +2 | 137 | +3.6% |
| Avg FTEs — overhead | 40 | 40 | — | 39 | +2.6% |
| Avg FTEs — total | 182 | 180 | +2 | 176 | +3.4% |
EBITDA is €310k below budget (16.1%), while revenue is €230k below budget (3.0%). The EBITDA shortfall comprises €230k less revenue and €120k more direct costs, partly offset by €40k lower operating costs. Gross profit is the intermediate result: counting its €350k shortfall again would duplicate the revenue and direct-cost effects.
This gives the investigation three priorities: explain the revenue shortfall, establish what drove the additional direct costs, and check whether the operating-cost saving will last. The favourable movement matters because it may reverse in a later period.
Quantify the revenue drivers before asking the business why
The statement also shows 62,840 billable hours against a budget of 64,200, and an average realised rate of €118.1 against €119.2. In this example, realised rate is revenue divided by billable hours, using the same scope for both measures.
The analyst next asks Précis to break the €230k revenue gap into the effects of billable hours and realised rate:
| Revenue effect | Calculation basis | Impact (€ thousands) |
|---|---|---|
| Fewer billable hours | 1,360 fewer hours valued at the budgeted average rate | −162.1 |
| Lower average realised rate | The rate difference applied to actual hours | −67.9 |
| Total revenue variance | Actual revenue less budget revenue | −230.0 |
Use unrounded rates calculated from revenue and hours; the displayed rates are rounded for readability. This follows the price-and-volume approach described by AFP, with hours representing activity in this services example.
The breakdown shows that roughly €162k of the gap sits in activity and €68k in the average revenue earned per hour. It directs the analyst towards two specific questions: what reduced delivered hours, and what changed the average realised rate?
The rate movement could include changes in service mix, contract rates, discounts or revenue adjustments. Project-level comparisons are needed to separate those effects. Likewise, fewer hours could reflect delayed starts, available work, delivery capacity or incomplete time records.
Prepare a focused investigation for business owners
The analyst uses the statement and revenue breakdown prepared with Précis to organise the business conversations around four questions:
| Priority | Question to resolve | Supporting evidence and business input |
|---|---|---|
| €162.1k activity effect | Where are the missing hours concentrated, and what prevented delivery? | Monthly and project comparisons, complete time records, delivery plans and discussion with the delivery owner |
| €67.9k average-rate effect | Is the movement explained by service mix, individual rates or revenue adjustments? | Comparable project revenue and hours, contract terms and commercial-owner input |
| €120k additional direct costs | Which costs increased, why were they needed, and will they continue? | Cost-account and supplier detail, approved commitments and delivery/procurement input |
| €40k lower operating costs | Is this a lasting saving or activity postponed to a later period? | Budgeted activity, expense and commitment records, and the budget owner’s revised schedule |
Use the available breakdowns to narrow these questions before approaching the business. A query such as “why are costs above budget?” becomes more productive when it names the cost category, period and team where the movement occurred. Where the required detail is missing, the analyst knows which records or confirmation to obtain.
This business investigation is part of finance’s responsibility. AFP and APQC’s research into effective FP&A teams emphasises business understanding, collaboration and asking questions beyond what the report itself reveals.
Validate the explanations with the business
The analyst takes those questions to the business. For this stage of the fictional case, assume they obtain the following additional records and confirm the findings with the relevant business owners. These details are illustrative additions to the case; they are not present in, or inferred from, the original sample statement.
| Validated finding | Financial contribution | How the analyst validates it |
|---|---|---|
| Starts on two customer engagements moved into Q2, reducing Q1 delivery by 1,360 billable hours | €162.1k revenue shortfall at the budgeted average rate | Revised start dates, delivery schedules and the project revenue bridge reviewed with the delivery owner |
| Delivered work shifted towards services with lower contracted rates; individual contract rates were unchanged | €67.9k revenue shortfall from service mix | Project-level revenue and hours compared with budgeted mix, checked against contracts with the commercial owner |
| Ongoing engagements required additional specialist subcontractor cover; those assignments ended at quarter close | €120k additional direct costs | Supplier charges, approved assignments and completion dates checked with procurement and delivery |
| A management training programme planned for March moved to April | €40k lower Q1 operating costs, with the expense expected in Q2 | Revised training dates and supplier commitments confirmed with the budget owner |
The analyst checks that the revenue explanations account for the same €230k gap identified earlier. The delayed starts and service mix explain the preliminary hours and rate effects; they are not additional amounts to add to them. The two cost findings complete the explanation of the €310k EBITDA shortfall.
Business-owner confirmation should be supported by records and a financial reconciliation. A label such as “timing” needs the specific activity, amount, revised date and evidence that it remains expected. Any material residual should have an explicit investigation owner and next review date.
Complete management commentary with causes, outlook and actions
With those findings validated, the analyst asks Précis to help assemble commentary covering causes, outlook and actions, then reviews and completes the report. In this fictional case, the final commentary could read:
Q1 EBITDA was €1.62m, €310k below budget (16.1%). Revenue was €230k below budget (3.0%): €162k relates to two customer engagements whose starts moved into Q2, and €68k to a greater share of work in services with lower contracted rates. Individual contract rates were unchanged.
Additional specialist subcontractor cover on ongoing engagements increased direct costs by €120k. Those assignments ended at quarter close. A €40k operating-cost underspend partly offset the shortfall because the March management training programme moved to April; this expense is expected in Q2.
The forecast now reflects the revised project starts, April training and the current service mix. Recovery of the delayed revenue remains dependent on the agreed Q2 starts. The delivery owner will review those dates weekly; the commercial owner will review the mix of booked work before the next forecast. Finance will assess the resulting revenue and margin outlook.
This example assumes finance has approved the revised forecast. The €162k and €68k amounts are rounded from the validated €162.1k and €67.9k contributions.
The commentary explains the financial effects, their business causes, what is expected to reverse and who will follow up.
Carry the findings into the forecast
Each validated cause needs its own forecast treatment. In this case, delayed project starts change the revenue schedule; a different service mix changes the expected average rate; the completed subcontractor assignments and rescheduled training have different cost implications.
Finance also checks capacity, commitments and remaining risks before assuming that delayed work will be recovered. Applying the entire €310k shortfall to the full-year forecast would miss these differences. Project timing can affect future delivery capacity, while mix can change the margin on later work.
The AICPA & CIMA Global Management Accounting Principles connect budgetary control with business drivers and evidence supporting projections. Use the validated findings to test the remaining plan, agree assumptions with the business, and evaluate actions or alternative scenarios. The assistant can prepare those comparisons for finance review.
For the next review, Reviewing the Latest Forecast shows how to compare forecast versions, challenge the remaining assumptions and turn the findings into management commentary.
What to check before sharing the report
Before the report goes to management, check that:
- The actual period, comparison version, scope and close status are explicit.
- The material drivers reconcile to the headline variance, with offsetting effects visible and no double counting.
- The business explanations are specific, quantified and validated against supporting records and business-owner input.
- The outlook distinguishes postponed activity, completed costs and changes expected to continue, with recovery assumptions tested.
- Actions have accountable owners and timing; forecast changes have finance approval.
- Any material unresolved item states what remains to be established, its decision implications, who owns the investigation and when it will return.
The resulting report should give management a basis for decisions. An initial findings summary serves the earlier investigation and should be labelled accordingly.
Explore the Précis variance-analysis workflow, or read how to prepare monthly management reporting without replacing Excel.