The 13-Week Cash Flow Forecast: The Tool That Separates Businesses That Survive From Those That Don't

Why Profitable Businesses Go Bust#

A building contractor turns over £800,000 per year. Gross margin is 32%. Net profit is £68,000. By any measure, a healthy business. Then a large client delays payment by 60 days on a £120,000 project. Meanwhile, subcontractor wages, materials, and insurance premiums don't wait. The business runs out of cash in week eight. The overdraft limit is £40,000. The shortfall is £80,000. The bank won't extend the facility without security the owner doesn't have. The business enters administration. Net profit: irrelevant. Cash: fatal. This story repeats across every sector, every year, in every economy.

What a 13-Week Forecast Actually Is#

A 13-week cash flow forecast is a week-by-week projection of every pound coming in and every pound going out for the next three months. Starting balance, plus receipts (customer payments, loans, grants), minus disbursements (wages, rent, suppliers, tax), equals closing balance per week. The closing balance of week one becomes the opening balance of week two. You can see, at a glance, whether week nine has a negative closing balance — and you have nine weeks to do something about it rather than nine days. The "13 weeks" convention comes from insolvency practice: it's the standard visibility window for distressed business recovery, but it's equally powerful as a prevention tool.

Building Your First 13-Week Forecast#

Start with your opening bank balance — the actual number from your bank feed today. Add all confirmed inflows: invoices with due dates in the next 13 weeks, recurring revenue subscriptions, any confirmed grants or loan draws. Apply a collection rate to invoices — if your average customer pays 12 days late, shift each invoice's expected receipt date by 12 days. Add all known outflows: payroll run dates, rent, standing orders, supplier payment terms, quarterly tax payments, loan instalments. The resulting 13-column spreadsheet is your first forecast. It's imperfect. Update it weekly and it becomes indispensable.

AskBiz + Xero: The Forecast That Updates Itself#

Building a 13-week forecast in a spreadsheet works — until you stop updating it because it's tedious. AskBiz connects to your Xero data and generates the forecast automatically: invoices due populate the inflow rows, bills scheduled in Xero populate the outflow rows, and your live bank balance from the Xero bank feed becomes the opening balance. Every time you raise a new invoice or approve a new bill in Xero, the forecast updates. You open AskBiz on Monday morning and see the current 13-week picture — not a stale spreadsheet from three weeks ago. When week 7 shows a projected negative balance, AskBiz sends you a push notification. You have six weeks to act.

What to Do When the Forecast Shows a Gap#

A negative week in your forecast is not a crisis — it's intelligence. With six or eight weeks' warning, you have multiple levers: chase the two largest outstanding invoices today, delay a discretionary capital purchase by one month, negotiate extended payment terms with a supplier, draw on an existing revolving credit facility, or arrange a short-term loan. Any one of these actions is manageable. The same gap discovered on the Thursday before payroll is catastrophic. The 13-week forecast turns financial emergencies into financial decisions.

• Most small businesses that fail weren't unprofitable — they ran out of cash while waiting for money they were owed.
• A 13-week rolling cash flow forecast shows you, today, what your bank balance will look like every week for the next quarter.
• Built properly in AskBiz connected to Xero, it updates automatically as invoices are raised and bills are paid.