A cashflow forecast a trade business will keep
A trade business can win work, price it well and still fail to make payroll. Profit is an opinion about a period; cash is a fact about a Friday.
The gap between them is materials bought now and invoices paid later, and it widens exactly when the business grows.
Growth consumes cash
A bigger job needs more materials sooner and pays later. Two of them at once can empty an account that looked healthy last month.
That is why a busy quarter often feels worse than a quiet one. The work is profitable and the money has not arrived yet.
Four lines are enough to see it coming
- Cash on hand, today, across every account.
- Money coming in, by the week it should realistically land rather than its due date.
- Money going out, including wages, suppliers, rent, vehicles and tax set aside.
- The closing balance, week by week, for the next eight weeks.
Eight weeks is far enough to act and near enough to estimate. Anything longer becomes fiction and stops getting updated.
Use realistic dates, not invoice terms
A forecast built on thirty day terms assumes every customer pays on time. The same forecast built on how each customer actually behaves is far less comfortable and far more useful.
A builder who reliably pays at day forty five goes in at day forty five. Optimism in this sheet is the thing that makes it useless.
Wages and tax are the two that end businesses
Both arrive on a date nobody moves. A forecast showing a shortfall three weeks out leaves time for a deposit, a payment plan or a conversation with a lender.
The same shortfall discovered on the day leaves none of those. The value of the sheet is entirely in the notice it gives.
Set money aside as it arrives
Tax withheld from a payment is not the business's money, and neither is the superannuation accruing on wages. Both feel like cash until the day they leave.
A separate account, funded on receipt rather than at quarter end, removes the worst surprise in small business. It costs nothing and changes the whole shape of a quarter.
Quotes accepted are the forward view
A forecast built only on issued invoices sees three weeks ahead. Accepted quotes with expected start dates extend it to the real horizon.
That also shows a quiet patch before it arrives, while there is still time to sell into it. Our guide to past customers covers the cheapest way to fill one.
Update it on the same morning each week
A forecast updated when somebody worries about money is a forecast that appears too late. Fifteen minutes on a fixed morning keeps it honest.
The discipline matters more than the format. A sheet updated weekly beats a sophisticated model touched twice a year.
Compare the forecast with what happened
After a quarter, hold last month's forecast against the real balances. The error is nearly always in the timing of receipts rather than the amounts.
Correcting the assumed payment days per customer makes the next forecast sharper, and that single correction usually explains most of the drift.
A line of credit is cheapest before you need it
A bank lends most readily to a business that can show eight weeks ahead and does not need the money today.
Arranging a facility during a good quarter costs a fee and sits unused. Arranging one during a bad month costs far more, if it happens at all.
What to change first
- Four lines, eight weeks, updated on a fixed morning
- Receipts land on the date each customer really pays, not the due date
- Wages, tax and super sit in the outgoing line at full value
- Tax and super move to a separate account as the money arrives
- Accepted quotes extend the view past issued invoices
- Last month's forecast meets the real balances each quarter
How to set it up
Subscribe to our newsletter
Keep updated with the latest changes.