ACL 509639|AFCA Member 54506|Business Finance Consultant

Cash flow forecasting

The 13-week forecast that turns a cash squeeze into a plan

A bank balance tells you where you are today. A 13-week forecast tells you which week is actually going to hurt — while there's still time to do something about it.

What a 13-week forecast actually is

It is not a budget and it is not a profit-and-loss statement. It is a weekly, cash-only ledger: what is actually expected to land in the bank account, and what is actually expected to leave it, week by week, for the next 13 weeks.

Profit and loss can look healthy while cash is tight, because it includes non-cash items and records income when it is earned, not when it is paid. A cash flow forecast strips that out and deals only in bank movements.

Start with the real opening position

Use today's actual bank balance, not a book figure. Include every account the business draws on day to day. If there is an overdraft or line of credit already in use, start from the net position, not just the transaction account.

List every expected inflow, week by week

Place each expected customer payment in the week it is realistically expected to land — based on the customer's actual payment behaviour, not the invoice terms. Add any confirmed finance drawdowns, asset sales or owner contributions in the week they are expected.

Be conservative with anything uncertain. An optimistic forecast that turns out wrong is worse than no forecast at all, because it delays the decision that should have been made weeks earlier.

List every committed outflow, week by week

Payroll and superannuation dates, GST, PAYG withholding and other BAS obligations, loan and lease repayments, rent, and the handful of suppliers the business cannot delay. These dates are usually fixed and known well in advance — the forecast just has to place them in the right week.

Build the running weekly balance

Add each week's inflows, subtract each week's outflows, and carry the closing balance into the next week's opening balance. The total at week 13 is not the point. The lowest point the balance reaches along the way — the trough — is the number that matters.

Find the critical week

Identify the specific week the forecast shows the lowest, or first goes negative. That week is the real deadline. "Sometime this quarter" is not a plan; a named week with a number attached is something that can actually be acted on.

Update it weekly, not monthly

Compare what actually happened against what the forecast predicted, then roll the model forward another week. A forecast that is three weeks stale has stopped forecasting and started recording history. The weekly update is what keeps the trough week accurate as the picture changes.

Once the gap is visible, decide early

A defined, temporary trough is a very different conversation with a lender than an unexplained cash emergency. Options usually include bringing forward collections, holding a discretionary cost, or arranging a working-capital or invoice-finance facility — and each of these works better arranged before the trough week than during it.

Useful official guidance

The Australian Government's cash-flow guide recommends keeping financial records current, forecasting cash movement and comparing the costs and risks of funding options before a shortfall arrives.

See your trough week before it arrives.

Download the 13-week template to build your own forecast, or explore working-capital finance if you've already found a defined gap.

General information only. This article does not replace accounting, tax or credit advice for your circumstances.