By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 14, 2026
Startup cash flow is the timing of money in and out of your bank account, and the way to control it is a rolling forecast kept in a spreadsheet you already use. Build it from your real bank balance, list every expected receipt and payment by week, and update it on a fixed day. That one habit shows your burn rate, your runway and any coming shortfall while you still have time to act. At Frac CFO we build these forecasts in Excel and Google Sheets, so you keep the tool you know and get a clearer view of your money.
TL;DR
- Cash flow is cash actually received minus cash actually paid. Revenue and profit can look healthy while the bank balance falls.
- Track two numbers every month: net burn (cash out minus cash in) and runway (cash balance divided by net burn).
- Use a 13-week forecast for the short term and a 12-month rolling forecast for planning. Both work well in Excel or Google Sheets.
- Build forecasts from real drivers (customers, prices, payment terms, payroll dates) and keep a written log of your assumptions.
- Shorter payment terms, upfront payments and a defined cash buffer are the quickest ways to improve cash flow.
Table of Contents
- What cash flow means for a startup
- Why cash flow sinks so many startups
- The numbers to track: burn rate and runway
- How to build a startup cash flow forecast in a spreadsheet
- Which forecast horizon should you use?
- Direct or indirect: which cash flow method?
- Practical ways to improve startup cash flow
- Spotting a shortfall early
- Our perspective
- Get a forecast built for you
- FAQ
- Sources
What cash flow means for a startup
Cash flow is the movement of money into and out of your business. A customer paying an invoice is cash in. Payroll, rent, software and supplier bills are cash out. The difference over a period is your net cash flow.
This is not the same as revenue or profit. Revenue is income earned for goods or services delivered, not necessarily money already collected. Profit is what remains after subtracting the expenses of the period from that income, as shown in a profit-and-loss account. Neither tells you when cash arrives or leaves.
That gap is why a company can be profitable on paper and still run out of money. The UK government’s financial model guidance warns that working-capital timing can cause cash shortages even when a business is profitable, and recommends showing cash runway and funding needs in forecasts. A UK government guide to financial management for small firms puts it plainly: cash management is key, because small businesses fail when they run out of cash.
A worked example
Imagine a startup that sells a $12,000 annual service contract in March and invoices it with 45-day terms. The $12,000 counts as revenue as the service is delivered. The cash does not arrive until mid-April. Meanwhile payroll of $9,000 goes out on March 31 and April 15. On the profit and loss the company looks fine. In the bank it is short by thousands of dollars for two weeks.

