A 13-week cash flow forecast lists every expected receipt and payment, week by week, for the next quarter. Its job is to show the lowest bank balance coming up, and the week it arrives, early enough to act.
How the weekly rows work
Each column is one week. The rows, in order:
- Opening balance: last week's closing balance. In week 1, today's reconciled balance across all business accounts.
- Receipts: one row per major customer, then one row for all other customers and one for other income.
- Payments: one row per cost type (see below).
- Net cash flow: receipts minus payments.
- Closing balance: opening balance plus net cash flow.
- Minimum buffer: the same figure every week (see below).
- Headroom: closing balance minus buffer. Show negative headroom in red. That red cell is the point of the sheet.
Use amounts including GST, because that is what moves through the bank. The net GST owed then appears once, as the BAS payment.
What goes in receipts
- Invoices already issued. From your aged receivables, put each invoice in the week you expect the money, based on how that customer actually pays. If a customer on 30-day terms usually pays in 45, forecast 45.
- Sales not yet invoiced. Confirmed work only, on its own row, so you can see how much the forecast relies on it.
- Other receipts: a GST refund, loan drawdown or asset sale, in the week it lands.
What goes in payments
- Net wages on each payday.
- Super. From 1 July 2026, under Payday Super, each contribution must reach the employee's super fund within 7 business days of payday. Put super in the same week as the pay run, or the week after. It is no longer a quarterly lump.
- PAYG withholding. The tax you withhold from wages. Small withholders pay quarterly with the BAS. Medium withholders pay monthly, by the 21st of the following month. Your activity statement shows which cycle applies to you.
- BAS. Quarterly BAS is due on 28 October, 28 February, 28 April and 28 July. Lodging online or through a registered agent can give you more time for some quarters. Use the date you actually pay.
- Suppliers: each open bill from your aged payables, in the week you will really pay it.
- Fixed costs: rent, leases, loan repayments, insurance and software, on their debit dates.
- One-offs: equipment, owner drawings and annual renewals.
Setting a minimum cash buffer
The buffer is the lowest balance you are willing to hold. A practical way to set it:
- Add up the payments you could not delay in a bad fortnight: one full pay run with its super and PAYG, rent and loan repayments.
- Add the biggest single payment due in the quarter, often the BAS.
- Hold that total as the buffer. If revenue is seasonal or concentrated in a few customers, hold more.
An overdraft limit is not a buffer. Plan to stay above the buffer without it.
Warning signs to watch
- Headroom turns red in any week, even if the quarter ends well.
- The red week moves closer each time you roll the forecast forward.
- Uninvoiced sales make up a growing share of receipts in weeks 1 to 6.
- One customer's receipts are big enough that a two-week delay would push you below the buffer.
- Actual receipts keep falling short of the forecast for the same customers.
- A BAS week overlaps a pay run and a large supplier payment.
Example case (invented figures): a business opens week 1 with $180,000 in the bank and sets a $120,000 buffer, made up of one fortnightly pay run with super and PAYG ($85,000) plus rent and loan repayments ($35,000). Weeks 1 to 6 have headroom, but in week 7 a $60,000 BAS payment, a pay run and a $70,000 supplier payment land together and the closing balance falls to $95,000, which is $25,000 below the buffer. Six weeks out, the owner agrees with the supplier to pay half of the $70,000 a fortnight later, which lifts week 7 to $130,000, back above the buffer. The owner also chases an overdue invoice from the largest customer for extra room.
The weekly routine
Each week, replace last week's forecast with actuals, add a new week 13, find the lowest headroom and agree one action for any red week. Once set up, this takes about 30 minutes.
Start with the free 13-week cash flow forecast template, which has rows for BAS, PAYG and Payday Super. How to read a cash flow forecast covers the weekly review, and the cash flow forecasting service covers having it built from your Xero, MYOB or QuickBooks data.
What to do next
- Check your numbers with the free online Diagnostics.
- Work through the free finance health checklist.
- Book a free 30-minute call: https://calendly.com/hello-thecfo-ipwt/30min
Related reading
- Free 13-week cash flow forecast template
- Cash flow forecasting service
- How to read a cash flow forecast
Frequently asked questions
What is a 13-week cash flow forecast?
A week-by-week list of expected receipts and payments for the next 13 weeks, showing each week's closing bank balance. Updated weekly, it always looks a quarter ahead.
Should a cash flow forecast include GST?
Yes. Customers pay you GST and you pay it to suppliers, so include GST in receipts and payments, then show the net BAS payment in the week you pay it.
How does Payday Super change my forecast?
From 1 July 2026, super must reach each employee's fund within 7 business days of payday. Forecast it beside every pay run, not as a quarterly payment.
How much cash buffer should I hold?
A common starting point: one full pay run with super and PAYG, plus rent and loan repayments, plus the largest single payment due in the quarter. Hold more if sales are seasonal.
Sources
- ATO, Payment deadlines for Payday Super: https://www.ato.gov.au/businesses-and-organisations/super-for-employers/paying-super-on-payday/payment-deadlines-for-payday-super
- ATO, Due dates for lodging and paying your BAS: https://www.ato.gov.au/businesses-and-organisations/preparing-lodging-and-paying/business-activity-statements-bas/due-dates-for-lodging-and-paying-your-bas
- ATO, Paying and reporting PAYG withholding amounts: https://www.ato.gov.au/businesses-and-organisations/hiring-and-paying-your-workers/payg-withholding/paying-and-reporting-withheld-amounts
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