lamp.
ResourcesPricingAbout
4 min readBy

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 pointWhat to checkEvidence to look atReviewerResult
Enquiry recordedEnquiry has a date, source and named ownerEnquiry book or lead sheetSales head
Quote approvedQuote value and discount were approved before it leftSigned quote copy, approval noteOwner
Order matches quoteItem, quantity, rate and terms equal the accepted quotePurchase order, order confirmationSales coordinator
Delivery or service proofDispatch or job completion is backed by a signed receiptChallan, job card, signed receiptOperations head
Invoice accuracyInvoice agrees with order and deliveryInvoice copy against order and challanAccounts lead
Collection follow-upOverdue amounts were chased on the planned datesFollow-up log, call notesAccounts lead
Renewal contactRenewal conversation started before the due dateRenewal calendar, message or call recordAccount owner
Complaint closureComplaints closed with the customer's acknowledgementComplaint registerQuality or service head

Part 2: findings log.

CustomerControl pointWhat was foundGap in ₹FixOwnerDue 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

CustomerControl pointWhat was foundGap in ₹FixOwnerDue date
Shree Ram TradersInvoice accuracyInvoice dated 9 Oct 2026 billed 120 units at ₹410; order confirmation says ₹3951,800Issue corrected paperwork and tell customer; add rate check before billingAccounts lead20 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.
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 →