What's Inside the Template
- Forecast tab: 13 weeks across, with grouped inflow categories (collections, new bookings, financing) and outflow categories (payroll, SaaS, rent, marketing, taxes, debt service).
- Actuals vs Forecast tab: enter weekly actuals, automatic variance percentages on inflows, outflows, and ending cash.
- Built-in metrics: average weekly net burn and implied runway in weeks, recalculated as you update inputs.
- Color-coded cells: blue for inputs, black for formulas, green for cross-sheet links, the same convention used in institutional finance models.
Why a 13-Week Cash Flow Forecast Beats a P&L
A profit and loss statement tells you whether you're profitable. A 13-week cash flow forecast tells you whether you'll still be in business in 90 days. Most startup failures aren't profitability failures, they're liquidity failures: payroll on the 15th, a customer payment that slipped, an annual insurance renewal nobody planned for. The 13-week horizon is long enough to see the next major cash events coming and short enough that every line item is forecastable with high accuracy.
How to Use This Template (5-Minute Setup)
- Enter your starting cash balance (cell B5 on the Forecast tab).
- Set Week 1's date, the rest auto-fill weekly.
- Forecast inflows: customer collections, new bookings, financing events.
- Forecast outflows: payroll, contractors, SaaS, rent, marketing, taxes, debt.
- Read your runway: the model auto-calculates average weekly burn and implied weeks of runway.
- Update weekly: swap in actuals on the variance tab to keep the forecast honest.
Best Practices for Weekly Cash Forecasting
- Update every Monday morning, before any weekly leadership meeting.
- Roll forward, drop the completed week, add a new week 13. Keep the horizon constant.
- Forecast collections by named customer when you have fewer than 50 active accounts.
- Always include a "miscellaneous" line item, real-world spend never fits perfectly into your categories.
- Annotate variances over 15%, the goal isn't a perfect forecast, it's a model you can defend in a board meeting.
Who This Template Is For
Founders and finance leads at pre-seed through Series B startups, especially SaaS, services, and subscription businesses. If you're managing 6 to 24 months of runway and need to brief your board, your investors, or yourself on cash position with confidence, this template is for you.
Frequently Asked Questions
How is this different from a 12-month budget?
A 12-month budget tracks accrual P&L by month. A 13-week cash flow tracks actual cash movement by week, when invoices are paid, when payroll hits, when taxes are due. Both matter; this one keeps you alive.
Does this work for non-SaaS businesses?
Yes. The categories are built for subscription businesses but the structure works for any company: rename categories to match your business and the formulas still work.
Can I share it with my board?
Absolutely. The model is designed to be presentation-ready as is, or copy the runway and burn outputs into your board deck.