Discount Leakage Audit · October 2026

Calderbrook Fasteners Ltd

Industrial fasteners, fixings, tools and site safety supplies for contractors, fabricators and maintenance teams across West Yorkshire and the North West. 42 staff. 1,102 invoice lines over 12 months, reconciled to the accounts, and 260 decided quotations.

Worked example. Calderbrook Fasteners 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 lines over the limit and not signed off.
The headline

What discounting costs

Discount given
£387,798
6.7% of list price
Share of gross profit
22%
given away before it was earned
Outside your own rules
£79,622
above the limit without sign-off, or with no reason and no sign-off
Margin to recover
£23,887–£47,773
a year, if the rules are kept
When

Discount by month

Discount as a percentage of list price by month. Quarter-end months, shown in red, are higher. The figures are in the bar labels.0%3%6%9%Oct 2025: 5.9%5.9OctNov 2025: 5.6%5.6NovDec 2025: 7.9%7.9DecJan 2026: 6.0%6.0JanFeb 2026: 5.5%5.5FebMar 2026: 8.8%8.8MarApr 2026: 6.1%6.1AprMay 2026: 5.7%5.7MayJun 2026: 7.8%7.8JunJul 2026: 6.5%6.5JulAug 2026: 5.2%5.2AugSep 2026: 9.2%9.2SepOct 2025 to Sep 2026; red = quarter-end month

Discount runs at 8.4% of list in quarter-end months against 5.8% in other months: the usual sign of discounts given to hit a period target rather than to win a customer.

Does it win work?

Win rate by discount

No discount36% · 25 of 70
Up to 5%40% · 36 of 90
Over 5% to 10%42% · 25 of 60
Over 10%42% · 17 of 40

Quotations with a discount over 5% won 42%, against 36% with none. Discount helps a little, but most of the difference comes with the first 5%; larger discounts add little. This shows association, not cause.

Who

Patterns by person

PersonList valueDiscountOver limit, not signed offOutside the rulesWith no reasonWin rate
Priya Desai
Sales team
£1,474,4709.8%161£69,66930%39%
Tom Hollis
Sales team
£1,355,3505.3%36£7,04411%44%
Sam Ridley
Sales team
£1,040,6803.7%4£2,1366%39%
Amy Clarke
Sales team
£323,2701.9%0£1573%39%
Neil Barton
Sales manager
£1,635,9307.7%0£6162%38%

Patterns, not blame. Priya Desai's accounts carry 87% of the discount outside the rules, mostly above the limit without sign-off; the fix is a sign-off step that is quick to use, not a reprimand. Some of the largest discounts are on the biggest accounts, with a reason and sign-off: those are policy, not leakage.

Why

Discount by reason

Volume33% · £127,704
Competitive match23% · £88,501
Long-standing customer15% · £59,031
Promotion15% · £56,339
None given14% · £56,222

Share of all discount, by the reason recorded. "None given" is the easiest to stop.

Where

Customers with the most discount

CustomerDiscount% of listOutside the rules
Gildersome Logistics£49,1657.6%£0
Aire Valley Fabrications£48,39310.5%£21,518
Heckmondwike Rail Services£42,7757.9%£616
Brightside Steel Erectors£42,27011.0%£24,602
Idle Water Utilities Contractors£34,4447.7%£0
Ilkley Mechanical Services£28,4736.7%£2,446
The rules

Who can give what

RoleWithout sign-off, up toAbove that, signed off by
Sales team5%Sales manager, up to 10%; above that, Managing director
Sales manager10%Managing director
Managing directorAny discountNot needed

Every discount also needs a reason from the list. Each month, check discount as a share of list by person, lines over the limit without sign-off, and lines with no reason; the quarter-end months first.

How confident are we?

What this rests on

Invoices total 99.6% of sales in the accounts, over 12 months. Discount is measured against your price list, so it is only as right as the list. Discount outside the rules counts discount above each person's limit without sign-off, and any discount with no reason and no sign-off. The margin to recover assumes you keep 30% to 60% of it, a judgement; some customers will push back. The win-rate comparison rests on 260 decided quotations; it shows association, not cause.

The months after

What the agent flagged from October to January, and what people decided

Fictional, continuing the example. Calderbrook chose the guided route and, in the final session, set up an agent in an AI assistant the business already uses, connected read-only to the sales ledger (its IT confirmed this before it committed). On the first working day of each month it copies the month's invoice lines into the workbook, tests every line with the audit's own rules, sets each person's discount against their rate in the audit, and sends the managing director a short note. It names any line at least £25 outside the rules, and flags anyone 2 points or more above their audit rate. It never changes a price, an invoice or a customer's terms. Nothing left the business, and no decision changed, without one of its own people approving it.

DateWhat the agent flaggedWhat was decided
15 Oct
Flag
Test run at set-up on September, the audit's last month: 23 lines over the limit without sign-off, £13,638 outside the rules, and two people well above their audit rates in a quarter-end month.As the audit found. The sign-off rule starts on 1 November, after the team briefing.
2 Nov
Flag
October, the month before the rule: 17 lines over the limit without sign-off, £6,910 outside the rules.The sales manager briefed the team: sign-off before the price is quoted, and a reason on every discount. October's invoices stand.
1 Dec
No flag
November: 4 lines outside the rules, £740; 5% of the discount with no reason.Nothing needed.
1 Dec
Flag
Six site safety lines priced above list: the price list in the export was out of date.The office manager updated the export; the six lines were within the rules.
4 Jan
Flag
December, a quarter-end month: one salesperson's discount at 12.1% of list against 9.8% in the audit.The managing director went through her three largest discounts with her: two now carry the competitor-match reason, one goes to the March price review.
4 Jan
No flag
December: 5 lines outside the rules, £1,180, against £13,638 in September, the last quarter-end.Nothing needed; the audit is rerun in April.

The test run on September, the audit's last month, matched the audit's own figures for it (92 lines, £13,638 outside the rules), which is how the set-up was checked. At the check-in on 27 November, after the first monthly run, Geoff and the managing director read the log together; no rule needed changing. The sign-off rule started on 1 November: the discount outside the rules fell from £13,638 in September to £740 in November and £1,180 in December, the next quarter-end. These are the audit's own measures, read monthly; the agent's part was making sure the check happened every month and the reopening in one salesperson's quarter-end was raised in January, not at the April rerun. No £ figure is claimed for the agent.