Cash Flow Variance Calculator
Every cash flow forecast is a promise, and the end of the period is when the promise gets scored. The gap between what was planned and what actually arrived in cash is where forecasting habits, collection problems and payment surprises all show up at once, in one unforgiving number.
This cash flow variance calculator scores the period in seconds. Enter the forecasted and actual cash flow and you get the variance in dollars, the variance as a percentage of forecast, and a plain favorable or unfavorable reading, so the size of the miss and its meaning arrive together.
Unfavorable
Variance here is for a net cash flow line: actual above forecast is favorable, actual below forecast is unfavorable. On a pure outflow line the reading flips, because spending more than planned is bad news even though the arithmetic sign is the same. The section below explains the sign trap in full.
Quick Answer
Key takeaways
- Cash flow variance is actual minus forecast, in dollars, and the same gap divided by the forecast, in percent. Both numbers matter: dollars say how much cash is missing, percent says how wrong the forecast was.
- Positive is favorable only on inflow and net cash flow lines. On a pure spending line, coming in above forecast is unfavorable. The sign never speaks for itself.
- Rank variances by dollars first and percent second. The biggest percentage in a report is usually a tiny line; the biggest dollar gap is where the cash went.
- In the cash flow trio, adequacy tests coverage of commitments and per-share prices cash for each share. This tool does the third job: scoring the plan against reality.
- Quick Answer
- How to use the cash flow variance calculator
- The variance formula, and the sign trap inside it
- Worked example: a $18,000 shortfall, and what to ask about it
- How cash flow variance differs from its neighbours
- What competing calculators miss
- Frequently Asked Questions
- Add This Calculator to Your Website
- References
How to use the cash flow variance calculator
Enter the forecast cash flow for a period and the actual cash flow for the same period, on the same definition, and press Calculate Variance. Forecasted means the figure in the budget or the latest reforecast, the number the period was planned against. Actual means what the bank and the cash flow statement say happened. The tool returns the variance in dollars, the variance as a percentage of forecast, and the actual result expressed as a share of the forecast, with a favorable or unfavorable label for a net cash flow line.
The card is pre-filled with the worked example below, a $120,000 forecast against $102,000 actual, so you can verify the outputs before entering your own period. Compare like with like: a forecast built on operating cash flow only cannot be scored against an actual that includes financing flows, and a quarter cannot be scored against a month. Most nonsense variance reports are definition mismatches, not performance stories.
The variance formula, and the sign trap inside it
The arithmetic is trivial. The interpretation is where reports go wrong, because the same positive sign means opposite things on different lines. Variance analysis convention, covered in standard guides such as the DoubleHQ variance accounting guide, is to label each line F or U, favorable or unfavorable, from its effect on the business rather than from the raw sign. On a revenue or net cash flow line, actual above forecast puts more cash in the business: favorable. On a cost or outflow line, actual above forecast takes more cash out: unfavorable, even though the subtraction produces the same positive number. This calculator is built for cash flow lines, where higher actual cash flow is the favorable outcome, and it labels accordingly. If you run a pure outflow through it, keep the dollar and percent figures and flip the label in your head.
There is a second trap, in the percentage. A 200% variance on a $500 line is $1,000. A 4% variance on a $2,000,000 line is $80,000. Sorted by percent, the report screams about the first and whispers about the second, while the cash went missing in the second. Read every variance table dollars first, percent second, and investigate in dollar order.
Worked example: a $18,000 shortfall, and what to ask about it
A business forecast $120,000 of net cash flow for the quarter and delivered $102,000. The variance is -$18,000, or -15.00%, and actual performance landed at 85.00% of plan. The calculator gives you those three numbers in seconds. The value is in the questions they force, in this order:
Timing or permanent? A customer paying two weeks late moves cash between periods and reverses next quarter. A lost contract does not reverse. Timing variances need patience; permanent ones need a new forecast.
Collections, payments or volume? Split the $18,000: how much is receivables arriving late, how much is payments leaving early or running high, and how much is simply less business than planned? Each has a different owner and a different fix.
One-off or pattern? A single missed quarter is an event. The same line missing three quarters running is a forecasting habit, usually optimism in collections timing, and the forecast method needs changing, not just the number.
What changes now? A variance report that ends in explanation has failed. It should end in an action: tighter collection follow-up, a rephased payment run, or a reforecast the rest of the year is managed against.
For contrast, run the favourable twin: forecast $80,000, actual $92,000. The variance is +$12,000, or +15.00%, with actual at 115.00% of forecast. Treat good news with the same suspicion as bad. A favorable variance caused by deferring supplier payments is borrowed from next period, and one caused by a single large early payment says nothing about the run rate.
How cash flow variance differs from its neighbours
Variance is a family, and the members get confused. This page covers total cash flow against its forecast. A narrower cousin already on the site, the BPS variance calculator, works in basis points for rate and margin movements, while the absorption variance calculator belongs to cost accounting and overhead recovery. Neither substitutes for this one: basis points cannot express a missing $18,000, and overhead absorption says nothing about whether cash arrived.
Within the cash flow set itself, the division of labour is clean. The cash flow adequacy ratio calculator asks whether operating cash covered the period's debt, capex and dividends, a coverage question with no forecast involved. The cash flow per share calculator divides operating cash down to each share and prices it, an investor question. This calculator asks the manager's question: did the period deliver the cash the plan promised? When a variance keeps repeating, the fix often lands in the budget itself, and the budget impact calculator helps size what a revised assumption does across a full year.
What competing calculators miss
Most variance tools online return the same two numbers this one does, and stop. The numbers were never the hard part.
Miss 1: no favorable or unfavorable judgement. A raw -$18,000 (-15.00%) leaves every reader to guess whether the sign is good or bad, and half of them guess wrong, because the answer depends on the line type. This tool labels the result for a net cash flow line and explains the outflow exception on the card, where the label is applied.
Miss 2: no defence against the percent trap. Tools that sort or headline by percentage push attention to small lines with wild swings. This page adds the actual-as-share-of-forecast figure, 85.00% in the example, which reads instantly, and the article ranks investigation by dollars first.
Miss 3: silence on the zero forecast. Divide by a zero forecast and the honest answer is that a percentage variance does not exist. Tools that print an infinity symbol or a crash pass the confusion to the reader. This calculator says plainly that the percentage has no meaning when the forecast is zero, while the dollar variance remains perfectly valid.
Frequently Asked Questions
The difference between actual cash flow and forecasted cash flow for the same period, shown in dollars and as a percentage of the forecast. Forecast $120,000 and actual $102,000 gives a variance of -$18,000, or -15.00%.
Divide the dollar variance by the forecasted cash flow and multiply by 100. In the worked example, -$18,000 divided by $120,000 is -0.15, or -15.00%. The forecast is the base because the forecast is the promise being scored.
On an inflow or net cash flow line, yes: more cash arrived than planned, which is favorable. On a pure outflow line, no: spending above forecast produces a positive variance that is unfavorable. That is why variance reports label lines F or U instead of trusting the sign, and why this calculator states it is labelling a net cash flow line.
Actual cash flow came in below forecast: the period delivered less cash than the plan assumed. The usual causes are collections arriving late, payments running higher or earlier than planned, or lower trading volume. Whether it matters depends on size and cause: a timing gap reverses, a lost contract does not.
There is no universal standard. As a working guide, stable businesses often treat within plus or minus 5% as normal noise, 5% to 10% as worth an explanation, and beyond 10% as a line that needs investigation and a reforecast. Volatile or seasonal businesses run wider bands and judge the dollar amount alongside the percent.
The dollar variance still works, it is simply the actual figure, but a percentage variance has no meaning because it divides by zero. This calculator tells you that instead of printing an infinite percentage. Use the dollar gap, or score the period against a non-zero baseline such as the prior period.
Monthly is the common rhythm for management accounts, with a deeper quarterly review against the annual plan. The point of the rhythm is catching a pattern early: one missed month is an event, three in a row is a forecasting problem.
Find which component repeats: late collections, optimistic sales timing, or payments drifting early. Fix that component in the forecast method, not just the next number, tighten collection follow-up, and reforecast the rest of the year so targets are managed against reality rather than the original hope.
Add This Calculator to Your Website
References
- DoubleHQ, "Variance Accounting Guide." The core formulas, variance equals actual minus budgeted, percentage variance against the budget base, and the rule that a positive variance is not always favorable. DoubleHQ: Variance Accounting Guide. Accessed October 2026.
- FinModelsLab, "Understand Budget Variance Analysis." The favorable and unfavorable convention by account type: positive revenue variances are favorable, negative expense variances are favorable. FinModelsLab: Budget Variance Analysis. Accessed October 2026.
- GoLimelight, "Variance Analysis: Formula, Examples, Types." Variance as actual against a defined baseline, with favorability decided by account type and context rather than the arithmetic sign alone. GoLimelight: Variance Analysis. Accessed October 2026.
- Accounting Insights, "What Is an Unfavorable Variance in Accounting?" Worked expense and revenue examples showing how the same subtraction reads differently by line. Accounting Insights: Unfavorable Variance. Accessed October 2026.
- City of Jackson, "Variance Analysis in Accounting." A public-sector training summary covering favorable and unfavorable variances, the main variance types, and regular monthly or quarterly review. Variance Analysis in Accounting (Training Summary). Accessed October 2026.