Wholesale fasteners, fixings and power-tool consumables to builders' merchants, fabricators and contractors across the Midlands. 64 staff.
Verdict: On average £3,440,583 is tied up in working capital: debtors take 57 days to pay (terms about 45), stock lasts 78 days and you pay suppliers in 40 (a cash cycle of 94 days). The accounts' year-end balance sheet shows £3,063,000, £377,583 below the average. Your targets would release £373,642 once (creditors checked against what suppliers are actually paid: £67,538, not £163,341); at the 50% expected, £186,821, worth £10,538 a year (£204,097 at the busiest month). The 7 actions to do should release £151,519 once (£75,760 if they do half as well), worth £9,567 a year, with savings beyond their running costs of £5,340 a year: a first-year net of -£1,969 (-£5,534 if half as well). Worth doing for the cash it frees, not the yearly return. Best for the first year: “Take Power-tool distributor K's 2.5% discount by paying within 10 days”. Suppliers paid late could claim £51,565 a year: pay them to terms first. One customer holds 23% of debtors.
Working capital ran from £3,079,000 (Dec 2025) to £3,774,000 (Jun 2026). The accounts' year end (31 December, in red) caught the quietest month: £3,063,000, £377,583 below the average (which is net of the £31,500 of old debts not expected to be collected). A bank or buyer reading the balance sheet alone would think less cash is tied up than usually is. Each month's days are worked on its last three months of trade, so the seasonal swing is allowed for.
| Lever and how the target was set | Now | Best quarter | Target | Cash once at the target |
|---|---|---|---|---|
| Debtor days Best quarter in own records | 57 | 55 | 55 | £79,546 |
| Stock days Best quarter in own records | 78 | 69 | 70 | £226,558 |
| Creditor days Terms agreed with customers or suppliers | 40 | 45 | 45 | £67,538 |
Debtors and creditors include VAT, so their days are worked on sales and purchases including VAT (20%); stock days on cost of sales; the cash cycle adds days of three different flows, so it is a guide. The creditor target is the 45 days agreed with suppliers on average, but the suppliers listed are already paid close to their own terms (some late), so paying everyone to terms releases £67,538, not the £163,341 the average suggests. Debtor actions add up to more than the 2-day gap to the target, so they are capped.
| Customer | Owed | Share | Terms → actual days | Cash if paid to terms |
|---|---|---|---|---|
| National builders' merchant group | £610,000 | 23% | 60 → 76 | £139,397 |
| Regional merchant A | £205,000 | 8% | 45 → 58 | £47,868 |
| Steel fabricator B | £150,000 | 6% | 45 → 55 | £28,274 |
| Housebuilder C | £148,000 | 6% | 30 EOM → 63 | £43,792 |
| Groundworks contractor D | £92,000 | 3% | 30 EOM → 54 | £15,386 |
| Engineering firm E | £70,000 | 3% | 30 EOM → 44 | – |
| Shopfitter F | £66,000 | 2% | 30 EOM → 52 | £8,975 |
| Merchant G | £49,000 | 2% | 30 EOM → 41 | – |
EOM: 30 days end of month, counted as 45. Aged debtors at 30 September 2026: Not yet due £1,512,000 · 1 to 30 days overdue £702,000 · 31 to 60 days overdue £291,000 · 61 to 90 days overdue £104,000 · Over 90 days overdue £63,000. Half of the £63,000 over 90 days is treated as uncollectable and taken off debtors before the days are worked out: a bad debt isn't cash to release.
| Supplier | Terms → actual days | Cash if paid to terms | Discount offered | Interest and compensation they could claim a year |
|---|---|---|---|---|
| Fastener importer H critical | 45 → 40 | £47,671 | – | – |
| Anchor and chemical fixings maker J critical | 45 → 44 | £5,425 | – | – |
| Power-tool distributor K | 60 → 58 | £5,918 | 2.5% (19% a year) planned | – |
| Abrasives supplier L | 30 → 46 | −£33,666 | – | £22,156 |
| Packaging supplier M | 30 → 38 | −£8,153 | – | £4,598 |
| Haulier N | 30 → 35 | −£6,904 | – | £24,811 |
Three smaller suppliers are paid 5 to 16 days beyond terms. Under the Late Payment Act they could claim interest at 8% above base rate and fixed compensation of £40 to £100 on every late invoice: £51,565 a year, nearly half of it compensation on the haulier's 600 small invoices. Bringing them back to terms costs about £49,000 of cash once. Power-tool distributor K's 2.5% for paying in 10 days instead of 60 is worth about 19% a year, far more than the 7.25% overdraft: it is planned, and counted on Actions.
| Action | Plan | Cash once, expected | Worth a year | Cost a year | First-year net |
|---|---|---|---|---|---|
| Take Power-tool distributor K's 2.5% discount by paying within 10 days Creditors · 4 days shorter · agreed in writing, 80% chance · Ties up cash, but the discount is worth about 19% a year. | Do | −£110,466 | −£6,975 | −£18,000 | £9,617 |
| Ask the two biggest suppliers for 60-day terms at the annual review Creditors · 4 days longer · best practice, 30% chance · Ask, don't take: both are critical to supply. | Do | £41,425 | £2,616 | £0 | £2,109 |
| Reset reorder points on the top 300 lines from actual demand Stock · 6 days fewer · best practice, 30% chance · Stock-outs if cut too far: see the Safety Stock and Reorder Plan. | Do | £50,765 | £3,205 | £1,440 | £165 |
| Hold the merchant group to its agreed 60 days Debtors · 3 days fewer · best practice, 30% chance · 23% of debtors: firm, but don't risk the account. Its published payment practices show what it pays others. | Do | £17,898 | £1,130 | £720 | £149 |
| Card and Direct Debit payment link on every invoice Debtors · 2 days fewer · best practice, 30% chance · Card fees are the cash cost. | Do | £11,932 | £753 | £3,300 | −£2,821 |
| Phone and statement chase at 7 days overdue on the top 30 accounts Debtors · 5 days fewer · own records or a trial, 50% chance · Tried on ten accounts in the summer. Keep it polite and named. | Do | £49,717 | £3,139 | £7,200 | −£4,633 |
| Return slow-moving lines to two suppliers under their returns terms Stock · 4 days fewer · agreed in writing, 80% chance · 10% restocking fee on £113,000 at cost. | Do | £90,249 | £5,698 | £0 | −£6,554 |
| Invoice finance on the merchant group's invoices Cash and bank · cash, not days · agreed in writing, 80% chance · Borrowing, not a release: fees and security. Take advice from your accountant. | Park | – | – | – | – |
The debtor actions are capped at the target, which makes the chase and the card link cost more a year than their cash is worth: do them for fewer bad debts and less chasing, or raise the target with a reason. The discount saving builds up over the first three months like the other actions. Invoice finance is parked: it is borrowing against the debts, not a release, and needs advice from the accountant.
Average balances of 12 month ends (debtors and creditors including VAT, so their days use sales and purchases including VAT at 20% and 20%; 50% of debts over 90 days overdue treated as uncollectable); 12 months' turnover, cost of sales and purchases from the management accounts; the owner's own targets, with creditors checked against what the suppliers listed are actually paid. Assumed: 50% of the gap to the targets achieved; each action counted at the chance it works (80% agreed in writing, 50% own records, 30% best practice, 20% a hunch), capped at the target on each lever, building up over 3 months. Cash is released once; only what it saves or earns recurs: 7.25% on the first £120,000 (the average overdraft), 2.75% beyond. Days assume sales and purchases stay at this level: growth ties up more cash. Not tax, legal or lending advice.
Most of the value is the cash itself, which comes once; what it is worth a year is modest, because beyond the £120,000 average overdraft it only earns the deposit rate. At the busiest month the same days would free £204,097: that is what to set against the overdraft limit. Re-run the Months sheet each quarter: the averages are the measure.
At handover the finance director started the actions marked Do, and booked the quarterly re-run. The agent was then set up in Hollinsmere's own AI assistant account, with read-only access to the accounting system. On the 10th of each month, after the month-end close, it adds the new month end to a new dated copy of the plan (the oldest drops off, so it is always twelve), refreshes the customers, suppliers and aged debtors, runs the checks and sends the finance director a short note. It uses the targets on Inputs: 55 debtor days, 70 stock days, 45 creditor days, and a flag when a measure moves more than 5 days the wrong side of its target over the latest three months. Nothing left Hollinsmere, and no decision changed, without one of its own people approving it. These events continue the fictional example.
| Date | What the agent found | Flag? | What people decided |
|---|---|---|---|
| 10 Nov | Fastener importer H, critical to supply, was paid at 49 days in October against 45-day terms: newly late. | Flag | Pay H to terms from November. The cash comes from the debtor actions, not from paying a critical supplier later. |
| 10 Nov | Debtor days for the three months to October rose to 58, within 5 days of the 55 target, so the note listed them without a flag. The merchant group was paying at 84 days. | Note only | The finance director phoned the merchant group's payables manager anyway and got all September invoices into its 20 November payment run. |
| 10 Dec | Debtor days for the three months to November reached 61, more than 5 days over the target. | Flag | The finance director asked the merchant group's finance director to hold to the agreed 60 days from January, and moved the statement chase on the top 30 accounts to weekly. |
| 10 Dec | An £18,400 invoice to Housebuilder C went over 90 days overdue. | Flag | The account went on stop until paid, as its credit terms allow. |
| 11 Jan | A supplier's discount had been typed as 2.5 instead of 2.5%. Checks showed CHECK, so the note reported a data problem and no figures. | Flag | The credit controller put it right; the rerun passed the next morning. |
| 12 Jan | Debtor days for the three months to December were back to 59, within 5 days of the target. The merchant group was paying at 66 days. | Note only | Nothing needed. The finance director read the note. |
At the check-in on 4 December, about day 45 and after the first monthly run, Geoff and the finance director read the first run's log together. No rule needed changing, and Geoff's upkeep of the set-up ended there.
What the agent added. The method is unchanged: same spreadsheet, same targets, same checks, same decisions. The agent made sure the month ends were added every month, not once a quarter. A critical supplier was put back on terms the month it slipped, before it asked, and the drift in debtor days was in front of the finance director each month until it turned. The benefit here is time to act; no new £ 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.