By the Advisory Team at Quantum House | Chartered Accountants & Tax Advisers, Sydney
Cash is the oxygen of a small business. A company can be profitable on paper and still fail if it runs out of cash at the wrong moment. Yet the majority of SME owners in Australia manage their cash position reactively — checking the bank balance when a bill arrives rather than forecasting what the position will be in four, eight, or twelve weeks. A simple cash flow forecast changes everything. This guide walks through how to build one, what inputs to include, and how to use it to make better business decisions.
What Is a Cash Flow Forecast and Why Does It Matter?
A cash flow forecast is a forward-looking projection of the cash coming into and going out of your business over a defined period — typically 13 weeks to 12 months. Unlike a profit and loss statement, which records accrual-based income and expenses, a cash flow forecast tracks actual cash movements — when invoices will be paid, when supplier bills are due, when tax obligations fall. It allows you to see cash shortfalls before they happen and take action in advance rather than in crisis.
Step 1: Define Your Forecast Period and Format
For most SMEs, a 13-week (quarterly) rolling forecast is the most practical starting point. It is short enough to be reasonably accurate, yet long enough to give you meaningful warning time. Use a simple spreadsheet with weeks or months as columns, and rows for each category of cash inflow and outflow. Your accounting software — Xero, for example — can export historical data to help populate the forecast. If you have outgrown that software, it may be time to consider moving beyond Xero to an ERP. Review and update the forecast weekly or fortnightly.
Step 2: Forecast Your Cash Inflows
Cash inflows include customer receipts, government grants, R&D tax incentive refunds, loan drawdowns, and asset sale proceeds. The most important input is your expected customer receipts — and this is where most business owners underestimate. Map your outstanding debtors by due date, apply a realistic collection assumption based on your actual debtor days, and then layer in new sales expected to be invoiced and collected within the period. Be conservative — optimistic assumptions are the enemy of a useful forecast.
Step 3: Forecast Your Cash Outflows
Outflows include wages and superannuation, supplier payments, rent, loan repayments, ATO obligations (GST, PAYG, income tax instalments), and capital expenditure. The key discipline here is timing: a $50,000 tax bill due on 28 February has a very different impact depending on whether you have identified it in December or stumbled across it in late January. List every known obligation by its expected due date, not just its accrual month.
Step 4: Build in Scenarios
A single-scenario forecast gives you one view of the future. A well-structured forecast includes a base case, a downside case (what if a major customer pays 30 days late or a key contract is delayed?), and an upside case (what if you win the new project being tendered?). Scenario modelling allows you to test the resilience of your cash position and identify the thresholds at which you would need to act — whether that means drawing on a credit facility, delaying capital expenditure, or accelerating debtor collections.
Step 5: Review Actuals Against Forecasts
The most common reason cash flow forecasts fail is that they are built once and never updated. The forecast must be a living document: every week or fortnight, compare actual cash movements to the forecast, understand why variances occurred, and roll the forecast forward. Over time, this process dramatically improves your forecasting accuracy and deepens your understanding of your business’s cash dynamics. Comparing your position against industry benchmarks adds a further layer of insight.
A Hypothetical Case Study: Seeing Around the Corner
Consider Brightwork Joinery, a fictional cabinetmaking business. Sales were growing and the profit and loss statement looked healthy — so the owner managed cash the way many do, by glancing at the bank balance when a bill landed. When they finally built a simple 13-week rolling forecast, it flagged a problem six weeks out. In a single fortnight, a $48,000 BAS payment and the quarterly superannuation guarantee both fell due — in the same period a major customer’s large invoice was not yet scheduled to be collected, while payroll still had to run as normal. On paper the business was comfortably profitable; in cash terms it was heading for roughly a $30,000 shortfall. Crucially, because they could see it six weeks ahead rather than the week it struck, they had options. They brought forward collection on two overdue invoices, deferred a non-urgent equipment purchase by a month, and arranged a small overdraft facility as a backup buffer. In the end the shortfall never eventuated: payroll and the ATO were paid on time, and the equipment was bought the following month out of ordinary cash flow. Nothing about the business was unhealthy — it simply needed to see around the corner. (This scenario is illustrative only; every business’s circumstances differ.)
Getting Professional Help With Cash Flow Forecasting
Building a robust cash flow model requires accounting expertise, industry knowledge, and familiarity with forecasting tools. Quantum House’s outsourced CFO and business advisory team build and maintain cash flow forecasts for SMEs, integrating accounting data with industry benchmarks to produce forecasts that are accurate, actionable, and presented in formats suitable for internal management and external stakeholders. If you would like to discuss cash flow forecasting for your business, contact Quantum House today.
Ready to talk? If you would like to discuss any of the topics covered in this article for your business, contact Quantum House today for a confidential consultation. Visit quantumhouse.com.au or call our Sydney office to speak with a senior adviser.