CFOSurge Australia/Owner questions/Cash flow

How do I build a 13-week cash flow forecast? One you'll actually use.

6 steps to get there, and a 3-minute check to find where you start.

The problem

You can't see which week cash will run short, so big bills keep arriving as surprises.

The way out

List what's certain first, then how customers really pay, then your own choices, week by week. Keep it current with 20 minutes every Friday.

The way out, step by step

Six stops on the road to a forecast you can trust

Hover over a step to light it up, click to open it.Tap a step to open it. 0 of 6 explored

★Clear road for the next 13 weeks
Driving without headlights: no view of the weeks ahead

Not sure which step you’re on?

Take the 3-minute check. Your result lights up your step above.

The full guide

Everything behind your answer, in detail

Read only the sections you need. Each one stands on its own.

Prepared by the CFOSurge Australia team

The answer in brief

A 13-week cash flow forecast lists every expected receipt and payment by week for the next quarter and shows the closing bank balance each week. Build it in order of certainty: fixed commitments first (wages, super, rent, loans, tax), then patterns (when each customer actually pays, when suppliers are paid), then decisions (drawings, equipment, hires). The number that matters is the lowest closing balance and the week it happens. Roll the forecast forward every week and compare it with what actually happened. That comparison is what makes it accurate.

On this page
  1. Six questions first
  2. Forecast vs budget
  3. The usual advice
  4. Commitments, patterns, decisions
  5. Build it step by step
  6. The 20-minute weekly update
  7. Six businesses
  8. When a week goes negative
  9. Mistakes that break forecasts
  10. What the forecast tells you
  11. Official sources
  12. Key terms
  13. Questions owners also ask
Stage 1 · Notice

Answer six questions before you read on

Commit to an answer for each before you reveal it.

1In the next three months, which week will your bank balance be at its lowest?

If you can't name the week, you're steering by the rear-view mirror. Every serious cash problem is visible weeks ahead to anyone who looks at dates rather than totals.

2Your budget shows a profit this quarter. Does it tell you whether you can pay wages in week 7?

No. A budget measures profit over a period. A cash forecast measures money on specific dates. A profitable quarter can still contain a week you can't pay staff.

3Why 13 weeks rather than 12 months?

Thirteen weeks is one quarter. It covers a full BAS cycle, every pay run and most large bills, and it's short enough to forecast by date with real accuracy. It's also long enough to act: arranging finance or renegotiating terms takes weeks, not days.

4Last month, how close was your guess of the month-end bank balance?

If you don't know, you can't trust any forecast yet. Comparing forecast with actual every week is what turns a guess into a tool.

5Who decides when your customers pay: their invoice due date, or the customers themselves?

The customers. Forecast receipts by when each customer actually pays, based on their history, not by the due date printed on the invoice.

6If your largest customer paid two weeks late, what would happen to your balance in week 5?

A useful forecast answers "what if" in a few minutes. If yours can't, it's a record of hopes rather than a decision tool.

A forecast isn't a prediction you hope comes true. It's an early-warning system you update until it's right.

Stage 2 · Understand

What a cash flow forecast is, and what it isn't

ToolMeasuresHorizonAnswers
BudgetProfit, by monthA yearWill this year be worth it?
Statement of cash flowsWhere cash went, after the factPast periodWhy did the balance change?
13-week cash flow forecastBank balance, by weekNext quarterCan we pay everything on time, and when is the tightest week?
12-month cash forecastBank balance, by monthNext yearCan we afford the plan, and how much funding do we need?

The 13-week forecast uses the direct method: it lists actual receipts and payments rather than starting from profit. It contains no depreciation, no accruals and no provisions, only money moving in and out of the bank on a date.

Stage 3 · Question the usual advice

The usual advice, and why most forecasts get abandoned

  • Download a template and fill in your monthly figures.
  • Use averages: monthly sales divided by four for each week.
  • Let your software forecast from invoice and bill due dates.
  • Update it when you can.
Why this fails: averages smooth away exactly the weeks that hurt, when payroll, BAS, rent and a loan repayment land together. Due dates assume customers pay on time, which many don't. And a forecast nobody checks against reality never earns trust, so it gets abandoned after a month.
Stage 4 · Rebuild

A forecast is a list of promises, habits and choices

Strip a forecast back and every line is one of three things. Building it in this order makes it both faster and more accurate:

