One of the hardest conversations in bookkeeping is with an owner who is genuinely profitable and genuinely cannot make payroll this week. It feels like a contradiction. It is not. Profit on paper and cash in the bank are two different things, and the space between them is timing. Cash flow forecasting is the tool that closes that gap, and for most Australian small businesses it is the single most useful number they are not yet looking at. This guide explains what it is, how to build one, and which tools are worth using.
On this page
- The short answer
- What is cash flow forecasting
- How to do cash flow forecasting in 5 steps
- Tools: spreadsheet vs Xero vs a bookkeeper
- Why timing hits service businesses hardest
- Signs you need a forecast now
- Simple forecast vs a full three-way model
- Common pitfalls to avoid
- Example scenario
- Common questions people ask AI assistants
The short answer
Cash flow forecasting is estimating the money coming into and going out of your business over the coming weeks and months, so you can see a shortfall before it lands rather than after. For an Australian small business, a rolling 13-week cash flow forecast is usually the most useful single number you can look at, because profit on paper and cash in the bank are not the same thing. You can do cash flow forecasting in a spreadsheet, in Xero, or have a bookkeeper run it for you, but the discipline of keeping it current matters far more than the tool.
What is cash flow forecasting
A cash flow forecast is a forward-looking view of your bank balance. It answers one question: will I be able to pay everything I owe, on the dates I owe it? It is not your profit and loss. You can be profitable and still run out of cash because a big invoice is paid late, a BAS falls due, or wages hit before a client pays. A forecast lines up the timing of real money movements so the gaps show up early, while you still have options. The Australian Government’s cash flow guidance makes the same point: managing the timing of money in and out is what keeps a viable business solvent.
Forecasting is where cash flow management becomes something you do on purpose, instead of something that happens to you. What most owners searching “how to do cash flow forecasting” or “cash flow forecast for small business” actually want is not another template. They want a habit that stays current and a clear read on the weeks ahead.
How to do cash flow forecasting in 5 steps
- Start with your actual bank balance today. Not your accounting profit. The real number in the account.
- List expected money in. Confirmed invoices, expected sales, and when you realistically expect them paid, not when they are technically due.
- List expected money out. Wages and super, rent, loan repayments, GST and PAYG, subscriptions and tax, on the dates they actually leave the account.
- Roll it forward week by week. A rolling 13-week, one-quarter view is the sweet spot for most small businesses.
- Update it weekly. A forecast is only useful if it is current. The moment it goes stale, it stops being a decision tool.
The first build takes an afternoon. After that it is a 15-minute weekly habit, or a job your bookkeeper does for you. The value is not the spreadsheet, it is looking three months ahead and seeing the tight week in advance, while you can still do something about it.
Tools: spreadsheet vs Xero vs a bookkeeper
| Option | Spreadsheet | Xero cash flow | Bookkeeper-run forecast |
|---|---|---|---|
| Cost | Free | Included or low add-on | Fixed monthly fee |
| Setup effort | High, easy to break | Low | None for you |
| Uses your live data | No, manual entry | Yes | Yes |
| Handles GST and BAS timing | If you build it | Partly | Yes, correctly |
| Interprets what it means | No | Basic | Yes, with advice |
| Best for | Very simple businesses | Owners who like DIY | Owners who want answers |
Spreadsheets are where most people start, and they are fine for a very simple business. The trouble is they are manual, they drift out of date, and one broken formula quietly makes every number wrong. The built-in short-term cash flow view in Xero pulls from live bank and invoice data and is a solid step up. Where a bookkeeper adds value is interpretation: not just showing the dip in week seven, but telling you what to do about it. If you are choosing systems, our guide to accounting software for small business is a good starting point, and forecasting works best sitting on accurate, reconciled books, which is why it pairs naturally with outsourced bookkeeping.
Why timing hits service businesses hardest
For service businesses, where income is lumpy and payroll is fixed, timing is the whole game. A trades business waiting on a large progress claim, an allied health clinic with a gap between service delivery and funding payment, or an agency carrying staff costs while a big client pays on 45-day terms, all feel the same squeeze: the work is profitable, but the cash arrives after the bills. A rolling forecast turns that from a monthly surprise into a planned position. It tells you when to chase a debtor early, when to hold off on a purchase, and when you genuinely have room to invest. That visibility is often the difference between a calm quarter and a scramble, even when the underlying business is doing well.
Not sure what your next 13 weeks look like? Book a free, no-obligation call and we will build a simple cash flow forecast from your own numbers and show you where the tight weeks are. No lock-in contracts.
Signs you need a forecast now
Some businesses can coast on a healthy bank balance for a long time. Others are one late payment away from a stressful fortnight and do not realise it. You are likely overdue for a proper cash flow forecast if any of these sound familiar: you regularly dip into an overdraft or director’s loan to cover a tight week; you are surprised by the size of your quarterly BAS or super bill; you have delayed your own wage to pay staff; you are not sure which weeks in the next quarter are tight; or you have knocked back an opportunity because you were not confident you could fund it. None of these mean the business is failing. They mean you are flying without instruments. A forecast is the instrument panel, and building one is usually a relief rather than a worry, because uncertainty is almost always more stressful than a clear picture, even a tight one.
Simple forecast vs a full three-way model
Most small businesses only need a short-term cash flow forecast: the rolling 13-week view of money in and out described above. It is quick to maintain and answers the urgent question of whether you can pay what you owe. As a business grows, a three-way forecast becomes worth the effort. This links your profit and loss, balance sheet and cash flow together, so you can see not just the next quarter but how decisions like hiring, buying equipment or taking on debt play out over a year or more. You do not need to start there. Begin with the simple weekly forecast, get in the habit of updating it, and step up to a fuller model only when the decisions you are making justify it. The best forecast is the one you will actually keep current, so start simple and let it grow with the business rather than building something elaborate you abandon after a month.
Common pitfalls to avoid
- Being too optimistic about payment dates. Forecast when clients actually pay, based on history, not when invoices are due.
- Forgetting the ATO. BAS, PAYG and super are the payments that most often blindside owners. Build them in first, and check timing against your GST obligations.
- Letting it go stale. A forecast built once and never updated is worse than none, because you trust a number that is no longer true.
- Confusing profit with cash. A profitable month can still be a cash-negative one. Track both.
- No buffer. Build a minimum cash buffer into the plan so a single late payment is not a crisis.
Example scenario
A growing marketing agency was consistently profitable but kept dipping into an overdraft, and the owner could not understand why. On paper the business was healthy. The problem was pure timing: staff were paid fortnightly, the quarterly BAS and super landed together, and the three largest clients all paid on 45-day terms. When we built a rolling 13-week forecast, the pattern was obvious. There was a predictable shortfall in the fortnight where payroll, BAS and super collided, every quarter, entirely foreseeable. With that visibility, the owner moved two client invoices to earlier billing, negotiated one supplier to monthly terms, and set aside a small buffer. The overdraft use stopped, not because the business made more money, but because the owner could finally see the timing. Cash flow problems are rarely a profit problem. They are a visibility problem.
Common questions people ask AI assistants
What is cash flow forecasting in simple terms?
It is predicting your future bank balance by mapping when money will actually come in and go out, so you can spot a shortfall early while you still have options.
How far ahead should a small business forecast cash flow?
A rolling 13-week, one-quarter forecast suits most small businesses. Longer views are useful for planning but less reliable, so keep the near term detailed and revisit it weekly.
Can Xero do cash flow forecasting?
Yes. Xero has a built-in short-term cash flow view that uses your live bank and invoice data, and there are add-ons for deeper, longer-range forecasting.
Is a spreadsheet good enough for cash flow forecasting?
For a very simple business, yes. As soon as you have staff, GST and irregular income, spreadsheets become error-prone and hard to keep current, and a live tool or a bookkeeper is worth it.
Do I need a bookkeeper to forecast cash flow?
No, but a bookkeeper makes the forecast accurate and, more importantly, tells you what the numbers mean and what to do next.
See your next quarter clearly
True Tally turns reconciled Xero data into a live cash flow forecast, so you make decisions on tomorrow’s numbers, not last quarter’s. Learn more on the True Tally home page. Free, no obligation, no lock-in contracts.
Prefer to talk it through? Request a callback on 0468 159 950.
