Simple cash flow forecast for a small business

16 November 2026 · Nunya Bunya

You know roughly what came in this month. You could probably say whether it was a good one or a thin one. What you could not say, without a long look at the bank account and a bit of guessing, is what next quarter looks like. And if your biggest customer rang tomorrow to say they were going elsewhere, you would not know how many weeks you had to respond.

A cash flow forecast answers both questions. It is a simple table that lists the money you expect to receive and the money you expect to pay out, month by month, so you can see what your bank balance will be at the end of each one. It does not need to be accurate to the dollar. It needs to be good enough to show you trouble while there is still time to do something about it.

The six numbers worth tracking

You do not need a financial model. For each month you only need these:

  1. Opening cash. What is in the bank on the first day of the month.
  2. Cash in. Money you expect to actually receive that month.
  3. Cash out. Money you expect to actually pay that month, including your own pay.
  4. Closing cash. Opening cash, plus cash in, minus cash out. This becomes next month's opening cash.
  5. Lowest closing cash. The smallest of your closing figures across the whole forecast.
  6. Share from your biggest customer. Their cash in, divided by your total cash in for the month.

The first four are arithmetic. The last two are where the insight is, and we will get to them.

How to build it, step by step

Open a spreadsheet and put the next three months across the top. Three is enough to start. Down the left side, you will list your money in and your money out. Here is how to fill it in.

  1. Start with the real bank balance. Use today's figure from your business account, not what you think it should be.
  2. List your cash in by source. Do not write one lump called "sales". Give your biggest customers their own lines and group the small ones together. For each, estimate what will land in your account that month, based on when they actually pay you, not when you do the work.
  3. List your cash out, starting with the fixed bills. Rent, insurance, phone, software, loan repayments, and a pay for yourself. Be strict about the pay. If you leave yourself out, the forecast will look healthier than your life is.
  4. Add the costs that move with your sales. Parts, materials, subcontractors. A simple way to do this is to look at last quarter and work out roughly what percentage of your sales these ate up, then apply that percentage to your forecast.
  5. Add the lumpy bills. Annual renewals, equipment, and tax. In Australia that includes your quarterly activity statement (the BAS, which is how you report and pay GST, the 10 per cent tax added to most sales, to the ATO). The GST you collect from customers is not your money, so the forecast needs to show it leaving.
  6. Do the sums, then find the low point. Calculate closing cash for each month and circle the smallest one.

A worked example: a mobile mechanic

Here is a made-up business to show the method. The numbers are invented for illustration, so do not read them as a benchmark for anyone. Say Sam is a mobile mechanic who services cars at people's homes and also does regular work for a local plumbing business that runs a few vans. Sam starts December with $8,000 in the bank.

Sam assumes January is quieter because customers are on holidays. The plumbing business is a steady $5,000 a month. Parts run at about 30 per cent of money in. Sam pays himself $5,000 a month. The annual van registration and insurance renewal of $1,800 falls in February, and so does a $2,400 BAS payment for the October to December quarter.

DecemberJanuaryFebruary
Opening cash$8,000$10,600$11,800
Cash in: private customers$9,000$7,000$9,000
Cash in: plumbing business$5,000$5,000$5,000
Total cash in$14,000$12,000$14,000
Parts$4,200$3,600$4,200
Van running costs$1,500$1,500$1,500
Insurance, phone, software$700$700$700
Van registration and insurance renewal$0$0$1,800
BAS payment$0$0$2,400
Sam's pay$5,000$5,000$5,000
Total cash out$11,400$10,800$15,600
Closing cash$10,600$11,800$10,200

Read that table and Sam looks fine. The lowest closing figure is $10,200, and the balance never dips below where it started. But February is a month where Sam takes in $14,000 and pays out $15,600, and the bank balance only holds up because December and January were good.

Now the question from the start. The plumbing business brings in $5,000 of Sam's $14,000 in December, which is just over a third of the total. Take that customer out from 1 December and the parts bill drops by about $1,500 a month, because there is less work to buy parts for. The net loss is roughly $3,500 a month.

DecemberJanuaryFebruary
Closing cash without the plumbing business$7,100$4,800-$300

That is the useful result. Sam would be overdrawn by the end of February, and the warning comes in December, not February. In that time Sam could find a replacement customer, cut spending, or arrange a small overdraft before it was urgent.

What good looks like versus what most people produce

Most small business owners who try this produce one of two things. The first is a yearly budget, which is a list of what they hope to earn and spend over twelve months. It is too far out to act on and nobody checks it. The second is a bank balance in their head, with a vague feeling that things are "okay".

A useful forecast is smaller and more honest. It covers three months, it is on one page, and it uses the dates money actually moves. Your biggest customers have their own lines. The awkward bills are in the months they will really arrive. It has a lowest-point figure at the bottom, and it comes with a scenario or two ("what if our biggest customer left", "what if sales dropped by a fifth"). It will be wrong in places, and that is fine. A forecast that is roughly right and updated monthly beats a precise one that was last touched in March.

The three mistakes that make it useless

1. Counting invoices instead of cash. If you invoice in December but the customer pays in late January, that money belongs in January. A business can be busy and profitable on paper and still run out of money because customers pay slowly. Use the date the money arrives, and be a bit pessimistic about late payers.

2. Leaving out the lumpy bills. Everyone remembers rent. Fewer remember the yearly insurance, the BAS, the accountant's fee, or the tax bill on this year's profit. These are the costs that cause surprises, because they arrive in one go. Go through last year's bank statements and look for any payment that only happens once or four times a year.

3. Writing it once and filing it. A forecast is a tool that gets updated. If you build it in one burst of enthusiasm and never open it again, it will be out of date by the time you need it. Each month, replace the forecast month with what actually happened, add a new month on the end, and look at how far off you were. After a few rounds your estimates get a lot better.

What to do with it once it is written

This is the part most guides leave out. A forecast on its own does nothing. It becomes useful when you decide in advance what you will do when it shows a problem.

Doing this properly takes an afternoon, mostly spent pulling together last year's bank statements and working out when your customers really pay. If you would rather have it done for you, a Financial Model & Forecast built from your own answers is $99. Either way, the aim is the same: to know what next quarter looks like before you are standing in it.