What it means
A business may have strong sales and still struggle to pay bills if customer cash arrives late, so a collection forecast estimates when invoices and new sales become cash. Compare actual receipts on the same period, currency and gross-or-net basis, because a payment processor's fee and settlement delay can make a bank deposit differ from the customer payment.
Build the forecast from invoice due dates, customer payment habits, known disputes, payment plans and expected new invoices. A due date is not the same as a likely payment date.
A customer that pays late should not be forecast at its due date without a reason, while a confirmed payment plan gives stronger evidence. Separate committed receipts from uncertain pipeline sales.
When the variance appears, identify its drivers by asking which customers or invoices account for most of it. Was an invoice missing, disputed or paid elsewhere, and did one early payment mask other delays?
A favourable total can be fragile if it depends on a one-off prepayment. Reconcile actual cash to the bank and receivables ledger, since unallocated receipts can make collections look short even when money arrived.
Refunds, chargebacks and credit notes can change the net position, so keep tax and currency effects visible if they are material. Refresh the forecast after actual payments are known, but retain the original snapshot to learn how well earlier assumptions worked, because replacing the forecast with actuals eliminates the variance without improving predictability.
Use the result to make decisions. A shortfall may call for a respectful customer follow-up, correction of an invoice, a revised payment plan or a near-term spending adjustment, but do not pressure a customer about a bill that has not been validly issued or is under a legitimate dispute.
If a forecast surplus is likely to reverse next month, avoid treating it as permanent free cash. Track trends by customer segment and reason, not just one monthly percentage, because a systematic optimistic bias might mean sales dates are being substituted for cash dates.
A repeated delay at one customer may require a credit review or better invoice documentation. For owners, the variance is a practical early warning; good forecasts are not perfectly right, they are updated honestly and explain important differences in time to act.
In practice
Real-world examples.
Example
A business forecasts $200,000 from a large customer, but the invoice is disputed. It revises the cash plan, resolves the documentation issue and records the revised expected date.
Example
A retailer receives card payments on time, but processor settlement arrives two days later. Finance reflects the payout timing in its bank-cash forecast, so the apparent shortfall disappears.
Example
A customer pays early after receiving a prompt-payment discount. The month shows a favourable variance, but the next month's forecast is adjusted for the missing receipt.
Formula
Calculation
Cash collection forecast variance = Actual customer cash receipts - Forecast customer cash receipts, for the same period and basis
Worked example. In a fictional month, a business forecasts $500,000 of customer receipts and collects $455,000.
- Variance = $455,000 - $500,000 = -$45,000, an unfavourable variance.
- Variance as a percentage of forecast = -$45,000 / $500,000 = -9%.
- If $30,000 of the gap is one invoice paid in the first week of the next month, then $30,000 is timing and $15,000 remains to be explained.
Investigate timing before treating the variance as lost revenue.Case study
Seen in the real world.
In this fictional case, Pinehill Catering forecasts June receipts using invoice due dates. Actual cash falls short because two customers lack required service sign-offs. Account managers supply evidence and confirm revised payment dates, and finance updates its six-week liquidity view, separates delays from disputes and adds a billing checklist.
Later forecasts use actual payment behaviour rather than due dates alone. The owner checks whether the cash gap changes a planned purchase, and a delayed receipt and a disputed invoice get different follow-up. Each month the team keeps the original forecast snapshot beside the actuals and assigns an owner to the largest differences, so that the corrected forecast becomes the next plan while the old one remains the benchmark for learning.
Watch out
Common mistakes.
- Treating revenue or an invoice due date as if it were cash already in the bank.
- Overwriting the original forecast with actual results, hiding the forecasting error.
- Explaining a shortfall as customer non-payment before checking invoice validity and unallocated receipts.
Questions
People also ask.
Does an unfavourable variance mean the sale is lost?
No. It may be a timing difference, dispute, missing invoice evidence or an actual collection problem; investigate the cause.
Should early receipts always be celebrated?
They help current cash, but may pull money forward from a later period rather than increase total collections.
Which forecast should be compared with actual cash?
Retain a dated snapshot made before the period and compare on the same cash, currency and timing basis.
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%