How to Build a 13-Week Cash Flow Forecast

A 13-week cash flow forecast lists opening cash, expected receipts, and expected payments for each of the next thirteen weeks. It is not an annual budget. It is a dated map of whether Friday’s payroll still exists in week nine. Build it from bank reality, not from hoped-for revenue.

Why thirteen weeks

Thirteen weeks is a quarter you can still name. It covers at least one tax date, one rent cycle, and several payrolls for most small firms. An annual budget can hide a two-week hole. A 13-week model cannot if you put real dates on the rows.

Protiviti’s 2026 Global Finance Trends Survey found 83 percent of CFOs ranked cash management among their top three areas of attention. The operational version of that finding, for a founder without a treasury team, is this forecast on a weekly refresh.

What goes in the first column

Start with spendable cash, not the whole bank total. Remove tax withheld, customer deposits you would have to return, and any restricted balance. That opening number is the only honest beginning. Bluevine’s October 2025 survey of 774 owners found 38.7 percent could not cover a month of operating expenses from cash on hand. If your opening line includes money you cannot spend, the whole model lies.

Receipts: dates, not wishes

Put invoices in the week you have evidence they will pay, not the week you issued them. Evidence means a date from the customer, a standing payment run, or a history you can defend. Everything else belongs in a slower bucket, not in week two.

Xero’s U.S. Small Business Insights for the second quarter of 2026 found average time to get paid at 29.3 days, up from 28.6 in the first quarter, while late payments improved slightly to 8.5 days. Use your own average days to pay, not a textbook 30. If a large customer just stretched terms, move their row out even if the invoice says net 15.

Do not forecast a miracle collection

A 13-week model that only works if a disputed invoice lands this Thursday is a hope chart. Keep a separate “upside” column if you need morale. The operating column should still close without it.

Clockwork.ai’s July 2026 analysis found one in five small and midsize businesses under $30 million revenue were projected to hit a cash crunch within 90 days, many of them profitable. Ninety days is roughly the span of this model. If week 8 goes negative in the base case, you have seen the crunch while you can still change collections or cost.

Payments: payroll first, then the calendar

Enter payroll on the actual pay date, including tax remittances. Enter rent, software annuals, loan draws, and inventory receipts on the dates they leave the account. Split large annual bills into the week they hit, not into a monthly average that never matches the bank.

SoFi’s 2026 small-business survey found 55 percent of owners had three months of cash or less. Three months is twelve to thirteen weeks. The model is sized for the reserve most owners actually have.

A weekly close of the model

Every Monday, replace last week’s forecast with actual cash in and out. Move slips to the new week. Recalculate the lowest week. If the lowest week is inside two payrolls, freeze hiring and start collection calls that day.

Hackett’s working-capital survey, reported by CFO.com in September 2026, showed days sales outstanding up 2.1 days for large U.S. nonfinancial companies in 2025. Your customers may be in that drift. The forecast is where you notice it before the P&L does.

What the model is not

It is not a full P&L. Depreciation does not belong here. Accrued revenue that has not been collected does not belong in receipts. Loan proceeds do belong, because they are cash, but they should be labeled so you do not mistake debt for sales.

Keep the sheet small enough that you will update it. Twelve receipt rows and twenty payment rows beat a 200-line workbook you abandon.

Frequently asked questions

How do I start a 13-week cash flow forecast this afternoon?

Opening spendable cash, payroll dates, rent, tax, and the invoices you truly expect in the next four weeks. Fill later weeks after that core is honest.

Should I include uninvoiced pipeline?

Not in the base case. Put pipeline in an upside column. The operating forecast should survive if no new deal closes.

How often should I update it?

Weekly, and on any day a large invoice is paid or slips. A monthly update is an annual budget in disguise.

What if every week looks fine until a tax payment?

That is the model working. Put the tax date in. Then either reserve cash in earlier weeks or change the payment plan before the week arrives.

Can software replace the dated list?

Software can pull bank and invoices. You still have to judge which receipts are real. The judgment is the forecast.

What number should sit at the top of the dashboard?

The lowest weekly closing cash in the next 13 weeks, and the date it hits. That pair beats a single runway multiple.