Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group

Key Takeaways

• Cash flow forecasting methods work as complementary layers, with each method serving a specific time horizon and decision type.
• The direct method gives the clearest short-term liquidity view for 1-13 weeks by tracking actual cash receipts and disbursements. The indirect method supports medium-to-long-term planning and financial reporting.
• A combined-cadence model with a 13-week direct forecast for liquidity, a monthly driver-based forecast for planning, and quarterly scenario analysis for risk gives 20-100 employee companies a defensible forecasting system.
• Forecast accuracy depends on matching the method to the decision timeframe, keeping data clean, and updating models on a steady cadence to avoid forecast decay.
• Get a customized forecasting plan that matches your methods and cadences to your current systems, team, and cash decisions.

Cash Flow Forecasting Methods For Growing SMEs

Five primary cash flow forecasting methods support most small and mid-sized companies. Each plays a different role:

1. Direct Method — schedules actual cash receipts and disbursements by period and supports short-term operational liquidity visibility over a 4-13 week horizon.
2. Indirect Method — starts from net income and adjusts for non-cash items and working capital changes, supporting medium-to-long-term planning and financial reporting.
3. Rolling Forecast — continuously extends the planning horizon by adding a new period as each one closes, keeping a constant forward view.
4. Driver-Based Forecast — derives cash flow from a small set of operational drivers such as headcount, bookings, DSO, and billing terms, which helps teams refresh assumptions quickly.
5. Scenario Analysis — models multiple outcome paths (base, downside, upside) against the same set of drivers and supports risk assessment and strategic decisions across short and long horizons.

The table below summarizes how each method works, the time horizon it covers, and the data it needs so you can match a method to your planning need at a glance.

Direct Vs. Indirect Cash Flow Forecasting

ASC 230-10-45-3 in US GAAP encourages the direct method but permits the indirect method. Both arrive at the same net cash from operating activities. The difference sits in how the model presents the path to that figure.

The direct method lists major classes of gross cash receipts and gross cash payments, such as cash collected from customers, cash paid to suppliers and employees, interest paid, and taxes paid. ASC 230-10-45-25 requires entities using the direct method to separately report at least seven classes of operating cash receipts and payments. The direct method gives operationally accurate short-term liquidity visibility because it tracks actual cash timing. Finance teams use it as the standard for 13-week cash flow forecasting and for any model where week-level precision matters.

The indirect method starts from net income and adjusts for non-cash items such as depreciation and amortization, along with changes in working capital accounts like accounts receivable, inventory, and accounts payable. EY’s July 2026 Financial Reporting Developments guide on ASC 230 notes that the direct method is “extremely difficult to implement in all but the simplest operations,” while the indirect approach is more familiar to financial statement users and less costly to prepare. The indirect method dominates formal financial reporting and supports medium-term planning, board reporting, and fundraising models.

For a 20-100 employee company, a simple rule works well: use the direct method for anything inside 13 weeks and the indirect method for anything beyond one quarter. The next step is choosing among all five methods as horizons, data, and team capacity change.

How To Choose The Right Cash Flow Forecasting Method

Method selection follows three variables: time horizon, data availability, and organizational capacity.

Choosing By Time Horizon

• 1–13 Weeks: Use the direct method as a rolling 13-week forecast. The 13-week format emphasizes weekly cadence over monthly aggregation and gives week-by-week visibility into cash position. Data required: AR aging from QuickBooks Online, bank feeds, payroll schedule from Gusto, and AP due dates from Ramp.
• 1–12 Months: Use a driver-based forecast. Driver-based forecasting computes collections from bookings multiplied by billing terms and DSO, so one driver change refreshes the whole model. Data required: bookings pipeline, DSO by customer segment, headcount plan, and billing frequency.
• 12+ Months Or Risk Analysis: Use scenario analysis on top of the driver-based model. Stress-test at least three scenarios, with the downside case assuming slower collections, a delayed deal, or a temporary cost increase.

Choosing By Data Availability

A direct 13-week forecast needs clean AR aging and confirmed bank balances. If AR aging is unreliable, inflow projections drift, so fix the bookkeeping before building the forecast. A cash flow forecast is only as reliable as the data beneath it.

Choosing By Company Size

A 20-100 employee company without a treasury team benefits from a staged rollout. Start with a rolling 13-week direct forecast because it delivers immediate liquidity visibility. Once that forecast runs reliably, layer on a monthly driver-based model to support planning decisions. Add quarterly scenario analysis when a specific event such as fundraising, a credit facility negotiation, or a major capital decision requires it.

