Cash Flow Forecast With AI: A 13-Week Forecast From Your Bank Statement in 30 Minutes

UK small businesses were paid 8.3 days late on average in the quarter to June 2026 and waited 29.1 days for their money, according to Xero's Small Business Insights, and the government's own analysis in July 2025 put the amount owed to small firms at any moment at £26 billion, about £17,000 per affected business, with 14,000 closures a year blamed on late payment. The Office for National Statistics found in June 2025 that 16% of trading businesses had no cash reserves at all, the highest share since 2020. Most of those businesses were profitable on paper. They ran out of cash on a Tuesday.

A cash flow forecast is the document that sees the Tuesday coming. Thirteen weeks is the standard horizon because it is one quarter: long enough to catch the VAT payment, the rent, the payroll and the Self Assessment bill, short enough to be built from real invoices and real direct debits rather than guesses. This guide shows how an AI agent builds one from a bank statement export in about 30 minutes, keeps it updated every Monday, and tells you which week needs a decision. It has the HMRC dates, the 2026 late payment numbers, the four prompts, what the forecasting tools charge, and the options when the forecast shows a gap. Everything was checked on 21 October 2026.

Why 13 weeks

The Association of Corporate Treasurers describes the operational cash forecast as a rolling 13-week view, and the reason is the calendar: a quarter contains every rhythm a small business has. Weekly takings, monthly payroll and rent, the quarterly VAT return, and at least one of the big annual dates. A 12-month forecast is a budget, built on assumptions. A 13-week forecast is built on things that are already true: the invoices you have sent, the direct debits that will leave, the dates HMRC has published. That is why it is the one lenders and accountants ask for first.

What goes in it

The last line is the point of the exercise. A forecast that shows £310 in week 7 three weeks in advance is a conversation with a customer or a supplier. The same number on the day is an overdraft charge.

Build it in four prompts

1. The forecast from the bank export

2. The receivables, with real expected dates

3. The scenarios

4. The Monday update

Four prompts, about 30 minutes the first time, and then five minutes a week. The free plan does it on 100 credits a day; the Go plan at £7 a month adds 2,000 credits for the weekly runs and the scenarios.

The dates that empty the account

• VAT: the return and the payment are due one calendar month and seven days after the end of the quarter. For a quarter ending 30 September, that is 7 November, and it is the week most forecasts hit their low point.
• PAYE and National Insurance: due by the 22nd of the following month when paid electronically, the 19th by post.
• Self Assessment: the balancing payment and the first payment on account on 31 January, the second payment on account on 31 July. A sole trader's January is two tax bills and a quiet month of sales.
• Corporation Tax: nine months and one day after the end of the accounting period for profits up to £1.5 million.
• Rent and insurance: quarterly rent and annual insurance renewals are the two payments people forget because they are not monthly. The agent finds them in the export.

Late payment: the numbers and the levers

• The numbers. The FSB and GoCardless surveyed 2,298 small businesses between October and December 2024 and found 45% seeing more late payments than a year earlier, with 24% paid up to 60 days late. The government's July 2025 analysis put the money owed at £26 billion, with 28% of businesses, about 1.5 million, affected. The Insolvency Service counted 21,590 insolvencies among small businesses in 2025.
• The interest. A business customer that pays late owes statutory interest at 8% above the Bank of England base rate, which has been 3.75% since the summer, so 11.75% a year, plus fixed compensation of £40, £70 or £100 per invoice depending on its size. Most small firms never claim it; an agent that adds the line to every business invoice changes the customer's priorities.
• The policy. The Fair Payment Code launched on 3 December 2024 and lists large firms by their payment record. The King's Speech on 13 May 2026 announced a Small Business Protections (Late Payments) Bill, reported to cap payment terms at 60 days and make interest on late payment mandatory; it is not law yet, so the forecast still assumes the real behaviour of each customer.
• The levers that work this quarter. Deposits on one-off jobs, invoicing on the day the work finishes rather than at month end, a card link on the invoice, and a chase at 7 and 14 days. The invoice guide covers the invoice itself.

When the forecast shows a gap

