lamp.
ResourcesPricingAbout
4 min readBy

Cancel-to-save: control and audit worksheet

When a customer asks to cancel or pause a membership, package, subscription or service contract, your team has one conversation in which to keep the relationship without upsetting the customer. This worksheet tests whether that conversation followed your own rules. An owner, a manager or a person outside the team samples closed cancellation cases and checks the records behind each one.

When to use it

Use it every month on the cancellations closed in that month, and again whenever you change the save offers or the people who handle cancellations. It is also useful after a complaint, for example when a customer says they were called again after saying no, or were charged after cancelling.

The template

Sample at least one case that ended in a save and one that ended in a cancellation. Keep one worksheet per month.

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
C1Every request is logged on the day it is madeCompare the date on the customer's message or call note with the date loggedCancellation request recordReviewer
C2The reason is recorded in the customer's own wordsRead the reason field for the sampled casesCustomer statementReviewer
C3Only an approved offer is madeMatch each offer given to your approved offer list and its limitApproved offer recordReviewer
C4The offer was approved before it was madeCheck the approval date is earlier than the date the offer was sentApproval message or noteReviewer
C5A customer who says no is not pressedRead call notes and messages after the first refusalConsent record, call notesReviewer
C6Billing stops on the agreed dateCompare the end date with the last charge or invoiceBilling recordReviewer
C7Win-back contact happens only where the customer agreedCheck each follow-up against the customer's stated preferenceConsent record, contact logReviewer

How to fill it

  • Ref: keep numbers fixed from month to month so trends can be seen.
  • How to test: write down which cases you sampled, by case number, so the test can be repeated.
  • Evidence to check: name the record and date you actually read.
  • Tester: must not be the person who handled the case.
  • Result and note: write Pass or Fail and one line on what you saw. Quote the customer's words if the case shows pressure.
  • Corrective action: a named person and a date. If a customer was wrongly charged, say how much and when it will be returned.

Refunds, credit notes, tax treatment of a cancelled invoice and consumer rules on contacting customers are set by law. Check the current rule on the official portal or with your CA before acting.

Example row

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
C6Billing stops on the agreed dateSampled case CS-1042, annual gym plan ended 31 OctBilling record, bank credit listReviewer: MeeraFail. A monthly charge of ₹1,499 was taken on 2 NovAccount owner to refund ₹1,499 by 10 Nov and tell the customer; billing to remove the plan from auto charge

Review and sign-off

  • The owner or a senior manager reviews the completed worksheet, not the retention specialist who handled the cases.
  • Review it every month, and weekly during a retention push or after a new offer is launched.
  • Escalate to the owner the same day if a customer was charged after cancelling, was contacted against their wish, or was given an offer nobody approved.

Keeping it up to date

  • Add a control whenever a new kind of cancellation problem appears, such as a new channel for requests.
  • Keep each worksheet with the cases tested for the period your CA or the law requires.
  • Rotate the tester and widen the sample after any month with more than one failure.
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 →