Cash Forecasting That Executives Trust: A Practical 13-Week Framework
A rolling cash forecast is useful when it is simple enough to update frequently and disciplined enough to expose changes in liquidity. A 13-week horizon is a common operating framework, but the appropriate horizon depends on the business.
Build the base model
Start with opening cash by account or operating pool. Add expected customer collections, payroll, taxes, supplier payments, debt service, capital spending and other material flows. Keep assumptions visible so reviewers can understand what drives each forecast line.
Separate known and estimated flows
Known scheduled payments can be entered with more confidence than uncertain collections. Use different categories for committed, probable and uncertain cash flows. This makes the forecast more informative than a single number that hides uncertainty.
Ownership by function
AR can provide collection assumptions, AP can provide payment schedules, payroll can provide payroll timing and treasury can consolidate the position. A single owner should maintain the final forecast while contributors remain accountable for their inputs.
Scenario analysis
Use at least a base view and one downside scenario for material uncertainties. Scenarios can test slower collections, higher expenses or delayed financing. The objective is to identify when management action would be required.
Forecast versus actual
At the end of each period, compare forecast and actual cash movements. Classify variances by timing, volume, assumption or missing item. Feed recurring causes back into the next forecast cycle.
Executive reporting
Executives generally need the opening position, projected minimum cash, major drivers, funding needs and material risks. Keep supporting transaction detail available for treasury and finance teams without overwhelming the main report.
Updated operational note
Last reviewed: September 16, 2026. Forecasting methods should reflect the organization's accounting data, payment schedules and liquidity requirements.