Revenue Beat Budget. Why Did Operating Profit Fall Short?

The quarter has closed. Revenue is ahead of budget and higher than the same fiscal quarter last year. Operating profit is below budget.

The CFO wants to know why revenue above budget has not delivered the expected operating profit. The controller needs the numbers to agree with the management accounts. The financial planning and analysis (FP&A) team needs to explain the gap and identify what to investigate next.

Consider a hypothetical company with several business units. Its finance team could use AIREA to follow those questions, inspect the supporting work and share a clear explanation. Finance remains responsible for the definitions, checks and interpretation.

Agree on the numbers before comparing them

For this review, the controller has prepared the closed quarter’s results, the approved budget and results for the same fiscal quarter last year. Data owners have approved their use in the analysis. Accounts and business units are grouped consistently across all three sets of figures.

Finance confirms the fiscal dates, reporting currency, exchange rates and treatment of transactions between group companies. Differences between the rates used for budget and actuals must remain visible, along with any incomplete records or unresolved adjustments.

The measures are explicit. Revenue is net of the credits included in the approved accounts. Gross profit is revenue less the agreed cost of goods sold. Gross margin is gross profit as a percentage of revenue. For this management review, operating profit is gross profit less operating expenses, using finance’s approved account classifications.

Finance uses these same definitions when reviewing each answer, even as the questions change.

Explore: find where revenue exceeded budget

The FP&A lead begins with a comparison the available data can support:

Compare actual revenue with budget and the same fiscal quarter last year by business unit. For each comparison, show the difference in reporting currency and percentage, and each unit’s contribution to the total difference.

AIREA can generate tables, charts and summaries in response to questions in plain English. The lead checks the totals against the management accounts before looking more closely at individual units.

Suppose one business unit accounts for most of the revenue above budget. The team then checks gross profit across all units. The strongest sales growth and the largest profit shortfall may come from different parts of the company.

Follow revenue through gross profit

For each business unit, compare revenue, cost of goods sold, gross profit and gross margin percentage with budget and the same fiscal quarter last year. Show changes in gross margin in percentage points.

Higher sales can increase gross profit while reducing the margin percentage. Looking at both helps finance understand how much profit the company retained and how that compares with the revenue it earned.

To explore what changed from last year, the lead can look at product detail within the units that need attention:

Within these business units, compare product groups with the same fiscal quarter last year. Show revenue, each group’s share of its unit’s revenue, gross profit and gross margin percentage. Which groups account for the largest changes?

This comparison helps explain changes from last year. Explaining a budget miss at product level also requires product level budget data. If that detail is unavailable, finance keeps the budget comparison at the level it supports. Pricing, product mix and cost explanations still need relevant data and business context.

Carry the comparison through operating profit

The team also checks operating expenses to complete the explanation of the company’s profit shortfall.

For the whole company, including all business units, compare operating expenses with budget and the same fiscal quarter last year by cost centre and expense category. For each comparison, show how the differences in gross profit and operating expenses explain the difference in operating profit.

The controller checks that accounts are grouped correctly and the figures reconcile. Finance then identifies which cost changes appear to be recurring and which reflect timing or individual charges.

Costs recorded earlier or later than budgeted may affect the comparison. The team checks the supporting records before treating a change as an ongoing trend. If it explores an alternative cost allocation, it labels that analysis as a scenario and keeps the approved actuals unchanged.

Analyze: test the explanation before the meeting

In AIREA, the team can open a generated output and use Lineage View to review process steps in plain English. The controller checks the periods, measures, filters and calculations against the intended question and source totals.

The FP&A lead pins the useful comparisons as evidence. They add Key Context explaining the reporting basis, confirmed business explanations and outstanding questions, then generate an analysis result.

The result should identify the units and expense categories contributing to the shortfall, explain what the evidence supports and make unresolved questions clear. Finance reviews the explanation with the same care as the numbers.

Share an explanation the CFO can review

After reviewing the result and checking that its contents are appropriate for the recipient, the lead can use AIREA’s Share function to send it to the CFO or finance director. Pinned evidence and Key Context stay attached. If either changes, the lead generates the result again before sharing.

The meeting can then focus on what matters: which variances need attention, what supports the explanation and who will investigate the remaining questions. The CFO can review the supporting work alongside the conclusion.

Bring a finance question from your latest performance review to an AIREA pilot conversation. Start with a completed reporting period and the evidence your CFO needs to understand the result.