Running a business without a cash flow forecast is a bit like performing a gig with no setlist - you might muddle through, but the chances of hitting a wrong note at the worst possible moment are uncomfortably high. Whether you're a freelance designer, a recording artist, or a creative agency owner in Penrith or anywhere across Sydney, understanding where your money is coming from and where it's heading is the backbone of financial survival.
This guide breaks down exactly how to create a basic cash flow forecast - without the dry, soul-destroying jargon that usually comes with accounting content. Let's tune this up properly.
A cash flow forecast is a forward-looking projection of how much money is expected to flow in and out of your business over a defined period. Think of it as the financial score for your business performance - it tells you what's coming up before it hits, so you're never caught flat.
It's important to distinguish a cash flow forecast from a cash flow statement. A cash flow statement looks back at what actually happened with your money. A forecast looks forward, estimating your future cash position based on expected income and expenses.
For Australian small businesses, cash flow forecasting is particularly valuable around key financial milestones: GST lodgement periods, Business Activity Statement (BAS) due dates, and the financial year-end on 30 June. Seasonal trading cycles also make forecasting essential - especially for creative businesses where income can spike around certain campaigns, events, or project cycles and then go quiet.
The bottom line? A cash flow forecast gives you visibility. And visibility gives you control.
Before you can build your forecast, you need to understand its five core components. The fundamental formula is straightforward:
Cash Flow = Cash Inflows − Cash Outflows
Here's how each piece fits together:
This is the cash sitting in your bank accounts at the start of the period. In your first month, it's simply your current bank balance. In every following month, the opening balance equals the closing balance from the month before.
These are all the funds expected to enter your business. Sources may include:
Critical point: Record cash when it will actually land in your account - not when you raise the invoice. If clients typically pay 30 days after invoicing, enter that income in the month the payment is expected to arrive.
All planned payments leaving the business. These fall into three categories:
Fixed costs - rent, insurance, employee salaries
Variable costs - raw materials, shipping, packaging (these shift with sales volume)
Periodic or irregular costs - equipment purchases, annual software subscriptions, ATO instalments, superannuation contributions
The irregular costs are the ones that trip most businesses up. Don't leave them out of your forecast.
Calculated by subtracting total outflows from total inflows for each period. A positive result means more money came in than went out. A negative result means the reverse - and that's your cue to plan ahead.
This is calculated as:
Closing Balance = Opening Balance + Total Inflows − Total Outflows
This closing balance rolls forward to become the opening balance for the next period. It shows your cash position at the end of each forecasting period.
Building a basic cash flow forecast doesn't require a PhD in finance. A spreadsheet - even a simple one in Google Sheets or Excel - is all you need to get started. Here's the process:
Determine how far ahead you want to plan. Your options generally look like this:
Most small businesses start with a 12-month rolling monthly forecast - it strikes the right balance between accuracy and planning value.
Set up one column per month and one row per income type. Start with sales, then layer in non-sales income such as tax refunds, grants, and royalties. Use historical data where available. For newer businesses, lean on market research and conservative estimates - it's far better to be pleasantly surprised than financially caught off guard.
Remember: always record income based on when cash will arrive, not when you invoice.
Map every dollar going out across your forecast period. This includes:
Watch out for months with three fortnightly payroll cycles - they catch businesses off guard more often than you'd think.
For each period:
That's it. Your forecast is built.
There are two primary methods for building a cash flow forecast, and the right choice depends on your planning timeframe and purpose.
| Feature | Direct Method (Bottom-Up) | Indirect Method (Top-Down) |
|---|---|---|
| Best for | Short-term (up to 13 weeks) | Long-term and strategic planning |
| Starting point | Actual cash transactions | Net income from P&L statement |
| Data used | Real receipts and payments | Profit adjusted for non-cash items |
| Precision | High - granular cash position view | Lower - broad financial picture |
| Adjustments needed | None - tracks actual cash movement | Depreciation, receivables, inventory |
| Used by | Most small businesses for daily management | Businesses seeking finance or planning growth |
| Formula | Cash Flow = Cash Inflows − Cash Outflows | Net Income ± Adjustments for non-cash items |
Many businesses benefit from using both approaches together - a short-term direct forecast for operational cash management, paired with a longer-term indirect forecast for strategic decisions and conversations with lenders.
Even experienced business owners make these errors. Being aware of them is half the battle:
Overestimating income - projecting revenue based on best-case scenarios rather than realistic payment patterns leads to nasty surprises.
Forgetting irregular costs - annual registrations, insurance renewals, superannuation, and ATO payment obligations are easy to overlook but hit hard when they arrive.
Ignoring payment delays - assuming clients will pay on time when many actually pay 30–60 days after invoice distorts your forecast significantly.
Treating it as a one-off exercise - a cash flow forecast is a living document. Update it monthly. Remove the completed period, add a new one to the end, and compare your estimates against actual results. This process reveals patterns and sharpens your future predictions.
Not accounting for GST - Australian businesses registered for GST must manage quarterly BAS payments, typically due on the 28th day after each quarter ends. Failing to account for these in your forecast creates nasty cash gaps.
Skipping scenario planning - once you have a base forecast, run a best-case and worst-case version. What happens if a major client delays payment? What if sales exceed projections? Stress-testing your forecast builds genuine financial resilience.
Cash flow problems rarely announce themselves loudly - they tend to creep up like feedback building in a speaker before the whole thing blows. Here are the early and critical warning signs to monitor:
Early warning signs:
Critical warning signs:
Research cited by Procfo Partners (2026) found that 82% of business failures stem from poor cash flow management - a statistic that reinforces just how important it is to stay on top of this, regardless of how profitable the business appears on paper.
One of the most important things any business owner can internalise is this: a profitable business can still run out of cash. If your income arrives in large lumps but your expenses are constant and weekly, you can be making money on paper while struggling to keep the lights on in reality.
Timing is everything. A cash flow forecast forces you to think about money in terms of when it actually moves - not when sales are recorded, not when invoices are raised, but when cash physically changes hands. That shift in thinking is what separates businesses that thrive from those that quietly grind to a halt.
For creative professionals and businesses in Penrith and across Sydney, where project-based income often ebbs and flows dramatically, this discipline is not a nice-to-have. It is foundational.
Keep your forecast updated monthly. Compare your actuals to your estimates. Look for patterns. Adjust. Rinse and repeat. A cash flow forecast that's regularly maintained and honestly assessed is one of the most powerful tools a small business owner has - and it doesn't require expensive software or an accountant to do the basics yourself.
Ready to crank your finances up to 11? Let's chat about how we can amplify your profits and simplify your paperwork - contact Amplify 11 today.
For most Australian small businesses, a 12-month rolling monthly forecast offers the best balance between accuracy and forward planning. Short-term forecasts covering 13 weeks on a weekly basis are also valuable for tight immediate cash management.
A profit and loss statement records revenue and expenses regardless of when cash changes hands, whereas a cash flow forecast focuses on the timing of actual cash movements into and out of your bank accounts. This distinction means a business can be profitable on paper while still facing cash shortages.
Cash outflows should include all planned payments such as rent, salaries, utilities, supplier invoices, loan repayments, equipment purchases, and irregular costs like ATO PAYG instalments, GST obligations via BAS, superannuation contributions, annual software subscriptions, insurance renewals, and professional memberships.
It’s recommended to update your cash flow forecast at least once a month. Regular updates allow you to remove completed periods, add new ones, and compare forecasted figures against actual cash movements to improve accuracy over time.
No, you don't necessarily need accounting software. A basic spreadsheet in Microsoft Excel or Google Sheets is sufficient to create a functional cash flow forecast. However, as your business grows, specialized accounting platforms and forecasting tools can help automate and integrate your data for more complex needs.
Sign up to receive relevant advice for your business.
