Cash Runway Management: A Monthly Founder Finance Dashboard
Cash Runway Management: A Monthly Founder Finance Dashboard
Most UK founders know when they're running low on cash. Fewer know exactly how long they have left. Even fewer have a system to predict, track, and defend that runway before the crisis hits.
Cash runway—the number of months your business can operate before running out of money—is the single most important financial metric for early-stage founders. Yet the majority of startups fail not because their product is bad, but because they miscalculated burn rate, missed seasonal revenue shifts, or failed to account for VAT bills and payroll tax deadlines.
This article walks you through building a practical monthly cash runway dashboard that actually works. We'll focus on UK-specific considerations: HMRC deadlines, company tax obligations, PAYE for early employees, and the timing of grant funding from Innovate UK or regional funds.
Why Runway Management Matters More Than You Think
Running out of cash isn't about being unprofitable on paper—many high-growth startups burn cash aggressively and are valued highly. Running out of cash is about timing. It's the mismatch between when you spend money and when money comes in.
For a typical UK SaaS founder with 3 employees and monthly recurring revenue:
- Payroll (PAYE, National Insurance contributions, pension auto-enrolment) typically accounts for 50–70% of burn
- Office rent, business rates, utilities, and broadband add another 15–20%
- Tools, hosting, and software subscriptions can consume 5–10%
- Marketing, travel, and operational expenses fill the gap
The problem: most of these costs hit your bank account immediately, while revenue—if you have it—may arrive 30–90 days later on invoice terms. If you've taken on SEIS investment or are waiting for Innovate UK grant drawdown, cash timing becomes a game of careful choreography.
Founders who manage runway actively—who forecast quarterly and adjust spending or fundraising accordingly—survive downturns, negotiate better terms with vendors, and avoid panic decisions like sudden layoffs or fire-sale funding rounds.
Building Your Monthly Cash Runway Dashboard: The Core Framework
A cash runway dashboard isn't fancy. It's a spreadsheet (or light tool) that answers three questions every month:
- How much cash do I have today?
- How much am I burning per month?
- How many months until I run out?
Let's build it from the ground up.
Step 1: Current Cash Position
Start with bank reconciliation. Log into your business bank account and record:
- Main operating account balance
- Any separate reserve or savings accounts
- Minus any uncommitted payment obligations (invoices due this month, scheduled transfers)
Many founders make the mistake of including undrawn funding commitments. Don't. If you have £50k from an EIS investor who hasn't wired funds yet, don't count it as cash. That money hasn't landed.
Similarly, if you're owed £10k from a client on 30-day terms but they're historically slow to pay, either forecast conservatively or add a "receivables collection assumption" row that reflects your actual payment receipt timing.
Step 2: Monthly Operating Costs (Fixed and Variable)
Break your costs into three categories:
- Fixed costs: Payroll (including employers' National Insurance), rent, business rates, insurance, subscriptions. These are committed and unlikely to change month-to-month.
- Semi-variable costs: Hosting and platform fees that scale with usage, payment processing fees (percentage of revenue), customer support tools.
- Variable costs: Marketing spend, freelance contractors, travel, ad spend. These can be cut or paused.
For HMRC timing specifically:
- PAYE and National Insurance: Due by the 19th of the following month (or 22nd if paying electronically). Budget the full employer NI contribution, even if you can only afford to pay net wages initially.
- VAT: If registered, typically due quarterly. Mark those quarters on your dashboard—March, June, September, December are common deadlines. Budget the net VAT owed (input tax minus output tax), not the gross revenue figure.
- Corporation Tax: Due nine months after your year-end (usually months 9–12 of trading). If you're profitable, set aside 15–20% of profit monthly into a separate account.
- Dividend tax: If you take dividends, budget for dividend tax due via Self-Assessment (or PAYE if you run payroll through dividends).
Step 3: Revenue Forecast (Conservative)
This is where most founders lie to themselves. Don't forecast what you hope to earn—forecast what you've earned historically, adjusted for known deals.
Rules of thumb:
- If you have no revenue, enter zero. Forecasting revenue before product-market fit is fantasy.
- If you have MRR (monthly recurring revenue), use that as your base. If you have ACVs (annual contract values), divide by 12 and apply a collection rate. E.g., "£5k ACV, 80% collection rate = £333/month".
- If revenue is seasonal (e.g., e-commerce with a peak in December), build in quarterly variation.
- If you're in pre-sales conversations, create a separate row for "pipeline" revenue with a conservative close rate (15–25%) and push the assumed cash receipt date 30–60 days beyond the close date to account for invoice payment terms.
Step 4: Net Monthly Burn
Subtract revenue from operating costs. This is your burn rate. Document it clearly:
Monthly Burn = Operating Costs – Revenue
If your costs are £15k and revenue is £3k, you're burning £12k per month. That's your base case.
Now create two scenarios:
- Bear case: Revenue drops 20%. Costs increase 10% (unplanned contractor, emergency spend). Calculate burn in this scenario.
- Bull case: Revenue grows 20%. Costs remain static (efficiency gain). Calculate breakeven or profit timing.
Step 5: Runway Calculation
Runway (in months) = Current Cash ÷ Monthly Burn
Example:
- Current cash: £60,000
- Monthly burn: £12,000
- Runway: 5 months
If you have £60k and you're burning £12k/month, you have until month 5 before you hit zero. That's your decision trigger. By month 3, you need to either raise capital, reduce costs, or reach revenue breakeven.
UK-Specific Considerations for Your Dashboard
SEIS/EIS Funding and Cash Timing
If you've raised SEIS (Seed Enterprise Investment Scheme) funding, you likely have investor money in the bank. Track it in a separate line. These funds are subject to spending rules—you can't pay yourself excessive salary or pay off other debts. Budget conservatively and assume that some of your SEIS/EIS tranche may need to be reserved for compliant spending (e.g., staff, R&D, eligible costs).
More importantly, if you're fundraising further, investors will want to see your runway. A common question in due diligence is "How long until you hit zero?" If you say "9 months," you're more likely to secure term sheets than if you say "3 months." Runway is leverage in negotiation.
Innovate UK Grants and Payment Timing
Many UK deep-tech and innovation startups draw down Innovate UK grant funding in staged tranches. These grants often reimburse costs after you've already spent the money. For your dashboard, mark when you expect each drawdown and adjust your cash position accordingly—but don't count it as revenue until it hits your bank account.
Employment and National Insurance
If you hire your first employee, you're liable for employer National Insurance contributions on earnings above the £9,100 annual threshold (approximately £758/month as of 2024). This is an immediate additional cost that many founders underestimate.
For payroll, use a PAYE service (HMRC's Basic PAYE Tools, or a provider like Payroll Bureau) and run it monthly. Budget the full employee cost—gross salary plus employer NI, employer pension contributions (mandatory if you have employees), and any benefits. The pay-by-date is typically the 19th of the following month (or 22nd if electronic).
HMRC Deadlines and Quarterly VAT
If you're VAT-registered (or choose to register), VAT is typically due quarterly on the 7th of the month following your quarter end (e.g., April 7th for January–March quarter). Add these as distinct line items in your dashboard for months 4, 7, 10, and 1 (if your quarters align with the calendar).
Example for a January–March quarter:
- You collect £40k in VAT from customers
- You pay £15k in VAT on supplies and costs
- Net VAT due: £25k, due April 7th
This is a surprise cash outflow if you haven't set money aside. Include it in your dashboard under "tax liabilities – VAT" for April.
Regional Grants and Start Up Loans
The UK government offers Start Up Loans of up to £25k at a fixed 6% interest rate. If you're considering this route, factor the monthly loan repayment into your burn rate. Similarly, regional devolved authorities (Scottish Enterprise, Welsh Government, Northern Ireland Executive) offer grants—factor in drawdown timing and any reporting requirements that might affect cash timing.
Structuring Your Dashboard: Tools and Templates
A runner-up mistake: building a dashboard so complex that you don't update it. Keep it simple.
Spreadsheet Approach (Google Sheets or Excel)
Create a single sheet with 13 rows (12 months plus a total) and these columns:
- Month (Jan–Dec or Month 1–Month 12)
- Beginning Cash Balance
- Revenue (forecasted)
- Operating Costs (fixed)
- Variable Costs (marketing, contractors)
- Tax & Payroll Adjustments (National Insurance, VAT, Corp Tax)
- One-Off Costs (if any)
- Net Cash Flow (Revenue – Total Costs)
- Ending Cash Balance (Beginning + Net Cash Flow)
- Runway (Ending Cash ÷ Monthly Burn)
Use conditional formatting to flag cells: green if runway is above 12 months, amber if 6–12 months, red if below 6 months.
Dedicated Startup Finance Tools
If you want automation, tools like Baremetrics (especially for SaaS), Futurly, or Mosaic integrate with your bank and accounting software and update your runway automatically. For most early-stage teams (under 5 people, under £100k/month burn), a spreadsheet is fine.
Integration with Your Accounting Software
Use accounting software (Xero, FreeAgent, Sage) to pull actual costs. At the end of each month, reconcile your bank account and update your forecast with actuals. Compare actual burn vs. forecasted burn. This is where you catch surprises early.
Monthly Review Discipline: Making the Dashboard Work
A dashboard only works if you update it and act on it. Build a monthly ritual:
- Day 1–5 of each month: Reconcile bank account. Log into your business bank account (most UK banks offer online portals or API access) and record your exact balance.
- Day 5–10: Update costs. Pull your accounting software export. Update payroll, VAT, and tax estimates if needed.
- Day 10–15: Forecast revenue for the next 3 months. Review pipeline. Adjust for known deals, seasonality, or delays.
- Day 15: Calculate runway. Run the three scenarios (base, bear, bull). Document any changes from the previous month.
- Day 20: Share with your co-founder or finance person (if you have one). Discuss any mitigations if runway is below 6 months. If you're raising capital, share with your investors as part of monthly updates.
This discipline forces difficult conversations early. If your runway is 4 months, you need to fundraise now—not in month 3 when desperation sets in.
Red Flags and Early Interventions
Your dashboard is an early warning system. Trigger these interventions:
- Runway below 6 months: Begin fundraising conversations immediately. Set target raise amount based on 18-month run-to-profitability or next major milestone.
- Actual burn exceeding forecast by 20%+: Investigate. Is payroll higher than expected? Did a one-off cost occur? Adjust forecast and costs accordingly.
- Revenue trending below forecast for 2+ consecutive months: Shift marketing budget, extend sales cycle assumptions, or reduce costs.
- Variable costs exceeding 40% of monthly spend: You're likely over-investing in growth before product-market fit. Consider pausing paid marketing until unit economics improve.
Cash Preservation Tactics When Runway Gets Tight
If your dashboard shows runway below 4 months and fundraising isn't imminent, activate these levers:
Cost Reduction (in priority order)
- Pause marketing spend. Kills cash bleed fastest. If your LTV-to-CAC ratio isn't 3:1+, marketing should be paused anyway.
- Renegotiate vendor contracts. Contact your largest SaaS subscriptions, cloud providers, and service providers. Many offer discounts for annual upfront payment (use your reserve to secure this) or will negotiate payment terms.
- Move to variable staffing. Replace headcount with contractors where feasible (though UK employment law is strict—ensure compliance with employment classification rules). Or negotiate part-time, project-based arrangements.
- Reduce office spend. Move to hot-desking, negotiate lease breaks, or go fully remote (with broadband support for the team—if your team is distributed, tools like Voove can provide robust connectivity for remote ops).
Revenue Acceleration
- Compress payment terms. If you're invoicing on 30-day terms, ask for upfront payment or 50% upfront / 50% on delivery.
- Raise prices. A 10% price increase on customers with strong satisfaction can net 5–8% additional MRR immediately (assuming minimal churn).
- Focus on high-margin revenue. If you have consulting or professional services revenue, shift effort there. Consulting margins (50–70%) beat SaaS margins (40–60%) while you're bootstrapping.
Building Trust with Your Board and Investors
If you've raised capital (SEIS, angel, VC), monthly cash updates are expected. Investors want to see:
- Current cash balance
- Monthly burn rate (actual vs. forecast)
- Projected runway
- Any changes to the 18-month plan
A founder who provides accurate, timely cash updates (even with bad news) is vastly more trusted than one who surprises their board with a "we need to raise capital immediately" moment in month 3.
Many UK angels and micro-VCs will ask to see your dashboard as part of diligence or ongoing reporting. A clean, updated spreadsheet signals fiscal maturity and reduces their perceived risk of capital loss.
Conclusion: Cash Is King, But Runway Is Sanity
Cash runway management isn't glamorous. It won't make your product better or impress customers. But it buys you time—the single most valuable asset in a startup. Time to find product-market fit. Time to fix a broken sales process. Time to fundraise on your terms, not in desperation.
Start building your dashboard today. Update it monthly. Share it with your co-founder or board. Act on the data. If you do this consistently, you'll survive downturns that kill less disciplined competitors. And that survival, over time, is how you win.
The founders who make it are rarely the smartest or the best-connected. They're the ones who know their numbers cold and adapt relentlessly based on reality, not hope.