Finance
13-Week Cash Forecast
A weekly projection of cash inflows, outflows, and ending balance over a rolling 13-week period. The standard short-term liquidity tool used by CFOs, lenders, and turnaround professionals.
The 13-week cash forecast is the standard short-term liquidity tool used by CFOs, lenders, and turnaround professionals. It captures timing realities that monthly forecasts miss: payroll, vendor payments, debt service, tax estimates, and lumpy quarterly items.
Refresh weekly with actual results; track variance vs. forecast to find systemic forecasting errors. Banks and creditors trust this format because it's specific and time-bounded.
Why 13 weeks and not 12 or 26: 13 weeks is roughly one quarter, which covers most of the lumpy items a small business faces (quarterly estimated tax, quarterly rent, seasonal working-capital swings). It's also short enough that receivables and payables can be forecast line-by-line rather than modelled from averages. Beyond 13 weeks the accuracy falls off fast; monthly forecasting takes over.
The line-item structure that works: opening balance, then five inflow categories (recurring recurring receivables, one-off customer payments, tax refunds, financing, other), five outflow categories (payroll and taxes, AP by vendor tier, rent and fixed costs, debt service, other), then ending balance. Each cell is a specific expected transaction, not a monthly ratio applied evenly. Payroll runs on specific dates; rent hits on specific dates; the forecast should show it that way.
The forecast becomes a decision tool the moment variance analysis starts. Every week, plot forecast vs actual for each cell and note the reason for the delta. Within a month the recurring forecasting errors surface (that customer always pays 10 days late; that vendor's ACH always clears a day later than the invoice). Correcting the model based on variance is what turns the forecast from a spreadsheet exercise into an accurate cash-flow tool.
For businesses approaching a liquidity crunch (missed covenant, thin cash cushion, growth outpacing collections), the forecast doubles as the operating tool. Weekly variance meetings between owner, controller, and CFO become the coordination point for AR chasing priority, AP stretching decisions, and 'hire' vs 'wait' calls. The forecast is the artifact; the discipline of running the meeting is the value.
Common pitfalls
- Modelling receivables and payables as monthly ratios rather than specific expected transactions — precision falls apart the moment a customer pays a week late
- Forgetting to include quarterly and annual outflows (tax estimates, insurance renewals, software annual contracts) — a forecast that misses them is misleadingly optimistic
- Building the forecast once and never re-forecasting; the discipline is the weekly refresh, not the initial build
- Not tracking variance vs actual — without the feedback loop the forecast stays wrong forever
- Using the 13-week for capital-allocation decisions that belong in the annual budget; the tool is short-term liquidity, not strategic planning
Related service
See FP&A servicesHave a 13-Week Cash Forecast situation in your business?
One team covering bookkeeping through fractional CFO, so the figure you just read about comes out of a ledger you can stand behind.