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 point | What to check | Evidence to look at | Reviewer | Result found |
|---|---|---|---|---|
| Enquiry captured | Date, source, contact and owner are all noted | Enquiry book or lead sheet | Sales head | |
| Need and fit assessed | Quantity, specification and delivery area were noted before quoting | Call notes, site visit note | Sales head | |
| Quote approved | Rate, discount and validity were approved before sending | Quote copy with approval note | Owner | |
| Terms agreed | Payment terms, delivery period and any advance were confirmed in writing | Order confirmation, message trail | Accounts lead | |
| Identity and tax details | Legal name, address and tax number match the customer's own documents | Customer form, copy of registration | Accounts lead | |
| First order recorded | Order matches the accepted quote | Purchase order against quote | Sales coordinator | |
| Welcome and handover | Customer knows the contact person for orders and payments | Welcome message or call note | Sales coordinator |
Part 2: findings log.
| Lead or customer | Control point | What was found | Gap in ₹ | Fix | Owner | Due 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 customer | Control point | What was found | Gap in ₹ | Fix | Owner | Due date |
|---|---|---|---|---|---|---|
| Sharma Fabrication | Quote approved | Quote of 12 Sep 2026 gave 8% discount on ₹2,40,000; owner's approval note says 5% | 7,200 | Confirm with customer, add discount limit to the quote form | Sales head | 12 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.