At a glance
- A 13-week cash flow forecast shows your bank balance at the end of each week for the next quarter. It tracks cash, not profit.
- Weekly is detailed enough to catch a bad week. Thirteen weeks is a full quarter, so it picks up the bills that only arrive every three months.
- Put receipts in the week customers actually pay, and payments in the week they actually leave the bank.
- Update it every week. A gap you see six weeks out is a problem you can fix. A gap you find on the day is a crisis.
What it is
A 13-week cash flow forecast is a simple table. Each column is a week. It starts with the money in the bank, adds the cash you expect to come in, takes away the cash you expect to go out, and shows what is left at the end of the week. That closing balance becomes the next week's opening balance.
It is not a budget and it is not a profit forecast. A budget tells you whether the year should make money. This tells you whether you can pay the bills on Friday.
Why weekly, and why 13 weeks
A monthly forecast hides too much. Wages, a large supplier bill and a tax payment can all land in the same week, and the month can still look fine on average. Your bank account doesn't work on averages. If it goes below zero for one week, that is the week that matters.
Thirteen weeks is one quarter. That is long enough to include the payments that come round every three months, such as your business activity statement (BAS) if you lodge quarterly. It is also short enough that you can make sensible guesses about which customers will pay and when. Past three months, the detail turns into guesswork.
How to build one, step by step
Start with the real bank balance
Use the balance in your bank account today, not the figure in your accounting software. Unpresented cheques and payments still processing can make the two differ.
Forecast receipts by when customers pay
Go through what customers owe you now and put each amount in the week you expect the money, based on how that customer really pays. If a customer on 30-day terms usually pays in 50 days, use 50. Then add new sales you expect to invoice, and when that cash should arrive.
List the regular payments
Wages on each payday, super with each payday (it now has to reach the fund within 7 business days of payday), rent, loan repayments, leases, insurance and subscriptions. Put each one in the week it leaves the bank.
Add supplier payments
Use what you owe suppliers now, then add what you expect to buy, based on when you will actually pay each one.
Add tax at its real due dates
GST and PAYG instalments are usually paid with your BAS. Tax withheld from wages is paid with your BAS too if you withhold $25,000 or less a year, but monthly if you withhold more. Put each payment in the week of its due date, not the week the period ends. Your accountant or registered tax agent can confirm your cycle, the dates and a sensible estimate of the amounts.
Roll the balance forward
Opening balance, plus receipts, minus payments, equals closing balance. Check that the sum works for every week before you rely on it.
A worked example
Take a made-up joinery business with about $2.5m of sales a year. It starts the quarter with $40k in the bank. Customers pay between $43k and $55k a week. Wages and super cost $38k a fortnight, suppliers about $22k to $26k a week, and rent plus a loan repayment $16k a month. On a normal week the business is fine. Then week 8 arrives.
To keep the example simple, tax withheld from wages is treated as part of the fortnightly wage line. Lime is money in the bank, coral is overdrawn. Week 10 is also tight at $3k.
In week 8, four things leave the bank at once: $38k of wages and super, $22k to suppliers, $16k of rent and the loan repayment, and a $58k BAS and PAYG instalment payment. That is $134k out against $43k in. The business started the week with $77k and ends it $14k overdrawn.
Nothing in that week is unexpected. Every due date was known months ahead, even if the BAS amount was only an estimate. The problem is that they all land together, and a monthly view would have smoothed them away.
| Week | Opening | Receipts | Payments | Closing |
|---|---|---|---|---|
| 1 | $40k | $48k | $24k | $64k |
| 2 | $64k | $44k | $60k | $48k |
| 3 | $48k | $50k | $25k | $73k |
| 4 | $73k | $46k | $77k | $42k |
| 5 | $42k | $47k | $24k | $65k |
| 6 | $65k | $45k | $60k | $50k |
| 7 | $50k | $52k | $25k | $77k |
| 8 | $77k | $43k | $134k | -$14k |
| 9 | -$14k | $55k | $26k | $15k |
| 10 | $15k | $49k | $61k | $3k |
| 11 | $3k | $53k | $25k | $31k |
| 12 | $31k | $47k | $60k | $18k |
| 13 | $18k | $54k | $42k | $30k |
Across the quarter, $633k comes in and $643k goes out, so the balance falls from $40k to $30k. A $10k fall over 13 weeks doesn't sound like much. The weekly view shows the real risk: one week where the account can't cover the bills.
Updating it every week
A forecast you build once and file away can be out of date within a fortnight. The value comes from keeping it current. Pick a fixed time each week, such as Monday morning, and do three things.
Compare forecast with actual
Put last week's real receipts and payments beside what you forecast. Note any big differences and why they happened.
Roll forward one week
Drop the week that has passed, reset the opening balance to the real bank balance, and add a new week 13 at the end. You always have a full quarter in view.
Fix your assumptions
If the same customer pays late every time, change when you expect their money. If supplier costs keep coming in higher, raise them. The forecast should get more accurate each week.
Over time, the forecast vs actual comparison is the most useful part. It shows whether your guesses run too hopeful, and which customers or costs you keep getting wrong.
What to do when it shows a gap
In the example, the owner sees the week 8 problem in week 1. That gives seven weeks to act. The usual options, roughly in order:
- Chase debtors. Ring customers with overdue invoices now, not in week 7. Invoice promptly when work is done, and make it easy to pay.
- Move the timing of payments you control. A large stock order or an equipment purchase can often wait two weeks. Some suppliers will agree to a short extension if you ask before the bill is due.
- Talk to your accountant about the tax payment. They can check the estimate and explain your options if you can't pay in full on time. Payment plans may be available, but ask early.
- Talk to the bank early. A lender is far more willing to help with an overdraft or a short-term facility when you show them a forecast weeks ahead than when you call on the day.
Owner drawings are another lever. If the business is short in week 8, holding back drawings in weeks 6 and 7 may close part of the gap.
Common mistakes
Using profit instead of cash
A sale only helps the forecast when the customer pays. Depreciation never appears at all, while loan principal and equipment purchases do. If your profit is up but the bank balance is not, our guide on why profit is up but cash is not shows where the money usually goes.
Forgetting the quarterly and annual bills
BAS and PAYG instalments are the obvious ones. Insurance renewals, annual licences, registrations and income tax payments catch people too. Go through last year's bank statements and list every payment that wasn't weekly or monthly.
Optimistic collections
Forecasting that every customer pays on the due date is a common error. Use how each customer actually pays. If a large invoice is in dispute, leave it out until it is settled.
Ignoring payment timing within the week
If wages go out on Tuesday and your biggest customer pays on Friday, the weekly closing balance can look fine while the account dips midweek. If your margins are tight, note which day the big items move.
Building it once and stopping
A forecast that isn't updated gives false comfort. The weekly roll forward is usually quick once the template is set up.
When the forecast keeps showing a squeeze
A one-off dip around a BAS week is a timing issue. A forecast that keeps trending down, week after week, usually points to something deeper: prices that are too low, customers who pay too slowly, or costs that have crept up. A Commercial Business Review looks at profit, pricing, customers and cash together, so you can tell which one you are dealing with.
See the quarter ahead clearly
A Commercial Business Review looks at where your cash goes, finds the pressure points, and gives you a short list of practical fixes.
See the Commercial Business ReviewGeneral information only, not advice for your circumstances. See our terms.

