100% online, Australia-wide
Advisory · Bookkeeping via BN Books · Tax via BN Tax

How to Build a 13-Week Cash Flow Forecast for Your Small Business

A 13-week cash flow forecast shows your cash position week by week for the next quarter. Here's how to build one in five steps, keep it rolling and avoid the common mistakes.

A 13-week cash flow forecast shows how much cash your business expects to have each week for the next quarter. In other words, it turns “I think we’ll be fine” into a number you can plan around. It’s short enough to stay accurate, yet long enough to spot a shortfall before it arrives. This guide walks you through building one, step by step.

Why 13 weeks?

Thirteen weeks is one quarter. That matters, because many big payments land on a quarterly rhythm. For example, a quarterly BAS payment, insurance renewals and seasonal stock orders can all fall inside the same window.

A yearly forecast is useful for planning. However, it’s usually monthly, and a month can hide a very tight week. A weekly view shows you the exact week the bank balance dips. As a result, you have time to act.

Weekly figures also stay realistic. You can usually see the next few weeks of sales, bills and wages clearly. Beyond three months, the numbers become guesses.

What goes into a 13-week cash flow forecast

The government’s business.gov.au cash flow guide describes a cash flow forecast as an estimate of your future sales and costs. It also suggests the same simple layout for every period:

  • Opening balance: the cash in the bank at the start of the week.
  • Cash incoming: customer receipts, grants, tax refunds and any other money in.
  • Cash outgoing: wages, rent, suppliers, loan repayments, tax and super.
  • Closing balance: opening balance plus incoming, minus outgoing.

Each week’s closing balance becomes the next week’s opening balance. That’s the whole engine. Meanwhile, the hard part is getting the inputs right.

How to build your 13-week cash flow forecast, step by step

1. Start with today’s bank balance

First, use the real balance from your bank accounts, not the figure in your accounting software. If your books are behind, get them up to date first. Our sister business BN Books looks after bookkeeping, so the numbers you start from are current.

2. List money coming in by the week you’ll receive it

Next, work from your unpaid invoices and expected sales. Be honest about timing. If a customer usually pays 45 days after the invoice, put the cash in that week, not the week you send the bill. Look back at last year, too, so seasonal highs and lows are included.

3. List every payment by the week it leaves

Then map out wages on each pay day, rent, suppliers, subscriptions and loan repayments. Don’t forget the large, irregular payments. Check the ATO’s BAS due dates so your GST and PAYG payments land in the right week. For tax questions, BN Tax can help.

4. Work out the closing balance for each week

After that, let the spreadsheet do the maths. Scan the closing balance row. Any week that falls below the buffer you’re comfortable with is a warning sign.

5. Plan your response early

If a tight week appears, you still have weeks to fix it. For instance, you could chase overdue invoices, move a purchase back, or talk to your bank about a facility. business.gov.au also suggests testing changes in your forecast before you commit, in its guide to improving your cash flow.

Keep your 13-week cash flow forecast rolling

A 13-week forecast is not a one-off report. Instead, each week you drop the week that has passed, enter what actually happened, and add a new week at the end. This is called a rolling forecast.

Comparing forecast to actual also makes you better at forecasting. Over time, you’ll learn which customers pay late and which costs creep up. Consequently, the numbers get more reliable each month.

Common 13-week cash flow forecast mistakes

  • Mixing up profit and cash. A profitable month can still leave you short if customers haven’t paid yet.
  • Forgetting GST. GST you collect isn’t yours to spend, so set aside what’s due on your BAS.
  • Being too optimistic. Plan for slow payers and quiet weeks, not your best-case month.
  • Building it once and leaving it. An out-of-date forecast is worse than none, because it gives false comfort.

Where Business Ninjas fits in

Many owners start a 13-week cash flow forecast and then run out of time to keep it updated. That’s where we come in. Our cash flow forecasting service builds and maintains the forecast for you. We also turn it into a short weekly or monthly report through our business performance reporting.

If you want more support, a virtual CFO can review the forecast with you and help you make the big calls. Heading into the holidays? Our Christmas cash flow checklist covers the seasonal pressure points.

We’re 100% online and work with small businesses Australia-wide, including Brisbane and the areas we service. Get in touch or call us on 1300 790 113 to talk about your forecast.

Newsletter Updates

Enter your email address below and subscribe to our newsletter