Your accountant tells you what happened. You need to know what's coming.

Your tax return tells you about last year. Your profit and loss tells you about last month. Neither can tell you whether you'll make wages in six weeks. A cash flow forecast can.

Does this ring a bell?

You find out there's a problem when it's already here. BAS is due and the money isn't there. A big supplier bill lands the same week as a three-pay month. A customer who always pays on time doesn't, and suddenly you're on the phone moving money around.

None of it was a surprise, really. The BAS date was known. The bill was coming. The pay dates are on the calendar. It just wasn't written down anywhere you'd see it coming.

That's the business living in your head again. You know roughly what's coming. Roughly isn't good enough when wages are on the line.

What is a cash flow forecast?

A list of the money you expect to come in and go out, week by week, for the next few months.

That's it. It's not a budget, and it's not your profit and loss. A budget is what you plan to earn and spend over a year. A forecast is when the cash will actually move. A sale you make in March that gets paid in May shows up in May.

The point is to see the low weeks before you get to them, while you've still got time to do something.

How far ahead should a cash flow forecast go?

Thirteen weeks is the most common starting point. It's a quarter, it catches your BAS, and it's close enough that you can actually predict it.

Further out than that, the numbers get vague. Closer than that, you won't see a problem in time to fix it. Thirteen weeks gives you room to chase invoices, move a purchase, or have a conversation with the bank before you need to.

How do I make a simple cash flow forecast?

One spreadsheet, one row per item, one column per week. Here's the order I'd build it in.

  1. Start with what's in the bank today. Your real balance, across all your business accounts.
  2. Add the money that's definitely going out. Wages and super every pay run. Rent. Loan repayments. Insurance. Subscriptions. BAS and PAYG on their due dates. These are the easy ones, because you know the amounts and the dates.
  3. Add the bills you know are coming. Supplier invoices already received, with their due dates.
  4. Add the money coming in. Start with invoices already sent. Put them in the week you expect to actually get paid, not the due date. If a customer always pays at 45 days, put them at 45 days.
  5. Add the work you're confident about. Booked jobs, regular customers. Be honest. If you're not sure, leave it out.
  6. Work out the closing balance for each week. Opening balance, plus money in, minus money out. That becomes next week's opening balance.

Then look for the lowest week. That's the one to plan around.

A very simple version looks like this:

Week 1Week 2Week 3Week 4
Opening balance40,00031,00038,00012,000
Customer payments in15,00030,0008,00025,000
Wages and super out22,00022,00022,00022,000
Suppliers and bills out2,0001,0004,0003,000
BAS out8,000
Closing balance31,00038,00012,00012,000

Week 3 is the one to worry about, and you can see it a fortnight ahead. That's two weeks to chase the slow payers or move a bill.

Know what's coming, but it still all lands on you? My free quiz, Why does everything still come back to you?, shows you which pattern is running your week.

How often should I update it?

Every week, at the same time. Friday works for a lot of owners.

Drop the week that's finished, add a new week at the end, and update anything that's changed. Did the customer pay? Did a new bill come in? It takes 20 minutes once it's set up.

If it only gets updated when there's a problem, it'll only ever tell you about problems you already know about.

It's also a perfect job to hand over. Your bookkeeper or office person can update it every Friday, and you read it. That's one less thing that lives in your head. If handing things over is where it falls apart, read You delegated it. So why are you still doing it?

What do I do when the forecast shows a low week?

You've got time, so use it.

  • Chase the invoices that should land before that week. See Customers on 30-day terms are using you as a bank.
  • Move non-urgent spending to after it.
  • Ring a supplier early and ask for a few extra days. It's an easy conversation two weeks out, and a hard one the day before.
  • If it keeps happening, the problem isn't timing. Look at your prices and your jobs.

Wages always come first. If you haven't already, give them their own account. See The #1 sign you're a good employer.

Why I care about this

I've run a business with staff for 22 years. For a long time I ran on the bank balance and my gut. A forecast didn't make the money appear, but it stopped the surprises. I could see the tight weeks coming and do something about them.

For where the money goes in the first place, read The accountant said pay yourselves a bonus. There was nothing in the bank to pay it with.

What to do next

Take the quiz. Why does everything still come back to you? shows you which pattern is running your week, and gives you something to fix it with straight away.

Want help working through the rest? The BAR is where owners with staff come to work out what to fix first, find the time to do it, and get held to it. It opens in February 2027. Join the waitlist.

HI, I'M SAM

I've co-run a field service business for 22 years and served 12 years in the Navy. Now I help solopreneurs get the back-end stuff done, the money, systems, marketing and AI, so they get their weekend back.

NOT SURE WHAT'S SLIPPING?

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore.

+123-456-7890000

Newsletter

Subscribe now to get daily updates.

Created with © systeme.io