How to forecast cash flow for a small business in Australia

Most small business owners keep a close eye on their profit and loss statement and assume that is enough. It is not. Profit is an accounting construct, counted the moment a sale is invoiced or a cost is incurred. Cash is what actually sits in the bank account, and the two rarely move in step. A business can be genuinely profitable on paper and still be unable to pay wages in a given week, because a large customer pays late, stock had to be bought and paid for months before it sold, or a quarterly BAS bill and a big supplier invoice happen to land in the same fortnight. Cash flow forecasting exists to catch that mismatch while there is still time to act on it, rather than discovering it the morning a payment bounces.

This matters more in Australia than the raw numbers suggest, because so much of small business cash flow is shaped by structural timing that owners do not control: quarterly BAS and superannuation deadlines, seasonal trade patterns around the summer retail peak and the slower start to the calendar year, and payment terms that are agreed on paper but rarely honoured to the day in practice. None of that is a reason to avoid forecasting. It is the reason forecasting pays off.

How do you build a cash flow forecast?

A working forecast has four ingredients, and the discipline is in keeping them separate rather than blending them into a single guess.

• Opening cash balance — what is actually in the account today, taken from your bank feed, not an estimate.
• Cash in — money you expect to actually receive in the period, based on when customers typically pay, not when you invoice them.
• Cash out — every payment you expect to make, including the irregular ones that are easy to forget: insurance renewals, BAS, superannuation, loan repayments and annual software renewals.
• Closing balance — the number that tells you whether you are heading toward a shortfall, and how much runway you have to fix it.

The most common mistake is forecasting cash in on trading terms rather than actual customer behaviour. If your invoices say 30 days but your customers typically pay in 45, forecasting on the stated terms will consistently overstate your near-term cash position. Pull your actual average days-to-pay from your accounting software before you build your first forecast, and use that number instead of the one printed on the invoice.

Which forecasting method should a small business use?

There are two standard approaches, and they answer different questions. Most businesses benefit from running both, at different levels of detail.

Method	What it answers	Best used for
13-week direct forecast	Will we have enough cash in the bank each of the next 13 weeks?	Near-term accuracy, early warning, weekly decision-making
12-month indirect forecast	What does our cash position look like across a full trading cycle, including seasonal swings?	Planning, budgeting, hiring decisions, loan or investor conversations

The 13-week direct forecast is built line by line from actual known and expected transactions: this week's confirmed invoices, this fortnight's payroll run, the supplier payment due on the 20th. Because the window is short, the inputs are largely known rather than estimated, which is why it tends to be accurate enough to act on directly. It is the version to check weekly.

The 12-month indirect forecast starts from your budgeted profit and loss and adjusts for the timing differences: adding back non-cash items, spreading seasonal revenue across the months it actually lands, and layering in known capital costs. It is inherently rougher, but it is the version that reveals a seasonal trough three months out, while there is still time to build a buffer or arrange finance ahead of it, rather than during it.

What assumptions most commonly break a forecast?

A forecast is only as good as its weakest assumption, and the same handful of errors show up repeatedly.

Optimistic collection timing is the biggest one, discussed above. The fix is simple: use your real average days-to-pay, reviewed quarterly, not your stated trading terms.

Treating a pipeline deal as confirmed cash. A verbal agreement or an unsigned quote is not cash in week six. Only include revenue in a near-term forecast once it is genuinely committed — signed, invoiced, or contractually due — and keep pipeline revenue in a separate, clearly-labelled "hoped for" line rather than blending it into the base case.

Forgetting the lumpy, irregular costs. Monthly costs like rent and payroll are easy to remember because they repeat. Annual insurance renewals, BAS and superannuation, and one-off software or equipment renewals are the ones that catch businesses out, because they are correct in total but wrong in timing. Building a simple calendar of every irregular payment for the year, once, removes this risk almost entirely.

Not stress-testing the downside. A single base-case forecast tells you what happens if everything goes roughly to plan. It is worth building a simple downside version alongside it — customer payments running two weeks later than expected, or one major order slipping to next month — so you know your actual buffer, not just your optimistic one. This is the same discipline behind knowing which business metrics to track every month: the number matters less than knowing early when it moves the wrong way.

How often should you update a cash flow forecast?

Weekly, for the 13-week rolling view, ideally on the same day each week so it becomes routine rather than something done only when cash feels tight. Each week, drop the week that has passed, add a new week 13 weeks out, and true up the actuals against what was forecast. That comparison — forecast versus actual — is where the real learning happens, because it tells you which assumptions are systematically wrong and need adjusting, rather than which single week went badly.

The 12-month view is worth revisiting monthly, or immediately after anything material changes: a new contract signed, a pricing change, a decision to hire, or a supplier renegotiation. A forecast that is never updated is a historical document, not a management tool.

Do you need software, or is a spreadsheet enough?

A spreadsheet is genuinely sufficient for most small businesses starting out, and there is no reason to buy a tool before you have proven you will actually maintain the habit manually. The point where dedicated forecasting software or a connected dashboard starts to earn its cost is usually one of two triggers: the manual weekly update starts getting skipped under time pressure, which defeats the entire purpose, or more than one person needs to see the same live numbers rather than a static document that is already out of date by the time it is shared. If you are already pulling numbers from Xero or MYOB manually each week, it is worth reading how other Australian small businesses have approached automating business reporting, because the same connections that feed a sales dashboard can feed a live cash position.

Where to start

Do not try to build a perfect 12-month model in the first sitting. Start with the 13-week direct forecast, because its inputs are largely known rather than estimated, and it will produce a genuinely useful answer within an hour using your bank feed and this month's invoices and bills. Run it for four weeks, compare forecast to actual each week, and correct your assumptions about payment timing as you go. Once that habit is solid and reliably accurate, layer in the 12-month indirect view for the bigger planning questions. The businesses that avoid cash crunches are rarely the ones with the most sophisticated model. They are the ones that look at the number every week, trust it because they have tested it against reality, and act on it while there is still room to move. If you want help building a forecast that is genuinely tailored to your payment terms and seasonality, book a consultation and we will work through your numbers together.