13-Week Cash Flow Forecast · from 12 October 2026

Wyebridge Joinery Ltd

Bespoke staircases, windows and fitted joinery for builders and homeowners across Herefordshire and the Marches. 26 staff. Built from the bank balance, the aged debtors and creditors reports, the payroll and loan schedules, and the owner's sales forecast.

Worked example. Wyebridge Joinery is a fictional business; every name and figure is invented. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 1 note), the note being the weeks below the minimum cash.
The headline

A squeeze in late October and November

Bank today
£38,500
cleared balance on 9 Oct
Lowest point
−£40,880
Week 4, starting 2 Nov 2026
Weeks below the minimum
7 of 13
minimum set at £20,000; first in week 3
Overdraft
£40,880
most used, against a £50,000 limit
Week by week

Closing bank balance

At or above the minimumBelow the minimumMinimum cashOverdraft limit
Closing bank balance for each of 13 weeks, with the minimum cash line and the overdraft limit. The figures are in the table below.−£50k−£25k£0£25kMinimum £20kOverdraft limit −£50kWeek 1 (from 12 Oct): closing £38,6301Week 2 (from 19 Oct): closing £24,5402Week 3 (from 26 Oct): closing −£26,8403Week 4 (from 2 Nov): closing −£40,8804Week 5 (from 9 Nov): closing −£24,2305Week 6 (from 16 Nov): closing £4,7006Week 7 (from 23 Nov): closing −£15,4507Week 8 (from 30 Nov): closing −£4,2108Week 9 (from 7 Dec): closing £22,2409Week 10 (from 14 Dec): closing £41,73010Week 11 (from 21 Dec): closing £42,83011Week 12 (from 28 Dec): closing £29012Week 13 (from 4 Jan): closing £24,64013Week
WeekStartsReceiptsPaymentsClosingStatusBiggest payments that week
112 Oct£16,440£16,310£38,630OKBills already received £13,170; Other overheads £1,900; Loans, HP and leases £1,240
219 Oct£12,360£26,450£24,540OKPAYE, NI and pension £20,300; Bills already received £5,430; Other overheads £720
326 Oct£32,040£83,420−£26,840Below minimumPayroll (net pay) £42,000; Bills already received £33,180; Owners' drawings or dividends £4,000
42 Nov£12,360£26,400−£40,880Below minimumVAT £24,600; Other overheads £1,800
59 Nov£22,640£5,990−£24,230Below minimumNew purchases (forecast) £4,750; Loans, HP and leases £1,240
616 Nov£61,600£32,670£4,700Below minimumPAYE, NI and pension £20,300; New purchases (forecast) £9,750; Other overheads £2,620
723 Nov£31,600£51,750−£15,450Below minimumPayroll (net pay) £42,000; New purchases (forecast) £9,750
830 Nov£47,320£36,080−£4,210Below minimumBills already received £16,040; New purchases (forecast) £10,000; Owners' drawings or dividends £4,000
97 Dec£36,700£10,250£22,240OKNew purchases (forecast) £10,250
1014 Dec£36,900£17,410£41,730OKNew purchases (forecast) £9,750; PAYE, NI and pension £3,800; Other overheads £2,620
1121 Dec£36,100£35,000£42,830OKPAYE, NI and pension £16,500; New purchases (forecast) £9,500; Rent and rates £9,000
1228 Dec£35,700£78,240£290Below minimumPayroll (net pay) £42,000; Corporation Tax £18,000; New purchases (forecast) £10,000
134 Jan£36,400£12,050£24,640OKNew purchases (forecast) £10,250; Other overheads £1,800
Why

What drives the squeeze

In week 3 the month-end supplier run (£33,180), October's net pay (£42,000) and the dividend all leave in the same week, while new sales invoiced since 12 October aren't paid for another four to seven weeks. The VAT return (£24,600) follows in week 4.

Week 12 is the second pinch: December's net pay and the Corporation Tax bill (£18,000) fall in the same week, straight after the quarter's rent in week 11.

Options

What the owner is weighing up

Illustrative choices for the worked example; each would be re-forecast before deciding.

  • Hold October's dividend until December.
  • Ask Ross Restoration to settle the disputed invoice now, less an agreed sum for the snagging.
  • Agree with Severnside Timber to split the October month-end payment over two weeks.
  • Ask the bank in good time to confirm the overdraft through to January.
