The Cash Flow Forecast Nobody Taught You
The concept is simple. Maintaining it manually? That's where things fall apart.
Last week we talked about the gap between your bank balance and your actual financial position — the invoices that haven’t landed, the bills that haven’t hit, the slow-motion collision you can’t see from the dashboard.
A few of you replied with some version of the same question: Okay, so what do I actually do about it?
Fair. Let’s talk about the tool that answers that.
There’s a thing CFOs at large companies use religiously. It’s called a rolling cash flow forecast — a forward-looking view of the cash you expect to receive and the cash you expect to spend, laid out week by week.
Here’s a simplified version of what it looks like:
Starting cash: $24,000 → $21,500 → $14,000 → $22,500
Expected cash in: $5,000 → $3,500 → $18,000 → $6,000
Expected cash out: -$7,500 → -$11,000 → -$9,500 → -$8,000
Ending cash: $21,500 → $14,000 → $22,500 → $20,500
See Week 2? Cash drops to $14,000. If you spotted that three weeks out, you’d know to hold off on that software upgrade. Or to nudge that overdue invoice. Or to line up a short-term credit facility, just in case.
The power of a forecast isn’t precision. It’s lead time.
So here’s the honest part.
The concept of a cash flow forecast is simple. The practice of maintaining one? That’s where things fall apart.
You need your current bank balance, your outstanding invoices, your upcoming bills, your expected revenue, your recurring obligations. You need to know which clients pay on time and which ones are habitually three weeks late. You need to update it — every single week — or the whole thing goes stale and becomes decoration.
Most business owners I’ve talked to have tried some version of this. A spreadsheet they built one ambitious Sunday afternoon. It worked great for two weeks. Then a busy Monday happened. Then another. Then the spreadsheet was three weeks out of date, and looking at it felt more stressful than helpful, so they stopped.
Sound familiar?
Here’s the thing nobody tells you about cash flow forecasting: the hard part isn’t building the forecast. It’s feeding it accurate, up-to-date numbers week after week while also running payroll, chasing invoices, managing vendors, and doing the actual work your business exists to do.
That’s fifteen minutes a week if nothing has changed. But things always change. An invoice gets paid late. A new expense pops up. A client delays a project. Now you’re re-checking bank balances, cross-referencing your AR, adjusting projections — and suddenly it’s not fifteen minutes, it’s an hour you didn’t have.
And the real cost isn’t just the time. It’s what happens when you miss something. When you forget that annual insurance premium hitting next week. When you don’t notice a client is 45 days past due until you’re scrambling to make payroll. When you pad expenses by 10% but the actual surprise was 30%.
A spreadsheet can’t ping you when your runway dips below a threshold. It can’t automatically pull your latest bank data. It doesn’t adjust when an invoice gets paid or a new bill hits.
This is exactly why we built MyRunwayHealth — not to replace your financial judgment, but to automate the part that’s hardest to do consistently: keeping the numbers current, surfacing the patterns, and flagging the problems before they become emergencies.
The best practice is knowing your cash position forward. The smartest move is not trying to maintain that view manually while also running a business.
Have you tried maintaining a cash flow forecast? How long did it last before the spreadsheet went stale? I’d love to hear what tripped you up.