lamp.
ResourcesPricingAbout
4 min readBy

Lead-to-customer: control and audit worksheet

This worksheet checks whether the steps between an enquiry and the first order are really followed, by looking at actual files instead of relying on memory. It is used by the owner, a sales head or someone from outside the sales team who samples recent leads and tests them against the paperwork.

When to use it

Use it once a month, after a lost deal that should have been won, and when a new person starts handling enquiries. Pick six to ten leads from the last period, including at least two that became customers and two that were dropped, so you see both the winning and the losing path. Do the sampling yourself and do not let the sales team choose the files, because hand-picked samples hide the problems you are looking for. A review of about an hour is usually enough for ten leads.

The template

Part 1: control points. Copy into a sheet and add one column per sampled lead if you want a grid.

Control pointWhat to checkEvidence to look atReviewerResult found
Enquiry capturedDate, source, contact and owner are all notedEnquiry book or lead sheetSales head
Need and fit assessedQuantity, specification and delivery area were noted before quotingCall notes, site visit noteSales head
Quote approvedRate, discount and validity were approved before sendingQuote copy with approval noteOwner
Terms agreedPayment terms, delivery period and any advance were confirmed in writingOrder confirmation, message trailAccounts lead
Identity and tax detailsLegal name, address and tax number match the customer's own documentsCustomer form, copy of registrationAccounts lead
First order recordedOrder matches the accepted quotePurchase order against quoteSales coordinator
Welcome and handoverCustomer knows the contact person for orders and paymentsWelcome message or call noteSales coordinator

Part 2: findings log.

Lead or customerControl pointWhat was foundGap in ₹FixOwnerDue date

How to fill it

  • Result found: write what you saw, such as "matches", "rate differs by ₹15 a unit" or "no record". A tick alone does not help the next reviewer.
  • Evidence to look at: note the document number or date you opened, so the check can be repeated.
  • Identity and tax details: compare against the customer's own papers. A mismatch in tax registration details is a statutory matter. Check the current rule on the official portal or with your CA before acting.
  • Gap in ₹: the money difference between what was quoted or agreed and what was ordered or billed. Write 0 if there is none.
  • Owner and Due date: one named person and one calendar date per fix.

Example row

Lead or customerControl pointWhat was foundGap in ₹FixOwnerDue date
Sharma FabricationQuote approvedQuote of 12 Sep 2026 gave 8% discount on ₹2,40,000; owner's approval note says 5%7,200Confirm with customer, add discount limit to the quote formSales head12 Nov 2026

Review and sign-off

  • The reviewer signs each line tested; the owner signs the whole worksheet and the date.
  • Run it monthly while the sales team is new, and at least quarterly after that.
  • Escalate to the owner at once if a gap shows a discount above authority, a missing customer identity record or an order accepted on terms nobody approved.

Keeping it up to date

  • Add a control point whenever a mistake happens twice, and remove one only when the owner agrees it no longer matters.
  • Keep completed worksheets with the sampled files for the period your CA or the law requires.
  • Compare findings across months: the same gap repeating means the fix did not hold.
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 →