How to Build a 13-Week Cash Flow Forecast for a UK Small Business

Most small businesses that get into trouble don't run out of customers. They run out of cash on a particular Friday, when the VAT bill, the payroll run and a late-paying client all land in the same week. A 13-week cash flow forecast is the cheapest early-warning system available to a UK small business. It takes an afternoon to set up, twenty minutes a week to keep going, and it will show you a squeeze roughly three months before it turns into an emergency.

Why thirteen weeks, and why weeks

Thirteen weeks is a quarter. That is long enough to cover a full VAT cycle and most supplier payment terms, but short enough that you can forecast with real names and real dates rather than guesses. Push much beyond three months and accuracy collapses, which is why most advisers suggest keeping the window fixed and rolling it forward one week at a time.

Work in weeks, not months. Months hide things. A month with a dreadful first fortnight and a strong finish looks perfectly healthy on a spreadsheet, even though you spent fourteen days wondering how you would make payroll.

Pick a start date — a Monday is traditional — and label each column with the week-ending date. Set up thirteen columns and never change the layout. Consistency matters far more than sophistication.

Start with the number in your bank, not your profit

Row one is your opening bank balance: cleared funds on day one, not the figure at the bottom of your profit and loss account. Those are different questions, and only one of them pays wages.

If you use accounting software, check the actual bank feed rather than the software's balance. Uncleared cheques, card payments that settle over several days and pending direct debits all create gaps between the two figures. Some of those gaps are a few pounds. Some are not.

Fill in the money coming in

List every source of cash you expect, by week. For most small businesses that means:

• Customer payments, invoice by invoice, using the date you genuinely expect the money — not the date printed on the invoice
• Recurring or subscription income, entered as a single line
• Cash and card takings, if you trade directly with the public
• VAT repayments, if you are usually in a repayment position
• Everything else: a grant tranche, an asset sale, an insurance payout, a director's loan

Forecast the payment date, not the amount

This is where most first attempts go wrong. A £6,000 invoice due on 14 March does not produce £6,000 on 14 March. Look back at how that customer actually pays. If they routinely take an extra three weeks, put the cash in the first week of April and keep it there. If a large customer always settles in the middle of the month, forecast it that way.

A forecast that is slightly gloomy is useful. One that flatters you is dangerous.

Fill in the money going out

Be exhaustive here. Missing a quarterly bill is the most common reason a forecast looks fine and then isn't. Work through a year of bank statements if you have to, and include:

• Payroll, including PAYE and National Insurance, on the date it leaves your account
• VAT, on the correct quarterly date, allowing for the month's delay if you file quarterly
• Suppliers and subcontractors — the ones you will actually pay this quarter
• Rent, business rates, service charges and utilities
• Insurance, especially annual premiums paid in one go
• Loan and lease repayments, including any balloon payments
• Corporation Tax and Self Assessment payments on account
• Pension contributions, professional subscriptions, software and any direct debits you have forgotten about

Round up rather than down. If a bill is usually £1,180, enter £1,200. Build a small cushion into the lines you are least sure about.

The timing shocks that catch people out

Cash flow problems are rarely caused by a business being unprofitable. They are caused by large payments clustering. Watch for:

• Quarterly bills — VAT, rent, insurance — landing in the same week
• The 31 January and 31 July Self Assessment dates, which arrive with little warning if you have not set anything aside
• Payroll falling on the last working day before a bank holiday
• Seasonal dips: the quiet fortnight after Christmas, the August slowdown, a lull specific to your sector
• Supplier payments on strict terms when your own customers take sixty days

Once you can see the cluster, you can act on it: bring a payment forward, ask a customer for earlier settlement, or agree a short extension with a supplier before the date rather than after it.

Read the forecast, don't just build it

Add a closing balance for every week: last week's closing balance, plus inflows, minus outflows. That single row is the whole point of the exercise.

Now look at it properly. Mark your minimum acceptable balance — many owners use a figure covering two weeks of payroll and essential bills — and highlight any week that drops below it. Then answer three questions:

1. Which week is the tightest, and why?
2. Is the problem a timing issue or a genuine shortfall?
3. What can I do four weeks earlier that I cannot do in the week it happens?

Run two or three versions side by side: a base case, a bad case where your two slowest payers drift another month, and a good case. The bad case is the one worth planning for.

Making it stick

Update it every week with what actually happened. Replace the forecast column with real figures, leave it as history and add a new week at the end. Thirty minutes on a Monday morning is enough. The discipline matters far more than the spreadsheet.

Keep it somewhere you will actually look at it, and share it with your accountant or bookkeeper before a squeeze becomes a crisis. Lenders, suppliers and HMRC are all considerably easier to deal with when you raise an issue three months ahead rather than three days. HMRC does have formal arrangements for spreading tax payments, and a bank would far rather see you arrive with a forecast than with an apology.

One final point: a 13-week forecast is a planning tool, not a substitute for professional advice. If your numbers suggest you may struggle to pay a tax bill, a loan or your staff, speak to an accountant or a licensed insolvency practitioner early. That conversation is almost always cheaper than the alternative.

Photo: TheAngryTeddy / Pixabay