Cash Flow · 2026-07-07

13-Week Cash Flow Forecast: A Practical Guide for Tight Cash

What a 13-week cash flow forecast is, why turnaround and finance teams rely on it, and how to build a rolling short-term liquidity view in Excel.

A 13-week cash flow forecast is a short-term, week-by-week view of expected cash receipts and payments over the next quarter. It is the standard tool in turnarounds, restructurings and any situation where liquidity is tight, because it answers the only question that matters when cash is scarce: will there be enough money in the bank to meet obligations, week by week? Thirteen weeks is used because it covers a full quarter while staying short enough to forecast with real accuracy.

Why 13 weeks, and why weekly

Monthly forecasts hide intra-month timing risk — payroll on the 25th can fail even if the month ends positive. Weekly granularity exposes exactly when a shortfall occurs, so you can act early: chase receivables, delay a payment, or draw on a facility before the gap, not after. Thirteen weeks balances precision (near-term weeks are highly reliable) with a useful planning horizon.

Build it from receipts and payments

A 13-week model is usually direct-method: you list expected cash receipts (customer collections by expected payment date) and cash payments (payroll, suppliers, rent, tax, debt service) for each week, then compute net movement and a running cash balance. The key discipline is timing — a sale in week 2 with 45-day terms is a receipt in week 8, not week 2. Getting collection timing right is what makes or breaks the forecast.

Make it rolling

The forecast is only useful if it is refreshed. Each week, drop the completed week, add a new week 13, and compare actuals against forecast to sharpen your assumptions. Persistent variances usually point to over-optimistic collection assumptions — the most common error in short-term cash forecasting.

What goes into each week

A robust 13-week model separates receipts and payments into consistent categories. Receipts are dominated by customer collections, timed by invoice date plus payment terms, with a haircut for late payers. Payments include payroll (usually the largest and least flexible line), supplier invoices by due date, rent and utilities, tax instalments, loan interest and repayments, and any one-off items. Keeping the categories identical week to week is what lets you compare forecast against actual and see exactly which line is drifting.

Managing a projected shortfall

When a week shows a shortfall, you have levers: accelerate collections through early-payment discounts or chasing overdue accounts, defer non-critical payments, draw on a revolving facility, or delay discretionary spend. The whole value of the forecast is that it surfaces the gap weeks in advance, so you choose calmly rather than react in the week the money runs out.

From 13 weeks to the full picture

A 13-week forecast manages the immediate runway; a multi-year cashflow model shows the strategic path. The EasyFinancialModels Cashflow Forecasting tool builds a monthly, quarterly or annual forecast with working-capital days (DSO, DIO, DPO) driving the cash timing, a peak-funding-need figure on the dashboard, and closing cash by period — free for 3 years. Use the monthly view to read the first quarter, then extend the horizon to plan funding well ahead of the gap.

→ Build your financial model free