Engineer a Cash Flow Model That Shows You Exactly Where Your Money Is Hiding
Why revenue projection is inadequate without the realism of expected future cash takings
Daniel locked up the office on the last Friday of January feeling, for the first time in two years, like a man who had genuinely cracked it. Three new clients signed in one month, the pipeline was full, and the team had delivered without a single complaint. He set his alarm for Monday morning and allowed himself, finally, to exhale. When Monday came, his phone was already ringing before Daniel was out of his house — it was the bank, and the news it carried felt nothing like the sense of success he had just three days earlier.
The Spreadsheet That Tells the Wrong Story
Daniel’s revenue projections were accurate. His cost estimates were reasonable. The arithmetic was clean. What the spreadsheet could see was that January had been exceptional. However, a critical piece of information had remained on the blind spot: the distance between exceptional revenue and available cash — and in that distance, Daniel’s business had quietly run out of road.
Most early-stage founders plan their finances exactly the way Daniel did. They project monthly revenue, subtract anticipated costs, and treat the resulting figure as their financial position. The logic feels sound. The numbers add up. But the result is a document that describes what a business hopes will happen, dressed up in the language of what the business expects to happen. After all, when your customer agrees to your terms and gives you firm dates, you should be justified to hold them to their word, shouldn’t you?
Revenue projections carry this optimism as a default. The deals that will close, the client who said, “next month,” the contract sitting with legal — all of it lands in the model as if it were already in the account. Cost estimates, meanwhile, tend to capture the known and committed while quietly ignoring friction: the delivery that needed a re-run, the subscription that auto-renewed at the worst possible moment, the specialist brought in to fix the thing that broke on a Wednesday. Neither distortion announces itself. Both feel, at the time of projection, like grounded and careful estimates.
That is the trap. It is pitch-deck thinking that has been applied to operational planning.
The Gap Every Founder Needs to Map
The Lead-to-Cash timeline is the elapsed time between the moment a sale is closed and the moment the resulting cash is available to spend. It moves through four stages: a lead becomes a sale, a sale generates an invoice, an invoice produces a payment, and that payment clears into the business account as spendable funds. Each transition takes time. Each introduces friction — approval chains, payment terms, processing delays, the client who pays on day 32 of a 30-day cycle.
For a small consulting firm in Toronto, a design studio in Amsterdam, or a product business supplying trade customers in Singapore, this timeline typically runs between 30 and 90 days. The monthly cash flow model records the sale in January. The cash arrives in March.
Here is the detail that catches founders off guard: as the business grows, this gap grows with it. Ten clients on 45-day payment terms is a manageable exposure. Forty clients on the same terms is a serious cash position hiding behind strong revenue numbers. Founders who have never mapped this gap tend to read the resulting cash pressure as evidence that something has gone wrong. More often, it is evidence that something has gone right — and that the business has outgrown a planning method built for an earlier, smaller version of itself.
Building a Fitting Cash-Flow Model
To anticipate your future, operational cash flows correctly, you need evidence-based cash flow projection, and it is a lot simpler than it sounds. The vague anxiety of “cash might get tight” is considerably harder to address, because it has no shape, no date, and no number attached to it.
One rule governs the entire approach: every number in the model must trace back to a real, verifiable source. That is the ‘evidence-based’ aspect and it comprises historical data from the business itself, confirmed supplier quotes, and actual payment timelines from existing customers. Where genuine data is unavailable, assumptions are written down, clearly labelled as such, and buffered — costs inflated by 20%, revenue estimates discounted by 20%. That single discipline, applied without exception, transforms a projection from a statement of intent into a working planning tool.
Our evidence-based cash flow model requires five inputs.
The first is the opening cash balance — the figure in the business bank account today, counting only what has cleared. The second is confirmed incoming cash: invoices already issued, due within the period, from customers with a track record of paying on time. The third is probable incoming cash: sales closed but not yet invoiced, or invoiced without a confirmed payment date — entered into the model at 70% of face value. The fourth is confirmed outgoing cash: every committed cost with a known payment date. The fifth is probable outgoing cash: anticipated costs without confirmed dates, entered at 120% of their estimated value.
These five inputs, mapped across the next eight to twelve weeks — weekly, because cash crises arrive in weeks rather than months — produce a projected cash position for each period ahead. Within that projection sits one number that matters above all others: the low point. The week in which the cash position is at its most stretched.
A low point that sits comfortably above zero is permission to move — to hire, to invest, to pursue the next stage of growth with genuine confidence. A low point at or below zero is specific, actionable intelligence: a defined shortfall, arriving in a known week, with enough lead time to address it. All things being equal, that is a solvable problem.
From Optimism to Architecture
The shift this model asks for is a thinking shift, and it is available to every founder regardless of background or sector. When the habit of planning from evidence replaces the habit of planning from hope, three things follow. Decisions about spending and growth are made against a known cash position. Conversations with lenders and investors change character entirely — a founder presenting a weekly, evidence-based cash flow model is presenting facts, and that commands a different quality of attention. The low-grade financial anxiety that accompanies uncertainty is replaced by something far more useful: the specific, manageable discomfort of knowing exactly where the pressure is, and having enough time to do something about it.
Daniel’s Monday morning phone call was the consequence of a gap he had never been taught to measure. That gap is visible, mappable, and entirely within a founder’s power to manage — once they know to look for it.
To build your first eight-week evidence-based cash flow model using only the data you already have, download the companion Evidence-Based Cash Flow Starter Checklist.