Profitable businesses go under all the time. Not because they weren't making money on paper, but because the money arrived later than the bills did. A big invoice is due in 45 days, payroll is due Friday, and "profitable" doesn't pay wages — cash in the bank does. A cash flow forecast is the one tool that tells you, in advance, whether you'll actually have the money when you need it.
The takeaway up front: a cash flow forecast is a simple, forward-looking timeline of the money coming in and going out of your business, so you can see a shortfall weeks before it happens instead of the morning it does. You don't need accounting software or a finance degree. You need a spreadsheet, an hour, and the numbers you already have in your head and your inbox. This guide shows you how to build one, keep it honest, and actually use it.
Cash flow is not profit
This is the distinction that catches owners out, so it's worth being blunt about it. Profit is revenue minus costs over a period — an accounting result. Cash flow is the actual movement of money in and out of your bank account, on the actual dates it moves. They are not the same thing, and the gap between them is where businesses get hurt.
Picture a simple example. You land a $10,000 project in January, deliver it, and send the invoice. On paper, January was a great, profitable month. But the client pays on 60-day terms, so the cash lands in March. Meanwhile you paid your team and your rent in January and February. You were profitable and nearly broke at the same time. Profit told you the deal was good; only cash flow told you when you could actually spend the proceeds.
Your finance fundamentals cover both, but if you only have time to watch one number closely, watch cash. Profit is the scoreboard at the end of the game. Cash flow is whether you can keep playing.
What goes into a forecast
A cash flow forecast has three moving parts, tracked period by period — usually week by week:
- Cash in. Every payment you expect to receive, on the date you realistically expect it. Customer payments, deposits, a loan drawdown, a tax refund. Not the invoice date — the pay date.
- Cash out. Every payment you expect to make: payroll, rent, suppliers, software, loan repayments, tax, your own wage. Everything that leaves the account.
- Running balance. Your opening bank balance, plus cash in, minus cash out, gives your closing balance for the period. That closing balance becomes the next period's opening balance, and the chain continues.
That closing balance line is the whole point of the exercise. When you scan across the weeks and see it dip below zero — or below the buffer you need to sleep at night — you've found a problem while you still have time to fix it.
The 13-week forecast: the small-business standard
The most useful format for a small business is the 13-week cash flow forecast — one quarter, broken into weekly columns. Thirteen weeks is far enough ahead to see trouble coming and act (chase invoices, delay a purchase, arrange a credit line) but near enough that your estimates are grounded rather than fantasy. Monthly forecasts hide the problem: a month can net out positive while you're actually overdrawn for ten days in the middle of it.
Set it up as a grid. Down the left, list your line items. Across the top, thirteen weekly columns. Here's the skeleton:
- Opening balance (this week's starting bank balance)
- Cash in — a row per major source, then a total
- Cash out — a row per major cost, then a total
- Net movement (cash in minus cash out)
- Closing balance (opening + net movement)
The single formula that matters: each week's closing balance = opening balance + total cash in − total cash out, and that closing balance is copied into the next week's opening balance. That's it. If you can build that chain, you have a working forecast.
Building it, step by step
-
Start with today's real bank balance. Not what your accounts say you're owed — the actual cleared figure in the account right now. That's week one's opening balance. Getting this wrong poisons every week after it.
-
List your fixed, predictable outflows. Rent, payroll, loan repayments, insurance, subscriptions, your own draw. These are the easy ones because you know the amounts and the dates. Slot each into the week it actually leaves the account.
-
Add variable and one-off outflows. Supplier orders, a tax payment due next month, a piece of equipment you're planning to buy. Estimate honestly and place them in the right week.
-
Forecast cash in — conservatively. Go through outstanding invoices and expected sales and enter each on the date you realistically expect payment, not the date it's due. If a client habitually pays two weeks late, forecast two weeks late. Optimism here is the most common way a forecast lies to you.
-
Let the balances roll. Build the closing-balance chain across all thirteen weeks. Now read it. Where does the closing balance get uncomfortably low or go negative? Those weeks are your early-warning flags.
Keep it deliberately simple at first. A dozen well-placed rows you'll actually maintain beats a forty-row masterpiece you abandon in a fortnight.
Reading what the forecast tells you
A forecast is only worth the hour if it changes a decision. Common patterns and what they're telling you:
- A dip in a specific week. A big outflow lands before a big inflow. Fix the timing, not the whole business: ask a supplier for a few extra days, invoice a client sooner, or ask for a deposit up front.
- A slow, steady decline. The closing balance drifts down week after week. That's structural — you're spending more than you're bringing in, and no timing trick fixes it. This is a costs-or-pricing problem, and it's worth revisiting your break-even point to see how far off the line you are.
- A comfortable, rising balance. Genuinely good — and also a signal. Now you can plan that hire or purchase from a position of knowledge rather than nerve.
The forecast doesn't make the decision for you. It just makes sure you're deciding with your eyes open instead of guessing.
Keep it alive
A forecast built once and forgotten is worse than useless, because you'll trust a number that's gone stale. Make it a habit:
- Update it weekly. Pick a quiet 20 minutes — Monday morning works well. Replace last week's estimates with what actually happened, then roll a fresh week onto the end so you always see 13 weeks ahead.
- Compare forecast to actual. When a week comes in very different from what you predicted, ask why. Over a month or two, this quietly makes your estimates sharper — especially around how late customers really pay.
- Watch the trend, not just today. One tight week is manageable. Three tight weeks in a row is the business trying to tell you something. For the deeper diagnostics behind the trend, pair this with your core finance metrics.
Common mistakes to avoid
- Forecasting revenue instead of cash. A signed deal isn't cash until it clears. Enter money on the date it lands, never the date it's earned.
- Being optimistic about payment timing. The single biggest source of forecast error. When unsure, assume later, not sooner.
- Forgetting the irregular bills. Quarterly tax, annual insurance, and yearly subscriptions blindside owners precisely because they don't show up monthly. Map them the moment you build the forecast.
- Leaving out your own pay. If the forecast only survives because you're not taking a wage, it's flattering you, not informing you. Put your draw in as a real line.
You don't need to become a finance person to run a business that doesn't run out of money. You need one honest spreadsheet, updated once a week, that answers a single question: will the money be there when the bill is? Build the forecast, keep it current, and most cash surprises stop being surprises — which is exactly the point.
