Building a 12-Month SaaS Cash Flow Forecast: The Template and the Method

Building a 12-month cash flow forecast is the most important financial exercise for early-stage SaaS founders. This guide walks you through the template structure, month-by-month logic, and how to avoid common errors.

The Monthly Forecast Structure

Each month row contains the same line items:

This ending balance becomes Month 1's starting balance. Repeat for 12 months.

Step 1: Gather Starting Data

Before building the forecast, collect this information:

• Current cash on hand (bank balance as of today)
• Current monthly revenue recognised (ARR / 12)
• Last 3 months of actual collections (cash collected, not revenue)
• Monthly headcount plan for next 12 months
• Monthly payroll estimate (salary + benefits + employer taxes)
• Monthly vendor costs (AWS, Stripe, tools, contractors, opex)
• Any planned capex, loan payments, or tax payments
• Your customer billing mix (% annual, % monthly, % quarterly)
• Average days sales outstanding (DSO) for each billing type

Step 2: Model Revenue Collections

The critical distinction: revenue recognised (P&L) vs revenue collected (cash). Model collections, not revenue.

Monthly Billing (net-30 terms):

A customer invoiced for €1,000 on April 1 is collected on May 1 (30 days later). 100% collected in the month after invoice. Assume 95% collection rate (1-2% payment failures).

Annual Billing (upfront):

A customer paying €12,000 annual on April 1 is collected April 1. 100% collected in month signed. Assume 98% collection rate (upfront payment has lower failure rate).

Example (April forecast):

• April monthly revenue booked: €95,000 (new customers signed)
• Billing mix: 60% monthly, 40% annual
• Monthly portion: €57,000 (60% of €95,000) – invoiced April, collected May
• Annual portion: €38,000 (40% of €95,000) – collected April upfront
• April collections include:
• — March monthly bookings: €54,000 x 95% = €51,300
• — April annual bookings: €38,000 x 98% = €37,240
• — Existing customer renewals, past due invoices
• Total April collections: ~€95,000 (this month) + €51,300 (prior) = €146,300

The key: April revenue recognised is €95,000, but April cash in is €146,300 (because of prior month monthly collections plus April annual collections). This is why annual billing accelerates cash.

Step 3: Project Monthly Expenses

Break expenses into categories and project them realistically:

Payroll: List all employees, their monthly salary, and burden (benefits, taxes, etc.). Standard burden in UK/EU is 20-25% of salary; in US it's 30-35%. Example: €5,000 salary + 25% burden = €6,250 monthly cost per employee.

Contractors: List active contractors and their monthly fees. Note: contractor payments are typically net-30 or net-45 from invoice, so last month's invoices are paid this month.

Cloud Infrastructure: AWS, Google Cloud costs typically scale with usage. Project based on current usage + expected growth. Example: €8,000/month, growing 5% monthly.

Subscriptions and Tools: List all SaaS tools (CRM, analytics, design tools, GitHub, etc.). Total typically €4-8k/month for a 10-person team.

Fixed Costs: Rent, insurance, office supplies, etc. These don't change month-to-month.

Variable Costs: If you have variable COGS (per-user hosting, credit card processing fees), calculate as % of revenue.

Step 4: Build the Monthly Forecast

Month 1 (April):

Starting Cash:          €2,500,000
Collections:            €146,300
  (March monthly + April annual + renewals)

Cash Out:
  Payroll:              €210,000
  Contractors:           €15,000
  AWS:                   €18,000
  Tools/subscriptions:    €6,500
  Rent:                  €12,000
  Insurance:              €3,500
  Other opex:            €8,000
Total Cash Out:         €273,000

Net Cash Flow:          €146,300 - €273,000 = -€126,700
Ending Cash:            €2,500,000 - €126,700 = €2,373,300

Month 2 starting cash is €2,373,300. Repeat for each month.

Step 5: Reconcile to Your P&L

Your 12-month cash flow should roughly reconcile to your 12-month P&L over the full year. Why? Because accrual-basis revenue eventually becomes cash (minus bad debt), and accrual-basis expenses become cash (minus accrued bonuses and other timing differences).

Reconciliation Check:

• Sum of all 12 months collections should be roughly 95-98% of 12 months P&L revenue (accounts for bad debt)
• Sum of all 12 months cash expenses should be 95-105% of 12 months P&L expenses (accounts for accruals, prepaid expenses, timing)

If your 12-month collections are €700k but your P&L shows €1m revenue, you have a problem: either your collections model is wrong, or your P&L revenue assumes deals that won't close.

Step 6: Model Three Scenarios

Create three copies of the forecast:

Base Case: Your realistic forecast. Revenue grows as planned, collections in line with history, expenses as budgeted. Ending cash is your base runway measure.

Optimistic Case: Revenue grows 15-20% faster, churn improves by 25%, collections improve by 2% (better execution). This is your bull case showing upside.

Conservative Case: Revenue growth stalls, churn rises 50%, collections slip 5% (macro headwinds, slower sales). This is your bear case survival scenario.

For each scenario, identify the month where cash reaches a critical level (€100k, €200k) as a trigger to act (fundraise, cut costs).

Step 7: Update Monthly

At the end of each month, update the forecast:

• Record actual cash in and cash out
• Compare to forecast (variance analysis)
• Update the forecast for Months 2-13 with new information
• Share with your CFO, board, and advisors

Over time, your forecast accuracy improves. Your first forecast might be 30% off. By Month 6, you're within 10%. This is normal and expected.

Common Errors to Avoid

Error 1: Using Revenue Instead of Collections

Revenue recognised and cash collected are different. Only cash counts. If you model €100k monthly revenue but collect €70k (due to payment terms or bad debt), your net burn is higher than you think.

Error 2: Forgetting Annual Expenses

Annual insurance, annual software renewals, bonus payouts, and tax payments create cash spikes. If you have three annual expenses of €20k each in Q4, you have a €60k cash outflow spike that month. Don't forget to model these.

Error 3: Not Including Contractor Invoicing Lag

A contractor invoices on April 15, gets paid on May 15 (net-30). Month 4 cash out is May; don't include it in April. Get invoicing dates and payment terms for all contractors.

Error 4: Forgetting Tax Payments

In the UK, corporation tax is paid 9 months after year-end; quarterly instalments if you're profitable. In the US, quarterly estimated tax is due. Model these explicitly, especially if you're approaching profitability.

Error 5: Not Reconciling to P&L

If your 12-month collections don't roughly match your P&L revenue, there's an error. Spend 30 minutes reconciling to catch these errors early.

When to Update and Review

Monthly: Update with actual results, reforecast the remaining 11 months.
Quarterly: Share with board and advisors.
When major changes occur: New customer, big churn, hiring spree, market shift. Update immediately.

Key Takeaways

• Monthly structure: starting cash + collections - expenses = ending cash.
• Model collections by billing type (annual upfront, monthly net-30). Use actual DSO, not assumptions.
• Include every expense: payroll, contractors, cloud, tools, rent, insurance, taxes, capex.
• Reconcile 12-month collections to P&L revenue; reconcile 12-month expenses to P&L expenses. Catch errors early.
• Create three scenarios: base, optimistic, conservative. Each shows different survival runway.
• Update monthly. This is your operating dashboard, not a one-time exercise.