Cash flow forecasting is not reserved for large businesses with finance teams. A well-maintained 13-week rolling forecast is the most practical financial tool a small business can have — and it takes less time to build than most owners think.
Why 13 weeks?
Thirteen weeks (one quarter) sits in a useful middle ground: long enough to see upcoming obligations clearly, short enough that the numbers are meaningful. It matches the BAS lodgement cycle and aligns with ATO quarterly super deadlines, making it natural to reconcile planning with compliance.
Monthly forecasting tends to hide the lumpy reality of weekly cash movement. A profitable business on paper can still miss a payroll because the model was too coarse.
The structure
A 13-week cash flow forecast has three sections:
Opening balance — actual bank balance at the start of each week.
Cash inflows — all expected receipts: invoices due, expected customer payments, any loan drawdowns or owner contributions. Be specific about dates. If you invoice net 30, do not count cash until week 4+.
Cash outflows — all expected payments: wages, rent, supplier invoices, ATO obligations (BAS, super, PAYG), loan repayments, and any irregular items like insurance renewals or equipment purchases.
The closing balance for each week becomes the opening balance for the next.
The ATO obligations layer
The most common reason a small business cash flow forecast fails is that ATO obligations are not mapped correctly to their due dates.
Key dates to include:
- BAS lodgement and payment: quarterly payers — 28 October, 28 February, 28 April, 28 July (28 August if lodging via a registered agent)
- Monthly BAS payers: 21st of the following month
- Super guarantee: quarterly — 28 October, 28 January, 28 April, 28 July
- PAYG withholding: small withholder (under $25k annually) — quarterly with BAS; medium withholder ($25k–$1M) — monthly by 21st
- PAYG instalments: quarterly — same dates as BAS
Plot each of these in the outflows column of the relevant week.
Practical tips for accuracy
Use bank data, not invoiced amounts. In your forecast, receipts only appear in the week you expect them in the bank — not the week you invoiced.
Apply a collection lag. Review your debtor ledger and calculate your average debtor days. If customers take 45 days to pay, model a 6-week lag between invoicing and cash receipt.
Separate fixed from variable outflows. Fixed outflows (rent, loan repayments, standing orders) can be copied forward automatically. Variable outflows (wages for a casual workforce, supplier invoices that fluctuate) need a fresh estimate each week.
Build a low-case scenario. Run a second version where invoiced sales convert at 70–80% of expected. This stress-test often reveals structural cash flow problems that a good month of sales would mask.
The rolling update discipline
The forecast only works if it is updated weekly. The process:
- Record actual opening balance (from bank rec)
- Mark receipts that came in vs. expected
- Mark payments made vs. expected
- Roll forward one week and add a new week 13
Total time for an experienced bookkeeper: 15–20 minutes per week. The output is a business owner who is never surprised by an ATO payment or a payroll shortfall.
Software options for Australian small business
Most cloud accounting platforms offer basic cash flow reports, but they are backward-looking. For forward-looking forecasting:
- Xero Cash Flow Forecast — limited to 30 days
- Float — popular cloud add-on for Xero/QBO; syncs actuals automatically
- Spotlight Forecasting — more advanced; used by bookkeepers advising clients
- Excel/Google Sheets — most flexible for custom multi-scenario models
Red flags to watch for
A 13-week forecast will surface these problems early:
- Negative closing balance in weeks 3–6 — structural working capital gap
- Outflows consistently exceeding inflows — business is not self-funding at current margins
- ATO payment dates as the biggest weekly outflow — obligations accumulating
Any of these should trigger a conversation about funding, payment plans, or operating cost review — not at year end, but when the forecast reveals it.
For bookkeepers
Preparing the template, training the client on the update process, and flagging structural issues during monthly reviews is bookkeeping work. Offering a quarterly cash flow review as an add-on service is one of the cleaner ways bookkeeping practices can increase average client value.