Cash Flow Forecasting

What Is Cash Flow Forecasting?

Cash flow forecasting is the process of estimating how much cash will flow into and out of an organization over a future period — typically 13 weeks, 6 months, or 12 months. Unlike accrual-based P&L forecasting, cash flow forecasting focuses on the timing of actual cash movements: when customers pay, when suppliers are paid, when payroll clears, when debt service is due.

A well-maintained cash flow forecast is one of the most important tools available to a CFO. It answers the question that keeps business owners up at night: will we have enough cash to run the business?

Why Cash Flow Forecasting Matters

Liquidity management: Identifying future cash shortfalls early enough to arrange financing, delay discretionary spending, or accelerate collections.

Capital allocation: Knowing when excess cash will be available to invest in equipment, inventory, acquisitions, or debt paydown.

Covenant compliance: Many debt agreements include minimum cash or liquidity covenants. Forecasting helps ensure compliance before a violation occurs.

Investor and board confidence: PE-backed companies and businesses with outside investors are often required to maintain current cash forecasts. Accurate forecasts build credibility; surprises destroy it.

Types of Cash Flow Forecasts

Short-Term (13-Week Rolling Forecast)

The most operationally important format. A 13-week rolling cash forecast tracks week-by-week cash movements, updated weekly. Used for day-to-day liquidity management and banking relationships.

Medium-Term (6-12 Month)

Bridges the short-term cash view with the annual operating plan. Less granular than the 13-week, but captures seasonal patterns, major capital expenditures, and debt obligations.

Long-Term (Multi-Year)

Used for strategic planning, M&A evaluation, and capital structure decisions. Typically built on assumptions rather than specific transaction-level data.

The Three Approaches to Cash Flow Forecasting

Direct Method

Forecasts cash inflows and outflows directly from operational data: accounts receivable aging (when customers will pay), accounts payable schedules (when suppliers are paid), payroll calendars, and scheduled debt payments.

• Pros: Most accurate for short-term forecasting; closely tied to operational reality
• Cons: Requires detailed AR/AP data; harder to maintain at scale

Indirect Method

Starts with net income and adjusts for non-cash items (depreciation, amortization) and working capital changes (AR, inventory, AP movements).

• Pros: Easier to build from existing financial statements; works for medium-to-long-term
• Cons: Less precise for short-term; dependent on P&L forecast accuracy

Hybrid Approach

Combines direct method for the near-term (4-8 weeks) with indirect method for longer periods. Most sophisticated FP&A teams use this approach.

Common Cash Flow Forecasting Challenges

Disconnected systems: AR data is in the ERP, inventory is in the warehouse system, and payroll is in a separate HR platform. Getting all of it into one place for cash forecasting requires significant manual work.

AR timing uncertainty: Customers rarely pay exactly on their stated terms. Building realistic collection timing assumptions requires analyzing actual payment history — data that many companies don’t have readily accessible.

Revenue forecast dependency: Cash forecasts are only as good as the revenue forecasts they’re built on. If sales pipeline data is disconnected from the finance function, cash forecasting accuracy suffers.

Manual update burden: Keeping a 13-week cash forecast current requires weekly updates from multiple data sources. In most mid-market companies, this is done manually in Excel — a fragile, time-intensive process.

How Go Fig Supports Cash Flow Forecasting

Go Fig connects AR aging, AP schedules, inventory levels, and revenue pipeline data into a centralized view — giving FP&A teams the real-time operational data needed to maintain accurate, continuously updated cash flow forecasts without manual data gathering.