If I could give every CFO one tool, it would be a disciplined 13-week rolling cash forecast. It's not glamorous. It won't impress anyone at a fintech conference. But it will save your business. Why 13 Weeks? The 13-week horizon is deliberate. It covers one full quarter — enough time to see seasonal patterns, anticipate covenant test dates, and plan for major outflows. It's short enough to maintain forecast accuracy, but long enough to provide meaningful decision-making lead time. The Weekly Cadence The power of the 13-week forecast isn't the spreadsheet — it's the cadence. Here's what a good weekly rhythm looks like: Monday • Update actual bank balances for the previous week • Roll the forecast forward by one week • Identify any new items that need to be included Wednesday • Review variance between last week's forecast and actuals • Adjust future weeks based on new information • Flag any headroom concerns to the CFO Friday • Circulate the updated forecast to key stakeholders • Highlight the top 3 risks and opportunities for the coming 4 weeks What to Include Your 13-week forecast should separately show: • Operating inflows (customer receipts, by entity if multi-entity) • Operating outflows (suppliers, payroll, overheads) • Financing flows (interest, principal repayments, new debt drawdowns) • Exceptional items (one-offs, M&A costs, restructuring) • Opening and closing cash by week • Headroom to facilities and covenant triggers Common Mistakes Forecasting Revenue Instead of Receipts Your forecast should show when cash arrives, not when you invoice. Map your DSO patterns and forecast receipts accordingly. Ignoring the “Lumpy” Items Tax payments, annual insurance premiums, bonus payments — these can be individually material. Map every significant irregular outflow. Letting it Go Stale A 13-week forecast that isn't updated weekly becomes worse than no forecast at all. It creates false confidence. The Payoff A well-maintained 13-week forecast delivers: • Early warning of cash shortfalls (weeks, not days) • Confidence in board reporting • Better bank relationship management • Foundation for long-term planning It's the single most impactful step on the journey to SLOS alignment.
Forecasting · 7 min read
The 13-Week Cash Forecast: Your Most Powerful Treasury Tool
The single most impactful tool a mid-market finance team can implement.