Cash Flow Forecasting for Small Business: A Plain-English Guide for Cairns Owners
Most business owners I talk to in Cairns are not short of work. They are short of certainty about the next few weeks. The jobs are booked, the invoices are out, the profit and loss looks reasonable, and yet there is a knot in the stomach every time a BAS or a payday comes around.
That is not a failure of effort. It is a gap in information. Profit is a scorecard for the past. Cash is what pays tomorrow. Cash flow forecasting for small business closes that gap, and it does not require software, a finance degree or a full day at the desk. It requires about an hour, once, and fifteen minutes a week after that.
Let me show you how it works, using the same approach I use with clients.
Why a profitable business can still run out of cash
Profit is what is left after you match income to the costs that helped earn it. Cash is what is actually sitting in the bank on a given day. The two move at different speeds, and that is the whole problem.
A few things pull them apart. You pay wages every week but your customers pay in 30 or 45 days. You buy stock in a big upfront order and sell it slowly. You pay GST and PAYG on the tax office's timetable, not yours. You have a strong month and decide to upgrade the ute, and the timing of that decision lands in the same week as three supplier invoices.
None of that shows up as a problem in a profit report. All of it shows up as a problem when you check the bank balance on a Thursday afternoon.
This is why so many good operators feel like they are working hard and getting nowhere. The business is making money. The money is just not in the right place at the right time. A forecast is how you see that before it happens rather than after.
What a forecast actually tells you
A cash flow forecast is a simple week-by-week table of money coming in and money going out. Not a budget. Not a projection for the bank. Just a rolling picture of what your bank balance is likely to do over the next thirteen weeks.
Thirteen weeks is the sweet spot for a small business. It is long enough to see a tight patch coming and do something about it. It is short enough that you can be reasonably accurate. And it lines up neatly with a quarter, so it catches a BAS, regular supplier payments and a few payroll cycles along the way.
What it tells you is specific and useful. Which week is the tight one. How big the gap is. Whether the gap is caused by a slow-paying customer, a stock order or a tax payment. And how much room you have before you need to act.
Building your first 13-week forecast, step by step
You already have everything you need. It is sitting in your bookkeeping file. Here is the sequence I would follow.
Step 1: Set the starting point
Write down today's actual bank balance, and any savings or offset accounts belonging to the business you would draw on if you had to. That opening number anchors the whole forecast. If it is wrong, everything after it is wrong.
Step 2: List the money you expect to collect
Go to your accounts receivable and list every unpaid invoice with the date you genuinely expect it to land, not the date it was due. If a customer has paid late every time for two years, forecast them late. Optimism here is the fastest way to build a forecast that lies to you.
Then add the cash sales and deposits you expect from work already booked. Keep it to work you have in writing. One-off hopes belong in a separate column marked maybe.
Step 3: List the money you expect to pay
Start with the fixed costs you cannot move: rent, wages, super, loan repayments, insurance, subscriptions. Then add the variable ones: supplier invoices, stock orders, subbies, fuel, card fees.
Then sit the tax aside on its own line. GST, PAYG withholding and income tax instalments rarely arrive in a convenient week. Knowing exactly which week they land is half the value of the exercise.
Step 4: Build the table and find the dips
Put the thirteen weeks across the top of a spreadsheet. Rows down the side: opening balance, money in, money out, closing balance. Fill in what you know, estimate the rest, and let the closing balance roll into the next week's opening balance.
Then look for the lowest number in that closing balance row. That is your tight week. Everything you do next is about protecting it.
Step 5: Update it every week
A forecast is not a document you write once. Each week, replace the estimate with what actually happened, roll the window forward one week, and check whether the tight week moved. Fifteen minutes on a Friday is enough.
After a month you will trust it. After a quarter you will wonder how you ran the business without it.
How to use the forecast to make real decisions
A forecast on its own changes nothing. What changes things is what you do when you can see a dip three weeks out.
Stock
If week six is tight, that is where the big stock order gets delayed or split. Ordering to a forecast rather than to a feeling protects the weeks that matter and keeps the shelves full where the sales actually are.
Staffing
You can see whether a new hire is affordable, and when. You can also see whether a quiet patch is a real threat or just a normal swing. That stops you from doing panic decisions in a slow fortnight and gives you a clear case when you do need to bring someone on.
Tax
Once you know the week the ATO payment lands, you can fund it deliberately instead of finding it. Many owners set aside a percentage of each week's collections into a separate account. The forecast tells you whether that percentage is enough.
Owner drawings
This is the one that catches people. A draw that feels comfortable in a strong month can hollow out the buffer you need two months later. The forecast lets you set drawings against the low point, not the high point.
There is a fifth decision too, and it is usually the most valuable: when to talk to your bank or your accountant. Approaching a lender with a thirteen-week forecast in hand is a completely different conversation from approaching them in a crisis.
Where to start if numbers are not your thing
You do not need to love this. You need it to be right, and to be looked at every week. If your bookkeeping is behind, start there, because a forecast built on a messy file just gives you a tidy version of the wrong answer.
If you would like a hand getting the first one built, that is exactly the work I do. A financial healthcheck reviews your systems and reporting and shows you where the gaps are between what you think and what your numbers are actually saying. Bookkeeping Plus keeps the file clean and the forecast current, week to week. And for larger or more complex businesses, contract CFO support puts the decisions under the same lens as the numbers.
You can see how each of those works on my services page.
The takeaway
If your business is profitable but the bank account does not feel like it, you are not doing anything wrong. You are missing one view of the business. Cash flow forecasting for small business is not a finance project. It is a habit of looking thirteen weeks ahead, one hour to set up and fifteen minutes a week to keep.
Start with your bank balance and your unpaid invoices. Put them in a spreadsheet with thirteen columns. Find the lowest week. Then decide what you are going to do about it, while you still have time to choose.
Comments
Post a Comment