Enquiry-to-Cash Map · records to 30 September 2026

Hartwell Air Conditioning Ltd

Air conditioning installation, servicing and repairs for offices, shops and restaurants across Greater Manchester and Cheshire. 28 staff. 640 enquiries over 12 months, followed from first contact to cash in the bank.

Worked example. Hartwell Air Conditioning is a fictional business; every name and figure is invented. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 2 notes), the notes being jobs completed but not invoiced, and an invoice long overdue.
The headline

From enquiry to cash

Orders won
26 per 100
enquiries; 152 orders at an average of £6,099
Enquiry to cash
125 days
on average, for jobs paid
Leaks a year
£202,169
gross profit on lost enquiries and orders, and work not invoiced
Cash to release
£91,595
once: jobs to invoice now, and invoicing and collecting to your standards
The route

Each step, against your own standards

Qualified
80%
get through · standard 90%
3 days
average · standard 2
Quotation sent
79%
get through · standard 95%
8 days
average · standard 7
Order won
40%
get through · standard 45%
21 days
average · standard 21
Work completed
97%
get through · standard 98%
33 days
average · standard 30
Invoiced
93%
get through · standard 100%
12 days
average · standard 2
Paid
98%
get through · standard 100%
48 days
average · standard 30

Share of enquiries that reached the step before and got through, and average days taken. Red marks a step below your standard; red days are slower than your standard. Only enquiries that have had time to move are measured.

The leaks

What each leak is worth a year

Qualified but not quoted£75,142
Enquiries not followed up£48,805
Quotations not won£40,076
Work done but not invoiced£33,819 · once £28,260
Orders cancelled£4,327
Late payment£3,775 · once £41,948
Slow invoicing£1,925 · once £21,387

The first two leaks are enquiries that never got a call back or a survey: they happen before anyone quotes, so they never appear in the win rate. Work completed but not invoiced is counted at full value, because the cost has already been spent; the jobs found can still be invoiced, shown as "once".

Where

By source

SourceEnquiriesWonWon per enquiryWon per quotationValue won
Website2404017%29%£231,490
Phone1512517%30%£148,750
Repeat customer1054341%67%£258,630
Referral923740%55%£245,400
Facilities manager framework52713%27%£42,740

Repeat customer enquiries become orders 41% of the time; facilities manager framework 13%.

Who does what

The hand-offs

Step toOwnerDone looks likeHand-off
QualifiedOffice teamCustomer called back, need and budget understood, logged in the CRMSurvey booked with an engineer
Quotation sentSurveying engineerSite surveyed; photos and measurements in the CRMSurvey pack to the estimator the same day
Order wonEstimatorQuotation sent and the customer called to check it arrivedFollow-up date set in the CRM
Work completedInstallation managerInstallation commissioned and signed off by the customerSigned job sheet to accounts the same day
InvoicedAccountsInvoice sent the next working dayInvoice on the debtors list with its due date
PaidAccountsPaid; reminders at 7 and 14 days overdueOwner told of anything 30 days overdue
What to fix

The fixes, in order

#FixLeak a yearEffortOwnerBy when
1Book the survey on the first call, from the engineers' shared calendar
Qualified but not quoted
£75,142LowOffice managerNovember 2026
2Call back every enquiry within 2 working hours, with a shared enquiry inbox and a daily check of anything not called
Enquiries not followed up
£48,805LowOffice managerNovember 2026
3Accounts invoice from the engineer's app the day the job is signed off; no paper job sheets
Work done but not invoiced
£33,819MediumOperations directorDecember 2026
4Direct debit or card payment by default for service contracts; reminders at 7 and 14 days for everything else
Late payment
£3,775MediumAccountsJanuary 2027
5Invoice the next working day after sign-off, checked every Friday against completed jobs
Slow invoicing
£1,925LowAccountsNovember 2026

Ranked by the value of the leak each fix addresses, then by effort. A fix rarely closes a leak completely: measure it by rerunning the map in six months.

How confident are we?

What this rests on

Built from 640 enquiries over 12 months to 30 Sep 2026. Each step is measured on enquiries that reached it at least 60 days before that date, so they have had time to move, and scaled to a year. Lost enquiries and orders are valued against your own standards, at the average order value and your gross margin; work not invoiced at its full value; slow invoicing and late payment at your cost of money of 9%. The standards are your judgement, and the values change with them. Unpaid invoices are 98% of the aged debtors.

The months after

What the agent flagged, and what was decided

Fictional, continuing the example. After the map, Hartwell chose the guided route and set up the agent in an AI assistant the business already uses, connected read-only to its CRM, its job system and its accounts system (its IT confirmed this before it committed). On the first working day of each month it adds the month's enquiries and stage dates to a new dated copy of the workbook, reruns the map on the latest 12 months against the standards the owners set, compares each leak with its value at the map and last month, logs what it finds and sends the operations director a short note listing each leak and its fix. Nothing left the business, and no decision changed, without one of its own people approving it: the agent never raised an invoice, chased a customer or changed a record.

Monthly runs
3
2 November to 4 January 2027
Flags raised
3
the other findings went in the monthly note
Fixes that held by January
3 of 5
the survey booking slipped, and was caught within a month
Open enquiries not called back
4
in November, from 20 at the map
DateWhat the agent foundWhat people decided
2 Nov 2026
Flag
Jobs completed and not invoiced within your 2 daysAccounts invoiced 8 that week; one was a warranty visit, not chargeable, and was closed
2 Nov 2026
Flag
Invoices more than your 30 days overduePhoned all three customers; two paid by 13 November, the third agreed to pay in two parts
1 Dec 2026
No flag
Enquiries not called back within your 2 days: far fewer since the shared enquiry inbox started on 9 NovemberNone needed
1 Dec 2026
No flag
Qualified but not quoted (the biggest leak) lower than at the mapNone needed
4 Jan 2027
Flag
Qualified but not quoted up more than your 10% line on last monthTwo survey slots held each morning for new enquiries; looked at again at the February run
4 Jan 2027
No flag
No completed job waiting more than 2 days for an invoiceNone needed

At the check-in in late November, after the first monthly run, Geoff and the managing director read the first log together and left every line where it was. After that the agent, its accounts and its log were Hartwell's.

By January three of the five fixes had held: the shared enquiry inbox, invoicing from the engineers' app and the overdue routine. The survey booking had not, and the agent showed it within a month. Invoicing the jobs it named recovered money the map had already counted (the work not invoiced), so it adds nothing new. Reading the monthly note and recording decisions took the operations director about 20 minutes a month (estimate). The months after add nothing to the figures above.

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.