Customer-to-renewal: control and audit worksheet
This worksheet helps you test whether the steps between winning a customer and getting them to renew are really being followed, using a sample of customer files instead of a general feeling. It is used by the business owner, a sales or accounts head, or a person from outside the team who checks the work once a month or once a quarter.
When to use it
Use it for a routine monthly or quarterly check, after a customer complaint or a lost renewal, and before you hand a set of customer accounts to a new person. Pick five to ten customer files at random, including at least one that has gone quiet, and test each control point against the paper or screen record behind it.
The template
Part 1: the control points to test. Copy this into a sheet and add one column per sampled customer if you want a grid.
| Control point | What to check | Evidence to look at | Reviewer | Result |
|---|---|---|---|---|
| Enquiry recorded | Enquiry has a date, source and named owner | Enquiry book or lead sheet | Sales head | |
| Quote approved | Quote value and discount were approved before it left | Signed quote copy, approval note | Owner | |
| Order matches quote | Item, quantity, rate and terms equal the accepted quote | Purchase order, order confirmation | Sales coordinator | |
| Delivery or service proof | Dispatch or job completion is backed by a signed receipt | Challan, job card, signed receipt | Operations head | |
| Invoice accuracy | Invoice agrees with order and delivery | Invoice copy against order and challan | Accounts lead | |
| Collection follow-up | Overdue amounts were chased on the planned dates | Follow-up log, call notes | Accounts lead | |
| Renewal contact | Renewal conversation started before the due date | Renewal calendar, message or call record | Account owner | |
| Complaint closure | Complaints closed with the customer's acknowledgement | Complaint register | Quality or service head |
Part 2: findings log.
| Customer | Control point | What was found | Gap in ₹ | Fix | Owner | Due date |
|---|---|---|---|---|---|---|
How to fill it
- Result: write what you actually found, for example "found, matches", "found, rate differs" or "no record". Avoid ticks only; a tick tells the next reviewer nothing.
- Evidence to look at: note the document number or date you opened so another person can find it again.
- Gap in ₹: enter the money difference between what was agreed and what was billed or collected. If there is no money effect, write 0.
- Fix and Owner: one named person per fix, never "team". Check the current rule on the official portal or with your CA before acting where a finding touches tax invoices or tax charged.
- Due date: a calendar date, not "soon".
Example row
| Customer | Control point | What was found | Gap in ₹ | Fix | Owner | Due date |
|---|---|---|---|---|---|---|
| Shree Ram Traders | Invoice accuracy | Invoice dated 9 Oct 2026 billed 120 units at ₹410; order confirmation says ₹395 | 1,800 | Issue corrected paperwork and tell customer; add rate check before billing | Accounts lead | 20 Oct 2026 |
Review and sign-off
- The reviewer signs each line and the owner signs the whole sheet, so the person who runs the process is not the only one who checks it.
- Run it monthly while the process is new or messy, and quarterly once results are stable.
- Escalate to the owner straight away when the same gap appears in more than one customer file, or when any gap involves customer money held, refunds or tax invoices.
Keeping it up to date
- Add a control point whenever a complaint or loss shows a step that was not being checked, and remove one only when the owner agrees it no longer matters.
- Re-sample a few files from the previous round to confirm that fixes were really made.
- Keep completed worksheets and the evidence references for the period your CA or the law requires, and store them where the next reviewer can find them.