Startup Cash Flow Tracker: Calculate Runway and Burn Rate with the CASH Model

A startup cash flow tracker is the essential operational tool for measuring net burn and projecting runway. This guide explains what belongs in a practical tracker, how to calculate burn rate and runway, and a repeatable framework for scenario testing and decision-making.

How to build a startup cash flow tracker

Start with a simple ledger that records cash receipts and disbursements by month and category. The core fields are opening cash, cash receipts (sales, financing), cash disbursements (payroll, rent, vendors, taxes, capex), and closing cash. The primary metric to derive is net burn, which feeds directly into runway projections and the runway and burn rate calculator used for fundraising and planning.

What to include in the tracker

Essential data columns

• Opening cash balance
• Operating cash inflows (MRR, one-off sales, interest)
• Operating cash outflows (COGS, payroll, rent, marketing)
• Financing inflows and debt repayments
• Capex and one-time investments
• Closing cash balance (calculated)

Key derived metrics

• Gross burn: total cash outflows in a period
• Net burn: total cash outflows minus cash inflows in a period
• Runway: current cash balance divided by average monthly net burn
• MRR growth rate and churn (for subscription models)

CASH Model checklist for reliable runway projections

Use the CASH Model as a quick operational checklist before sharing forecasts with investors or making hiring decisions:

• Capture — Record all cash transactions by category and date.
• Analyze — Compute gross burn, net burn, and average monthly changes.
• Scenario-test — Build best, base, and worst-case monthly projections for 6–18 months.
• Hold reserves — Define a minimum cash buffer and trigger actions when runway hits thresholds.

Example scenario: calculate burn rate and runway

Startup Alpha has $150,000 in the bank. Monthly receipts average $20,000 (sales), monthly operating expenses total $45,000. Net burn = 45,000 - 20,000 = 25,000 per month. Runway = 150,000 / 25,000 = 6 months. If a cost reduction plan cuts expenses to 35,000, new net burn becomes 15,000 and runway increases to 10 months. This simple calculation is the foundation of the runway and burn rate calculator used in planning conversations.

How to build a runway and burn rate calculator

Design a calculator or spreadsheet with these sections: inputs, monthly forecast table, summary metrics, and sensitivity controls. Inputs should include starting cash, expected monthly revenue, fixed and variable expenses, payroll schedule, and any planned one-time spends. Add toggles for fundraising or hiring scenarios and formulas that update net burn and runway automatically.

Practical tips

• Keep the tracker monthly and update it at least once per week when cash is tight.
• Distinguish non-cash accounting items (depreciation) from cash flows so net burn is accurate.
• Use rolling three-month averages for volatile revenue streams to smooth runway estimates.
• Automate bank-feed reconciliation where possible to reduce manual errors.
• Link scenario buttons to display how hiring or price changes alter runway instantly.

Trade-offs and common mistakes

Common mistakes

• Counting booked revenue instead of actual cash receipts, which overstates runway.
• Mixing capital financing with operating cash in net burn calculation—keep financing separate.
• Failing to include timing lags (AR, AP) that shift cash flow across months.
• Not building worst-case scenarios; lack of stress-testing leads to surprise shortfalls.

Typical trade-offs

• Precision vs. speed: detailed daily models are accurate but time-consuming; monthly models are faster and sufficient for most decisions.
• Simplicity vs. visibility: keep a compact tracker for leadership but maintain a separate detailed ledger for accounting and audits.
• Conservatism vs. growth: aggressive revenue assumptions reduce perceived burn but increase risk; use conservative base cases when planning runway.

For official guidance on small-business cash management practices and planning, consult the Small Business Administration resources on cash flow management: Small Business Administration.

Implementation checklist before investor meetings

• Confirm closing cash balance from bank statements.
• Present net burn for the last three months and projected runway under three scenarios.
• Document assumptions behind revenue and expense projections.
• Include a contingency plan: action items at runway thresholds (e.g., 6 months, 3 months, 1 month).

FAQ: How to build a startup cash flow tracker?

Start with a monthly spreadsheet that lists opening cash, cash receipts, cash payments, and closing cash. Compute net burn (outflows minus inflows) and divide current cash by net burn to get runway. Add scenario tabs for hiring, fundraising, and sales changes. Keep financing separate from operating cash flow.

FAQ: What is the difference between gross burn and net burn?

Gross burn is total cash spent each month. Net burn subtracts operating cash receipts from gross burn, showing how much cash the company loses monthly. Net burn is the preferred metric for runway calculations.

FAQ: How often should the cash runway be updated?

Update the cash runway weekly when runway is under 12 months; monthly updates are typical when runway is more than 12 months. Increase frequency around fundraising, major hires, or revenue volatility.

FAQ: Which expenses should be excluded from cash runway calculations?

Exclude non-cash accounting items like depreciation and amortization. Separate financing inflows (equity, loans) and debt principal repayments from operating net burn; include them in a separate financing schedule.

FAQ: Can a cash runway be extended without raising capital?

Yes. Common actions include cutting discretionary spending, delaying hires, renegotiating vendor terms, increasing prices, or accelerating receivables. Each action should be modeled in scenario tests to show impact on runway.