Nothing is wrong with the business. The timing is wrong, and a cash flow forecast is the tool that shows it in advance.
Why cash flow sinks so many startups
Startups spend before they earn. They hire, build and market first, and collect later. That makes timing the main risk. One academic study of startup failure, from Ghent University, cites cash flow mismanagement as a factor in 82% of failures. Research on FinTech startups also finds that external funding lowers the likelihood of reaching break-even, linked to delayed financial discipline and a focus on rapid growth.
The lesson for a founder is practical: raising money does not replace managing money. Cash you can see in a forecast is cash you can plan around.
The numbers to track: burn rate and runway
Two figures sit at the center of startup cash management.
| Metric | How to calculate it | What it tells you |
|---|---|---|
| Gross burn | Total cash going out per month | How expensive it is to run the company |
| Net burn | Cash out minus cash in per month | How fast your bank balance is falling |
| Runway | Cash balance divided by net burn | How many months you can operate at the current pace |
For example, with $240,000 in the bank and a net burn of $30,000 a month, your runway is eight months. If you add two hires and net burn rises to $42,000, runway drops to under six months. The calculation is simple, but it assumes burn stays constant. In reality, hiring, annual software renewals and tax payments move it, which is why a forecast is more reliable than a single formula.
Average at least three months of actuals when you calculate burn, and leave out one-time items such as a funding round, so the figure reflects normal operations.
Investors look at these figures too
Research in an academic journal links operating cost estimates, burn rate and LTV:CAC (the lifetime value of a customer divided by the cost of acquiring one) to valuation, with investors favoring sustainability over growth at any price. If you plan to raise money or eventually sell, understanding how your numbers feed into business valuation methods helps you decide which metrics deserve the most attention now.
How to build a startup cash flow forecast in a spreadsheet
A forecast does not need special software. A clean workbook with a few tabs does the job. Here is the routine, step by step, including where it usually goes wrong.
Step 1: Start from your real cash balance
Begin with what is in the bank today, not with what you hope to have. Pull the balance from your bank account and, if you have several accounts, add them together. The most common error is starting from a book balance that includes uncleared checks or payments that have not landed.
Step 2: List cash receipts by week or month
List each source of incoming cash and the date you expect it, not the date you invoice. For subscription revenue, use billing dates and your churn assumption. For invoiced work, add your customers’ real payment habits: a client on 30-day terms who typically pays in 45 days belongs in week seven, not week four.
Where it goes wrong: treating signed contracts as cash, and ignoring slow payers. Be conservative here.
Step 3: List cash payments
Include payroll and payroll taxes, rent, software, contractors, supplier bills, insurance, loan payments and tax payments. Put annual and quarterly items in the week they fall due, not spread evenly. A $6,000 annual insurance bill that appears in one week is the kind of surprise a forecast should catch.
Step 4: Calculate net cash flow and ending balance
For each period: opening balance plus receipts minus payments equals closing balance. The closing balance of one period becomes the opening balance of the next. Highlight any period where the closing balance drops below your minimum buffer.
Step 5: Base it on drivers and log your assumptions
A sturdy model is built bottom-up, from the drivers of revenue and cost, with a detailed assumptions log so others can see why each number is there. That is the approach in the UK government’s financial model guidance, which also notes that a business that habitually overestimates growth may find investors discount its projections. Write down each assumption (customer count, price, conversion rate, payment days, hiring dates) in one tab so you can change it and watch the whole forecast update.
Step 6: Add scenarios
Run three versions: a base case, a downside where revenue comes in 20% lower or customers pay 15 days later, and an upside. The downside is the one that decides how much cash you hold. If it shows you running out in month nine, you know months in advance that you need to cut costs, collect faster or raise funds.
Step 7: Update it on a schedule
A forecast you build once is out of date in a month. Pick a day each week or month, replace forecast figures with actuals, and roll the horizon forward. This is the step that turns a spreadsheet into a management tool.

