A profit and loss statement tells you whether the business made money last month. It doesn't tell you whether there's enough cash in the bank to make payroll next month. Those are two different questions, and startups get into trouble more often from the second one than the first.
A cash flow forecast answers the question that actually matters day to day: how much cash will the business have, and when. It's one of the simplest financial tools available to a founder, and also one of the most consistently skipped, usually because it sounds more complicated than it is.
This is a practical walkthrough of building one from scratch — no accounting background required, no expensive software needed to start.
Why a Cash Flow Forecast Matters More Than a Budget
A budget describes what you plan to spend. A cash flow forecast describes what you'll actually have available, factoring in timing — when invoices get paid, when payroll goes out, when a big expense hits. Two businesses can have identical budgets and completely different cash positions, simply because of when money moves in and out.
This distinction matters most for startups because timing gaps are common and often severe. A client who pays net-60 can leave a real gap between delivering the work and having the cash from it, even if the business is profitable on paper. A cash flow forecast is what surfaces that gap early enough to plan around it.
Quick Comparison: Forecast Approaches by Startup Stage
Stage | Recommended Approach | Update Frequency |
|---|---|---|
Pre-revenue / early idea stage | Simple monthly forecast, 6–12 months out | Monthly |
Early revenue, unpredictable | 13-week rolling forecast | Weekly |
Steady recurring revenue (SaaS) | Monthly forecast, 12–18 months out | Monthly, revisited after big changes |
Preparing to raise or facing tight runway | 13-week rolling forecast | Weekly, sometimes daily |
The tighter the runway or the more unpredictable the revenue, the more frequently the forecast needs updating. A well-funded SaaS company with predictable subscriptions can get away with monthly updates. A pre-seed startup burning through savings cannot.
Building the Forecast: Step by Step
Step 1: Start With Your Actual Cash Balance
This sounds obvious, but the starting point has to be the real number in the bank account today, not a rounded estimate. Every projection from here builds on this figure, so an inaccurate starting point undermines everything that follows.
Step 2: List Every Cash Inflow, By Date
This isn't the same as listing revenue. It's listing when cash actually arrives. If a customer signs a contract in March but pays net-30, that cash shows up in April, not March. For startups with a mix of payment terms, this step alone often reveals gaps that a simple revenue projection would have missed entirely.
Include every source: customer payments, any remaining investment tranches, loan disbursements, tax refunds — anything that adds cash to the account on a specific date or within a specific window.
Step 3: List Every Cash Outflow, By Date
Same principle in reverse. Payroll, rent, software subscriptions, contractor payments, loan repayments, taxes — mapped to when they actually leave the account, not when they were budgeted.
Founders often underestimate irregular outflows here — annual software renewals, quarterly tax payments, or one-time equipment purchases — because they don't happen every month and are easy to forget when building a forecast focused on recurring costs.
Step 4: Calculate Net Cash Flow for Each Period
For each week or month in the forecast, subtract total outflows from total inflows. This gives you the net change in cash for that period — positive if more came in than went out, negative if the reverse.
Step 5: Roll the Balance Forward
Starting cash balance, plus or minus each period's net cash flow, gives you the projected ending balance for that period — which becomes the starting balance for the next one. This rolling calculation is what turns a list of numbers into an actual forecast, showing exactly where the cash position is heading over time.
This is the number that matters most: the lowest point your projected cash balance reaches. If that number goes negative at any point in the forecast, that's your warning — with enough lead time to actually do something about it.
Step 6: Build in a Buffer for Uncertainty
Real cash flow rarely matches a forecast exactly. Customers pay late. Expenses come in higher than expected. A reasonable buffer — some founders use 10–15% padding on expected inflows, or a few weeks' delay assumption on customer payments — makes the forecast more realistic and less likely to create false confidence.
Common Mistakes When Building a Cash Flow Forecast
Using revenue instead of actual cash timing. This is the single most common error. A forecast built on when revenue is recognized, rather than when cash actually arrives, can look healthy right up until the moment it isn't.
Forgetting irregular, non-monthly expenses. Annual insurance premiums, yearly software renewals, and quarterly taxes are easy to leave out of a forecast built around "typical monthly costs," and they tend to land unexpectedly when they finally hit.
Building the forecast once and never updating it. A forecast is only useful if it reflects reality. One built in January and never touched again is stale by March, especially for an early-stage business where circumstances change quickly.
Being overly optimistic about payment timing. Assuming every customer pays exactly on time is rarely realistic. Building in a modest delay assumption, based on actual historical payment behavior, makes the forecast far more reliable.
Not distinguishing between committed and uncertain inflows. Confirmed revenue and hoped-for revenue (a deal "likely" to close) belong in different columns. Blending them together makes the forecast look more solid than it actually is.
Best Practices for Ongoing Cash Flow Management
Update the forecast on a fixed schedule — weekly if runway is tight, monthly if it's comfortable
Track forecasted numbers against actuals regularly, and adjust future assumptions based on where the gaps show up
Separate confirmed inflows from probable ones, and weight the forecast toward what's confirmed when runway is tight
Flag the lowest projected cash point clearly, and treat it as the number that drives urgent decisions
Use a simple spreadsheet before investing in forecasting software — the discipline matters more than the tool at the early stage
A cash flow forecast doesn't need to be perfectly accurate to be useful. It needs to be directionally right and updated often enough to catch problems while there's still time to act.
FAQs
How far out should a startup's cash flow forecast go? For startups with tight runway, a rolling 13-week forecast is common because it balances enough lead time with reasonable accuracy. For more stable businesses, forecasting 12–18 months out can work well for longer-term planning, alongside a shorter, more detailed near-term view.
Do I need accounting software to build a cash flow forecast? No. A spreadsheet is enough to start, especially for an early-stage business with a manageable number of transactions. Dedicated cash flow software becomes more useful as transaction volume and complexity grow.
What's the difference between a cash flow forecast and a cash flow statement? A cash flow statement reports what already happened. A cash flow forecast projects what's expected to happen. Both matter, but the forecast is the one that helps you act before a problem occurs rather than after.
How often should the forecast be updated? This depends on how tight the runway is and how predictable revenue is. Startups with limited runway or unpredictable revenue benefit from weekly updates; more stable, well-funded businesses can often update monthly.
What should I do if the forecast shows a negative cash balance in a few months? Treat it as an early warning, not a crisis. Depending on the situation, options usually include cutting costs, accelerating collections, delaying non-essential spending, or starting a fundraising or lending conversation earlier than planned.
Should the forecast include revenue that isn't confirmed yet? It can, but it should be clearly separated from confirmed revenue, often in its own line or column, so the forecast doesn't overstate how solid the cash position actually is.
Is a cash flow forecast still necessary once a startup is profitable? Yes. Profitability and healthy cash flow aren't the same thing, and even profitable businesses can face cash timing gaps, particularly if they're growing quickly or dealing with slow-paying customers.
Conclusion
A cash flow forecast isn't a finance-team luxury reserved for larger companies. It's one of the most direct tools a founder has for seeing a cash problem coming with enough time to actually respond to it. Building one doesn't require expensive software or a finance background — it requires an honest list of when money actually moves, updated often enough to stay useful.
Comments (0)
No comments yet. Be the first to comment!