Finance Foundation
Cash Flow Forecasting If You Hate Spreadsheets

Cash flow forecasting has a reputation for being complicated. It isn't, or at least it doesn't need to be. The complexity usually comes from trying to build a forecast that does too many things at once — that serves as a budget, a scenario model, a board report, and an operational tool simultaneously. When you focus on what a cash flow forecast actually needs to do for an early-stage business, it becomes much more manageable.
The purpose of a cash flow forecast is simple: to tell you, with reasonable confidence, how much cash you will have at a future point in time. Everything else is in service of that answer.
The direct method: start with cash in, cash out
The most useful cash flow forecast for an early-stage company is built using the direct method: explicitly listing the cash you expect to receive and the cash you expect to pay out, week by week or month by month. This is different from working off your P&L — a P&L records revenue when it's earned and expenses when they're incurred, but cash forecasting cares about when the money actually moves.
The timing differences matter more than most founders realise. You might invoice a client in March and not receive payment until May. You might prepay six months of software licences in January that your P&L spreads across six months. Your payroll might hit the bank on the 25th of each month but your rent on the 1st — which means the first week of every month has higher cash outflows than any other week. A P&L doesn't show you any of this. A cash flow forecast does.
A simple 13-week rolling forecast
For most seed-stage businesses, a 13-week rolling cash flow forecast is the right tool. Thirteen weeks — one quarter — is far enough out to give you time to respond to problems before they become crises, and close enough in that the forecast is based on real, knowable information rather than speculation. You update it every week, dropping the week that just passed and adding a new week at the end.
The inputs to a 13-week forecast are: your opening cash balance, expected cash receipts from customers (based on actual invoices outstanding and realistic payment timing), expected salary and contractor payments, expected supplier payments (based on outstanding invoices and payment terms), and any other known large cash items — tax payments, loan repayments, capital expenditure. The output is a week-by-week cash balance that tells you where you're tight and where you have headroom.
When to extend the horizon
A 13-week forecast tells you about your near-term cash position. For strategic decisions — whether to hire, when to raise, how much runway you have before you need to act — you need a longer horizon. A 12–18 month cash model, built at the monthly level, serves this purpose. It's less precise than the 13-week forecast but more useful for planning. The two tools complement each other: the 13-week forecast for operational management, the 12-month model for strategic planning.
Most founders who resist cash flow forecasting are thinking of the complicated version. The simple version — a 13-week rolling forecast and a monthly strategic model — takes about two hours to set up and 30 minutes per week to maintain. The value it provides, in terms of early warning on cash constraints and confidence in strategic decisions, is out of proportion to the time investment.



