Lead-to-customer: exception and recovery register
This register records everything that goes wrong between the first enquiry and the first order, along with the step taken to put it right. It is used by the sales head, the person who prepares quotes and the owner, so that problems are fixed once and not rediscovered by the next person.
When to use it
Use it whenever a lead or new customer file does not follow the normal path: a quote with a wrong rate, a discount beyond authority, a duplicate customer, a lead that has gone silent, or an order that does not match the quote. Review open lines every week and close them only when the fix is proved. Anyone who handles a lead can add a line, but only the sales head or the owner can close one. This keeps the register honest, because the person who made a mistake is not the only one deciding it is fixed.
The template
Part 1: common exception types and the usual recovery. Keep this list at the top of the sheet and add your own.
| Exception type | How it is usually spotted | Usual recovery step | Who decides |
|---|---|---|---|
| Quote sent with wrong rate or quantity | Customer query, or checking before the order | Withdraw the quote, issue a corrected one with a new reference | Sales head |
| Discount beyond authority | Quote review, or approval note missing | Stop the quote, get the owner's decision in writing | Owner |
| Duplicate customer record | Two files with the same phone or name | Merge into one, keep the older reference, note what was moved | Accounts lead |
| Lead gone silent | No contact past the follow-up date | Two attempts on different days, then mark lost with a reason | Sales head |
| Order differs from the accepted quote | Order checked against quote | Confirm in writing which version stands | Sales head |
| Customer details incomplete | Missing address or registration details at order time | Hold the order until the form is complete | Accounts lead |
Part 2: the register itself.
| Date found | Lead or customer | Exception | Effect in ₹ | Owner | Recovery step taken | Next check | Closed on |
|---|---|---|---|---|---|---|---|
How to fill it
- Exception: pick a type from Part 1 and add one line of detail. If none fits, write a new line and add the type to Part 1.
- Effect in ₹: the amount at risk or lost, for example the value of the quote or the extra discount given. Write 0 if no money was affected.
- Recovery step taken: what was actually done, with a date, not the plan.
- Next check: the calendar date when someone will confirm the fix held.
- Closed on: fill only when the evidence is attached, such as the corrected quote or the written confirmation from the customer.
- Exceptions involving tax registration details are a statutory matter. Check the current rule on the official portal or with your CA before acting.
Example row
| Date found | Lead or customer | Exception | Effect in ₹ | Owner | Recovery step taken | Next check | Closed on |
|---|---|---|---|---|---|---|---|
| 3 Nov 2026 | Gupta Logistics | Quote for 400 units at ₹118; price list says ₹128 | 4,000 | Sales head | Called customer 4 Nov, corrected quote QT-311B issued, reason noted | 10 Nov 2026 | 10 Nov 2026 |
Review and sign-off
- The sales head reviews the register every week; the owner signs off monthly.
- Look at the most common exception types each month and fix the cause, such as an outdated price list.
- Escalate to the owner at once for any exception worth more than the limit you set, or any customer who has threatened to cancel.
Keeping it up to date
- Never delete a line; mark it closed or corrected, so the history can be explained later.
- Keep the register for the period your CA or the law requires.
- Update the usual recovery steps whenever you find a better way to fix a problem.