Get a method-selection recommendation based on your current data, team size, and planning horizon, and see how Condesa Financial Group can build and maintain the right mix for you.

The Combined-Cadence Model For 20-100 Employee Companies

The most defensible forecast for a 20-100 employee company uses three methods on three cadences with connected outputs. Each layer answers a different question while feeding the others.

Layer 1 — 13-Week Rolling Direct Forecast (Weekly Cadence): This layer serves as the liquidity instrument. It tracks actual cash receipts and disbursements week by week, built from AR aging in QuickBooks Online, bank feeds, payroll data from Gusto, and AP schedules from Ramp. A well-maintained 13-week cash flow forecast targets high accuracy in the near weeks and gradually lower accuracy by week thirteen. The controller or fractional CFO owns this layer and updates it every week. A 13-week forecast that is not updated weekly becomes unreliable within a short period.

Layer 2 — Monthly Driver-Based Forecast (Monthly Cadence): This layer serves as the planning instrument. It derives cash flow from a focused set of operational drivers such as bookings, headcount, DSO, billing terms, and gross margin. For a professional services firm, revenue is modeled as staff FTEs multiplied by billable hours per week, utilization rate, and average billing rate. The FP&A owner or fractional CFO updates this monthly by replacing the prior month’s forecast with actuals and rolling the horizon forward. Where the 13-week direct forecast and the monthly driver-based model overlap, they should reconcile.

Layer 3 — Quarterly Scenario Analysis (Quarterly Cadence): This layer serves as the risk instrument. It models base, downside, and upside outcomes against the driver-based model’s assumptions. A downside case should model new sales down 25-40%, collections stretching 10-15 days, and one large customer churning or paying late. Build triggers in advance, such as freezing hiring and cutting discretionary spend if ending cash in any forecast week drops below a defined threshold. The fractional CFO owns this layer and presents it to the CEO and board each quarter.

The three layers connect in a loop. The 13-week direct forecast feeds actual cash data into the monthly driver-based model, which corrects collection timing assumptions. The monthly driver-based model feeds the scenario analysis with updated driver values. When the 13-week forecast flags a projected shortfall, the scenario analysis provides the pre-built response playbook.

What Is A 3-Way Cash Flow Forecast?

A 3-way forecast links the P&L, balance sheet, and cash flow statement so that a change in one flows correctly through the others. Net income from the P&L flows into retained earnings on the balance sheet and into the cash flow statement as the starting point under the indirect method. Ending cash from the cash flow statement must equal cash on the balance sheet. If the balance sheet does not balance, the model is wrong somewhere.

For SMEs, a 3-way forecast matters most in three situations:

• Fundraising: Investors and lenders expect an internally consistent model. A standalone P&L projection without a linked balance sheet and cash flow statement cannot show whether the business will have the cash to execute its plan.
• M&A: Acquirers and their advisors stress-test the model. A 3-way forecast that breaks under scenario analysis signals weak financial controls.
• Major Capital Decisions: A new facility, a significant equipment purchase, or a large hiring plan each affects the balance sheet and cash flow in ways a P&L alone cannot capture. For SaaS businesses, a 3-way forecast handles deferred revenue by recognizing income proportionally on the P&L while tracking the full cash injection on the cash flow statement and the unearned portion as a liability.

A 3-way forecast works best after a reliable 13-week direct forecast is in place. Build the operational layer first, then add the 3-way model as the strategic layer above it.

Which Cash Flow Forecasting Method Is Most Accurate?

Accuracy depends on time horizon and data quality rather than a single superior method.

• Direct Method, 1-13 Weeks: This method gives the most accurate short-term liquidity view. Weeks one through four rely mostly on committed data such as invoices already raised, approved bills, payroll, rent, loan repayments, and known tax amounts, while weeks nine through thirteen rely more on assumptions. The direct method stays accurate in the near term because it tracks actual cash timing.
• Driver-Based Method, 1-12 Months: This method works best for medium-term planning when drivers are well-calibrated. Mature finance teams maintain both a direct 13-week forecast and an indirect 12-24 month model, and the two should reconcile where they overlap.
• Scenario Analysis, 12+ Months: This method focuses on bounding the range of outcomes and pre-building responses rather than point accuracy. Research from the International Journal of Forecasting shows that probabilistic forecasts often outperform point estimates for decisions under uncertainty.

