The 13-week cash flow forecast: a practical guide for treasury teams

The 13-week cash flow forecast is the workhorse of short-term liquidity management. It's long enough to see a full quarter of obligations and short enough to forecast with real accuracy. Done well, it tells you exactly when cash gets tight — and gives you time to act.

Why 13 weeks?

Thirteen weeks is one quarter. It lines up with how most businesses think about near-term obligations: payroll cycles, supplier terms, tax payments, and debt service. It's the horizon where a direct forecast — built from actual expected receipts and disbursements — beats a model extrapolated from the P&L.

What goes into it

A solid 13-week model is organized by category and by week:

• Receipts — customer collections, interest income, intercompany inflows
• Disbursements — payroll, suppliers (AP), rent, tax, debt service
• Financing — drawdowns, repayments, FX settlements

Each line is forecast per week, then rolled up to a net movement and an ending cash position per bank account.

Variance analysis is the point

A forecast you never check is just a guess. Each week, compare last week's forecast to what actually happened, by category. Persistent variance in one category — say, collections always landing a week late — is a signal to adjust your assumptions, not just the numbers.

This is exactly where Palm's models earn their keep: they learn the timing patterns in your historical transactions so the forecast self-corrects instead of waiting for a human to notice the drift.

Common pitfalls

1. Too much granularity, too soon. Start at the category level. Add detail where variance demands it.
2. Stale assumptions. Revisit collection and payment timing every cycle.
3. No owner. A forecast without a weekly owner decays within a month.

Build the structure once, automate the data, and spend your time on the decisions — not the spreadsheet.