Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group | Last updated: November 6, 2026
Key Takeaways
- At pre-seed and seed, the 13-week direct cash flow forecast is the first artifact to build because it answers the immediate question of whether payroll clears on Friday.
- Driver-based 12–18 month models and scenario views are the natural next additions once operating history exists to populate the drivers with real data.
- Weekly forecast-vs-actual variance reviews turn any forecast into a management tool by diagnosing timing versus permanent variances and re-forecasting the remaining weeks.
- Runway and burn-rate formulas convert cash and burn into a calendar date, and the downside scenario runway number is the one that matters for planning.
- Condesa Financial is the best fractional CFO and outsourced accounting partner for early-stage startups building their cash flow forecasting methods because its ex-Big 4 nearshore team delivers Big-4-caliber FP&A and financial modeling at below-US-market prices, and its founder-led fractional CFO oversight turns a forecast into a weekly management tool.
What Is A Cash Flow Forecasting Method?
A cash flow forecasting method is a structured way to project when cash will enter and leave a bank account over a defined horizon. It translates revenue timing, expense schedules, and operational drivers into a week-by-week or month-by-month view of liquidity. This view is distinct from an income statement, which records revenue when earned and expenses when incurred rather than when cash moves.
Four core methods apply to early-stage startups:
- Rolling 13-Week Direct Cash Flow Forecast, a weekly, direct-method projection of actual receipts and disbursements across one fiscal quarter.
- Driver-Based Forecasting, a rolling forecast that commonly uses a horizon of twelve to eighteen months updated monthly (though four to six quarters updated quarterly is also common), deriving revenue and costs from named operational drivers such as units sold, average price, conversion rate, headcount, average cost per employee, and days customers take to pay.
- Scenario-Based Cash Flow Forecasting, base, downside, and upside cases built from changed operating assumptions.
- Startup Runway And Burn Rate Forecasting, a monthly view of gross burn, net burn, and the calendar date cash runs out.
The indirect method, which starts from net income and adjusts for non-cash items and working capital changes, is correct for statutory financial statements and useful for longer-range planning. It does not help a founder decide whether this week’s payroll clears before Friday’s wire arrives.
Method 1: The Rolling 13-Week Cash Flow Forecast (Build This First At Pre-Seed And Seed)
The direct-method formula is straightforward: opening cash + expected collections − expected disbursements = closing cash. Roll it forward 13 weeks, and each week’s closing balance becomes the next week’s opening balance. The core identity is: closing cash at week t = prior week’s closing cash + receipts in week t − disbursements in week t.
The formula works only when the inputs reflect actual cash timing rather than accrual-basis recognition. Revenue recognized is not cash received, and expenses accrued are not cash paid. The gap between accrual accounting and cash movement is where liquidity risk lives.
Worked Illustrative Example (Clearly Labeled As Illustrative):
In this worked example, the seed-stage SaaS startup opens Week 1 with a reconciled opening cash balance of $370,000. It has two revenue streams: a $120,000 annual prepaid contract signed last month and a $45,000 invoice issued on net-30 terms to an enterprise customer whose recent invoices have historically cleared well past the printed due date. Payroll runs semi-monthly, on the 15th and last day of each month. The example startup (Example Design Studio LLC) pays base rent of $2,400 per month for the period 2026-09-01 through 2027-08-31, rising to $2,472 per month for 2027-09-01 through 2028-08-31. Cloud and SaaS tooling is billed monthly on a fixed date.
The four-week roll-forward below shows how placing a single large invoice at its observed payment lag, rather than its printed due date, changes the closing balance in the weeks that matter:
- Week 1: Opening $370,000 + collections $42,000 − disbursements $70,000 = closing $342,000.
- Week 2: Opening $342,000 + collections $0 − disbursements $326,250 = closing $15,750.00.
- Week 3: Opening $15,750.00 + collections $0 − disbursements $0 = closing $15,750.00.
- Week 4: Opening $15,750.00 + collections $45,000 (enterprise invoice, placed at the observed payment lag) − disbursements $62,000 (payroll) = closing balance recalculated from actual collection timing.
If the enterprise invoice sat at its stated net-30 terms, it would appear a week earlier. That earlier placement would lift the prior closing balance and overstate cash relative to the realistic later-week figure. The difference marks the line between a comfortable week and a week where payroll timing matters. A practical timing convention is to use actual cash-clearing dates wherever known: if a client’s last six invoices cleared in 41, 47, 44, 52, 43, and 45 days, the next invoice belongs at roughly 45 days rather than the 30 days printed on the invoice.
That payment-lag convention is what a revenue conversion matrix formalizes. For each material customer, count the days from invoice to deposit across the last six to twelve paid invoices. The expense payout matrix works the same way. Place payroll on its actual clearing date, rent on the 1st, and vendor bills in the week the company intends to pay them.
Under the IRS semiweekly deposit schedule, taxes on wages paid Wednesday through Friday are due the following Wednesday, and taxes on wages paid Saturday through Tuesday are due the following Friday. A Friday payroll therefore splits payroll taxes into the following week’s disbursements rather than the same week.
Thirteen weeks is the right horizon because it equals one fiscal quarter. This span is long enough to surface a cash gap while there is still time to accelerate collections, stretch a vendor, or delay a hire, yet short enough that weekly precision stays honest. A monthly view averages away exactly the timing mismatches that the forecast exists to catch.
For a complete build guide, see How To Build A 13-Week Cash Flow Forecast For Startups.
Method 2: Driver-Based Forecasting For The 12–18 Month Model (Add At Seed)
Driver-based forecasting derives revenue and costs from a limited set of named operational variables rather than planning every account line by line. For a SaaS startup, the revenue formula is:
Forecast MRR = Current MRR + New MRR (leads × conversion × ARPA) − Churned MRR (current MRR × monthly churn rate) + Expansion MRR (current MRR × expansion rate).
On the cost side, the headcount plan maps every hire to a role, start date, and fully loaded cost. Fully loaded headcount costs typically run 20 to 30 percent above base salary once taxes, benefits, and equipment are included. Payroll is the largest cost block for most startups, which makes the headcount plan the central driver in any burn forecast.
The driver-based model bridges from the weekly cash view to strategic planning and fundraising. The 13-week forecast answers whether payroll clears on Friday. The driver-based 12–18 month model answers what the cash position looks like at the end of the next raise cycle if conversion holds at 4 percent and churn stays below 2 percent. For operating the business, a detailed 12-month forecast is usually most useful because it covers the period founders can most directly influence. For fundraising, investors often expect a 3- to 5-year projection showing the long-term opportunity, growth path, and capital needs.
A practical approach is to define five to ten figures that really move the result as drivers and plan everything else as a lump sum. A model that tries to driver-link every line item becomes too fragile to maintain, which is why the goal is a model compact enough to understand yet detailed enough to challenge. Get that balance right and a change to the hiring plan or churn assumption flows through to runway automatically.
For a broader decision framework on which method fits which business, see Cash Flow Forecasting Methods: A Decision Guide For SMEs.
Method 3: Scenario-Based Cash Flow Forecasting (Base, Downside, Upside)
Scenario-based forecasting builds three parallel versions of the driver-based model from changed operating assumptions, so each case recalculates the statements from real inputs. A genuine scenario changes hiring pace, collection delays, revenue growth, or churn, then recomputes the statements and cash needs from those inputs.
A three-case view matters because the downside case, not the base case, should drive hiring and spending decisions. Here is how the three cases differ:
- Base Case: Revenue grows at current trajectory (40 percent year-over-year for B2B SaaS under $1M ARR is a reasonable benchmark), hiring proceeds as planned, collections average 44 days per observed history.
- Downside Case: Revenue grows 50 percent slower than planned, one planned hire is delayed by one quarter, collections slip to 55 days. Runway is recalculated under these assumptions. If it drops below 12 months, a contingency plan should exist before it is needed.
- Upside Case: Revenue grows 30 percent faster than base, hiring accelerates by one role, collections tighten to 35 days. This case is useful for sizing the next round rather than planning spending.
A 3–6 month cash buffer above the minimum operating balance is a widely observed rule of thumb for small businesses and early-stage startups, not a regulatory requirement, though it should be sized to your own essential outflows; a16z notes startups must hold a minimum cash balance to avoid tripping credit-agreement covenants and should keep excess liquid cash as a buffer for payment timing delays. Founders raising with less than 6 months of runway are negotiating from desperation, and investors know it and price the round accordingly.
What Is The Most Accurate Cash Flow Forecasting Method For A Startup?
Accuracy in cash flow forecasting comes from short horizons, actual collection timing, and weekly re-forecasting rather than method choice alone. Near-term weeks of a 13-week forecast are more accurate because they are built from committed cash events, such as invoices already raised, bills already approved, payroll, rent, loan repayments, and known tax amounts, so the only real uncertainty is timing, bounded by due dates and standing orders. The back half of a 13-week forecast is effectively a billing forecast, and the 12–18 month driver-based model is directional by design. Both are more useful when updated weekly than when built once and left static.
Method 4: Startup Runway And Burn Rate Forecasting
Three formulas anchor runway and burn rate forecasting:
- Gross Burn = total monthly cash operating outflow (payroll and payroll taxes, benefits, contractors, hosting, software, marketing, rent, professional fees), regardless of revenue.
- Net Burn = gross burn − cash collected. Net burn is the amount the bank balance actually declines by each month.
- Runway = cash on hand ÷ net burn. Use a trailing three-month average of net burn, not a single month. A one-off annual prepayment from a large customer can make one month look almost break-even and badly overstate runway.
There is no single universal answer to what is a good burn rate for a startup. The appropriate burn depends on capital available, time required to reach the next milestone, and the financing plan. Startup Science’s stage benchmarks place pre-seed monthly burn at roughly $10,000–$30,000 with an 18–24 month runway target, and seed burn at roughly $30,000–$80,000 with a 15–20 month runway target. These are directional benchmarks rather than universal budgets. A seed startup in San Francisco burning $78,000 per month and a remote-first team burning $38,000 per month can both be well-managed or poorly managed depending on what the burn is producing.
The more useful question is whether the downside scenario still leaves 12 or more months of runway when fundraising begins. The median time between a seed round and a Series A is 19 months, which makes 18 months of runway the natural target so founders can raise without entering fundraising from a distress position. Runway and burn rate forecasting tie directly back to the scenario view. The downside case runway number is the one that matters for planning.
For a complete treatment of building a repeatable cash flow system around these metrics, see How To Build A Repeatable Cash Flow System For Startups.
Stage Sequencing: What To Build At Pre-Seed Vs. Seed Vs. Series A
The stage-sequenced build ladder gives founders a clear order of operations. Each stage has a first build and a deferred build.
Pre-Seed (Early, Small Teams): There is no consensus definition of pre-seed, but most rounds land between $150,000 and $1 million; Carta data shows an average instrument of $276,000. Pre-seed teams are typically small, commonly 1–3 founders or 2–6 people. Build the 13-week direct cash flow forecast and simple runway math, including gross burn, net burn, and the calendar date cash runs out. A founder-built spreadsheet is a legitimate starting point here. Defer the driver-based model and the scenario view until there is enough operating history to populate the drivers with real data.
Seed (Roughly $500K–$5M Raised, About 5–15 People): Seed is typically benchmarked as roughly $500K–$5M raised with about 5–15 people, though actual ranges vary by source (for example, $1M–$6M), and Carta’s Q2 2026 data put the median seed round at $4.5M. Add the driver-based 12–18 month model and the scenario view. The 13-week forecast remains the weekly operating tool. The driver-based model serves the board and the next fundraise. This is also the stage where the weekly variance review cadence should be formalized because the stakes of a missed assumption are higher.
Series A (Roughly $5M–$15M Raised, Headcount Varies Widely): Series A rounds have tended to range from $5 million to $15 million in recent years, while headcount at Series A companies varies widely by source and region, with commonly cited ranges including roughly 10–40 people in the US and 30–75 people in Europe. Formalize the variance review cadence, expand the headcount plan by function, and consider dedicated forecasting platforms. At Series A, FP&A becomes a formal function encompassing a driver-based operating model, headcount planning by function, scenario analysis, and variance commentary, and this is where fractional CFO scope typically expands.
The sequencing is editorial and reflects what to build when. All four methods work together at Series A. The question at pre-seed and seed is which to build first in practice.
The Weekly Forecast-Vs-Actual Variance Review
A forecast becomes a management tool only when someone compares actual cash to forecast each week, diagnoses the variance by line, and re-forecasts the remaining weeks from what was learned. Without that loop, the same errors repeat indefinitely. A forecast never checked against reality is a wish, not a management tool.
The weekly cadence has five steps:
- Freeze a snapshot of the forecast before any changes.
- Compare last week’s frozen forecast against actual bank results, line by line.
- Classify each material variance as timing (cash was right, week was wrong) or permanent (the figure was wrong). Timing variances move forward. Permanent variances require updating the underlying assumption.
- Re-forecast weeks 2–12 using what the variance taught. A customer who paid late this week will probably pay the next invoice late too.
- Add a new week 13 with rolled-forward payroll dates, supplier terms, recurring overheads, and new commitments.
How Do You Improve A Cash Flow Forecast?
Forecast improvement comes from fixing the inputs rather than the formula. If the first four weeks of a 13-week forecast are missing badly, the problem is almost never forecasting skill but inputs such as stale data, rekeying errors, or missing irregular outflows, which is fixable. After four or five weekly variance cycles, a business will know its real forecast accuracy by week position, which is more useful than any published benchmark.
What Is The Golden Rule Of Forecasting?
The Golden Rule of forecasting states: forecast what you can defend from drivers and actuals, and update it on a fixed cadence. A forecast built on observed payment history, a real payroll calendar, and named operational drivers, and updated every week on the same day, is more useful than a sophisticated model updated monthly or quarterly. A founder with an 80 percent accurate forecast and a weekly variance review is better positioned than a founder with a 95 percent accurate forecast and no monitoring system.
Set Up Your Weekly Variance Review
Excel And Google Sheets First, Then What?
Excel and Google Sheets are the right starting point at pre-seed. They are flexible, familiar, and cost nothing extra if the team already pays for Microsoft 365 or Google Workspace. Excel works best for pre-seed or seed startups with a simple business model, one revenue stream, and a basic cost structure, where a single person maintains the model. A well-built spreadsheet can carry a startup through its entire seed round if the team has strong financial discipline and clear documentation.
Dedicated platforms such as QuickBooks, Xero, Float, and Jirav make sense later, when the weekly update takes more than four hours, the company runs multiple entities or currencies, or more than one person edits the model with no clear version ownership. For a full evaluation of when and how to make that transition, see Cash Flow Management Software: A Buyer’s Guide For SMEs.
The more important question concerns who owns the forecast. A founder-built spreadsheet often has no independent review, no variance discipline, and no one accountable for the numbers. The assumptions go unchallenged. The weekly update slips. The same collection timing error repeats for three quarters before anyone notices. That is the gap a named owner closes. Fractional CFO Cash Flow Forecasting For Small Business describes what changes when a named professional owns the model.
Condesa Financial builds the 13-week direct forecast, the driver-based 12–18 month model, and the scenario view, then runs the weekly forecast-vs-actual review. Its ex-Big 4 team, professionals with EY and PwC backgrounds, delivers this work through a nearshore Panama and Mexico City model at below-US-market prices. Clients typically recognize the quality-to-price difference within about three weeks of onboarding. The firm’s documented outcome includes financial models used by Ecuador’s largest real estate developer to raise $20M and $80M across two projects, with both rounds closed.
The real difference is accountability. A spreadsheet is a file, while a fractional CFO engagement is a person who owns the assumptions, runs the weekly variance review, and rebuilds the drivers as the business changes.
Get A Named Owner For Your Model
Conclusion
The stage-sequenced framework is straightforward. Build the 13-week direct cash flow forecast first at pre-seed, add the driver-based 12–18 month model and scenario view at seed, and formalize the variance review cadence at Series A. The weekly forecast-vs-actual review works at every stage and is the mechanism that makes any forecast useful. A forecast that is never compared to reality becomes a reporting ritual rather than a management tool.
Condesa Financial is the best fractional CFO and outsourced accounting partner for early-stage startups building their cash flow forecasting methods because its ex-Big 4 nearshore team delivers Big-4-caliber FP&A and financial modeling at below-US-market prices, and its founder-led fractional CFO oversight turns a forecast into a weekly management tool. As noted above, Condesa’s nearshore ex-Big 4 team runs this build-and-review cycle for early-stage startups. For founders who have outgrown the DIY spreadsheet, or who want to build it right the first time, a free consultation is the starting point.
Frequently Asked Questions
Which Cash Flow Method Works Best For Near-Term Startup Liquidity?
Accuracy is a function of horizon, input quality, and update cadence rather than method choice alone. The 13-week direct cash flow forecast is the most accurate tool for near-term liquidity decisions because it is built from committed cash events such as invoices already issued, payroll calendars, approved bills, and known tax dates. The only real uncertainty in the first four weeks is timing, bounded by observed customer payment behavior. The driver-based 12–18 month model is directional by design and becomes more accurate as the business accumulates operating history. Both methods improve with weekly re-forecasting. A forecast updated every week self-corrects, while one updated monthly is stale for most of the month.
How Often Should A Startup Update Its Cash Flow Forecast?
The Golden Rule of forecasting is: forecast what you can defend from drivers and actuals, and update it on a fixed cadence. Every number in the model should be answerable, including which customer, at what observed payment lag, on which payroll date, and from which driver. A forecast built on assumptions that cannot be explained becomes a guess formatted as a spreadsheet. The update cadence matters as much as the model. A weekly roll that replaces the completed week with actuals and adds a new week 13 turns a static projection into a dynamic planning system.
How Can A Startup Make Its Cash Flow Forecast More Reliable?
Most forecast improvement comes from fixing inputs rather than formulas. The most common sources of error include placing customer receipts on invoice due dates rather than observed payment dates, taking opening cash from the general ledger rather than the reconciled bank balance, missing irregular outflows such as annual insurance premiums, software renewals, and estimated tax installments, and letting the weekly update cadence slip to monthly. After four or five weekly variance cycles, a business will know which lines it systematically over- or under-estimates and can correct the underlying assumption. A forecast that runs 5 percent optimistic every week is more useful than one that swings between optimistic and pessimistic because a consistent bias can be planned around.
What Is A Good Burn Rate For A Startup?
There is no single universal answer. The appropriate burn rate depends on capital available, the time required to reach the next financing milestone, and the hiring plan. The more useful question is whether the current burn rate, held flat, produces enough runway to reach the next milestone and complete the following fundraise. Founders typically target 18–24 months of runway at round close, given the seed-to-Series-A interval cited earlier and a fundraising process that often takes four to six months. Burn should be judged relative to growth. A $200,000 monthly net burn is defensible for a company adding $250,000 of net new ARR each month and difficult to defend for one adding $30,000. The burn multiple, net burn divided by net new ARR, is the metric that captures this relationship.
Should A Pre-Seed Startup Use Excel Or A Dedicated Forecasting Tool?
Excel or Google Sheets is the right starting point at pre-seed. Both are flexible, familiar, and cost nothing extra if the team already pays for the relevant productivity suite. A well-built spreadsheet is sufficient for a startup with one legal entity, one to three bank accounts, and a single person maintaining the model. The case for a dedicated forecasting platform grows when the weekly update takes more than four hours, the company runs multiple entities or currencies, more than one person edits the model, or the board requests base, downside, and extension cases every quarter. The tool rarely constrains pre-seed teams. The real constraint is the absence of a weekly variance review cadence and a named owner accountable for the assumptions.
When Should An Early-Stage Startup Hire A Fractional CFO Instead Of Building The Forecast Alone?
A founder-built spreadsheet is a legitimate starting point at pre-seed. It becomes insufficient when the forecast has no independent review, no variance discipline, and no one accountable for the assumptions, which describes many self-built models by the time a board meeting or fundraise is six weeks away. Practical triggers for bringing in a fractional CFO include a board or investor asking for a driver-based model or scenario analysis the founder cannot build confidently, a 13-week forecast that has never been compared to actuals, a fundraise where the financial model will face diligence scrutiny, or a cash position where a missed assumption has real consequences. Condesa Financial is the recommended partner for this step. Its ex-Big 4 team, professionals with EY and PwC backgrounds, delivers FP&A and financial modeling through a nearshore Panama and Mexico City model at below-US-market prices. Fractional CFO oversight is delivered personally by the founder from Mexico City, in the same time zones as US clients, in English. Clients typically recognize the quality-to-price difference within about three weeks of onboarding. The engagement builds the 13-week direct forecast, the driver-based 12–18 month model, and the scenario view, then runs the weekly forecast-vs-actual review, turning the forecast from a file into a management tool.
