13-Week Cash Flow Forecast: A Practical Guide

What a 13-week forecast should answer

For every week, management should know three things: the cash expected to arrive, the payments it must make, and the ending bank balance after those movements. The forecast should also show the lowest projected cash balance and the week in which a funding decision is needed.

An otherwise profitable company can still run out of cash. Revenue recognized in October may not be collected until November, while payroll is due on Friday. That timing mismatch is exactly what the 13-week forecast is designed to expose.

Build from cash movements, not accounting profit

1. Opening cash: reconcile unrestricted operating bank balances to a specific date. Exclude restricted balances and cash that cannot be used to meet obligations.
2. Receipts: project customer collections from accounts-receivable aging, confirmed collection dates, contractual payment terms and realistic new-sale collections. Separate committed receipts from uncertain assumptions.
3. Payments: schedule payroll, contractor fees, suppliers, rent, taxes, debt service, capital expenditure and other payments by actual expected settlement date.
4. Financing: show debt drawdowns, repayments and equity injections separately rather than concealing them in operating receipts.
5. Closing cash: roll the prior week's closing balance into the next week's opening balance.

Model one column per week. Keep historical actuals, a current forecast and a forecast-versus-actual variance view in the same controlled workbook or in clearly linked tabs.

Worked example: the cash gap appears in week two

Consider the following entirely illustrative business with amounts in USD thousands. Receipts and payments are assumed to settle within the weeks shown.

Week 1 closes at $80,000: $100,000 + $90,000 − $110,000. Week 2 starts with that $80,000 and closes at only $50,000. If management requires a minimum operating reserve of $60,000, the forecast identifies a $10,000 shortfall to that reserve during week 2, even though cash is still positive.

The distinction matters. A breach of the management reserve is not automatically the same as an inability to pay a specific obligation, but it is an early decision signal.

Test collection delays before calling the forecast safe

Suppose $60,000 of week-two receipts move to week four, with every other assumption unchanged. Week-two closing cash falls from $50,000 to negative $10,000. Week-three closing cash becomes $25,000, before the delayed receipt is recovered in week four. That timing shift creates a real funding problem that the base forecast hides.

Useful downside scenarios include slower customer collections, delayed project milestones, a payroll step-up, unexpected tax payments and a supplier tightening credit terms. The purpose is to quantify a decision: accelerate collection, reschedule discretionary expenditure, secure financing or reduce cash commitments.

Do not blend the downside into the base case. Keep each scenario visible, documented and reversible.

Five checks before management relies on the file

• Bank reconciliation: opening cash agrees to the actual bank position on the forecast date.
• No double counting: a collected invoice cannot appear as both an accounts-receivable receipt and a new-sales cash receipt.
• Weekly roll-forward: each opening balance equals the preceding week's closing balance, with no hardcoded overrides.
• Due dates and taxes: payroll, debt service, VAT/sales taxes and annual payments are scheduled in the correct week.
• Variance discipline: every completed week is compared with actual receipts/payments, explaining timing differences separately from permanent forecast errors.

A forecast that only gets updated when cash is already tight is too late. Refresh it regularly, roll it forward one week, and keep a clear change log for significant assumptions.

How to use the forecast in a management meeting

Lead with the lowest projected balance, the date it occurs, the major receipts at risk, and the actions required to protect the cash floor. Then connect the next 13 weeks to the wider operating forecast so hiring, margins and funding decisions are consistent with the liquidity outlook.

For related project work, see FP&A and cash flow modeling, startup financial modeling, or discuss a cash forecasting engagement.