Variance Analysis (Budget vs Actual)

What Is Variance Analysis?

Variance analysis is the process of comparing budgeted or forecast figures to actual results, identifying where the two differ, and determining why. In a cash flow context, it measures the gap between projected cash movements and what actually happened, and uses that gap to improve future forecasting accuracy.

How It's Calculated

The core calculation is straightforward:

Variance = Actual Amount − Budgeted Amount

For revenue and inflows, a positive variance is favorable, more cash came in than expected. A negative variance is adverse, less came in than planned.

For costs and outflows, the sign convention inverts: a negative variance is favorable, costs were lower than budgeted, and a positive variance is adverse, costs exceeded the budget.

Some organizations express variance as a percentage of the budgeted figure to make comparisons easier across items of different sizes:

Variance % = (Variance / Budgeted Amount) × 100

The calculation itself is not the analysis. The analysis is the explanation: what caused the gap? Was revenue lower because a contract closed late, because a customer paid in the wrong month, or because the forecast assumption was wrong? The answer determines whether the variance is a one-off timing difference or a signal that the budget needs revision.

For cash flow specifically, variances fall into two categories:

Timing variances, cash moved in a different period than forecast but the total amount is unchanged. A payment expected in Week 3 arrived in Week 4. The forecast was accurate; the timing was off.

Volume variances, the underlying amount was different from what was forecast. A sale was smaller than budgeted, or a cost overran. These require a different response because they affect the total, not just the timing.

Distinguishing between the two is the analytical step that makes variance analysis useful.

Worked Example

A business development consultancy closes its books for Q2. Here is a simplified comparison of budgeted versus actual cash flows for the quarter, in USD:

The net cash position is $25,400 below budget. The two significant variances are client receipts and subcontractor fees.

Client receipts: -$26,000

Investigation shows that $19,000 of the shortfall relates to two invoices that were paid in July rather than June, a timing variance. The remaining $7,000 relates to a project that was reduced in scope at the client's request, a volume variance. The forecast for Q3 should include the $19,000 arriving as a July inflow and should reduce future revenue assumptions for that client.

Subcontractor fees: -$3,500

A project required additional specialist input not anticipated at the time of budgeting. The variance is a volume variance, the cost was actually higher than planned, not merely timed differently.

Marketing spend: +$4,800

A planned campaign was delayed to Q3. This is a timing variance, the money has not been saved, it will be spent next quarter. The Q3 budget should anticipate the higher marketing outflow.

The closing balance is $25,400 below budget, but $19,000 of that arrives in Q3 due to timing. The genuine cash performance shortfall is $7,000 from reduced project scope plus $3,500 in additional costs, a total adverse volume variance of $10,500.

Why It Matters in Practice

It separates noise from signal in the monthly numbers

Not every unfavorable variance represents a problem, and not every favorable variance represents good performance. A client receipt arriving two weeks late looks like underperformance on the cash flow statement for that month. It is actually a timing difference that will reverse next month. Without variance analysis, both outcomes look the same: the actual is below budget and the month looks bad. With analysis, the timing variance is identified, the volume variance is isolated, and the right management response, or non-response, follows.

It creates accountability for budget assumptions

A budget that is never compared to actuals is just a document. When variances are tracked and explained every month, the people who built the budget have to defend their assumptions against what actually happened. That discipline improves future forecasting because it forces the question: why was the assumption wrong? Was the revenue assumption too optimistic? Was a cost category underestimated because the project scope was unclear? Each explained variance is a data point that should feed directly into the next budget cycle.

It gives the rolling forecast a reliable foundation

A rolling forecast that is never anchored to actuals drifts from reality over time. Variance analysis is the mechanism that prevents that drift. When each month's actual results are compared to forecast, the variances that represent genuine forecast errors, not timing, are used to recalibrate the forward assumptions. A business that consistently underestimates subcontractor fees by 10% because of scope creep should adjust its forward assumptions rather than repeating the same error in the next quarter's forecast.

How Variance Analysis Affects Your Cash Flow

Variance analysis compares forecast cash to actual and explains the gap. It is how each forecast makes the next one sharper.

The sharpening effect is cumulative. A business that conducts variance analysis every month and feeds the findings back into the rolling forecast builds a model that is grounded in observed behavior rather than initial assumptions. After six months of tracking that client receipts consistently arrive a few days after the budgeted date, the forecast should shift to reflect that pattern. After identifying that a particular cost category consistently overruns by a modest amount, the budget for that category should be adjusted accordingly. None of those improvements requires sophisticated analytical tools, they require the discipline of comparing what was projected to what happened, explaining the difference, and updating the forward model.

The cash flow consequence of better forecasting is more accurate projected bank balances. A forecast that consistently understates outflows or overstates collection timing will show the business as more cash-comfortable than it actually is. Decisions made on the basis of that forecast, whether to draw on a credit facility, whether a capital expenditure can proceed, will be made with inaccurate information. Variance analysis corrects that over time. A business that tracks and learns from its variances makes fewer decisions based on a forecast that has already diverged from reality.

How You'd See This in Cash Flow Frog

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, Sage Intacct, Odoo, Zoho Books, and FreshBooks and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

Because the forecast draws from live accounting data, the actual cash flows recorded in the books update the picture automatically as the period closes. The comparison between what was planned and what actually arrived is built from the same source, planned amounts set in the forecast against actual transactions recorded in the accounting system. If a client payment was projected in Week 3 but arrived in Week 5, that appears as a variance in the period-by-period view. For businesses with multiple entities or currencies, the planned-versus-actual view consolidates natively across all of them. You can explore how planned versus actual works in Cash Flow Frog at cashflowfrog.com/features/planned-vs-actual/.

For a step-by-step process, variance types, and the causes behind budget gaps, see the full guide on budget vs. actuals variance analysis.

Related Terms

• Cash Flow Budget
• Cash Flow Forecast
• Scenario Analysis
• Rolling Forecast
• Operating Expenses
• Cash Flow Analysis