Three-way forecasting: how a profitable business still runs out of cash

A business can be profitable every month and still run out of cash. When it happens it lands as a shock, because the profit and loss looked healthy the whole way down.

Profit and cash are not the same thing, and they do not move at the same time. You book a sale in March and the customer pays in June. In between you still pay staff, rent, suppliers and VAT. The P&L says you are winning. The bank balance disagrees.

A three-way forecast shows both at once, and stops the gap between them turning into a surprise.

What a three-way forecast actually is

A three-way forecast links the three core financial statements into a single model: the profit and loss, which shows whether you are making money; the balance sheet, which shows what you own and owe; and the cash flow, which shows what is moving in and out of the bank.

The point is not three reports side by side. It is that they are joined. Win a large contract and the P&L improves, the balance sheet picks up debtors and stock, and the cash flow shows the gap before the money lands. Change one assumption and all three move together, the way they do in real life.

Profit is an opinion. Cash is a fact.

Why profit and cash drift apart

The gap between them is timing, plus a set of things that never touch the P&L at all:

• Debtors. You invoice today and get paid in thirty, sixty, sometimes ninety days. The profit is booked now; the cash lands later.
• Stock. Cash goes out to buy or build inventory long before it sells and turns back into cash.
• Capital spending. Buying equipment drains cash now, but the P&L only feels it slowly, as depreciation.
• Loan repayments. The capital you repay is cash out of the door, yet it never appears as a cost in the P&L.
• VAT and tax. You collect money you will later hand to HMRC. It sits in the account looking like your cash, right up until it is not.

A profit-only forecast is blind to every one of these. That is the blind spot a three-way model removes.

The forecast lenders actually ask for

When a business goes for a loan, an overdraft or an invoice facility, the bank almost always asks for a three-way forecast. Not to make life difficult, but because a profit forecast on its own cannot answer the only question they care about: can this business pay the money back, on time. That answer lives in the cash flow, and the cash flow only makes sense next to the profit and the balance sheet that drive it.

For accountants, this is where three-way forecasting stops being theory. A client asks for help with a funding application, and a proper three-way model is the deliverable, built on data you already hold and priced as advisory work. For the short-term cash view that sits underneath it, see Thirteen weeks on one page.

Where it usually goes wrong

Building a three-way forecast by hand is hard, harder than most people expect going in. The three statements have to reconcile. The balance sheet has to balance in every single period. Retained earnings has to flow from the P&L, the cash line has to tie back from the cash flow, and working capital has to move in step across all three. One broken formula in month three, and every period after it is wrong.

So spreadsheet three-way models tend to be one of two things: wrong in a way nobody has spotted, or so fragile that nobody dares change an assumption in case it breaks. Neither is much use when a client is waiting on a funding decision.

Where Dash AI fits

Three-way modelling is the specific job Dash AI was built to take off your desk. Concretely, three things.

Built on your actual ledger. Dash connects to Xero, QuickBooks or Sage, so the model opens from real balances rather than a blank template, and the balance sheet reconciles because it is built from your own actuals.

The three statements stay linked. Change a price, a hire date or a payment term and it flows through profit, balance sheet and cash together, without re-plumbing a single formula.

The balance sheet balances by construction. There is no period three months in where it stops tying out without telling you, and no afternoon lost to finding the one that did.

What it will not do is set your assumptions. Whether debtors stretch to sixty days, whether the raise lands in the third quarter, whether you take the loan at all, those are still your calls. Dash keeps the mechanics honest so the time goes on the judgement.

The honest version

A three-way forecast is more work than a simple cash flow projection, and not every business needs one every month. If you are not raising finance, carry little stock or debt, and your cash converts quickly, a straightforward cash flow view may tell you enough. The three-way forecast earns its place when timing, financing or the balance sheet move the outcome, which, for most businesses that are growing, holding stock or borrowing, is exactly the situation they are in.

And it will not fix the underlying problem on its own. If customers pay in ninety days while suppliers want thirty, a three-way forecast will show you the squeeze in sharp detail, but closing it still means changing the terms, the pricing or the financing. The forecast makes the problem visible early. It does not make it go away.

Common questions

What is a three-way forecast?

A financial forecast that links the three core statements, profit and loss, balance sheet and cash flow, into one connected model. Change an assumption in one and it flows through the other two, so the numbers always reconcile.

Why do banks ask for a three-way forecast?

Because a profit forecast alone does not show whether a business can service its debt. Lenders want to see the cash position over time, and only the three-way model ties profit, working capital and financing together to show it.

What is the difference between a cash flow forecast and a three-way forecast?

A cash flow forecast shows money in and out. A three-way forecast shows that same cash flow alongside the profit and the balance sheet, and keeps all three linked, so you can see why the cash moved, not just that it did.

Can you build a three-way forecast in Excel?

You can, and plenty of people do. The hard part is keeping the balance sheet balanced in every period and the three statements reconciled as assumptions change. One broken link and the model stops reconciling, with nothing on the page to flag it, which is why spreadsheet three-way models are so often wrong without anyone noticing.

How far ahead should a three-way forecast go?

Twelve months is the usual horizon, extended to two or three years when you are raising finance or planning major investment. The further out you go, the broader the assumptions, so treat the later periods as direction rather than precision.