A 13-week rolling cashflow forecast is one of the most powerful tools a business owner can have. Most people associate it with businesses in difficulty — it’s actually for businesses that want to stay out of it. Thirteen weeks is the sweet spot: long enough to see problems approaching, short enough to forecast with reasonable accuracy.
The structure is straightforward. Start with your opening bank balance. Add expected receipts each week — broken down by client, contract, or revenue line. Subtract expected payments — payroll, suppliers, PAYE, rent, subscriptions, loan repayments. The result is your closing balance each week, and a clear view of any weeks where cash goes negative.
The real value is in the review. Every Monday, update last week’s actuals and roll the forecast forward by one week. Where did actuals differ from forecast? Why? What does that tell you about the next twelve weeks? A cashflow forecast that’s reviewed weekly becomes a live model of your business — not a document that’s out of date the moment it’s finished. Pair it with a clear trigger point for action (say, when projected balance falls below one month’s costs) and you’ll never be caught off guard by a cashflow squeeze again.
