Cash Flow Forecasting for Small Business — A Practical Guide

Cash Flow Kills Profitable Businesses

It is entirely possible to be profitable on paper and unable to make payroll. This is not an edge case — it is one of the most common ways Australian small businesses get into trouble. A P&L shows whether you made profit last month. It doesn't show whether you can pay your ATO bill, your supplier invoices, and your staff wages in the next three weeks.

Cash flow management is about timing. The gap between when you earn money and when you receive it is where businesses fail. Forecasting that gap — seeing it before it arrives — is what gives you options.

Why Cash Flow Forecasting Matters More Than P&L for Day-to-Day Survival

Your P&L is a historical document. It tells you what happened. A cash flow forecast is a forward-looking tool. It tells you what's coming.

The practical difference: if you see a cash gap coming in three weeks, you have four or five responses available. You can chase debtors, draw down on a credit line, defer a non-critical payment, raise invoices early, or call your key supplier to negotiate terms. If you see the gap on the day your account goes below zero, you have one response — and it's reactive and expensive.

Profitable businesses can run out of cash when large receivable payments are delayed, when quarterly BAS obligations fall in a slow revenue week, or when a big project requires upfront materials spend that won't be recovered for 60 days. The forecast shows these collisions before they happen.

The 13-Week Rolling Forecast

The 13-week rolling forecast is a standard tool in corporate treasury — used by large businesses to manage short-term liquidity. It works equally well for small business because the structure is simple:

• Starting balance: Current bank account balance
• Week-by-week receipts: Forecast cash coming in — from outstanding invoices (by expected payment date), and future invoices you'll raise based on work in progress or scheduled jobs
• Week-by-week payments: Forecast cash going out — wages (by pay date), supplier payments (by due date), rent, loan repayments, BAS, super, insurance premiums
• Closing balance: Starting balance plus receipts minus payments. This rolls forward as the opening balance for the next week.

The forecast rolls forward each week — drop the completed week, add a new week at the end so you always have 13 weeks of visibility. Updating it takes 20–30 minutes per week once the structure is built.

How to Build the Forecast

Start with a spreadsheet — 14 columns (weeks 1–13 plus a row description column) and rows for each receipt category and payment category. The key inputs:

• Receipts: Pull your aged receivables from Xero. Group invoices by expected payment date (not invoice date). Add a row for forecast new invoices based on your pipeline or recurring revenue.
• Payments: List every fixed recurring payment — rent, wages, super, loan repayments, insurance. For variable payments (materials, subcontractors), use recent averages as the baseline and adjust when you have confirmed orders.
• BAS and tax: These are often the biggest single payment in a quarter. They must be in the forecast explicitly, at the actual lodgement and payment date — not smoothed across the quarter.

Once built, the model is mostly about updating: moving actual receipts from forecast to actual, revising payment timing as it changes, and adding new invoices as they're raised.

Cash Flow Patterns by Business Type

Different businesses have different structural cash flow patterns that should be reflected in the forecast:

• Seasonal businesses (trades, landscaping, hospitality): Strong summer, slow winter, or the reverse. Plan to build cash reserves during peak periods rather than depleting them immediately. Arrange credit facilities during strong periods — lenders are more willing when revenue is high.
• Project-based businesses (construction, consulting, fit-out): Large upfront material or subcontractor costs followed by delayed progress claims or retentions. The forecast needs to explicitly model the timing of progress payments and final payments, not just total project revenue.
• Subscription or recurring revenue businesses: More predictable receipt patterns, but payments can still cluster. Quarterly BAS, annual insurance renewals, and annual software licence renewals can all land in the same week without planning.

What to Do When You See a Gap Coming

The forecast is only useful if you act on it. When the closing balance shows negative in week six:

• Accelerate invoicing: Are there jobs or services ready to invoice that haven't been raised yet? Raise them now.
• Chase debtors early: Identify the largest outstanding invoices and make personal contact before the standard reminder process. A phone call recovers money faster than an automated email.
• Draw down before you need to: If you have a business line of credit, draw it down while the account is healthy — banks look at your balance when they process credit requests.
• Defer non-critical payments: Talk to suppliers before invoices are due, not after. Most suppliers will extend terms without penalty if asked in advance.
• ATO payment arrangements: If a BAS payment will cause a gap, the ATO has formal payment arrangement options. Apply before the due date, not after — the ATO treats late payers and those who arrange early very differently.

Xero's Cash Flow Tools — Useful But Limited

Xero has two built-in cash flow features worth knowing:

• Short-term cash flow: Under the Business Overview tab, this shows a 30-day projection based on outstanding invoices and bills. Useful for a quick check, but it only captures transactions already in Xero — it doesn't model future invoices you haven't raised or recurring payments not in the system.
• Cash Flow Statement: Historical cash flow by category — operating, investing, financing. Useful for understanding where cash came from and went, but backward-looking.

For more sophisticated forecasting, Float and Dryrun both integrate directly with Xero, pull live data, and allow scenario modelling. Float is particularly popular with Australian businesses at the $500k–$5M revenue range. Both have monthly subscription costs that are minor relative to the decision-making value they provide.

When a Bookkeeper Should Own the Forecast

Building and maintaining a 13-week forecast takes discipline. For most business owners, the right model is to have your bookkeeper or CFO build and update it, and to review it with them weekly or fortnightly. The review meeting should answer three questions: where is cash tight in the next 13 weeks, what's the response, and what's changed since last week?

A bookkeeper who manages your forecast is fundamentally different from one who just reconciles transactions. The forecast is one of the core outputs of a CFO-as-a-Service engagement — because it's the tool that keeps solvent businesses solvent.