The 13-Week Cash Flow Forecast: Why Lenders Ask for It and How to Build One

Ask any bank, invoice financier or turnaround adviser for the one document they want from a small company under pressure, and the answer is the same: a 13-week cash flow forecast. Not the annual budget, not last year’s accounts — a week-by-week view of the cash actually coming in and going out over the next quarter. This guide explains why that specific format matters, how to build one properly, and the mistakes that make lenders discount yours on sight.

Why 13 weeks?

Thirteen weeks is a quarter — long enough to see a VAT bill, a payroll cycle repeating, and a slow-paying customer’s effect on your position; short enough that the numbers stay grounded in real invoices and real commitments rather than hope. Annual forecasts smooth over the exact thing that kills small companies: the week where three outflows land together and the inflows don’t. Profitable businesses fail in specific weeks, not in specific years.

What goes in it

The structure is simpler than the reputation suggests. Columns for each of the next 13 weeks; rows split into receipts and payments; a running closing balance along the bottom.

  • Opening balance: actual bank position, today, all accounts netted.
  • Receipts: week by week, when customers will actually pay — not when invoices fall due. If a customer habitually pays at 45 days, forecast 45 days.
  • Payments: payroll, rent, suppliers, loan repayments, and the ones that ambush people — VAT quarters, PAYE each month, Corporation Tax, insurance renewals, and the annual software subscriptions everyone forgets.
  • Closing balance each week: the line that matters. Any week it goes negative is a decision you need to make now, not then.

The mistakes that make lenders ignore your forecast

  1. Invoice-date receipts. Forecasting cash on the date you invoice rather than the date customers pay inflates the early weeks and destroys credibility with anyone who reads forecasts for a living.
  2. Missing tax weeks. A forecast with no VAT payment in it tells a lender you haven’t reconciled it against reality. As we covered in how lenders actually read your accounts, the tax lines are where they look first.
  3. Round numbers everywhere. £10,000 in, £8,000 out, every week, is a sketch, not a forecast. Real weeks are lumpy; the lumps are the point.
  4. Never updating it. A 13-week forecast is a rolling document — each week you replace the week that just happened with actuals and add a new week 13. A forecast built once for a funding application and never touched again reads exactly like what it is.

When you’ll be asked for one

Applying for a working-capital facility or short-term finance; negotiating time to pay with HMRC; any conversation where an accountant, investor or bank wants evidence you understand your own cash. Arriving with a credible rolling 13-week forecast changes the tone of all of these conversations — it is the clearest possible signal that the numbers are managed rather than discovered.

Building it: spreadsheet or software

A spreadsheet works, and plenty of finance directors run exactly that. The honest costs are time — keeping receipts realistic and rolling it weekly is a discipline — and the risk that the forecast drifts from what’s actually in your accounting system.

If your books are on Xero, Vigil for Business builds the 13-week rolling forecast directly from your live Xero data, alongside a monthly board pack, balance-sheet health checks, a forward P&L view and a tax calendar with every VAT, PAYE and Corporation Tax date. There’s a free read-only preview — connect Xero and see your bookkeeping score and the issues found, no card required — and the full suite is £39/month with a 14-day trial. Disclosure: Vigil is developed by an associated company.

Frequently asked questions

How is this different from a budget?

A budget allocates spending over a year and measures performance. A cash flow forecast predicts your bank balance week by week. You can be exactly on budget and still hit a week where you cannot pay wages — the forecast exists to see that week coming.

Should I use invoice dates or payment dates?

Payment dates, always — based on how each customer actually behaves, not your payment terms. This single choice separates forecasts lenders trust from ones they discount.

How often should it be updated?

Weekly. Replace the completed week with actuals, extend the horizon by one week, and note where reality diverged from forecast — the divergences teach you more than the forecast itself.


Want someone to look at it properly?

A cash flow forecast is only as good as the bookkeeping underneath it. Insight Professional Partners is the accountancy practice run by this site’s author, a CIMA Member in Practice. Start with the free bookkeeping health check — it tells you what an accountant would find in your books, at no cost and with no obligation.

Raising finance?

If the forecast shows a gap you cannot bridge internally, Granton Finance arranges commercial facilities and will tell you honestly whether the numbers support the ask before you approach anyone.

About the author. Peter Edwards ACMA CGMA is the founder of Finance Clearly. He qualified with the Chartered Institute of Management Accountants and has spent 25 years in corporate finance, most recently as a finance director.

General information, not financial or tax advice, and Finance Clearly is not authorised or regulated by the Financial Conduct Authority. Rates and allowances change; confirm the current position on GOV.UK before acting.