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 type | Typical cause | First response on the same day | Recovery step | Owner |
|---|---|---|---|---|
| Wrong or short delivery | Order copied wrongly, picking error | Call the customer and apologise, confirm what is missing | Send the correct items and collect the wrong ones | Operations head |
| Late delivery or visit | Stock gap, route or staff clash | Give a new firm date | Prioritise the job, offer a goodwill step if agreed | Operations head |
| Billing dispute | Rate or quantity differs from order | Ask for the customer's copy of the order | Correct and reissue paperwork, record the difference | Accounts lead |
| Missed payment promise | Customer cash delay or follow-up gap | Phone and note a new date | Agree a part payment plan if needed | Accounts lead |
| Service or quality complaint | Process or training gap | Acknowledge and log the details | Redo, repair or replace as approved | Service head |
| Renewal lapsed | No early contact, price concern | Call the contact to understand why | Offer revised terms within approval limits | Account owner |
Part 2: the register itself.
| Ref | Date raised | Customer | What went wrong | Value at risk (₹) | Recovery action | Owner | Target date | Closed 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
| Ref | Date raised | Customer | What went wrong | Value at risk (₹) | Recovery action | Owner | Target date | Closed on |
|---|---|---|---|---|---|---|---|---|
| EX-014 | 6 Oct 2026 | Lakshmi Clinic | Annual service contract expired on 30 Sep with no renewal call | 42,000 | Call the practice manager, offer renewal at last year's rate, send revised contract | Account owner | 9 Oct 2026 | 8 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 →