Cash Flow Forecasting for Small Business: A Practical Template

Plenty of profitable businesses go under. It sounds like a contradiction until you've lived it: the work is coming in, the invoices look healthy, the year will show a profit — and yet one Thursday there isn't enough in the account to cover wages. That gap between "profitable on paper" and "money in the bank" is where small businesses quietly die, and it's almost always avoidable. The tool that avoids it is a cash flow forecast, and it's far simpler than it sounds.

A cash flow forecast is nothing more than a clear-eyed look at the money you expect to come in and go out over the months ahead, so you can see a squeeze coming while there's still time to do something about it. This guide gives you a plain-English template, a worked example you can copy, and the habit that turns it from a one-off spreadsheet into an early-warning system for your business.

Why Cash Flow Forecasting Matters

Cash flow isn't one problem among many for Australian small businesses — it's the problem. Ask owners what keeps them up at night and the same answer comes back more than any other.

Sit with that second figure. Close to half of the businesses that fail don't fail because nobody wanted what they sold — they fail because they ran out of cash. Declining revenue, thin cash reserves and seasonal swings all play a part, but the common thread is being caught by surprise. A forecast removes the surprise. It won't magically create money, but it will show you the gap far enough ahead that you have real options instead of a panic.

"The plans of the diligent lead surely to plenty, but those of everyone who is hasty, surely to poverty."

— Proverbs 21:5 (NKJV)

Diligent, thought-through plans lead to plenty; haste leads to want. A cash flow forecast is diligence made practical — a small, steady habit that keeps you out of the reactive scramble that drains so many good businesses. It's a cornerstone of the financial stewardship we coach.

Profit Isn't Cash

The single most important idea to grasp is that profit and cash are not the same thing, and they're frequently out of step. Profit is an accounting figure — revenue minus expenses on paper. Cash is the actual money moving through your bank account. A business can be genuinely profitable and still run dry.

Picture it. You invoice a big customer $50,000 in June; on paper, that's profit and it looks great. But they pay on 60-day terms, so the cash doesn't arrive until August. Meanwhile, July's wages, rent, stock and BAS all fall due now. The profit is real, but it can't pay this month's bills — the timing is the problem. Multiply that across every invoice, supplier and tax deadline and you can see why so many owners feel squeezed despite a healthy-looking profit and loss statement. Forecasting cash, not just watching profit, is what closes that blind spot — and it pairs naturally with knowing your numbers well enough to understand your business's real value.

Build Your Forecast: A Simple Template

You don't need special software — a spreadsheet, or even paper, will do. The structure is the same every time: for each month ahead, start with what's in the bank, add what comes in, subtract what goes out, and carry the result forward. Here's the method, step by step.

The discipline that makes this work is honesty about timing. The most common forecasting mistake is assuming money arrives the day you invoice it. Base your "cash in" on when customers really pay, and your forecast will actually protect you. Our free 90-day planning tool can help you set the quarterly rhythm this fits inside.

A Worked Example

Here's a simple four-month forecast for an imaginary small business. Notice how it tells a story the profit and loss statement never would.

The business is fine overall — it ends Month 4 with more cash than it started. But look at the trend from Month 1 to Month 3: the balance is sliding, from $12,500 down to just $4,500. Months 2 and 3 both burn more cash than they bring in. If a large unexpected bill landed in Month 3, this business could be in real trouble — and without a forecast, the owner wouldn't see it coming until the balance was already dangerously low.

Reading the Forecast and Acting Early

The whole value of the forecast is what it lets you do before the tight month arrives. Seeing that Month 3 dips to $4,500, a diligent owner acts back in Month 1: chasing overdue invoices to pull cash in sooner, staging a non-essential purchase until Month 4, or trimming discretionary spend for a few weeks. None of those moves are dramatic — but made early, they turn a potential crisis into a non-event.

That's the shift a forecast creates: from reacting to anticipating. If the numbers show a genuine shortfall you can't close by timing alone, you'll know early enough to arrange finance on good terms — an overdraft or facility organised calmly weeks ahead always beats one begged for in a crisis. And if they show a healthy surplus, that's information too: it might be the moment to build the cash reserve every business should hold against the lean months, the way the ant prepares in summer.

"Go to the ant, you sluggard! Consider her ways and be wise, which, having no captain, overseer or ruler, provides her supplies in the summer, and gathers her food in the harvest."

— Proverbs 6:6-8 (NKJV)

The ant's wisdom is simply this: prepare in the good season for the lean one. A cash flow forecast is how a business does exactly that — seeing the summer surplus and the winter gap in advance, and stewarding the difference wisely.

Real Result: The Reward of Financial Discipline

Getting on top of your numbers doesn't just keep you safe — over time, it builds real wealth. Jason Riley and Dean Wahploe of Login Systems engaged coaching to bring structure and financial discipline to a growing business, and the compounding results went well beyond survival.

Read the full Login Systems story →

Cash flow forecasting is where that discipline starts. It's the humble, weekly habit that keeps the doors open — and, kept up over years, the quiet foundation of everything else you're building. Master this one number, and you've mastered the one that most often decides whether a business lives or dies.

Frequently Asked Questions