How to Create a Cash Flow Forecast for Your Geelong Small Business

Why a cash flow forecast matters more than your P&L

Plenty of profitable Geelong small businesses have gone under simply because the cash wasn't in the bank when it needed to be. Your profit and loss statement tells you whether the business model works. Your cash flow forecast tells you whether you can actually pay wages, suppliers and the ATO on the days those payments fall due.

The gap between the two comes down to timing. You might invoice a client in Newtown for $8,000 in March but not get paid until May. Meanwhile your BAS, super guarantee and rent don't wait for that invoice to clear. A forecast closes that visibility gap and gives you weeks — not days — of warning before a shortfall hits.

What you need before you start

You don't need fancy software to build your first forecast — you need accurate, current data. Pull together:

• Your current bank balance across all business accounts, as of today.
• Outstanding invoices (accounts receivable) with realistic expected payment dates, not just due dates.
• Outstanding bills (accounts payable) and their due dates.
• Recurring fixed costs — rent, loan repayments, subscriptions, insurance.
• Payroll obligations, including PAYG withholding and superannuation guarantee contributions.
• Upcoming BAS and income tax instalments from your ATO lodgement schedule.

If your books are up to date in Xero, most of this is a few clicks away. If they're not, this is the moment to reconcile — a forecast built on stale data is worse than no forecast at all.

Building your 13-week forecast, step by step

A 13-week rolling forecast is the industry standard because it covers a full quarter — long enough to spot trends, short enough to stay accurate. Here's the structure:

• Step 1 — Opening balance: Start with your actual bank balance in week one.
• Step 2 — Cash in: List expected customer payments week by week, based on when clients actually pay (not invoice terms).
• Step 3 — Cash out: List every outgoing — suppliers, wages, rent, loan repayments, ATO obligations — in the week you expect to pay them.
• Step 4 — Net movement: Cash in minus cash out for each week.
• Step 5 — Closing balance: Opening balance plus net movement, which becomes next week's opening balance.

Roll it forward every week, replacing projections with actuals as they land. Within a month you'll have a forecast that's genuinely predictive, not just a guess.

Accounting for Geelong's seasonal cash flow patterns

Generic forecasting templates often miss local seasonality, and that's where a lot of Geelong businesses get caught out. Consider:

• Hospitality and tourism around the Bellarine Peninsula and Great Ocean Road corridor typically sees a summer surge and a noticeably quieter autumn/winter — cash reserves built in January need to stretch through June.
• Trades and construction often slow down over the wet winter months, with fewer billable days but the same fixed overheads.
• Retail around Pakington Street and the CBD sees predictable spikes around end-of-financial-year sales and the pre-Christmas period.

Map your own historical bank statements against these patterns — even 12 months of Xero data will show you the quiet stretches you need to forecast around, rather than being surprised by them every year.

Don't forget GST, PAYG and super in your projections

The single biggest cash flow mistake we see is businesses treating GST collected as available cash. It isn't — you're holding it on trust for the ATO under the A New Tax System (Goods and Services Tax) Act 1999. Build these obligations into your forecast as dedicated line items:

• GST: Set aside the net GST liability from each sale as it happens, ideally into a separate savings account.
• PAYG withholding: Factor in withholding amounts from every pay run, due with your BAS.
• Superannuation guarantee: Under the Superannuation Guarantee (Administration) Act 1992, SG contributions are due quarterly by the 28th day following the end of each quarter. Missing this deadline means the shortfall becomes non-deductible and attracts the Superannuation Guarantee Charge — a cash flow hit that's entirely avoidable with forward planning.
• Income tax instalments: If you're on quarterly PAYG instalments, these need their own forecast line rather than being absorbed into "general expenses."

Under the Tax Agent Services Act 2009 (TASA 2009), a Registered BAS Agent can help you calculate and time these obligations accurately — which is exactly the kind of forward planning that keeps a forecast honest rather than optimistic.

Tools: from a simple spreadsheet to Xero-integrated forecasting

You have three realistic options, depending on the complexity of your business:

• Spreadsheet: A well-built Excel or Google Sheets template is perfectly adequate for sole traders and micro businesses. It's manual, but it forces you to understand every line.
• Xero's short-term cash flow tool: Built into Xero, it projects roughly 30 days forward using your outstanding invoices, bills and repeating transactions. It's a solid daily check-in tool but not a full quarterly forecast.
• Dedicated forecasting apps: Tools like Float or Fathom integrate directly with Xero and automate the rolling 13-week forecast, updating actuals from your bank feed automatically. Worth the subscription once you're managing payroll and multiple contracts.

Whichever you choose, the forecast is only as good as the Xero data feeding it — accurate bank reconciliation and up-to-date invoicing are non-negotiable.

Keeping your forecast accurate week after week

A forecast built once and forgotten is worthless within a fortnight. Build a habit:

• Set a fixed weekly time (Monday morning works well) to reconcile actuals against last week's projections.
• Investigate variances — if a client paid late, adjust future assumptions for that client rather than hoping it won't happen again.
• Extend the forecast by one week each time you review it, so you always have a 13-week runway.
• Flag any week where the projected closing balance drops below your minimum buffer — that's your trigger to chase invoices, delay non-essential spend, or arrange finance ahead of time.

Getting your cash flow forecast right isn't a one-off project — it's a habit that pays for itself the first time it warns you about a shortfall three weeks before it happens instead of three days. Start with a simple 13-week spreadsheet built from your current Xero data, add in every GST, PAYG and super obligation, and review it every Monday. If your books need tidying up before any forecast will be reliable, that's the first step worth taking — and it's exactly where we can help.