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.
| Week | Starts | Receipts | Payments | Closing | Status | Biggest payments that week |
|---|---|---|---|---|---|---|
| 1 | 12 Oct | £16,440 | £16,310 | £38,630 | OK | Bills already received £13,170; Other overheads £1,900; Loans, HP and leases £1,240 |
| 2 | 19 Oct | £12,360 | £26,450 | £24,540 | OK | PAYE, NI and pension £20,300; Bills already received £5,430; Other overheads £720 |
| 3 | 26 Oct | £32,040 | £83,420 | −£26,840 | Below minimum | Payroll (net pay) £42,000; Bills already received £33,180; Owners' drawings or dividends £4,000 |
| 4 | 2 Nov | £12,360 | £26,400 | −£40,880 | Below minimum | VAT £24,600; Other overheads £1,800 |
| 5 | 9 Nov | £22,640 | £5,990 | −£24,230 | Below minimum | New purchases (forecast) £4,750; Loans, HP and leases £1,240 |
| 6 | 16 Nov | £61,600 | £32,670 | £4,700 | Below minimum | PAYE, NI and pension £20,300; New purchases (forecast) £9,750; Other overheads £2,620 |
| 7 | 23 Nov | £31,600 | £51,750 | −£15,450 | Below minimum | Payroll (net pay) £42,000; New purchases (forecast) £9,750 |
| 8 | 30 Nov | £47,320 | £36,080 | −£4,210 | Below minimum | Bills already received £16,040; New purchases (forecast) £10,000; Owners' drawings or dividends £4,000 |
| 9 | 7 Dec | £36,700 | £10,250 | £22,240 | OK | New purchases (forecast) £10,250 |
| 10 | 14 Dec | £36,900 | £17,410 | £41,730 | OK | New purchases (forecast) £9,750; PAYE, NI and pension £3,800; Other overheads £2,620 |
| 11 | 21 Dec | £36,100 | £35,000 | £42,830 | OK | PAYE, NI and pension £16,500; New purchases (forecast) £9,500; Rent and rates £9,000 |
| 12 | 28 Dec | £35,700 | £78,240 | £290 | Below minimum | Payroll (net pay) £42,000; Corporation Tax £18,000; New purchases (forecast) £10,000 |
| 13 | 4 Jan | £36,400 | £12,050 | £24,640 | OK | New purchases (forecast) £10,250; Other overheads £1,800 |
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.
Illustrative choices for the worked example; each would be re-forecast before deciding.
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.
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.
| Date | What the agent found | Flag? | What people decided |
|---|---|---|---|
| 19 Oct | Weekly 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 only | Nothing needed. The managing director read the weekly note. |
| 26 Oct | Marches 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. | Flag | The 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 Nov | Week 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. | Flag | The office manager recorded the reason on Actuals. No decision changed. |
| 23 Nov | The 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. | Flag | The office manager added the credit note. Checks passed again the same morning. |
| 7 Dec | A 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. | Flag | The 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 Jan | Both 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 only | The 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.