Cash Flow Forecast: See the Gap Before You Commit

Picture this. The work is finished and invoiced. Wages fall due next week, but the client pays next month. A cash flow forecast turns that tension into a visible number. It estimates when money enters and leaves your bank account, not when you earn it.

What does a cash flow forecast tell you?

A cash flow forecast answers one narrow question. What will my bank balance be, by date, under stated assumptions? It tracks money movements, not accounting profit. A profitable business can hold too little cash while it waits to be paid (British Business Bank, n.d.).

A profit-and-loss statement matches revenue and costs to a period. Historical cash-flow reporting looks backward. A forecast looks forward and marks its figures as estimates (Australian Government, n.d.-b).

This article uses the direct method. List the receipts and payments you expect, on the dates you expect them. Under that method, a sales invoice is not a receipt. The receipt is money landing in the account. That rule prevents a common error: treating good sales as though they were already cash.

A forecast also makes your assumptions visible. Once written down, you can challenge them and correct them as facts arrive.

Why can profit arrive before cash?

Because a sale and its payment are different events. You can finish the work, record the revenue, and still run short before the money lands.

Consider a hypothetical illustration. A service business finishes a project in March and invoices it. The accounts look healthy. But approval delays and payment terms push the money to May, while payroll and supplier bills fall due in April. On paper the month was strong. In the bank it was tight.

Profit alone does not answer the cash-timing question. Review profit before a new cost and you may feel safe. Review dated cash and you may see a shortfall in one fortnight.

Which dates and payments belong in the forecast?

Start with a defined account scope and currency. Reconcile your opening balance to the actual bank balance on a set date. Money legally restricted, such as a court-ordered hold, is not spendable cash. Show it separately from cash available to spend.

An internal earmark is different. Setting money aside for next month's tax bill does not remove it from the bank. The bill stays in the forecast once, as a payment. If you subtract the earmark now and the bill later, you count the same obligation twice. That mistake invents a shortfall.

Do not count an undrawn credit facility as cash. Never assume an unapproved facility is usable. An approved undrawn facility may matter to liquidity, but track it separately with its conditions.

Then list items on their real dates. Receipts go on expected collection dates, not invoice dates. Payments go on due dates: payroll, supplier bills, debt principal and interest, tax, subscriptions, capital purchases and owner withdrawals. Employee costs and taxes belong in the plan, and payment due dates deserve close tracking (Australian Government, n.d.-a). Tax and payroll rules vary by country. Dating them is universal; rates and statutory deadlines are not.

Depreciation reduces accounting profit but is not a cash payment. Leave it out. Exclude transfers between accounts that are all inside the forecast's scope.

Here is a small illustrative table, using invented currency units. These figures aggregate all receipts and payments for the example.

Each row starts where the last ended. The closing figure becomes the next opening figure. That chain turns a list into a forecast.

What changes when a customer pays late?

Move the same 10,000 receipt from week 2 to week 3. Week 2 then closes at negative 3,000: 8,000 plus nothing, minus 11,000. The table assumes no overdraft. That negative figure is an unmet cash need under those assumptions. It is not a borrowing recommendation, and it is not proof of insolvency.

Notice what did not change. The customer still owes the full amount. No profit was lost, provided the customer eventually pays in full and no extra collection or financing costs arise. The gap is 3,000 in timing, not 10,000 in loss. Comparing actual receipts and payments against estimates helps here. It shows where projections and reality diverge (Business Development Bank of Canada, n.d.).

When a difference appears, ask which kind it is. A timing difference means the money is late but expected. A demand or cost difference means the number itself was wrong. The first needs a cash plan for the delay. The second needs a harder look at pricing, costs or pipeline.

Suppose you are weighing an extra week-2 equipment payment. It needs its own row. Do not fold it quietly into operating expenses. Do not approve it on the base case alone.

What can you change before committing to a new cost?

You have more room than one yes-or-no choice suggests. The forecast hands you a short list of options to check.

Check collection dates first. A confirmation can firm up an expected date. It does not promise faster payment. Fix invoicing errors, which can trap money. Agree new terms in advance, not on your own. Put off spending you can choose to skip. See if you can shift when you hire, or how much.

Getting skilled help is a fair step, not a last resort. Questions on books, tax, lending and insolvency belong with properly qualified specialists. Delaying wages or tax is not a plan. Breaking contracts is not a plan either.

If you want to talk through the choice itself, and whether advisory support fits, you can discuss advisory support .

For a wider view, explore Mherie Vic insights on the systems around this decision. You may also find service pricing and customer concentration risk useful companions.

How should you update the forecast as facts change?

Choose a horizon and interval that match your payment timing and the decision. A weekly view across the next few months is an illustrative option. It is not a universal mandate, and no single safe buffer figure fits everyone.

Keep a short assumptions log beside the table. For each line, record the evidence, the owner, the review date, and whether it belongs to your base or delay case. Evidence means the document or message that supports the date or amount. A review date keeps the entry from going stale. Here is one filled row, for illustration only.

Then compare. Place actual receipts and payments next to your estimates. Explain each difference in one line. That habit keeps the forecast useful rather than decorative. Treat the table and log as an editorial planning aid, not a validated forecasting model.

The forecast will never be perfectly right. Its value is making assumptions visible early. Update it, and it keeps earning its place.

This article is for informational and educational purposes only and does not constitute financial, legal, tax, medical, or professional advice. Individual results vary.