Insights

How to Read a Cash Flow Forecast

A plain-English, six-step guide for business owners, using a 13-week forecast.

By TheCFO Team | 2026-11-21 | Insights

You do not need to read every cell of a cash flow forecast. Check that it starts from the right number, find the week that matters, test the assumptions that usually go wrong, and leave with a decision. This guide walks through that review in six steps for a 13-week forecast. To build one, start with the 13-week cash flow forecast page.

Step 1: check the starting point

Before reading anything else, compare the week 1 opening balance with your bank accounts today. They should match, across every business account, to the dollar or close to it.

If they do not match, stop. Either the bank accounts are not reconciled, an account is missing, or the forecast is out of date. Every later week inherits the error.

Also check the date. A forecast not rolled forward for three weeks describes a period that has partly happened.

Step 2: find the lowest headroom week

Read along the closing balance row and find the lowest point. Then compare it with:

  • your minimum buffer, the balance you have decided never to go below, and
  • your overdraft limit, if you have one.

The week that matters is the one with the least headroom, not week 13. A forecast can end the quarter well above the buffer and still dip below it in week 6.

Step 3: trace what drives that week

Read down the column for the lowest week. Usually two or three items explain it, for example a quarterly BAS payment, a pay run and a large supplier bill landing together. Quarterly BAS is due on 28 October, 28 February, 28 April and 28 July, so check whether one of those dates falls in or near your low week.

Step 4: test the receipts

Receipts are where forecasts most often go wrong, because they assume customers pay on time. Ask:

  • Timing: is each major customer forecast on its actual payment pattern from the aged receivables, or on invoice terms?
  • Concentration: what happens to the low week if your largest customer pays two weeks late? If that alone pushes you below the buffer, you have a concentration risk.
  • Confidence: how much of weeks 1 to 6 relies on sales not yet invoiced? A high share means the near-term forecast is softer than it looks.

Step 5: check the payments you cannot move

These are predictable, so errors here usually mean a row is missing:

  • Every pay run is shown, with super beside it. From 1 July 2026, under Payday Super, each super contribution must reach the employee's fund within 7 business days of payday.
  • PAYG withholding is on the right cycle: quarterly with the BAS for small withholders, or monthly by the 21st of the next month for medium withholders.
  • GST is included in receipts and payments, with the net BAS payment shown in the week you actually pay it.
  • Annual and quarterly costs, such as insurance, registrations and software renewals, are in their real weeks.

Step 6: compare forecast with actual

A good forecast keeps last period's forecast beside the actual result. Look for patterns, not one-off misses:

  • The same customer is late again and again: move their receipts to their real pattern.
  • Payments keep running higher than forecast: a cost row is missing or understated.
  • The gap is shrinking: the forecast is becoming reliable enough for bigger decisions.

Turning the reading into decisions

Every review should end with an action for any week that is below the buffer. The common levers, in rough order of ease:

  1. Collect specific overdue invoices, starting with the largest.
  2. Agree a later date for a large supplier payment, before it is due rather than after.
  3. Move a discretionary purchase or owner drawing to a week with more headroom.
  4. Stage a stock order into two smaller orders.
  5. Talk to your bank early about a temporary facility, with the forecast in hand.

Example case (invented figures): a forecast opens at $210,000, matching the bank. The lowest week is week 9, at $70,000 against a buffer of $100,000. Down the column: a $55,000 BAS payment, a $90,000 pay run with super, a $50,000 supplier bill and a $40,000 equipment payment. The largest customer's $60,000 receipt is forecast in week 8, but that customer has paid about 12 days late on its last three invoices. Moving the receipt to its real week, week 10, drops week 9 to $10,000. The owner defers the equipment payment to week 11, which lifts week 9 to $50,000, and agrees with the supplier to pay the $50,000 bill a fortnight later. Week 9 now closes at $100,000, right on the buffer, and the owner calls the customer about the invoice today.

Three questions for whoever built it

  • What are the three assumptions this forecast is most sensitive to?
  • What would have to happen for us to go below the buffer, and how likely is it?
  • Who updates it each week, and when?

If you want someone to build, update and review a forecast with you, see TheCFO's cash flow forecasting service. The free 13-week cash flow forecast template follows the same layout as this guide.

What to do next

  1. Check your numbers with the free online Diagnostics.
  2. Work through the free finance health checklist.
  3. Book a free 30-minute call: https://calendly.com/hello-thecfo-ipwt/30min

Related reading

Frequently asked questions

What is the first thing to check in a cash flow forecast?

That the week 1 opening balance matches your bank accounts today. If it does not, every later week is wrong by the same amount or more.

Which week matters most?

The week with the lowest headroom, meaning the closing balance minus your minimum buffer. It is often not the last week of the forecast.

Why do cash flow forecasts go wrong?

Most often because receipts assume customers pay on their terms rather than on their actual pattern, or because a payment row such as super, PAYG or an annual cost is missing.

How often should I review my forecast?

Weekly for a 13-week forecast. Roll it forward, compare forecast with actual, find the lowest headroom week and agree an action for it.

Sources

TheCFO Team

Your next step

Start with the free online diagnostics, or book a free 30-minute call with TheCFO Team.

Book a free 30-minute callTry the free diagnostics