Weekly Cash-Flow Variance Analysis and Funding-Gap Decisions

A forecast does not become unreliable because actual cash differs. It becomes unreliable when the difference is not reconciled, explained and reflected in the next decision.

Start from reconciled cash

Record the actual opening balance for the completed period and reconcile the closing balance to the bank. If the roll-forward cannot reproduce actual closing cash, withhold the variance conclusion until the missing movement or classification error is resolved.

Separate amount and timing variance

An amount variance changes the expected economic value of a receipt or payment. A timing variance moves cash between weeks. The distinction matters: a receipt delayed by seven days creates a current-week shortfall and a later-week recovery, while a bad debt may create a permanent gap.

Classify the largest differences as timing, amount, omitted item, duplicated item or classification. Then show whether the variance is expected to reverse and in which week.

Reforecast—do not overwrite history

Preserve the forecast version that management relied on, record actuals against it and create the next forecast version from the latest reconciled position. Rewriting the old forecast destroys accountability and makes forecast quality impossible to assess.

Calculate the funding gap against a buffer

The funding gap is the amount required to keep cash at or above the deliberate minimum buffer. It is not limited to avoiding a negative bank balance. If opening cash is 80,000 and the buffer is 120,000, the immediate gap is 40,000 even if a customer receipt later lifts week-one closing cash above the buffer.

For each scenario, identify the lowest cash position, the first breach and the maximum gap to the buffer. Include the opening position as well as all thirteen week-end positions.

Turn the breach week into a decision deadline

The first breach tells management when the consequence appears. The action deadline must be earlier. A new facility may require several weeks for approval and documentation. A collection intervention may need to begin before the invoice is overdue. A supplier negotiation loses credibility if it starts on the payment date.

Attach an owner, due date and evidence of completion to every material cash action. “Monitor collections” is not an action. “CFO to obtain written confirmation of the 250,000 receipt date by Tuesday” is.

Challenge scenarios that cross

Upside should generally preserve at least as much cash as base, and base at least as much as downside, but legitimate scenarios may cross because of timing. Surface the exact weeks and balances when ordering is violated. A crossing path may reveal that an apparently favourable decision brings a payment forward or delays a different receipt.

A useful weekly cash meeting

1. Reconcile actual opening and closing cash.
2. Review the five largest forecast-versus-actual variances.
3. Confirm which timing variances reverse in later weeks.
4. Review the lowest cash point and first buffer breach by scenario.
5. Decide and assign actions before the decision deadline.
6. Publish the new forecast version and preserve the prior version.

What to report upward

The executive or board summary should state the current liquidity status in checked numbers: actual opening cash, minimum buffer, lowest forecast cash, first breach, required liquidity, week-thirteen closing cash and the most consequential assumption. Narrative should explain those facts—not contradict them.