Cash flow forecasting without the spreadsheet nightmare

What a cash flow forecast actually does

Your profit and loss tells you what you earned. Your bank balance tells you what you've actually got. A cash flow forecast bridges the two, showing where your balance is likely to sit in four, eight or twelve weeks if things unfold the way you expect. That number decides whether you can hire someone, whether the BAS gets paid without drama, and whether a quiet month turns into a crisis or barely registers.

It isn't a prediction so much as an early warning system. See the balance dip below zero in week nine and you've got nine weeks to chase debtors, push back a purchase or ring the bank. Skip the forecast and you find out in week nine anyway, with none of those options left.

Why 13 weeks is the sweet spot

Thirteen weeks covers a full quarter: one BAS cycle, one round of quarterly super, and enough of a business's seasonal rhythm to mean something. Go longer and the estimates turn into guesswork; annual forecasts have a place for planning but go stale within weeks. A rolling 13 week view, where you drop last week and tack a new one on the end, never goes out of date because it never stops being rebuilt.

How to build one in about an hour

The structure is genuinely simple: one row for opening bank balance, a set of rows for cash in, a set for cash out, and a closing balance that rolls into the next week. That's it. Work through it in this order.

• Start with today's actual bank balance, across every trading account you use.
• List cash in week by week: invoices already issued, timed by when customers usually pay rather than the due date, plus recurring revenue and a realistic guess at new sales.
• List cash out week by week: wages and super, rent, loan repayments, supplier bills already sitting in your accounting file, and any known one off costs.
• Add tax as its own line: BAS, PAYG withholding if it's paid separately, income tax instalments. These are the payments that blindside owners most often.
• Work out the closing balance each week and carry it forward as next week's opening balance.

If your books are current in Xero or similar, most of this already exists as unpaid invoices and bills sitting in the system. Building the forecast is mostly a matter of resorting information you already have, by date instead of by account.

A worked example

Here's a simplified four week extract for an example services business starting with $42,000 in the bank. Every figure below is illustrative only.

Look at week 3. The balance more than halves because a pay run and the BAS land in the same week while collections are light. There's nothing wrong with this business, but an owner who can see it coming has options: pull an invoice follow up forward, push a supplier payment back a few days. An owner who only watches the balance fall has neither.

Keeping it alive in ten minutes a week

Pick a fixed time, Monday morning works for most people, and run through three things: update the opening balance to what actually happened, check last week's forecast against reality, and roll the whole thing forward a week. That middle step is where the learning happens. If receipts keep landing under forecast, that's telling you something about your debtors, not just your spreadsheet.

Resist the urge to add more detail. A forecast with eight cash out categories that actually gets updated every week beats a forty line masterpiece abandoned by month two. The goal isn't precision, it's an early warning.

Where NextEra fits in

We reconcile client files weekly, which means the inputs for a reliable forecast are already sitting in the books we manage, and our management reporting includes a rolling cash flow view alongside the usual profit reporting. Want a clear read on where your cash position is headed and what's actually driving it? The Strategic Finance Review is a sensible place to start.