What it means
Forecasts are never exactly right, so the useful question is not whether there was a variance but what caused it. Breaking the total difference into receipts and payments, and then into individual categories, turns a vague sense that cash is tight into a specific and fixable issue.
A variance is described as favourable when it leaves the business with more cash than planned and unfavourable when it leaves less. Note that the logic reverses between the two sides: receipts coming in above forecast is favourable, while payments coming in above forecast is unfavourable.
The most important distinction is between timing variances and permanent ones. A customer paying on the third of the month instead of the last day of the previous month creates a large variance that reverses immediately, whereas a customer disputing an invoice creates a gap that may never close.
Variance analysis also improves the forecast itself. If receipts come in 8% below forecast for four months running, the problem is the assumption about collection speed, not the customers, and the model should be corrected rather than the sales team blamed.
Set a materiality threshold so the exercise stays useful. Investigating every difference above, say, $10,000 or 5% of a line keeps attention on items that matter instead of producing a page of explanations nobody reads.
In practice
Real-world examples.
Example
A council leisure operator reports a $40,000 unfavourable cash variance and traces almost all of it to an energy bill arriving a week earlier than the forecast assumed. The finance officer flags it as a timing variance and takes no further action beyond correcting the payment calendar.
Example
A staffing agency shows favourable payment variances for three consecutive months and initially treats it as good cost control. Closer review finds that supplier invoices are being processed late, so the cash saving is only a deferral that will land as a large outflow in one month.
Example
A manufacturer runs a monthly variance review that splits receipts by customer size and finds that mid sized accounts consistently pay eleven days later than assumed. Rebuilding the forecast on the actual pattern cuts the average monthly variance from 14% to under 4%.
Think of it
“Cash flow variance is the gap between what you expected and what actually happened with cash.
Formula
Calculation
Cash flow variance = actual cash flow - forecast cash flow
A wholesaler forecast receipts of $1,200,000 and payments of $950,000 for the month, giving a forecast net cash flow of $1,200,000 - $950,000 = $250,000. Actual receipts came in at $1,110,000 and actual payments at $920,000, so actual net cash flow was $1,110,000 - $920,000 = $190,000.
The total variance is $190,000 - $250,000 = -$60,000, an unfavourable variance of $60,000 / $250,000 = 24% against forecast. Splitting it shows receipts $1,110,000 - $1,200,000 = -$90,000 unfavourable, partly offset by payments $920,000 - $950,000 = -$30,000, which is favourable because $30,000 less was spent than planned.
The two components reconcile: -$90,000 on receipts plus $30,000 of saving on payments equals the -$60,000 total. Management then finds that $75,000 of the receipts shortfall is one customer paying four days late, which will reverse next month, while $15,000 relates to a disputed invoice that may not be recovered at all.Case study
Seen in the real world.
The following is an illustrative and fictional example. Ravenstock Supplies, an invented plumbing distributor, produced a monthly cash forecast that the board reviewed but never compared with actual results, on the reasonable sounding basis that the past could not be changed.
After a near miss on a payroll run, the fictional finance manager began a simple variance review each month. Over one quarter the receipts variance was unfavourable by $80,000, then $95,000, then $110,000, and every explanation offered pointed to the same cause: the forecast assumed 30 day payment while the customer base was actually averaging 44 days.
Ravenstock did not change a single customer relationship. It rebuilt the forecast on 44 day collections, which pushed the projected low point $200,000 deeper and prompted the board to arrange a facility it would otherwise have discovered it needed far too late. The illustrative lesson is that a persistent variance is usually a message about the forecast rather than about performance.
Watch out
Common mistakes.
- Reporting only the total variance, which nets a large receipts shortfall against an equally large underspend and hides two separate problems.
- Treating every unfavourable variance as poor performance, when many are pure timing differences that reverse in the following period.
- Explaining the same variance month after month without adjusting the forecast assumptions that keep producing it.
Questions
People also ask.
Is a favourable variance always good?
No, because underspending can mean essential maintenance or marketing was deferred, which usually creates a larger outflow later.
How large a variance justifies investigation?
Most finance teams set a threshold such as 5% of the line or a fixed dollar amount, so effort goes to items that could genuinely change a decision.
Does variance analysis apply to a rolling forecast?
Yes, and it is arguably more valuable there, since each comparison feeds straight back into the next version of the forecast.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%