1 · Commitments

Known date, known amount

Wages, super, PAYG withheld, BAS, rent, loan repayments, insurance, subscriptions, tax instalments. These are nearly certain. Enter them first.

2 · Patterns

Repeated, but variable

Customer receipts and supplier payments. Forecast them from behaviour: when each customer has actually paid in the past, not when the invoice says.

3 · Decisions

Things you choose

Owner drawings, dividends, equipment, hires, marketing pushes. Enter these last, because they're your levers. If a week goes negative, these are the first lines you move.

Two numbers then matter more than any total: the low point (the lowest weekly closing balance) and the floor (the minimum balance you're willing to hold, usually one pay run plus a buffer). Your job each week is to keep the low point above the floor.

Find your cash low pointExample figures · replace with yours
Stage 5 · Build

Build it step by step

  1. Opening balance.

    The actual balance of every business bank account today. Don't use the accounting software's figure if it isn't reconciled.

  2. Commitments calendar.

    Put every fixed payment in its week: each pay run, super payments, PAYG withheld, BAS, rent, loan and lease repayments, insurance, income tax instalments, software and subscriptions. Check last year's bank statements for annual bills you might forget.

  3. Receipts by customer.

    List what each customer owes and the week you expect payment, based on how many days late they usually pay. Add expected new sales and the delay before each is collected. Group small customers into one line.

  4. Supplier payments.

    Bills already received, by the week you'll actually pay them, plus purchases you expect to make for the sales in step 3.

  5. Decisions.

    Drawings or dividends, equipment, hires, marketing. Keep each on its own line so you can move it.

  6. Closing balance each week.

    Opening + receipts − payments. Mark the floor, and highlight any week below it.

  7. Two scenarios.

    Your largest customer pays two weeks late. Sales come in 15% below plan. If either pushes the low point below the floor, plan for it now.

Keep it to about 20–30 lines. More detail adds effort, not accuracy.

Stage 6 · Verify

The 20-minute weekly update that makes it accurate

  1. Replace last week's forecast with actuals.

    Enter the real receipts, payments and bank balance.

  2. Explain the biggest variance.

    Which line was furthest off, and why? A customer paying later than usual, a bill you forgot, a sale that slipped.

  3. Fix the pattern, not just the number.

    If a customer is consistently late, move all their future receipts. If a bill was missed, add it to the commitments calendar.

  4. Add a new week 13.

    The forecast always looks a full quarter ahead.

  5. Check the low point and the floor.

    If the low point has moved below the floor, decide this week what to do about it.

Within a couple of months, aim for your four-weeks-out balance to land within about 5–10% of what actually happens. If it doesn't, the variance notes will show you which pattern is wrong.

Stage 7 · Compare

What the forecast reveals in six different businesses

Every business has its own tight weeks. Pick the closest to yours to see what its forecast showed and what it did about it.

These are composite businesses with illustrative figures, built to show how the method works. They are not CFOSurge client results.

Hover over a business for a preview (tap on a phone), then click to open the full case.

Stage 8 · Act

Your forecast shows a negative week. What now?

Work through these levers from fastest and cheapest to slowest and most expensive. Note how many weeks you have before the low point; that decides which levers are still open.

LeverHow fastCostHow
Bring receipts forwardDaysLowInvoice unbilled work now, call the largest overdue customers, ask for deposits on new work
Move decisionsImmediateNoneDelay drawings, dividends, equipment and non-essential spending past the low point
Reschedule supplier paymentsDaysGoodwillAgree a short delay in advance; never just pay late
Tax payment plan1–2 weeksInterestContact the ATO before the due date if a BAS or tax payment can't be met. Never delay super
Short-term facility2–6 weeksInterest and feesApply while the forecast still shows the gap, not after it arrives
Owner fundsDaysYour riskRecord any money you put in as a loan to the business

If the same week goes negative every quarter, the forecast isn't the problem. The cause is structural; see profitable but no cash.

Stage 9 · Avoid

Seven mistakes that break forecasts

7 mistakes
  • Forecasting receipts from invoice due dates. Use each customer's actual payment behaviour.
  • Leaving out GST, PAYG withheld and super. They're some of the largest payments of the quarter.
  • Including non-cash items. Depreciation and accruals don't belong in a cash forecast.
  • Forgetting owner drawings. They're cash out like any other payment.
  • Never comparing with actuals. The forecast never gets better, and nobody trusts it.
  • Too much detail. Hundreds of lines take hours to update and don't make it more accurate.
  • Only one person understands it. Keep it simple enough that someone else could update it.
Stage 10 · Decide

What the forecast tells you to do

Summary table
What you seeWhat it meansWhat to do
Low point above the floor every weekHealthyKeep updating weekly; consider whether surplus cash should pay down debt
One week below the floorA timing clashMove a decision or bring receipts forward for that week
Several weeks below the floorA real shortfallAct on the levers now and arrange funding while you have time
The balance falls steadily every weekA structural problemCheck margin and owner pay; a forecast can't fix a business that uses more cash than it makes
Big variances every weekThe patterns are wrongRebuild receipts by customer from actual payment history
Reference

Official sources and guidance

Rules, rates and thresholds change. Check the current position at these official sources before acting.

Reference

Key terms in plain English

12 terms
Cash flow forecast
A schedule of expected receipts and payments by date, showing the bank balance in each period.
13-week cash flow forecast
A rolling cash forecast by week covering the next quarter.
Rolling forecast
A forecast that drops the week just finished and adds a new week at the end, so it always looks the same distance ahead.
Direct method
Forecasting actual receipts and payments, rather than starting from profit and adjusting it.
Opening balance
The actual bank balance at the start of the forecast.
Closing balance
Opening balance plus receipts less payments for the week.
Low point
The lowest weekly closing balance in the forecast, and the week it happens.
Floor
The minimum balance you're prepared to hold, usually one pay run plus a buffer.
Variance
The difference between what you forecast and what actually happened.
Scenario
A version of the forecast with one assumption changed, such as a customer paying late.
Commitments
Payments with a known date and amount, such as wages, rent, loans and tax.
Collection pattern
How long each customer actually takes to pay, used to forecast receipts.
Reference

Questions owners also ask

What is a 13-week cash flow forecast?

A week-by-week schedule of expected receipts and payments for the next quarter, showing the closing bank balance each week. It's rolled forward weekly so it always looks 13 weeks ahead.

Why 13 weeks?

Thirteen weeks is one quarter, so it covers a full BAS cycle and every pay run. It's short enough to forecast accurately by date and long enough to act, for example to arrange finance.

What should a cash flow forecast include?

Opening bank balance; customer receipts by expected payment week; payments to suppliers; wages, super and PAYG withheld; GST and income tax payments; rent, loans and leases; insurance and subscriptions; owner drawings or dividends; and planned equipment or hires.

What is the difference between a budget and a cash flow forecast?

A budget measures expected profit over a period, usually by month. A cash flow forecast measures expected money in the bank on specific dates. A business can meet its budget and still run short of cash in a particular week.

How accurate should a cash flow forecast be?

After a couple of months of weekly updates, aim for the balance four weeks out to land within about 5–10% of what actually happens. The variance notes tell you which assumption to fix.

Should I use my accounting software's forecast?

It's a useful starting point for bills and invoices already entered, but it usually uses due dates and misses payments not yet in the system, such as tax, drawings and future purchases. Check and adjust it by hand.

How do I forecast customer receipts?

List what each customer owes and use their actual payment history to set the expected week. Add new sales with a typical collection delay. Group small customers together.

Do I include GST in a cash flow forecast?

Yes. Receipts and payments include GST, and the BAS payment goes in as its own line in the week it's due.

Do I include depreciation?

No. Depreciation isn't a cash payment. Include the actual payments for equipment or loan repayments instead.

What do I do if the forecast shows a shortfall?

Bring receipts forward, move discretionary spending, agree supplier delays in advance, contact the ATO early if a tax payment can't be met, and arrange a facility while you still have time.

How long does it take to keep updated?

About 20 minutes a week once it's built: enter last week's actuals, explain the biggest variance, fix the pattern, and add a new week.

Keep going

Related owner questions

Want a second pair of eyes on this?

If you'd like the forecast built from your own records, or want help with what it shows, CFOSurge's Australian CFO team can work through it with you, using your actual numbers.

Talk to CFOSurge Australia

CFOSurge Australia · General information only. It isn't financial, tax or legal advice for your circumstances. Worked examples use illustrative figures.