13-Week Cash Flow Forecast Template: Build One That Actually Works

Every finance leader eventually gets the same request, usually on a bad day: how much cash do we actually have, and how long does it last? The monthly P&L cannot answer that question. Cash lives and dies on timing, and a quarter of timing is exactly what a 13-week cash flow forecast gives you: far enough out to act, close enough in to be right.

Most templates fail for a boring reason. They start from the P&L and divide by four. Revenue is not receipts, expenses are not disbursements, and a month divided by four is not a week. A useful 13-week model is built direct: money in, money out, by week, on the calendar those payments actually follow.

The structure that works

You need five blocks and no more.

Opening balance. The real bank balance on the start date, not book cash. Reconcile once, then roll it forward.

Receipts. Take your revenue by month, then shift it by your DSO. If customers pay in 38 days, this week's receipts trace back to invoices from five and a half weeks ago. This single adjustment is most of the accuracy in the model. Add known one-offs (tax refunds, asset sales) as their own lines so nobody mistakes them for run rate.

Payroll. Model it on the payroll calendar, not smoothed. If you pay on the 15th and the last day of the month, two weeks out of four carry the hit. Payroll is the disbursement people get fired for missing, so it gets its own block.

Supplier payments. COGS and non-payroll opex, shifted by your DPO. If you are stretching payables, say so in the assumption cell instead of hiding it in the numbers.

Everything else, then the roll. Capex, debt service, distributions, a manual adjustment line for the things only you know are coming. Net the week, roll the balance, and put a minimum-cash threshold under it so the model flags the week trouble starts instead of making someone squint for it.

The five mistakes that break these models

One, starting from the P&L instead of cash. Two, smoothing payroll. Three, ignoring DSO and DPO and booking sales as same-week cash. Four, building it once for a board meeting and letting it rot; a 13-week model is a Monday ritual, twenty minutes, actuals in, week 14 added. Five, burying the assumptions; every timing assumption belongs in a labeled cell someone else can challenge.

How to maintain it in 20 minutes a week

Monday morning: enter last week's actual receipts and disbursements, reconcile the closing balance to the bank, roll the window forward one week, and read the flag row. If the minimum-cash flag trips inside six weeks, that is an escalation, not a footnote. The habit matters more than the math. A mediocre model updated weekly beats a beautiful one updated quarterly, every time.

A 13-week forecast will not make cash appear. What it does is buy you weeks of warning, and weeks of warning are the difference between quietly drawing a line of credit and explaining a missed payroll. Build it direct, shift it for timing, respect the payroll calendar, and update it every Monday.