The practical question becomes which method gives the most reliable answer for the decision in front of you this week. For payroll and vendor payments, use the direct method. For hiring plans and credit facility sizing, use the driver-based model. For fundraising and risk planning, use scenario analysis.

Data Requirements And Failure Modes

Core Data For Each Forecast Type

• 13-Week Direct Forecast: AR aging segmented by expected collection week, AP aging segmented by net due date, payroll schedule with exact pay dates from Gusto, bank balance reconciled to the actual bank statement, and a calendar of known one-time items such as quarterly taxes, insurance renewals, and planned capital expenditures.
• Monthly Driver-Based Forecast: Bookings pipeline by close date and contract type, DSO by customer segment based on actual payment history, headcount plan with start dates and fully loaded cost per head, and billing frequency data showing whether customers pay monthly or on annual prepay.
• Quarterly Scenario Analysis: The driver-based model plus assumption ranges for the three to five drivers that most affect cash, typically collections timing, sales volume, and key cost drivers.

Forecast Decay And How To Fix It

A 13-week cash flow forecast that is built once and reviewed passively loses predictive value within two to three weeks, and skipping two consecutive weeks of updates usually degrades accuracy below useful thresholds. Forecast decay happens as assumptions about customer payment timing, disbursement dates, and cash balances drift from reality.

The fix is a rolling update cadence. A 13-week cash flow forecast should be updated weekly so a new week thirteen rolls in as the completed week drops out and each week’s actual results feed back into assumptions. The five most common causes of forecast decay at SMEs are:

• Using invoice dates instead of expected payment dates for AR inflows.
• Omitting irregular disbursements such as quarterly estimated taxes and annual insurance renewals.
• Failing to roll the forecast forward weekly.
• Projecting best-case collection scenarios instead of observed payment behavior.
• Treating the forecast as a finance-only exercise without input from sales and operations on pipeline timing and purchasing commitments.

Collections are the single largest variable in any cash forecast and also the hardest to predict. Most companies lack a systematic way to model collection timing based on historical payment patterns, so they guess optimistically and variance accumulates. The practical fix is to apply actual historical collection rates to AR aging buckets. For example, collect 85% of current (0-30 day) balances, 75% of 31-60 day balances, 50% of 61-90 day balances, and 20% of 91+ day balances in the period.

How Condesa Financial Group Supports SME Forecasting

Condesa Financial Group builds and maintains the combined-cadence model described in this guide for SMEs with 20-100 employees. The firm provides fractional CFO oversight and outsourced accounting staffed by ex-Big 4 (EY, PwC) professionals nearshore from Panama and Mexico City at rates that compare favorably with US-market alternatives.

For the 13-week direct forecast, Condesa pulls AR aging and bank feeds directly from QuickBooks Online, AP schedules from Ramp, and payroll data from Gusto. The weekly update cycle of reconciling actuals, rolling the horizon forward, and flagging variance takes 60-90 minutes per week under Condesa’s operating model. This cadence aligns with practitioner guidance that a controller or fractional CFO spending 60-90 minutes a week on the 13-week model, with brief input from AR and AP owners, works for most SMBs without a full treasury team.

For the monthly driver-based forecast and quarterly scenario analysis, Condesa’s fractional CFO translates operational data into a planning model the CEO can use for hiring, capital, and financing decisions. The founder personally delivers the fractional CFO layer and handles questions on tax structuring, fundraising readiness, and working capital management that sit beyond a bookkeeping team’s scope.

Condesa’s financial modeling has supported two closed capital raises for Ecuador’s largest real estate developer, with $20M and $80M secured for separate projects. For an Austin-based real estate startup, Condesa rebuilt a prior CFO’s financial model in four weeks, producing a cohesive model and investor narrative for an active raise.

The firm serves clients across the United States, Latin America, and select engagements in Europe and Asia. Clients in high-cost-of-living US markets such as New York, Chicago, and San Francisco often see the largest price advantage relative to local fractional CFO and outsourced accounting options.

Schedule a forecasting review to benchmark your current process, identify method gaps, and design a combined-cadence model sized to your team and data.

Frequently Asked Questions

How Do I Create A Cash Flow Forecast In Excel?

A 13-week direct cash flow forecast in Excel uses 14 columns, one label column and 13 weekly columns, and three sections: cash inflows, cash outflows, and a weekly summary. Start from the reconciled bank balance across all operating accounts. Build inflows from AR aging segmented by expected collection week and apply historical payment rates to each aging bucket. Build outflows from AP aging segmented by net due date, the payroll schedule with exact pay dates, and a calendar of known one-time items such as quarterly tax payments and annual insurance renewals.

