Budget vs Actual: A Practical Guide to Variance Analysis

A carefully built annual budget that sits in a folder until December does not manage anything. A budget starts creating value the moment you compare it with what actually happened, understand why the numbers differ and decide what to do about it. That discipline is called budget vs actual, or plan vs actual.

This guide covers what plan vs actual reporting is, why it is one of the most useful tools a CEO, CFO or business owner has, how to set it up from scratch, how often to review it, and how to run variance analysis that produces decisions rather than just another spreadsheet.

What is budget vs actual?

Budget vs actual is a systematic comparison between the financial plan and the real results, for the same period and at the same level of detail. Most companies run it on the profit and loss statement: revenue, cost of sales, operating expenses and profit. More mature finance teams extend it to the balance sheet and to cash flow.

Every line shows three values: plan, actual and the variance between them, both in currency and as a percentage. The variance is only the starting point. The real questions are why it happened and whether it will continue.

Budgetary control is not the same as bookkeeping

Bookkeeping records what happened. Budgetary control compares what happened with what you intended, and asks management to own the gaps. Both rely on the same data, but only one of them is a forward-looking management tool.

Why plan vs actual matters

• Early warning: an overspend or a revenue shortfall spotted after one month can still be fixed. Spotted in the year-end accounts, it usually cannot.
• Clear ownership: when every budget line has an owner, variance reviews become professional conversations with department heads instead of a search for someone to blame.
• Better forecasting: each month of comparison shows where the organization tends to be too optimistic or too cautious, so next year's budget is more accurate.
• Stronger conversations with banks and investors: a business that can show plan, actual and a clear explanation of the gaps signals that it is in control of its numbers.
• Cash protection: a gap in profitability is often an early sign of a cash problem on the way.

How to set up plan vs actual reporting

Before you compare anything, make sure the plan and the books speak the same language. Most budgetary control processes fail at this stage, not during the analysis.

1. Use one line structure: build the budget on the same chart of accounts as the general ledger, or on a clear mapping between the two. If the budget has a single "Marketing" line and the books split it across ten accounts, agree upfront how they roll up.
2. Phase the budget realistically: dividing the annual budget by twelve creates false variances in any seasonal business. Phase each line according to its expected timing.
3. Assign owners: every line or cost center needs a person who can explain it.
4. Keep accounting policies consistent: accruals, prepaid expenses and deferred revenue must be booked the same way every month, otherwise the comparison reflects booking dates rather than reality.
5. Set materiality thresholds: decide in advance which variances need an explanation, for example a combination of an amount and a percentage of the line.

How often should you review budget vs actual?

For most businesses the answer is monthly, after the books are closed. That cadence shows trends without overreacting to noise. Sensitive indicators such as sales, bank balances and the short-term cash forecast deserve a more frequent look. The quarterly review is the right moment to update the forecast for the rest of the year.

Variance analysis: understanding what really happened

A variance is a symptom, not an explanation. The goal of variance analysis is to break every material variance into its drivers and decide whether it requires action.

Price variance and volume variance

For revenue and cost of sales, separate two effects. A volume variance comes from selling more or fewer units than planned. A price variance comes from a different average price, caused by discounts, product mix or supplier price changes.

A simple illustration: you planned 1,000 units at ₪100 and actually sold 900 units at ₪110. Revenue is almost on plan, yet it hides two opposite variances: a volume variance of minus ₪10,000 and a price variance of plus ₪9,000. Each tells a different story and calls for a different response.

Timing variances vs permanent variances

A timing variance is income or spend that moved between periods, such as a campaign pushed to next month or a deal signed later than expected. It reverses later in the year. A permanent variance will not come back: a lost customer, a supplier price increase, a hire above plan. Permanent variances must flow into the updated forecast.

Favorable variances need explaining too

Spending below budget is not automatically a saving. It may point to a delayed hire, a project that never started or an invoice that has not been booked yet. The same applies to revenue that comes in above expectations.

Example: a plan vs actual P&L

The table below is an illustrative example only, with made-up figures in ₪ thousands, for one month in a mid-sized business. A positive variance means better than plan; a negative variance means worse than plan.

What does the example show? Revenue is 6% below plan, but operating profit is almost 29% below plan. Cost of sales fell by less than revenue, so gross margin eroded, probably because of price or mix. The marketing saving looks good on paper, but it is worth checking whether it is just a delayed campaign. If so, the spend will land next month.

Common budgetary control mistakes

• A budget that never changes: when reality shifts materially, keep comparing to the original budget but add an updated forecast so you know where the year is heading.
• Looking only at the bottom line: profit on target can hide large variances that offset each other.
• Explanations without action: "revenue was down" is not analysis. Good analysis ends with a decision or a forecast update.
• Ignoring the balance sheet and cash: a company can hit its profit target while building up overdue receivables and slow-moving inventory.
• Manual spreadsheet work: copying data from the accounting system into Excel takes days, introduces errors and delays the report.

A practical five-step monthly process

1. Close the month: post all documents, reconcile the bank accounts and book accruals and month-end entries.
2. Produce the plan vs actual report: for the month and year to date, by line and by cost center.
3. Filter for material variances using the thresholds you agreed in advance.
4. Collect explanations from line owners: the cause, whether it is timing or permanent, and the action.
5. Hold a short management review and update the forecast for the rest of the year based on the permanent variances.

The first few cycles take longer. After that the process becomes a short routine that management expects and relies on.

How Simplogic helps

Simplogic is an AI-powered FP&A platform with ERP-grade accounting built in, so plan and actual live on the same data. You can build a plan, track plan vs actual in P&L and balance sheet terms, analyze variances and produce management reports, and ask the AI about any variance to get answers grounded in your books.