How to build a 13-week cash flow forecast

Most businesses that fail are profitable on paper. What kills them is timing — and a 13-week forecast is the best tool for seeing the collision coming.

A big invoice lands 45 days late, payroll hits next Friday, and suddenly a healthy company can't make a payment. A 13-week cash flow forecast is the single best tool for seeing that coming early enough to act. This guide walks through building one from scratch — the same structure banks, restructuring advisors, and CFOs use.

Why 13 weeks specifically?

Thirteen weeks is one quarter — the sweet spot between two bad extremes. A monthly budget is too coarse to catch a week where three big bills land at once. A daily forecast is too noisy to maintain. Thirteen weekly buckets show the genuine pinch points while staying realistic to update.

Step 1: Start with your actual cash balance

Not your balance from a statement three weeks ago. The real, cleared number today. Every forecast is only as good as its starting point, so reconcile first if your books are messy.

Step 2: Map cash IN by week

List every source of money coming in and when it actually lands — not when you invoice. This is what people get wrong. If customers pay on 30-day terms, an invoice you send this week is cash four-plus weeks out.

• Customer collections, by expected pay date
• New sales you expect to collect within the window
• Loans or funding draws
• Tax refunds or rebates

Be conservative — assume slow payers pay slow.

Step 3: Map cash OUT by week

Now the outflows, again by the week money actually leaves:

• Payroll and contractors — know your exact pay dates
• Rent and lease payments
• Loan and interest payments
• Software and subscriptions
• Inventory or cost of goods
• Taxes — mark the due dates now; they lump unpredictably

Step 4: Calculate net flow and ending cash

For each week:

Each week's ending cash becomes the next week's beginning cash. That chain is the whole forecast. Watch the ending-cash row — specifically the lowest point across all 13 weeks.

Step 5: Set a minimum buffer and flag breaches

Pick a floor — the minimum cash you'll operate with, often one payroll cycle. Any week your projected ending cash drops below it, you want a visible alert. That alert is the point: it tells you now that week 8 is a problem, while you still have seven weeks to fix it.

Step 6: Make it rolling

A static forecast goes stale in a week. Every Monday, drop the finished week and add a new week 13 at the far end. Ten minutes a week is the cost of never being blindsided by cash again.

Common mistakes to avoid

• Forecasting invoices instead of collections. Revenue isn't cash. Model when money arrives.
• Forgetting lumpy items. Quarterly taxes and annual renewals wreck a forecast that only models smooth costs.
• Being optimistic on inflows. If you must be wrong, be wrong slow on money in, fast on money out.
• Not updating it. A forecast you never touch is worse than none — it gives false confidence.

This article is for general informational purposes and isn't financial, tax, or legal advice. For decisions specific to your business, consult a qualified professional.