Cash Flow Budget for Startups: 13-Week Forecast, Scenario Planning, and Runway Control

Why a cash flow budget beats a P&L in startup reality

P&L shows performance; cash flow shows survival. Startups live and die by payment timing. A cash flow budget translates sales, invoices, and terms into bank movements, giving precise visibility on runway and funding needs. For a broader budgeting strategy, see the companion guide: budget for startups.

Design principles: earn vs invoice vs cash

Model three layers explicitly: recognition (revenue/expense), invoicing, and payment. The cash model tracks layer three while respecting the other two. Always reconcile with bank statements.

The structure: seven tabs for board-ready clarity

1) Opening/Cash, 2) Cash In (customer receipts by invoice), 3) Cash Out (vendors, payroll, taxes), 4) CapEx & Financing, 5) VAT/Taxes, 6) Scenarios, 7) Dashboard.

Step-by-step implementation

Step 1: Time buckets

Use monthly columns for 18 months and weekly columns for a rolling 13-week forecast. This dual zoom supports both strategic and tactical decisions.

Step 2: Data intake

Import invoice lists (customers/vendors) with due dates, payroll calendar, tax schedules, loan amortization, CapEx plan, and grant tranches. Tie historical actuals to bank statements to validate timing assumptions.

Step 3: Convert pipeline to receipts

Map pipeline → orders → invoices → due dates → payments. Apply stage probability for opportunities and historical DSO. Example: Receipts_month = Σ(Invoices with due in month) * (1 - expected slippage%).

Step 4: Payment plans for outflows

Represent each outflow as a schedule: vendor terms (N14/30), annual software prepayments, payroll last banking day, rent first day. Large purchases become milestone payments rather than single hits.

Step 5: VAT and taxes

Compute output vs input VAT per period and place settlement in the legal due month. Add payroll taxes, social contributions, and corporate tax prepayments as separate lines to avoid masking spikes.

Step 6: Capital and credit

Include equity tranches, convertibles, grants, and their payment dates. For credit lines: model draw/repay, interest accrual, and covenants. Add a minimum-cash guardrail to trigger mitigation actions.

Step 7: One cash curve to rule decisions

Formula: Ending Cash = Beginning + Cash In - Cash Out per bucket. Visualize with markers for payroll, VAT, and debt service. Flag when cash < 2 months of net burn.

Cash drivers that matter

• DSO/DBO control: Base on history plus conservative buffers. Renegotiate DBO with key vendors.
• Milestone billing: Break large enterprise deals into deposits and delivery milestones.
• Annual prepay: Offer discounts to pull forward cash; recognize revenue over time in P&L but take cash upfront.
• Collections: Automated dunning at day 7/14; include payment links and soft-locks for chronic late payers.

Scenario planning that moves the needle

Best: higher prepayments, faster onboarding, deferral of noncritical spend. Base: historic DSO/DBO. Worst: 30-day delays on top 10 accounts, 5% write-offs, no annual prepay, VAT back-payment. Toggle scenarios via named ranges for instant model shifts.

13-week cash: concrete layout

Rows: Opening Cash; Inflows—Subscriptions (renewals, annual prepay), Enterprise milestones, Grants; Outflows—Payroll (gross, taxes, benefits), Payroll taxes, Vendors (hosting, ads, hardware), Software renewals, Rent, VAT, Debt service, Other. Columns: Weeks 1–13 + Total.

Controls before sharing

• VAT settlement in correct month?
• Annual software placed on the actual renewal date?
• Enterprise payment behavior realistic?
• Payroll and payroll taxes aligned?
• Any negative daily/weekly balance indicating overdraft fees?

Operating cadence

Weekly: Roll the 13-week window, update collections status, match new invoices. Monthly: Close actuals vs forecast, explain variances, update assumptions. Quarterly: Rework vendor terms, revisit credit line, stress-test scenarios.

Formulas and heuristics

Runway (cash): Months = Ending Cash / Avg Monthly Net Burn
Net Burn: Cash Out - Cash In
Buffer: target ≥ 3 months of net burn; raise when forecasted runway enters 6–9 months.

Frequent mistakes and quick fixes

• Confusing P&L with cash → always model by payment dates.
• Ignoring annual renewals → keep a renewal calendar and place cash on renewal week.
• No dunning workflow → automate reminders and enforce soft locks.
• No scenarios → operate based on worst case to preserve runway.

Ready for fundraising

Show a before/after cash curve with the planned raise, including tranche dates and runway extension. Anchor investor discussions in cash visibility rather than only P&L. For complementary budgeting strategy, see startup budget guide. Explore more resources at Foundbase.io.