How to Build a Cash Flow Forecast

A cash flow forecast answers one question that matters more than any other in a startup: how many months until the bank account hits zero?

Profit is an accounting construct. Cash is oxygen. A company can show a healthy P&L while running out of money - because customers haven’t paid yet, because a tax bill lands in Q3, or because a single month of high hiring cost more than projected. This guide shows you how to build a 12-month cash flow forecast from scratch, with real numbers and the discipline to keep it accurate over time.

Profit vs Cash Flow: Why They Differ

Before building the model, understand why profit and cash are different.

Example: In January you close a €20,000 contract with net-60 payment terms. Your P&L shows €20,000 revenue in January. Your bank account shows €0 additional cash in January and €20,000 in March. If your payroll is due in February, the P&L says you’re profitable; the bank says you’re short.

This gap - known as the cash conversion cycle - is why profitable startups go bankrupt every year.

Direct vs Indirect Method

There are two ways to build a cash flow forecast:

Use the direct method. It is transparent, requires no accounting knowledge to read, and maps directly to your bank statements. Every number in a direct forecast answers: “Did cash go in or out of the account, and when?”

Step 1 - Separate Profit from Cash Flow

Write down your last three months of bank statements alongside your P&L. Identify every line that differs between them. Common sources of divergence:

• Accounts receivable: Invoices raised but not yet collected
• Accounts payable: Bills received but not yet paid
• Deferred revenue: Customers who prepaid (common in SaaS)
• Payroll timing: Salary costs hit P&L in the month worked but may be paid on the 25th or last day
• Tax deposits: VAT/GST collected from customers and held until the quarterly filing

Once you can explain the reconciliation between profit and cash, you understand the model you’re about to build.

Step 2 - Choose the Direct Method

Open a spreadsheet. Create the following structure:

Row 1:  Opening Balance
Row 2:  --- INFLOWS ---
Row 3:  Customer receipts
Row 4:  Investor capital
Row 5:  Grants / other receipts
Row 6:  TOTAL INFLOWS  (sum rows 3–5)
Row 7:  --- OUTFLOWS ---
Row 8:  Payroll (salaries + employer taxes)
Row 9:  Rent & facilities
Row 10: Software & subscriptions
Row 11: Marketing & paid acquisition
Row 12: COGS / cost of delivery
Row 13: Loan repayments
Row 14: VAT / tax settlements
Row 15: Capex / one-off purchases
Row 16: TOTAL OUTFLOWS (sum rows 8–15)
Row 17: NET CASH  (row 6 minus row 16)
Row 18: Closing Balance  (row 1 + row 17)

Columns are months: Jan, Feb, Mar … Dec.

Key formula: Closing Balance = Opening Balance + Total Inflows − Total Outflows. The next month’s Opening Balance = prior month’s Closing Balance. This chain must be unbroken.

Step 3 - Map Your Cash Inflows

For each month, estimate the cash that will actually land in the bank.

Customer receipts - the most important line. Do not use your revenue forecast directly. Apply your payment lag:

• If you invoice net-30, month 1 revenue arrives in month 2
• If you invoice net-60, month 1 revenue arrives in month 3
• SaaS subscriptions billed upfront arrive in the same month

Example (B2B SaaS, net-30 invoicing):

Investor capital - enter the exact expected wire date. If a round is expected to close in April, model the cash arriving in April, not March. Fundraising timelines slip; build in a one-month buffer.

Grants - enter the disbursement schedule from the grant agreement, not the award date. Governments routinely take 60–120 days to transfer approved funds.

Step 4 - Map Your Cash Outflows

This is where most forecasts fail. Founders model the obvious monthly costs and forget the lumpy ones. Work through every category:

Payroll - the biggest outflow for most startups. Include:

• Gross salaries
• Employer social security / payroll taxes (typically 15–30% on top of gross depending on jurisdiction)
• Pension contributions
• Any bonus payments (quarterly or annual)

Example at a 12-person team with €60,000 avg salary: monthly gross payroll ≈ €60,000. Add 20% employer taxes → €72,000 cash out per month.

Periodic outflows to model explicitly:

Rule of thumb: your first draft will miss 15–20% of outflows. After you build the model, ask your accountant or CFO to review it line by line before you use it for decisions.

Step 5 - Build the Monthly Grid

Here is an illustrative 3-month extract from a 12-person SaaS startup:

Note: the February software line includes a €20,000 annual AWS renewal. Without it explicitly modeled, February shows €4,200 - a €20,000 blind spot.

Step 6 - Stress-Test with Scenarios

Never present or manage to a single scenario. Build three:

The downside case is the most important. If downside runway drops below 6 months, that is a crisis signal - not a planning footnote.

Typical downside lever: if you model 20 new customers/month in base, use 13 in downside. Keep COGS and fixed costs constant - they don’t compress automatically when revenue disappoints.

Step 7 - Use the Forecast to Manage Runway

Runway = Closing Balance in month N ÷ average monthly burn.

More precisely: count the month at which Closing Balance first goes negative. That is your runway.

Updating the forecast:

1. At month-end, replace forecast figures with actuals from your bank statement
2. Reforecast the remaining months with updated assumptions
3. Calculate forecast vs actual variance for every line item
4. Investigate any line with >15% variance - either your assumption was wrong or something unexpected happened

Warning thresholds:

Common Mistakes to Avoid

1. Booking revenue on invoice date, not collection date - your cash forecast will overstate cash for weeks or months
2. Forgetting VAT/GST - if you’re VAT-registered, the money you collect from customers includes tax you owe to the government; it is not your cash
3. Ignoring annual renewals - a €50,000 AWS or Salesforce renewal in month 7 can flip a comfortable month into a cash crunch
4. Building one scenario - a single-scenario forecast provides no information about risk; you don’t know if the business survives a 30% revenue miss
5. Not updating monthly - a forecast built in January and never touched is fiction by April. Actuals must replace estimates as they come in

Key Takeaway

A 12-month cash flow forecast built with the direct method - mapping actual receipts and payments by month, modeled in three scenarios, updated monthly against actuals - is the most important financial tool a startup founder can maintain. It tells you precisely how much time you have, gives you enough lead time to respond to a deteriorating situation, and demonstrates financial discipline to every investor, board member, and lender you will ever work with. Build it before you need it; the time to understand your runway is not when you have three months left.