Cash Flow Forecasting for Small Business: A Practical Guide

A Sydney construction business won a $2.1 million government contract — the largest in its history. Three months into the project, with retention clauses delaying client payments, the business could not cover its subcontractor invoices. The contract was profitable. The business nearly failed anyway. No one had modelled what the payment timing would do to the cash position week by week.

Cash flow forecasting is not accounting. It is not about recording what happened. It is about knowing — with enough lead time to act — what is going to happen to your cash position over the coming weeks and months.

The 13-Week Rolling Forecast: The Standard That Works

The 13-week rolling cash flow forecast is the most widely used business finance tool for a reason: close enough to be accurate, far enough out to be actionable. Longer forecasts — six or twelve months — involve too much uncertainty to be precise. Shorter forecasts do not give you enough time to respond to what they reveal.

For each of 13 weeks, track five figures:

• Opening cash balance — what you have at the start of the week
• Receipts — cash you expect to receive and when
• Payments — cash you expect to pay out and when it falls due
• Net cash movement — receipts minus payments
• Closing cash balance — which becomes next week's opening balance

The result is a week-by-week picture of your cash position for the next quarter — including any weeks where the balance turns negative. A negative balance in week eight is not a problem that arrives in week eight. It is a problem you can solve today, while you still have seven weeks of options.

The Most Common Forecasting Error: Invoice Date vs Cash Receipt Date

The single most common mistake is recording receipts on invoice date rather than expected collection date. If you raise an invoice on 1 April with 30-day terms, the cash arrives in late April or early May — not on 1 April. Building your forecast on invoice dates rather than actual collection dates produces a forecast that is systematically optimistic by 30 to 60 days.

For each expected receipt, model the actual payment date based on the invoice terms, the client's historical payment behaviour, and any known constraints — month-end payment runs, approval cycles, seasonal patterns. This single adjustment transforms a theoretical forecast into a realistic one.

What to Include on the Payments Side

Fixed payments — rent, loan repayments, payroll, regular subscriptions — are straightforward to schedule. Variable payments require more attention. Items SME owners frequently underestimate or omit:

• Tax payments — GST, VAT, PAYE, corporate income tax — often quarterly or annual and individually significant
• Supplier payment terms shorter than your client payment terms — the most common source of structural cash squeeze
• Seasonal payroll — additional staff for peak periods
• Professional fees — accountant, legal, compliance — which tend to cluster in specific months
• Insurance renewals and equipment maintenance, easy to forget in weekly planning

How to Use the Forecast Once Built

When your forecast reveals a projected negative balance in week seven, that is not a problem arriving in week seven — it is a problem you can solve today. Options typically include:

• Accelerate collections — prioritise chasing overdue invoices; offer early payment discounts to key clients
• Negotiate extended supplier terms — many suppliers extend terms for a good customer who asks early rather than under pressure
• Draw on credit facilities — overdraft, revolving credit, or invoice financing arranged in advance
• Defer discretionary spending — push non-urgent purchases into a period with a stronger cash position

The earlier you identify the problem, the more options you have and the lower the cost of each option. A cash shortfall identified six weeks out is a planning problem. The same shortfall identified on payroll day is a crisis.

The Weekly Review Habit

A forecast built once and never updated becomes irrelevant within two weeks. The minimum viable maintenance habit is a weekly review — 20 to 30 minutes to update actual receipts and payments, roll the forecast forward by one week, and note any significant changes to the projected closing balance.

Over time, the gap between your forecast and actual results tells you something important — specifically, which clients and which cost categories you are systematically wrong about. That knowledge makes every subsequent forecast more accurate and every business decision more grounded. AI tools like Clarivian can connect to your accounting software and surface early cash warnings in your morning brief, so the monitoring happens automatically rather than requiring you to remember to look.

Disclaimer: This article is for informational purposes only and does not constitute legal, financial, or regulatory advice. Programme details, eligibility, and funding amounts change frequently. Always verify on official government websites or with a qualified advisor before acting.

Clarivian monitors market signals, regulatory changes, and business opportunities overnight, delivering a personalised brief to SME owners every morning at 07:00.