Building a 13-Week Cash Flow Forecast
Module 4: Cash Flow & Working Capital, Chapter 6
The short answer
A 13-week cash flow forecast is a rolling, week-by-week projection of cash in and cash out, roughly one quarter at a time, updated weekly as actuals replace estimates. It's the practical tool that ties together everything in this module: your AR-based collections forecast, your cash conversion cycle, and the real cost of any financing gap.
Why 13 weeks specifically?
Because it's roughly one quarter, long enough to see a real trend and plan around it, short enough that the projections stay reasonably accurate. A monthly forecast is often too coarse to catch a specific week where cash runs tight; an annual forecast is too far out to be reliable at the weekly level.
What actually goes into it?
How does this connect to the rest of the module?
The "cash in" line is exactly the receivables forecast covered earlier in this module, applied week by week instead of as a single 30-day projection. The gaps this forecast reveals are exactly what a line of credit, covered in the previous chapter, exists to bridge. And the overall discipline of tracking it weekly is what turns the abstract cost-of-slow-DSO discussion into a concrete, visible number: the week your projected balance goes negative.
How should it actually be maintained?
As a rolling forecast, not a static one. Each week, replace that week's estimate with the real actual number, and add a new week 13 weeks out to keep the window constant. This is what makes it far more accurate than a forecast built once and left untouched, actuals continuously correct the model instead of estimates compounding errors over a full quarter.
What should you actually do with this?
Build the first version now, even roughly, using your current aging report and known recurring expenses. A ready-to-use 13-week cash flow forecast template, structured exactly this way, is available as a free download alongside this course, use it as your starting point rather than building the spreadsheet structure from scratch.
Quick check
Three questions. No email required, this one's just for you.
1. Why is 13 weeks a commonly used window for this kind of forecast?
2. What does the "cash in" line of a 13-week forecast primarily rely on?
3. Why is a rolling forecast, updated weekly, more accurate than one built once per quarter?
Frequently asked questions
Do I need special software to build a 13-week cash flow forecast?
No, a well-structured spreadsheet is sufficient for most small and mid-size businesses. The discipline of updating it weekly matters more than the tool used to build it.
What's the single most common mistake in building one of these?
Assuming AR collects exactly on schedule, rather than applying realistic collection rates by aging bucket, the same mistake covered earlier in this module's forecasting chapter.
What comes after this module?
Module 5, AR Metrics, Benchmarking & Reporting, goes further into building the ongoing reporting habit this forecast depends on.
Sources
- Standard 13-week rolling cash flow forecast methodology
Prefer to have this run for you?
A Receivables Review shows exactly where your own AR process could improve.
Book a Receivables Review