How to Build a 13-Week Cash Flow Forecast

A 13-week cash flow forecast is the single most practical tool for managing short-term liquidity. It is long enough to capture a full quarter of cycles — receivables, payroll, inventory, debt payments — but short enough to stay accurate and actionable.

Why 13 Weeks

Monthly forecasts hide timing problems. A business can look profitable on a monthly basis but still run out of cash in week three because payroll hits before a major receivable clears. A weekly view over 13 weeks exposes those gaps before they become crises.

The Structure

Each week, track three things:

• Opening balance: cash on hand at the start of the week.
• Cash in: expected deposits, customer payments, and any funding draws.
• Cash out: payroll, rent, inventory, loan payments, taxes, and other obligations.

Closing balance = Opening + In − Out. That closing balance becomes next week's opening. The chain reveals exactly when the account dips below safe levels.

A Worked Example

Hypothetical example for illustration only.

Week 2 shows the danger: a large outflow (payroll plus a loan payment) hits before the week 3 receivable clears. Without this view, the owner would be surprised. With it, they can arrange a working capital draw in advance — or delay a discretionary expense.

What to Include in Outflows

• Payroll (including taxes and benefits)
• Rent and utilities
• Inventory and materials purchases
• All financing payments, including loan payments and daily/weekly MCA remittances
• Estimated taxes (sales, payroll, income)
• Owner's draw or distributions

If you carry a merchant cash advance, estimate its weekly deduction carefully — it is often the line item that breaks the forecast.

Keeping It Honest

A forecast is only useful if it is realistic. Common mistakes:

• Assuming all receivables arrive on time.
• Forgetting irregular expenses (insurance, equipment repairs).
• Omitting owner draws.
• Not updating it weekly — a stale forecast is worse than none.

Update the forecast every week with actuals, then roll forward another week. This is the core habit of effective cash flow planning — and it is what separates businesses that predict gaps from those that react to them.