lamp.
ResourcesPricingAbout
3 min readBy

Customer-to-renewal: exception and recovery register

This register records every time something goes wrong between a customer's enquiry and their renewal, what it put at risk, and what you did to put it right. Sales, service and accounts staff use it so that problems are fixed once, visible to the owner, and not rediscovered at renewal time.

When to use it

Log an exception the day it is noticed: a wrong item sent, a missed visit, a billing dispute, a broken payment promise, an unhappy call or a renewal that lapsed. Use it also to review patterns at the end of each month and decide which cause deserves a permanent fix.

The template

Part 1: standard exception types and first response. Adapt the wording to your business.

Exception typeTypical causeFirst response on the same dayRecovery stepOwner
Wrong or short deliveryOrder copied wrongly, picking errorCall the customer and apologise, confirm what is missingSend the correct items and collect the wrong onesOperations head
Late delivery or visitStock gap, route or staff clashGive a new firm datePrioritise the job, offer a goodwill step if agreedOperations head
Billing disputeRate or quantity differs from orderAsk for the customer's copy of the orderCorrect and reissue paperwork, record the differenceAccounts lead
Missed payment promiseCustomer cash delay or follow-up gapPhone and note a new dateAgree a part payment plan if neededAccounts lead
Service or quality complaintProcess or training gapAcknowledge and log the detailsRedo, repair or replace as approvedService head
Renewal lapsedNo early contact, price concernCall the contact to understand whyOffer revised terms within approval limitsAccount owner

Part 2: the register itself.

RefDate raisedCustomerWhat went wrongValue at risk (₹)Recovery actionOwnerTarget dateClosed on
EX-001
EX-002

How to fill it

  • Ref: a running number that never repeats, so conversations can point to one line.
  • What went wrong: facts in one sentence, with the document number involved.
  • Value at risk (₹): the order value, unpaid amount or yearly renewal value that could be lost, not the cost of the fix.
  • Recovery action: what will be done, by whom, and what the customer is told.
  • Closed on: fill it only after the customer confirms the problem is resolved, not when you finish your part.

Example row

RefDate raisedCustomerWhat went wrongValue at risk (₹)Recovery actionOwnerTarget dateClosed on
EX-0146 Oct 2026Lakshmi ClinicAnnual service contract expired on 30 Sep with no renewal call42,000Call the practice manager, offer renewal at last year's rate, send revised contractAccount owner9 Oct 20268 Oct 2026

Review and sign-off

  • The owner of each line signs when closed, and the manager reviews all open lines weekly.
  • Do a monthly review of the register for repeated causes, and write one prevention step for the top cause.
  • Escalate to the owner immediately when value at risk is large for your business, when the same customer appears twice in a month, or when any line stays open past its target date.

Keeping it up to date

  • Never delete a line; mark it closed so patterns remain visible.
  • Update the standard exception types when a new kind of problem repeats.
  • Keep the register for the period your CA or the law requires, because it may support credit notes and disputed invoices.
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 →