• Move the receipts. The chase list from prompt 2, a deposit on the next job, an early-payment discount of 2% for a customer who can pay this week.
• Move the payments. Ask the supplier for 45 days once, before the invoice is late. Time the owner's drawings around the VAT week. If an HMRC bill cannot be paid on time, ask HMRC for a Time to Pay arrangement before the deadline, not after.
• Borrow against what you are owed. Invoice finance advances most of an invoice's value the day it is raised, at a fee. For a larger or longer gap, the British Business Bank's Growth Guarantee Scheme, the successor to the Recovery Loan Scheme, carries a 70% government guarantee on facilities from £25,001 for term loans up to £2 million and has been extended to 2030; from July 2026 the terms on loans up to £1.1 million run to ten years. The forecast is the document the lender asks for.
• Change the model. If the gap is structural rather than a bad month, scenario 4 in prompt 3 is the one to read: a price rise with a smaller sales drop usually beats a cost cut.

What the forecasting tools charge

Keep the accounting software for the books. The forecast is a different job, and it is the one most small businesses never set up because the tool for it costs more than the overdraft fee it would save.

How an AI agent differs from a spreadsheet template

ChatGPT, Claude, Gemini, Microsoft Copilot, Manus and Meta's Muse will all explain a cash flow forecast and fill a template if you type the numbers in. Jobbit builds and maintains it:

• It reads the bank export and finds the recurring payments, the takings pattern and the odd ones out.
• It applies each customer's real payment habit to the invoices, so the receipts land in the right week.
• It runs the scenarios and names the two actions for each.
• It updates every Monday from the new export, explains the differences and rolls the forecast forward.
• It chases the invoices with the messages from the list, and adds the statutory interest line for business customers.
• It drafts the lender pack when a gap needs finance: the forecast, the receivables and the scenarios.

A 30-minute plan

• Minutes 0 to 5. Export 12 months of transactions as a CSV from your business account; Starling, Monzo Business, Tide and HSBC all do it from the app or the website.
• Minutes 5 to 15. Run prompt 1. Read the list of uncategorised transactions and answer them.
• Minutes 15 to 20. Paste your unpaid invoices. Run prompt 2. Send the first three chase messages.
• Minutes 20 to 25. Run prompt 3. Note the lowest week in each scenario.
• Minutes 25 to 30. Run prompt 4 and put "send bank export" in Monday's calendar.

Read next

• AI for spreadsheets: if the forecast has to live in Excel for your accountant.
• How to write an invoice that gets paid: the invoice the forecast depends on.
• Do you need invoicing software?: the agent that invoices, chases and reconciles.

Frequently asked questions

What is a 13-week cash flow forecast?

A week-by-week table of the cash coming in and going out over the next quarter, starting from today's bank balance and ending with a closing balance for each week. Thirteen weeks is the standard horizon because it covers every payment rhythm a small business has, including the quarterly VAT bill, and because it can be built from real invoices and direct debits rather than estimates.

How do I make a cash flow forecast from my bank statement?

Export 12 months of transactions as a CSV, then categorise them, find the recurring payments, work out the weekly takings pattern and lay the next 13 weeks out with an opening and closing balance for each. An agent on Jobbit does the categorising and the table from the export in a few minutes with prompt 1 above.

How often should I update a cash flow forecast?

Weekly. Reconcile last week against the forecast, explain the differences, roll it forward one week and update the expected dates on unpaid invoices. Prompt 4 sets the agent to do it every Monday from a fresh bank export and to send a one-page summary.

What are the HMRC payment dates a cash flow forecast must include?

VAT one calendar month and seven days after the quarter end; PAYE and National Insurance by the 22nd of the following month; Self Assessment on 31 January and 31 July; Corporation Tax nine months and one day after the accounting period ends. The VAT week is the low point in most small-business forecasts.

How late do UK customers pay?

Xero's Small Business Insights for the quarter to June 2026 put the average at 8.3 days late and 29.1 days to be paid. The FSB and GoCardless found 24% of small firms paid up to 60 days late in late 2024, and the government estimated £26 billion owed to small businesses at any time in July 2025. Late business customers owe statutory interest at 8% above base, 11.75% at the moment.

Can AI do a cash flow forecast?

Yes, and better than a template, because it reads the bank export and the invoices rather than waiting for you to type them. An agent on Jobbit categorises the transactions, applies each customer's payment habit, runs the scenarios and updates the forecast every Monday. You still make the decisions it flags.

What should I do if the forecast shows I will run out of cash?

Act in the order that costs least: chase the invoices on the list, take deposits on new jobs, ask a supplier for longer terms before the invoice is late, time your own drawings around the VAT week, and ask HMRC for a Time to Pay arrangement before a deadline rather than after. For a larger gap, invoice finance or a Growth Guarantee Scheme loan, with the forecast as the lender's pack.