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

Why Melbourne Businesses Need a Forecast

Melbourne's small business scene runs on tight margins — CBD rent, inner-suburb lease increases, and seasonal foot traffic swings in areas like Fitzroy, Richmond and the Docklands all put pressure on cash. A profitable business on paper can still run out of money if invoices sit unpaid for 60 days while wages, rent and supplier bills keep hitting the account on schedule.

A cash flow forecast is simply a forward-looking map of money in and money out. It doesn't need to be complicated — a well-built spreadsheet or a connected Xero app will do the job for most trades, hospitality venues, allied health clinics and professional services firms across Victoria.

Cash Flow Forecast vs Profit & Loss

Business owners often confuse a healthy profit and loss statement with a healthy bank balance. Under ITAA 1997, your P&L recognises income when it's earned and expenses when they're incurred — not necessarily when cash actually changes hands. Depreciation, accrued revenue and prepaid expenses all distort the picture.

• Profit and loss — accounting-based, includes non-cash items, used for tax reporting
• Cash flow forecast — cash-based, tracks bank balance week by week, includes GST, loan repayments and super

You need both. But when it comes to keeping the doors open in a Melbourne winter slow season, cash flow is the one that matters day-to-day.

Building a 13-Week Cash Flow Forecast

A rolling 13-week forecast is the industry standard used by bookkeepers and CFOs because it balances accuracy with usefulness. Here's the process:

• Step 1 — Start with your actual bank balance as of today, pulled directly from your Xero bank feed.
• Step 2 — List confirmed cash inflows week by week: outstanding invoices with due dates, recurring client retainers, and any expected loan drawdowns.
• Step 3 — List all cash outflows: rent, wages, superannuation guarantee contributions, supplier payments, loan repayments, insurance and BAS instalments.
• Step 4 — Apply realistic payment timing, not invoice terms. If your average Melbourne client pays 12 days late, build that lag into the forecast rather than assuming 30-day terms are honoured.
• Step 5 — Calculate the running balance for each week and flag any week where the projected balance goes negative or below your buffer target.
• Step 6 — Update weekly using actuals from the previous week, rolling the forecast forward so it stays a live 13-week view rather than a static document.

Factoring in BAS, PAYG and Super Timing

The single biggest cash flow shock for Melbourne small businesses is forgetting that GST collected during the quarter isn't actually your money — it belongs to the ATO. Quarterly BAS is due on the 28th of the month following each quarter (with a further four weeks if your registered BAS agent lodges electronically), and PAYG withholding on staff wages compounds this if you haven't set funds aside.

• Superannuation guarantee payments are due 28 days after the end of each quarter under the Superannuation Guarantee (Administration) Act 1992 — missing this deadline triggers the non-deductible Super Guarantee Charge, which hits cash flow twice as hard.
• PAYG instalments based on last year's income can catch growing Melbourne businesses off guard if turnover has jumped and the instalment hasn't been varied.
• Build a separate "GST held" line in your forecast and physically move GST collected into a separate savings account each week — most Melbourne bookkeepers recommend this over trying to track it mentally.

For agent lodgement details and current due dates, the ATO's business portal at ato.gov.au is the authoritative source, and your registered BAS agent (like True Tally) can confirm your specific lodgement program dates.

Using Xero to Speed Up Forecasting

Xero's built-in short-term cash flow feature projects your bank position 7 and 30 days ahead automatically, using outstanding invoices, unpaid bills and repeating transactions already sitting in your file. It's a great early-warning tool but doesn't replace a full 13-week forecast.

• Connect your Melbourne business bank feed directly to Xero so the forecast updates from real transactions, not manual entry
• Use repeating invoice and bill templates so recurring cash movements (rent, subscriptions, retainers) flow into the forecast automatically
• Export aged receivables and payables reports weekly to refine payment timing assumptions
• Connect apps like Float or Fathom for a longer, more visual rolling forecast if you want dashboards beyond Xero's native tool

Common Mistakes Melbourne Owners Make

• Using invoice terms instead of actual payment history — if your average client pays late, your forecast should reflect that reality
• Forgetting seasonal dips — Melbourne hospitality and retail often see a January and post-Christmas cash crunch that a forecast built in November would miss without adjustment
• Not separating GST and super from operating cash — spending money that's already earmarked for the ATO is the fastest way to a cash crisis
• Building it once and never updating it — a forecast is only useful if it's a living document reviewed weekly, not a one-off spreadsheet from tax time
• Ignoring loan and lease repayment schedules — especially relevant for Melbourne businesses carrying equipment finance or a commercial lease with annual rent reviews

What to Do Next

Start small: pull your current Xero bank balance, list every confirmed inflow and outflow for the next four weeks, and build from there. Add BAS, PAYG and super due dates as fixed anchor points, then extend the forecast to a rolling 13 weeks once the habit sticks. If spreadsheets aren't your thing, a Melbourne bookkeeper who already works inside your Xero file can set this up once and keep it updated as part of your regular bookkeeping — turning a stressful guessing game into a five-minute weekly check.