Most cash flow surprises weren't unknowable. They were visible six weeks out to anyone who was looking, and nobody was looking, because the tool for looking didn't exist.
The tool is a rolling 13-week cash flow forecast. One quarter forward, one week at a time, updated every week. It's the single highest-return hour of financial work a small business owner can do, and it takes about that long once it's built.
Why 13 weeks and not 12 months
An annual budget is a planning document. It answers "what should this year look like," and it's wrong by February in a way that doesn't much matter.
A 13-week forecast answers a different question: "will I be able to make payroll on August 14, and what happens if that draw comes in late." That question has a right answer, and the answer changes weekly.
Thirteen weeks is the useful horizon because it's long enough that you can still act. Six weeks out, you can accelerate a collection, delay an order, move a hire, or call the bank while a call is still routine rather than urgent. Two weeks out, all you can do is watch.
The context worth knowing: the JPMorgan Chase Institute, which tracks 2.1 million small business bank accounts, found the typical small business held 17.6 cash buffer days in 2025 — under three weeks of outflows, if the money coming in stopped. Half hold less than that. At that margin, a thirteen-week view isn't a luxury. It's most of your warning.
What goes in it
One column per week. Thirteen columns. Four blocks of rows.
Starting cash. Every operating account, actual balance, not the balance in the register. Start from what the bank says.
Cash in. Not revenue. Collections. This is the block that takes real work, and it's the block that makes the forecast worth anything.
- Receivables you expect to collect, by customer, in the week you actually expect them, based on that customer's history rather than your terms
- New work you expect to bill and collect inside the window
- Everything else: a draw on the line, a tax refund, an owner contribution, an asset sale
Cash out. In the week it leaves.
- Payroll, on the actual pay dates, including employer taxes
- Rent, insurance, debt service, the recurring items with fixed dates
- Vendor payments, by vendor, in the week you intend to pay
- Sales tax and estimated tax payments, which are the most commonly forgotten rows on any forecast
- Anything seasonal or annual that happens to land in the window
Ending cash, and the gap. Starting cash plus in minus out. Carry it forward as next week's starting balance. Then add one more row underneath: your minimum operating balance, the number below which you're uncomfortable. Chart the ending balance against that line. The forecast is that picture.
The forecast isn't a prediction. It's a list of the weeks where you'd have to do something, sorted by how soon.
The rules that make it survive contact with reality
Most forecasts die in week three. These are the habits that keep one alive.
- Weekly, same day, same hour. Monday morning, before anything else. It takes twenty minutes once the structure exists.
- Roll it forward. Drop the week that just ended, add a new week 13. The horizon stays constant.
- Record what actually happened. Put the actual next to the forecast for the week that closed. Being wrong is fine. Being wrong the same way every week is information about your collections.
- Be pessimistic on timing, honest on amounts. If a customer pays in 47 days on average, forecast 47, not the 30 on the invoice.
- Keep it in one file with one owner. A forecast maintained by committee is maintained by nobody.
What it looks like in your business
Contractors. The forecast is built around draws and retainage. Retainage is money you've earned and cannot spend, and it belongs on the forecast in the week it's actually released, not the week the job finishes. Material buys ahead of a draw are the classic squeeze, and they're visible weeks out on a proper forecast.
Family practices. Cash in follows payer remittance cycles, not the appointment schedule. Forecast by payer with their real turnaround, and treat a denied claim as a claim, not as cash. A meaningful share of claims are denied on first submission and paid only after rework, which lands the money weeks later than the billing date. Forecast from collections rather than billings, or you'll overstate your cash every month.
Professional services firms. Payroll is the largest and least flexible outflow, and it hits on fixed dates regardless of collection. The forecast's job is to show you the week where a slipped collection meets a payroll date, which is the only week that actually matters.
What to do next
Build the first one from your last 90 days rather than from scratch. Your bank statements will tell you what actually goes out and when, and your receivables aging will tell you who actually pays and how slowly. Both are better inputs than memory.
Then look at the ending-cash row and find the lowest week. That week is your plan for the quarter.
If you'd rather have a forecast built and maintained alongside your close, that's what cash flow and forecasting is. Or book a free discovery call and we'll walk through your actual numbers, not a template.