Plenty of profitable businesses run out of cash. Customers pay late, a big supplier invoice lands the same week as payroll, or a tax payment gets forgotten. A 13-week cash flow forecast is the simplest tool I know for seeing that coming.
Thirteen weeks is one quarter. It’s long enough to spot a problem while you can still do something about it, and short enough that your estimates stay realistic. Weekly columns matter because cash problems happen in specific weeks, not averaged across a month.
You need three blocks of rows:
Closing cash for one week becomes opening cash for the next. That’s the whole model.
The most common mistake is optimism. If a customer usually pays 45 days after invoice, forecast 45 days, even if your terms say 30. If you’re not sure a deal will close, leave it out and treat it as upside.
A forecast that’s usually a bit pessimistic is far more useful than one that’s usually a bit wrong in your favour.
Seeing a shortfall eight weeks out gives you options: chase specific invoices, ask a supplier for different terms, move a purchase, or talk to your bank before you need the money rather than after. Seeing it the same week gives you very few.
A spreadsheet is enough to start. Once the routine sticks, the same structure can move into a dashboard that pulls actuals from your accounting software automatically.