The 13-week cash flow forecast

The 13-Week Cash Flow Forecast: What It Is and Why Growing Businesses Need One

Your profit and loss tells you how last month went. It doesn't tell you whether you can pay wages in week seven.

Most businesses that run short of cash aren't losing money. They're profitable on paper, but the cash arrives later than the bills do. A big customer pays at 60 days instead of 30. The BAS falls in the same week as payroll. An annual insurance bill lands on top of a quiet month. None of that shows up in a monthly P&L until it has already happened.

A 13-week cash flow forecast is the tool that shows it before it happens.

What is a 13-week cash flow forecast?

It's a week-by-week view of the cash going in and out of your bank account over the next 13 weeks, which is one quarter.

Each week shows:

  • the bank balance at the start of the week

  • the cash you expect to receive

  • the cash you expect to pay out

  • the bank balance at the end of the week

It rolls forward. Every week you drop the week that has passed, add a new week at the end, and replace forecast numbers with what actually happened.

Why weekly, and why 13 weeks?

Weekly because cash problems are about timing. A month can look fine in total and still have one week where the account goes below what you need to operate. A monthly forecast averages that week away. A weekly one shows it.

Thirteen weeks because a quarter is long enough to catch the big, lumpy payments (BAS, insurance renewals, loan repayments, annual software bills) and short enough to forecast with real confidence. You know your customers, your payroll dates and your supplier terms for the next three months. Beyond that, a monthly forecast does the job better.

What goes into it

Cash in

  • Customer receipts, based on when customers actually pay, not when you invoice. If a customer always pays at 45 days, forecast 45 days.

  • Other receipts: GST refunds, grants, loan drawdowns, capital from owners.

Cash out

  • Payroll on the actual pay dates, plus PAYG withholding.

  • Superannuation. Under Payday Super, super now goes out with each pay run instead of quarterly, which changes the timing for many businesses.

  • Suppliers, based on the terms you actually pay on.

  • BAS: GST and PAYG instalments in the weeks they're due.

  • Rent, loan repayments, leases and subscriptions.

  • Annual and one-off items: insurance, registrations, equipment, bonuses.

Then add one line most forecasts leave out: the minimum cash balance you're comfortable holding. The forecast is only useful when it shows you which week you drop below that line.

How to build one in five steps

  1. Start from the bank, not the P&L. Take today's real bank balance. A cash forecast built from profit numbers will be wrong from week one.

  2. List receipts customer by customer. Use your debtors list and each customer's real payment habits. Be honest about the slow payers.

  3. List payments by due date. Payroll, suppliers, tax and fixed costs, each in the week it actually leaves the account.

  4. Roll it weekly. Every Monday, put in last week's actual numbers and add a new week 13. This takes 20 to 30 minutes once it's set up.

  5. Compare forecast with actual. Where you were wrong tells you which assumptions to fix. After a month or two, the forecast becomes reliable enough to make decisions on.

The mistakes I see most often

  • Forecasting profit instead of cash. Revenue isn't cash until the customer pays.

  • Forgetting the quarterly hits. The BAS quarter is where many forecasts get caught out.

  • Optimistic receipts. The forecast assumes everyone pays on time. They don't.

  • Building it once. A forecast that isn't updated weekly stops being a forecast within a month.

Signs you need one now

  • Your bank balance swings a lot from week to week.

  • You're growing, and growth is using cash faster than profit is making it.

  • You're about to hire, sign a lease, buy stock or take on a big contract.

  • Your bank, lender or investor has asked for a cash forecast.

  • You've looked at the account before a payroll run and felt your stomach drop.

What I've learned building these

Over 25 years I've built cash flow forecasts for multi-entity banking groups and for businesses with one bank account. The tools change. The discipline doesn't: start from the bank, be honest about timing, and update it every week.

The value isn't the spreadsheet. It's seeing week nine coming while it's still week one, when you have time to chase a debtor, move a payment, talk to the bank or delay a hire.

Want a 13-week cash flow forecast built for your business? Book a call and we'll look at where your cash is heading.

Previous
Previous

Do you need a part-time CFO?

Next
Next

Simplify Your Finances with Virtual Bookkeeping Services on Xero