How to Build a 13-Week Cash Flow Forecast for Your Small Business
Profit tells you whether a business can work. Cash tells you whether it can survive next month. Plenty of profitable businesses still run short of cash, because money arrives later than it leaves: customers pay in 30 days or more, while wages, rent and tax fall due on fixed dates. A 13-week cash flow forecast is a simple weekly view of the next three months that shows those gaps before they arrive.
The Australian evidence is a warning. In ASIC's analysis of company failures for 2018–19, “inadequate cash flow or high cash use” was the most commonly reported cause, cited in 51% of external administrators' reports.
Why 13 weeks?
Thirteen weeks is one quarter. It is far enough ahead to give you time to act, and close enough to forecast with reasonable accuracy. It also lines up with the quarterly rhythm of many Australian obligations: for most small businesses reporting GST quarterly, BAS payments fall due on 28 October, 28 February, 28 April and 28 July. Businesses that report monthly have a different due date, and extra time may apply in some cases, so confirm your own dates with the ATO or your registered agent.
What you need before you start
Build it in seven steps
A simple worked example
Illustrative figures: imagine a small services business with $25,000 in the bank. Over the next four weeks it expects $30,000 in customer payments. Its payments are wages of $12,000, super of $1,440 (12% of those wages), rent of $3,200, suppliers of $9,000 and a BAS payment of $6,500, a total of $32,140. Cash at the end of week four is $25,000 + $30,000 − $32,140 = $22,860.
That looks healthy. But the forecast is weekly, so it also shows when the money moves. If the BAS payment and a pay run land in the same week, before a large customer payment arrives, the balance can dip well below $22,860 midway through the month. If the biggest customer pays $10,000 two weeks late, the month ends at $12,860. You want to see that in a spreadsheet, not in your bank account.
Keep it alive
What to do when the forecast shows a gap
The point of a forecast is that you find the gap early enough to act. Common options are chasing overdue invoices sooner, asking for deposits or shorter payment terms, delaying non-essential spending, negotiating supplier terms, and speaking to your bank early rather than at the last minute.
Tools
A spreadsheet is enough to start. Accounting software such as Xero, MYOB and QuickBooks can give you the lists of unpaid invoices and bills that feed the forecast, and a financial dashboard can then track it week by week.
Conclusion
A 13-week cash flow forecast turns cash from a worry into a plan. You will know which weeks are tight, which decisions can wait, and when it is safe to invest. At Skilvizer, our Cashflow Clarity service helps founders build a forecast that fits their business and learn to maintain it themselves.
This article is general information only, not financial or tax advice. Confirm your obligations, including BAS, PAYG and superannuation, with your registered tax agent or accountant.
Sources
- ASIC, corporate insolvencies 2018–19 (causes of failure reported by external administrators)
- Australian Taxation Office, due dates for lodging and paying your BAS
- Australian Taxation Office, Payday Super
- Australian Taxation Office, the super guarantee rate increase to 12%
Dollar figures marked as illustrative are worked examples, not client results.
Related articles
All insights →Ready to make your numbers work for you?
Book a free 30-minute strategy call and we'll map out the first step of your business growth pathway together.
Book Your Free Strategy Call