Cash Flow Forecasting: The Report That Prevents the Emergency
Profitable companies fail on timing, not margin. A thirteen-week rolling forecast is the cheapest insurance available.
Profit is an accounting opinion; cash is a fact. A business can be profitable on paper and unable to make payroll, because the invoices are issued and the money has not arrived. This failure mode is entirely predictable and routinely unmonitored.
The thirteen-week rolling forecast
The standard tool is a week-by-week view of cash in and cash out for the next quarter, updated weekly. Thirteen weeks is long enough to see a problem while you can still act — negotiate terms, chase receivables, delay a purchase — and short enough that the numbers are grounded rather than aspirational.
What goes in it
- Confirmed receivables with realistic payment dates, not invoice dates. Use each client's actual payment history, not their stated terms.
- Committed outgoings: payroll, rent, subscriptions, tax, loan repayments.
- Probable new revenue, weighted by pipeline stage and discounted deliberately.
- Known one-offs — the annual insurance renewal that surprises the same business every year.
What to automate
Pull actuals from the accounting system and pipeline from the CRM automatically, so the forecast is a live view rather than a spreadsheet someone rebuilds monthly and eventually stops rebuilding. Automate the alert too: notify when the projected minimum drops below a threshold you set in advance, while you are calm. If you would rather have it built than described, that is what our automation work covers.
Using it
- Review weekly, briefly. This is a fifteen-minute habit, not a monthly meeting.
- Track forecast against actual and learn your own bias. Everyone is optimistic about receivables in a predictable direction.
- Model the obvious scenarios: your largest client pays thirty days late, or the pipeline delivers half of what you expect.
- 13 weeks the standard forecast horizon
- weekly update cadence
- lowest balance the number that matters
Frequently asked questions
Does our accounting software already do this?
Most produce a basic projection from invoice dates, which assumes clients pay on time — the assumption that causes the problem. A useful forecast uses actual payment behaviour per client and includes weighted pipeline.
How accurate can a forecast be?
Weeks one to four should be close, five to eight reasonable, nine to thirteen indicative. That is enough: the purpose is seeing a problem in time to act, not predicting the future precisely.
More on this topic: Growth & Strategy.
Keep reading
Want this built for your business? See what we do.