We cover the mechanics in two guides: how to build a 13-week cash flow forecast in Excel for the short term, and building a rolling 12-month forecast for planning. If you want the structure ready-made, our 13-week cash flow forecast template is built for Excel and Google Sheets.
Which forecast horizon should you use?
| Horizon | Best for | Update |
|---|---|---|
| 13 weeks, by week | Day-to-day cash decisions, payroll timing, collections | Weekly |
| 12 months, by month | Hiring plans, runway, fundraising timing | Monthly |
| 3 years, three statements | Investor conversations and long-term planning | Quarterly |
Most early-stage founders need the first two. The third becomes useful when you raise a round or take on a lender, and it ties your income statement, balance sheet and cash flow statement together. Our three statement financial model template is designed for that stage.
Direct or indirect: which cash flow method?
A cash flow statement can be prepared two ways. The direct method lists actual cash receipts and payments. The indirect method starts from profit or loss and adjusts for non-cash items and changes in working capital, as ICAEW explains.
For managing a startup week to week, the direct method is the more useful one. It matches how you think about money: what comes in, what goes out and when. The indirect method is common in formal financial statements and in three-statement models.
Practical ways to improve startup cash flow
These moves work whether you are pre-revenue or growing fast.
- Ask for upfront payment. Annual prepayment, deposits or milestone billing bring cash in before you spend it.
- Shorten payment terms. Moving from 45 days to 14 days can change a forecast from red to green. Send invoices the day work is done.
- Follow up on receivables. Set a calendar reminder at due date, and again a week later.
- Stretch payables sensibly. Pay suppliers on the due date, not early, as long as you keep the relationship healthy.
- Time hiring to cash. Add a hire to the forecast first and check the runway before you make the offer.
- Review recurring costs quarterly. Unused subscriptions and duplicate tools add up.
- Hold a buffer. Many founders aim to keep a few months of expenses in reserve. Set your own number from your downside scenario, then treat it as a floor in your forecast.
If working capital is your main squeeze, our Working Capital Optimizer helps you see how receivables, payables and inventory affect your cash. For a quick, structured plan when the balance is tight, see our 72-hour treasury playbook for startups.
Spotting a shortfall early
Watch these signals in your spreadsheet:
- The forecast closing balance dips below your buffer in any week of the next 13.
- Runway falls under six months while you still have no funding plan.
- Average days to collect from customers keeps rising.
- Net burn rises for three months in a row without matching revenue growth.
When one appears, you have options: cut or delay spending, collect faster, renegotiate terms, or start a financing conversation early. The UK small business guide also advises seeking qualified independent financial advice before taking on finance and keeping regular management accounts for lenders. In practice, that means a qualified accountant or financial adviser. Our Cash & Financing Optimizer is built to help you compare funding choices against your cash position, and there is a sample decision report you can read first.
Our perspective
Most founders we talk to are not short of data. They are short of a clear picture. Their numbers sit in a bank portal, an invoicing tool and three spreadsheets, and nobody has joined them into one view of the next 13 weeks.
We believe the answer is not another platform to learn. A well-built Excel or Google Sheets model gives you complete control and understanding of your own data, because you can see every formula and change every assumption yourself. Our work is focused only on spreadsheet-based finance, so that is where we put our attention.
A forecast should do three things: show your runway, show your shortfalls early, and let you test a decision before you make it. When the numbers finally tell a story, hiring, pricing and fundraising decisions get easier.
frac
Get a forecast built for you
If you would rather not build the model from scratch, we offer options at each stage. Our Excel templates give you ready-made structures. Our Launch Kit is a $650 one-off package. For a tailored model, one-time finance projects include a 13-week cash flow forecast, budget build and KPI dashboard. For ongoing support, our Starter plan is $600 per month, or $7,200 per year, with hands-on onboarding and email support.
Whichever route you choose, you keep your finances in the spreadsheets you already use, and you get a forecast you understand.
FAQ
How do I create a cash flow forecast for a startup?
Start with your current bank balance, then list expected cash receipts and payments by week or month, using the dates money will actually move. Calculate the closing balance for each period and roll it forward. Add a downside scenario and update the sheet on a fixed schedule.
Can a company be profitable but have no cash?
Yes. Profit counts revenue when it is earned and expenses when they are incurred, while cash only counts money received and paid. If customers pay slowly or you buy inventory and pay salaries before collecting, a profitable business can still run short of cash.
What is a good runway for a startup?
There is no single number that fits every company. Many founders aim for at least six months at all times, and start planning a raise or cost cuts well before that. Your downside scenario and how long it takes you to raise or collect cash should set your own target.
How often should I update my cash flow forecast?
Update a 13-week forecast weekly and a 12-month forecast monthly. Replace estimates with actual figures, then extend the horizon so it always looks the same distance ahead.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources
- A Guide to Financial Management for SMEs (UK government, 2012)
- Track 1: Financial Model Essentials (GOV.UK, 2025)
- Third Edition of the IFRS for SMEs, Section 23 exposure draft (IFRS Foundation, 2022)
- About a business (ICAEW, 2019)
- Cash flow statements: the direct or indirect method? (ICAEW, 2025)
- Pattyn, Ghent University (2023), startup failure and cash flow
- Predicting break-even in FinTech startups (ScienceDirect, 2025)
- ACADEMIA International Journal for Social Sciences (2025)
- Business Valuation Methods: 7 Approaches Compared

