lamp.
ResourcesPricingAbout
4 min readBy

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 typeHow it is usually spottedUsual recovery stepWho decides
Quote sent with wrong rate or quantityCustomer query, or checking before the orderWithdraw the quote, issue a corrected one with a new referenceSales head
Discount beyond authorityQuote review, or approval note missingStop the quote, get the owner's decision in writingOwner
Duplicate customer recordTwo files with the same phone or nameMerge into one, keep the older reference, note what was movedAccounts lead
Lead gone silentNo contact past the follow-up dateTwo attempts on different days, then mark lost with a reasonSales head
Order differs from the accepted quoteOrder checked against quoteConfirm in writing which version standsSales head
Customer details incompleteMissing address or registration details at order timeHold the order until the form is completeAccounts lead

Part 2: the register itself.

Date foundLead or customerExceptionEffect in ₹OwnerRecovery step takenNext checkClosed 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 foundLead or customerExceptionEffect in ₹OwnerRecovery step takenNext checkClosed on
3 Nov 2026Gupta LogisticsQuote for 400 units at ₹118; price list says ₹1284,000Sales headCalled customer 4 Nov, corrected quote QT-311B issued, reason noted10 Nov 202610 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.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →