Profitable businesses fail from cash, not from losses. The income statement records a sale when the work is done; the bank records it when the customer pays. The gap between those two events is where companies die, and it widens exactly when things are going well.
The 13-week cash flow forecast is the standard tool for managing that gap. It is used in turnarounds because it works under pressure, but there is no reason to wait for pressure.
Why thirteen weeks
Thirteen weeks is one quarter — long enough to see a seasonal turn, a quarterly tax payment, or an insurance renewal coming, and short enough that weekly estimates remain honest.
Beyond about a quarter, weekly precision becomes false precision. Inside it, you can name most of the specific invoices and bills involved rather than extrapolating averages.
The forecast is weekly, and that granularity is the point. A monthly view showing a positive month conceals the Tuesday in week three when payroll and a tax deposit land together and the account goes negative. Cash problems are timing problems, and monthly buckets hide timing.
What goes in it
Structure it as a simple grid — thirteen columns, one per week.
Opening cash. The actual bank balance, not the book balance. They differ by outstanding checks and deposits in transit, and the bank’s number is the one that clears payroll.
Receipts, by source:
- Collections on existing receivables, scheduled by expected payment date rather than terms
- Expected new sales converted to cash, with a realistic lag
- Other inflows — loan draws, tax refunds, owner contributions
Disbursements, by category:
- Payroll and payroll taxes, on their actual dates
- Vendor payments
- Rent, insurance, debt service, subscriptions
- Estimated tax payments — the quarterly dates are known in advance
- Capital expenditures
- Owner distributions
Closing cash, which becomes the next week’s opening.
Then add a line for your borrowing capacity, so the forecast shows both cash and liquidity. A week with $8,000 of cash and an untouched $200,000 line of credit is not the same as a week with $8,000 and nothing behind it.
Where forecasts go wrong
Optimistic collections. The most common failure by a wide margin. Terms say net 30; the customer pays in 47 days. Use each customer’s actual behavior, not the invoice. Your accounts receivable aging already contains this evidence.
Forgetting the irregular items. Quarterly estimated taxes, annual insurance premiums, workers’ compensation audit assessments, and equipment maintenance are all knowable and all routinely omitted. These are precisely the payments that turn a comfortable week into an overdraft.
Ignoring the payroll calendar. Businesses on biweekly payroll have two months a year with three pay periods. Owners forecasting “monthly payroll” miss it every time.
Treating it as a budget. A budget is a target you commit to. A forecast is your best estimate of what will happen. Mixing them produces a document that is neither — aspirational enough to be useless for planning and rigid enough to be ignored.
Keeping it honest
Update it weekly, on the same day, and — this is the step that creates the value — compare last week’s forecast to what actually happened.
That variance review is what converts the exercise from bookkeeping into forecasting skill. After a month or two you learn that a particular customer always pays a week late, that materials run 10% over estimate, that a category is systematically understated. The forecast gets progressively more accurate because you are calibrating it against reality rather than rebuilding it from assumptions.
An hour a week is a realistic commitment once the template exists.
What it is actually for
Three things.
Avoiding surprises. Seeing a shortfall in week nine gives you eight weeks to act. Discovering it on the day gives you a wire transfer from a personal account and an uncomfortable call.
Making decisions with confidence. Can we take on this job that requires $60,000 of materials up front? Can we hire in March? The forecast answers questions the income statement cannot.
Talking to lenders from strength. Borrowing capacity is easiest to arrange before you need it. An owner who arrives with a 13-week forecast showing a manageable, temporary gap is a fundamentally different applicant from one who arrives when the account is empty. Federal Reserve small business credit surveys consistently show cash flow management among the most common reasons firms seek financing — and preparation materially affects the terms.
Starting
Build the first one in a spreadsheet. Do not buy software for this.
Start with your actual bank balance, list every payment you know is coming for the next thirteen weeks, schedule your receivables by realistic payment dates, and see what the closing balances look like. The first version will be wrong. Update it next week and it will be less wrong.
Our cash runway calculator gives you the summary view — months of runway and a stress case — which is a useful companion to the week-by-week detail.