How confident are we?

What this rests on

The opening balance is from the bank on 9 Oct 2026. Of the receipts, 34% come from invoices already raised, timed by each customer's usual lateness, and 66% from forecast sales, timed by an assumed payment pattern. Of the payments, 16% are bills already received, 19% forecast purchases, and the rest regular payments. Of the regular payments, 14% are estimated and 4% assumed. The further ahead the week, the less certain the figure.

The first four weeks are the firmest: they rest almost entirely on invoices and bills that already exist. From week 5 onwards, more of the receipts depend on the sales forecast and the assumed payment pattern, so roll the forecast forward every week with the actual figures.

The months after

What the agent flagged, and what was decided

At handover, the managing director held October's dividend and asked the bank to confirm the overdraft through to January. The agent was then set up in Wyebridge's own AI assistant account, with read-only access to the bank feed and the accounting system. Every Monday at 7:00 it enters last week's actual figures in a new dated copy of the forecast, rolls it forward a week, runs the checks and sends the managing director a short note. It uses the rules on Inputs: a minimum of £20,000 and an overdraft limit of £50,000. Nothing leaves Wyebridge, and no decision changes, without one of its own people approving it. These events continue the fictional example.

Weekly runs
13
19 October to 11 January
Flags raised
4
the other runs sent the weekly note only
Shortfall flagged
26 Oct
two days before the payroll that would have taken the bank beyond the limit
Weeks beyond the overdraft at the bank
0
against a £50,000 limit
DateWhat the agent foundFlag?What people decided
19 OctWeekly roll-forward. Week 1 closed at £38,110 against a forecast of £38,630. The £520 gap is within 10% of the week's payments, so no reason was needed.Note onlyNothing needed. The managing director read the weekly note.
26 OctMarches Homes' invoice INV-4412 (£28,800) now showed an expected payment date of 13 November in the accounting system, instead of 30 October. The weeks starting 26 October and 2 November moved from Below minimum to Beyond overdraft: −£52,160 and −£66,200 against the £50,000 limit.FlagThe managing director phoned Marches Homes, which agreed to pay £14,400 on 30 October and the rest on 13 November. Severnside Timber agreed to take half of bill ST-88213 (£9,210) on 13 November. October's dividend stayed held. The office manager entered the agreed dates; the rerun put both weeks back within the overdraft, at −£28,550 and −£42,590.
9 NovWeek 4 closed £3,390 better than forecast, more than 10% of the week's payments (£2,640). The bank feed showed the VAT payment to HMRC was £21,210, against £24,600 on the draft return.FlagThe office manager recorded the reason on Actuals. No decision changed.
23 NovThe Debtors list no longer matched the aged debtors report: a £1,140 credit note to Wye Valley Interiors (CN-0112) was missing. Checks showed CHECK, so the note said the forecast could not be relied on that week.FlagThe office manager added the credit note. Checks passed again the same morning.
7 DecA new tight week came into view as the forecast rolled forward: the week starting 1 February 2027, at £6,300 against the £20,000 minimum. VAT for the quarter to 31 December (£23,000, paid on 5 February) falls a week after January's net pay.FlagThe managing director held December's dividend, asked the office manager to invoice the two December stage payments on completion instead of at month end, and put it on the agenda for the January meeting with the bank.
11 JanBoth December stage payments arrived in early January, £15,100 sooner than the payment pattern assumed. The week starting 1 February moved back above the minimum, to £21,400.Note onlyThe managing director decided to pay the held dividends only after the February VAT payment, and to re-forecast first.

At the 30-day check-in on 16 November, Geoff and the managing director read the log together. No rule needed changing.

What the agent added. The method is unchanged: same spreadsheet, same checks, same decisions. The agent made sure the roll-forward happened every Monday and the bad news arrived early. The flag on 26 October gave the managing director two days to act before the payroll went out, and the problem was fixed with two phone calls. The benefit here is time to act; no £ figure is claimed for it.

Fictional and labelled: these events continue the worked example. The same six events are the sample rows in the Agent log of the worked-example spreadsheet. The agent is part of the guided and done-for-you routes; the self-implement kit does not include it.