How to Build a 13-Week Cash-Flow Forecast

A 13-week cash-flow forecast is not a smaller annual budget. It is a short-horizon operating instrument built around the expected clearing date of cash receipts and payments.

Why thirteen weeks?

Thirteen weeks is long enough to see a quarter of payroll, tax, debt, supplier and customer timing, but short enough for management to challenge individual movements. It converts a general concern about liquidity into a dated decision: the week a buffer is threatened, the size of the gap and the lead time available to respond.

1. Set the opening position and minimum buffer

Start with reconciled cash available at the beginning of the first week. Exclude undrawn facilities unless the forecast explicitly models a permitted draw. Then set a deliberate minimum cash buffer. The buffer is not zero; it is the amount management wants available for operational uncertainty, payment timing and commitments that cannot be deferred safely.

If opening cash is already below the buffer, record an immediate breach. A receipt expected later in week one does not remove the opening funding need.

2. Forecast receipts when cash is expected to clear

List material customer receipts, recurring income, asset proceeds, funding and other inflows. Use the week cash is expected in the bank—not the invoice date, revenue-recognition date or contractual due date. Separate large or uncertain receipts so management can challenge them individually.

3. Forecast payments by operational commitment

Map payroll, tax, rent, suppliers, debt service, capital expenditure and other payments to the week they are expected to clear. Keep unavoidable commitments visible. A stress scenario is useful only when it does not quietly remove costs that management cannot actually avoid.

4. Roll cash forward every week

The calculation is simple: opening cash plus receipts less payments equals closing cash. The following week opens with the prior week's closing cash. The discipline lies in timing, completeness and reconciliation—not complicated mathematics.

Worked example

Assume an illustrative business opens week one with 250,000 in cash and maintains a 100,000 buffer. Week-one customer receipts are expected to be 120,000 and payments 180,000, producing closing cash of 190,000. In week two, closing cash falls to 135,000. In week three, a major receipt slips while payroll and tax remain fixed, reducing closing cash to 70,000.

The important output is not merely “cash is tight.” The base forecast identifies a 30,000 gap to the buffer in week three. If the delayed receipt has a realistic lead time of two weeks, the decision deadline occurs before the breach: accelerate collection, renegotiate a supplier payment, defer discretionary expenditure or arrange committed funding.

5. Build scenarios from named assumptions

A base case should represent management's most supportable view. An upside case may accelerate a specific receipt or improve a known commercial outcome. A downside case may delay collections, increase a payment or preserve uncertainty. Scenarios should identify the movement changed, its base timing and the revised timing or amount. A label alone is not evidence.

Sometimes an item is cancelled or deferred beyond the horizon. Record that disposition explicitly rather than hiding it in a zero or a fictional week fourteen. If upside and downside paths cross, investigate why rather than forcing the labels to look orderly.

6. Update actuals and explain variance

At the end of each week, reconcile the actual closing bank position. Replace forecast movements with actual movements for completed weeks, roll the new opening position forward and explain the largest timing and amount variances. A forecast that is not reconciled becomes a spreadsheet narrative rather than a cash control.

The weekly management questions

• What changed since last week?
• Which receipt or payment drives the lowest cash point?
• When is the first buffer breach, including the opening position?
• What action must be completed before that week?
• Who owns the action and what evidence will confirm it?

Use the free worked tool

The Executive Compass Cash Command Centre builds a 13-week forecast in your browser, tests base, upside and stress timing, identifies the funding gap and exports an Excel workbook. Detailed financial inputs stay in the browser and are not submitted to Executive Compass.