Calculate the running balance each week. Opening balance plus inflows minus outflows equals closing balance, which becomes the next week’s opening balance. The initial build usually takes four to eight hours, and weekly maintenance takes 30-60 minutes once the template is in place. The model should be updated every week without exception, for the reasons covered in the forecast-decay section.

How Often Should I Update My Cash Flow Forecast?

Update the 13-week direct forecast weekly on a fixed day, replacing the prior week’s forecast with actuals and adding a new week at the far end. Update the monthly driver-based forecast monthly, rolling forward one month and refreshing driver assumptions based on actual results. Refresh quarterly scenario analysis each quarter and after any structural change such as a major FX move, a large customer win or loss, or a financing event.

More frequent updates make sense during periods of tight liquidity, rapid growth, or active fundraising. Match the update cadence to the decision cadence. If the CEO makes cash-affecting decisions weekly, the forecast needs to stay current weekly.

Can I Run Cash Flow Forecasting Without A Fractional CFO?

A controller or fractional CFO, not a bookkeeper, typically builds and maintains a 13-week direct cash flow forecast using clean books from an accounting system such as QuickBooks or Xero. That person pulls AR and AP aging, payroll schedules, and bank data, then updates the model weekly with variance analysis.

The mechanical work stays manageable. The gap often appears in interpretation and response, such as deciding whether a projected shortfall calls for a credit line draw, a collections push, or a disbursement delay, and then framing that analysis for the CEO. Driver-based forecasting and scenario analysis also require judgment about which drivers to model, what assumption ranges are defensible, and how to connect the forecast to a fundraising or lender narrative.

These layers are where fractional CFO oversight adds the most value relative to cost. Companies preparing for a capital raise, managing a credit facility with cash covenants, or navigating rapid growth usually find the interpretation and communication layer hard to sustain without senior finance expertise.

What Is The Difference Between A Cash Flow Forecast And A Budget?

A budget sets a target for what the business intends to achieve over a fixed period, typically a fiscal year, and leaders measure performance against it. A cash flow forecast estimates what will actually happen to cash balances over a forward-looking horizon and updates regularly as new information arrives.

A budget answers whether the business is on track against its plan. A forecast answers whether the business will have enough cash to meet obligations in a specific week. The annual budget and the 13-week rolling forecast should live as separate tools, with the forecast grounded in actual transaction data rather than budget assumptions.

What Data Do I Need Before Starting A Cash Flow Forecast?

The minimum data set for a 13-week direct forecast includes the reconciled bank balance across all operating accounts as of the forecast start date, an AR aging report segmented by customer and aging bucket with historical collection rates applied to each bucket, and an AP aging report segmented by vendor with net due dates.

You also need a payroll schedule with exact payment dates for the next 13 weeks, a debt service schedule with interest and principal payment dates, and a calendar of known one-time cash events such as quarterly estimated taxes, annual insurance renewals, and planned capital expenditures. If the AR aging is unreliable because the books are not current or transactions are miscategorized, the forecast will be unreliable regardless of method. Clean, current bookkeeping forms the foundation for every forecasting method.

Conclusion

Cash flow forecasting methods work as layers that answer different questions. The direct method shows whether cash will be in the account on a specific date this quarter. The driver-based method shows whether the operating model generates enough cash to fund the plan over the next year. Scenario analysis shows what happens to cash if the plan shifts.

A 20-100 employee company without a dedicated treasury team benefits from a combined cadence of 13-week direct for liquidity, monthly driver-based for planning, and quarterly scenario analysis for risk, with clear ownership for each layer. Method selection follows time horizon first, then data availability, then organizational capacity. Accuracy reflects how well the method fits the decision, how current the data is, and how consistently the model is updated.

Book a free consultation with Condesa Financial Group to assess your current forecasting process, identify method and data gaps, and build a combined-cadence model your CEO can rely on without hiring a full treasury team.

Condesa Financial Group is a price-competitive fractional CFO and outsourced accounting firm serving SMEs across the United States and internationally. The firm’s nearshore delivery model, staffed by ex-Big 4 professionals from Panama and Mexico City, provides Big-4-caliber financial oversight at rates accessible to 20-100 employee companies. Condesa measures success by building defensible financial models that hold up when it matters.