Cash forecast variance is the difference between the cash movement you expected and the movement that actually occurred. The number matters, but the explanation matters more. A missed collection, an unplanned purchase and an opening-balance error can produce the same closing cash shortfall while requiring very different responses.
Many teams update next week’s forecast immediately and overwrite the original assumptions. That makes the latest cash position visible, but removes the evidence needed to learn from the miss. At AB Consulting, a practical review preserves the original forecast, reconciles actual movements and assigns actions to the assumptions that failed.
This guide shows how to build that review. It complements a 13-week cash flow forecast by explaining the weekly differences. All worked figures are illustrative, not client results.
Define cash forecast variance consistently
Choose one sign convention before reviewing the numbers. In this guide, a positive variance improves closing cash compared with the forecast. A negative variance reduces it. Use these formulas:
- Receipt variance: actual receipts minus forecast receipts.
- Payment variance: forecast payments minus actual payments, with payments entered as positive amounts.
- Closing cash variance: actual closing cash minus forecast closing cash.
The opening-balance variance must also enter the reconciliation. If actual opening cash differs from the forecast, the closing balance can miss its target even when every receipt and payment matches. Do not force that difference into an operating category merely to make the report balance.
Agree the cash perimeter too. Specify bank accounts, currencies, restricted balances and treatment of transfers between included accounts. A transfer within that perimeter should not create both a business receipt and a business payment. Keep available borrowing separate from the cash balance, while showing it where it helps management assess liquidity.
BDC’s cash flow guidance recommends regularly comparing actual inflows and outflows with projections and adjusting the forecast. The five-step review below turns that comparison into an operating routine rather than a spreadsheet update alone.
Review cash forecast variance in five steps
1. Freeze the forecast you are testing
Save a dated version at the agreed weekly cut-off. Record the assumptions behind large receipts, payroll, supplier runs, tax payments and capital expenditure. Identify the owner of each material assumption and the evidence used at the time.
Compare actual results against that frozen version. You may also compare against the latest forecast for operational planning, but label the two comparisons clearly. Otherwise, moving the expected date after a payment arrives can make the model look more accurate than it was.
2. Reconcile actual cash before explaining it
Use settled bank movements for the actuals. Match them to customer, supplier or other supporting records and the agreed categories. Check duplicates, refunds, fees, currency movements and transfers. Then verify opening cash plus receipts minus payments equals closing cash.
If a cash forecast variance remains unexplained, keep it visible as an unresolved reconciliation item with an owner. A commentary such as “timing” does not substitute for evidence. Your team needs to know whether it is reviewing a forecast miss or incomplete actual data.
3. Separate timing, amount and missing items
Use a small set of explanation codes. Timing means the cash movement is still expected but in a different period. Amount means the value differs, such as a customer deduction or revised supplier charge. Omission means a movement was absent from the forecast. Data covers classification, duplication or opening-balance errors.
An item can contain more than one cause. For example, a customer may delay a €20,000 invoice and dispute €3,000 of it. Split the amounts rather than labelling the whole invoice as timing. Ask for support for the revised receipt date; a delayed invoice should not automatically move forward one week indefinitely.
4. Rebuild the cash bridge and future weeks
List material differences and ensure their total explains the closing cash variance. Update the future forecast using confirmed actions and revised assumptions. A delayed receipt belongs in a future week only when the collection evidence supports it. A permanent reduction should not reappear as future cash.
Check the lowest projected cash balance across the remaining horizon, not only the next week. An earlier supplier payment can improve a later week mechanically, but still create a liquidity problem today. The cash forecast variance bridge explains the past; the updated forecast supports the next decision.
5. Assign the action and improve the assumption
For each material difference, record cause, evidence, revised assumption, action owner and due date. Actions may include resolving a disputed invoice, approving a revised purchase timetable or changing who supplies payroll inputs. Keep necessary payments and contractual obligations visible when considering cash actions.
Use management reporting to show recurring causes. If collections repeatedly arrive two weeks later than assumed, revisit the collection logic instead of adding optimistic commentary. A model improves when its inputs reflect actual operating behaviour.
Cash forecast variance: a worked weekly bridge
Illustrative example: a business begins the week with €80,000 of cash. It forecasts €120,000 of receipts and €100,000 of payments, leaving €100,000 at the end of the week. Actual receipts are €95,000 and actual payments are €108,000.
| Cash measure | Forecast | Actual | Cash effect |
|---|---|---|---|
| Opening cash | €80,000 | €80,000 | €0 |
| Receipts | €120,000 | €95,000 | −€25,000 |
| Payments | €100,000 | €108,000 | −€8,000 |
| Closing cash | €100,000 | €67,000 | −€33,000 |
The bridge reconciles: €100,000 forecast closing cash − €25,000 receipt variance − €8,000 payment variance = €67,000 actual closing cash. The independent bank check is €80,000 + €95,000 − €108,000 = €67,000.
The team then explains the €33,000 gap. A €20,000 customer payment moved to the following week; a €5,000 credit reduced receipts permanently. A €6,000 supplier payment occurred one week early, and €2,000 of bank charges had been omitted.
Only €26,000 is a timing shift: the delayed €20,000 receipt and €6,000 payment brought forward. If the revised receipt arrives as supported and all other assumptions hold, next week’s cash movement improves by €26,000 relative to its original plan. The €7,000 credit-and-charges impact remains. Management should therefore revise future closing balances instead of assuming the entire €33,000 recovers.
Use cash forecast variance to support decisions
Set materiality limits for explanation based on the size and liquidity of the business. Review both absolute amounts and items that could breach the minimum cash buffer. An apparently small tax or payroll omission can matter more than a larger timing movement that has no effect on the lowest balance.
A percentage error can help compare periods, but label its denominator. A €33,000 closing variance against a €100,000 forecast balance is 33%. It describes this example; it is not a benchmark or a reliable measure when the forecast balance is near zero. Inspect receipt and payment accuracy separately so favourable differences do not hide offsetting errors.
Close the meeting with three outputs: a reconciled actual balance, a revised forecast and an action register. Confirm that the original forecast remains available, timing explanations have evidence, permanent changes stay removed, and every material unresolved item has an owner.
Build a forecast review that improves cash decisions each week. Contact AB Consulting to discuss a finance deep-dive covering financial management, cash assumptions and a reporting routine your team can maintain.
