How to build a 13-week cash flow forecast that keeps you ahead of cash problems

A 13-week cash flow forecast is the most practical financial tool for managing business cash. It's long enough to see problems coming with enough time to act, short enough to be accurate, and granular enough to be actionable. Any business that has ever been surprised by a cash shortfall should be running this.

The structure: 13 weeks, one column per week. Three sections: cash in (collections from clients, any other inflows), cash out (payroll, vendor payments, rent, loan EMIs, tax payments, any other outflows), and net position (opening balance + cash in - cash out = closing balance). The closing balance each week becomes the opening balance for the next week.

Build it bottom-up, from actual expected transactions. Don't estimate — use your accounts receivable aging to project collection dates, your purchase orders and vendor payment terms to project outflows, and your payroll dates, rent dates, and EMI dates for fixed outflows. The more specific your inputs, the more useful the output.

The forecast will almost immediately show you weeks where your projected closing balance is uncomfortably low or negative. Those are your action points: is there a receivable you can collect earlier? A payment you can defer? A credit facility you can draw? The value of the forecast is that you see these situations 4–8 weeks in advance and have time to act, rather than seeing them 4 days in advance when your options are limited.

Update it weekly — every Monday, roll forward by one week (drop week 1 now that it's complete, add a new week 13), update actual collections and payments from the prior week, and revise forward weeks based on any new information. The forecast should take 30–60 minutes per week to maintain.

Share it with your CFO, finance manager, or accountant. This should be a shared tool, not a founder's personal spreadsheet.