How to Build a 13-Week Cash Flow Forecast
The 13-week cash flow forecast is the most operationally critical financial tool for any company managing through a period of growth, stress, or transformation. This guide covers construction, maintenance, and the management disciplines that make it genuinely useful rather than a finance team exercise.
Why 13 Weeks?
The 13-week horizon (approximately one quarter) is the operational sweet spot for cash flow forecasting. Shorter horizons (4 weeks) provide high accuracy but insufficient lead time to respond to potential shortfalls. Longer horizons (6 months) become too speculative to be operationally useful—the precision required to plan week-by-week cash movements six months into the future is not achievable. The 13-week period also aligns naturally with quarterly business planning cycles, investor reporting schedules, and bank covenant measurement dates—all of which may have cash-related triggers or reporting requirements. For companies in distress or rapid growth, the 13-week forecast is not optional—it is the primary tool by which management demonstrates to lenders, investors, and boards that cash is being actively managed. Lenders who have extended forbearance agreements almost universally require weekly 13-week forecast updates as a condition of their cooperation.
Building the Model
The 13-week cash flow model has three components: cash inflows, cash outflows, and the net cash position. Build it as a true cash model—when cash actually moves, not when GAAP revenue is recognized or expenses are accrued. Cash inflows by week include: customer payments (build from the AR aging—which invoices are due when, and what is your historical collection rate by aging bucket?), any new contract payments expected, proceeds from any planned capital events (draws on credit facilities, equity proceeds if actively raising), and any asset sale proceeds. Cash outflows by week include: payroll (list each payroll date for the period, with the expected gross payroll each period); benefits and payroll taxes (typically paid 1–2 days after payroll); vendor payments (build from the AP aging—which payables are due when, and which will you pay on time vs. defer?); rent and facility costs (typically paid on the first of each month); software subscriptions; and any large one-time payments (tax payments, debt service, capex). The resulting weekly cash position (beginning cash + inflows – outflows = ending cash) should be reviewed by the CFO weekly and compared against the prior week's forecast to identify any forecast errors. Forecast errors are important diagnostic information—they reveal which assumptions are most unreliable and where the model needs improvement.
Managing the Forecast: Actuals vs. Forecast
The most common mistake in 13-week forecast management is treating it as a set-and-forget model. The forecast must be updated weekly—not just rolled forward, but genuinely updated with the prior week's actuals, with any changes to expected inflows or outflows, and with new information about the business that affects the cash outlook. Create a simple variance report each week: expected cash inflows vs. actual cash inflows, expected outflows vs. actual outflows, and the resulting impact on the cash position relative to the prior week's forecast. Any variance above a threshold (say, $25,000 for a company with $500,000 in weekly cash flows) should have an explanatory note. Share the 13-week forecast and the weekly variance report with the board or relevant investors. Many companies are reluctant to share detailed cash forecasts because they reveal the company's runway precisely and may trigger investor concern. But investors who are left to estimate runway from quarterly financials are often more concerned than they would be if given transparent, professionally managed cash reporting. Transparency about cash management builds confidence; opacity invites speculation.
Frequently Asked Questions
What software should we use to build the 13-week forecast?
Excel or Google Sheets for most companies. The 13-week cash flow forecast must be updated weekly and shared with multiple stakeholders—a spreadsheet format is more flexible and accessible than any purpose-built tool. Financial planning software can integrate a cash forecast, but the operational management process works equally well in a well-designed spreadsheet.
How do we forecast accounts receivable collections?
Build a collection curve from your historical data: what percentage of invoices are paid within 30 days, 60 days, and 90 days? Apply this collection curve to the current AR aging to project weekly collections. For companies with concentrated revenue (a small number of large customers), collect individual expected payment dates from each major customer account and use those to build the inflow forecast.
Related Articles
What a Fractional CFO Actually Does (vs. Your Bookkeeper)
Most early-stage companies confuse bookkeeping with financial leadership. A bookkeeper records what happened; a fractional CFO shapes what happens next. Understanding the difference—and knowing when your business needs which—is one of the most important financial clarity decisions a founder or CEO makes.
Read →
How to Build a Series A Financial Model from Scratch
A Series A financial model is not a spreadsheet exercise—it is the quantitative expression of your business thesis. Investors will spend hours in your model asking what-if questions, and the quality of your model directly affects their confidence in your financial management capability. Build it to withstand that scrutiny.
Read →
The Monthly Close Process: A CFO's Step-by-Step Guide
The monthly financial close is the operational heartbeat of the finance function. A clean, timely close process produces the reliable financial data that drives management decisions, satisfies investor reporting requirements, and creates the foundation for an annual audit. Most companies close too slowly and too inconsistently—here is how to fix that.
Read →
The Crimson Bench · Est. 2002 · Founded in New York City
Deploy an Executive in 48 Hours
Verified corporate accounts only. Ivy League-educated. Flat-rate pricing. 14-day no-cause cancellation.
25,000+ Ivy League Executives · 150,000+ Global Consultants · 48-Hour Deployment