Customer-to-renewal: daily operating review pack
This is a one-page sheet for a short daily huddle where the sales, delivery and accounts people look at the same customer numbers and agree what needs action today. It suits a small business where one owner or manager runs the day and wants to see stuck customers before they turn into complaints or lost renewals.
When to use it
Fill it every working day before the huddle, ideally by the same person from the same records. Use it for the first thirty minutes of the day, and carry unresolved items to the next day instead of rewriting the sheet.
The template
| Measure | What to enter | Source record | Action trigger | Owner |
|---|---|---|---|---|
| New enquiries | Number received since last review, and how many have a named owner | Enquiry book | Any enquiry without an owner | Sales head |
| Quotes waiting for reply | Number and total value in ₹, with the oldest quote date | Quote register | Quote older than your follow-up period | Sales head |
| Orders confirmed | Number and total value in ₹ | Order book | Order without a delivery date | Sales coordinator |
| Deliveries and visits due today | Number planned, number completed by evening | Dispatch plan, job cards | Anything planned but not completed | Operations head |
| Open complaints | Number open and the oldest complaint date | Complaint register | Complaint with no reply yet | Service head |
| Money due today | Amount due in ₹ and amount received in ₹ | Receivables list, bank entries | Promised payment not received | Accounts lead |
| Renewals falling due | Customers due in your renewal window and who has been contacted | Renewal calendar | Due customer not yet contacted | Account owner |
| Customer escalations | Customers who called or wrote twice about one issue | Call log, messages | Any repeat contact | Manager |
How to fill it
- What to enter: write numbers and rupee values, not comments. Three or four words of note are fine for the oldest item.
- Source record: pull the figure from the named register so the same count can be reproduced by anyone.
- Action trigger: decide your own limits once, write them in this column, and keep them for a few weeks before changing. They are your rules, not fixed standards.
- Owner: the person who answers for the line in the huddle, not whoever typed it.
- Add a last line for decisions: one action, one person, one time.
Example row
| Measure | Today | Yesterday | Note | Owner |
|---|---|---|---|---|
| Money due today | Due ₹86,500, received ₹40,000 | Due ₹52,000, received ₹52,000 | Balance ₹46,500 is from Gupta Hardware; they promised transfer by 4 pm | Accounts lead |
Review and sign-off
- The manager reads the sheet in the huddle and initials it; the owner reviews a week of sheets together each Saturday.
- Review daily, and look at the trend over the week for lines that keep appearing as triggers.
- Escalate to the owner the same day when a customer has contacted you twice on the same issue, when a large order has no delivery date, or when a renewal customer has not been reached by the planned date.
Keeping it up to date
- Remove a line that never triggers an action for a month, and add one when a repeated problem is not visible on the sheet.
- Review your trigger limits each quarter against what actually caused trouble.
- Keep the daily sheets for the period your CA or the law requires, since they support the figures in your records.
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 →