lamp.
ResourcesPricingAbout
3 min readBy

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

MeasureWhat to enterSource recordAction triggerOwner
New enquiriesNumber received since last review, and how many have a named ownerEnquiry bookAny enquiry without an ownerSales head
Quotes waiting for replyNumber and total value in ₹, with the oldest quote dateQuote registerQuote older than your follow-up periodSales head
Orders confirmedNumber and total value in ₹Order bookOrder without a delivery dateSales coordinator
Deliveries and visits due todayNumber planned, number completed by eveningDispatch plan, job cardsAnything planned but not completedOperations head
Open complaintsNumber open and the oldest complaint dateComplaint registerComplaint with no reply yetService head
Money due todayAmount due in ₹ and amount received in ₹Receivables list, bank entriesPromised payment not receivedAccounts lead
Renewals falling dueCustomers due in your renewal window and who has been contactedRenewal calendarDue customer not yet contactedAccount owner
Customer escalationsCustomers who called or wrote twice about one issueCall log, messagesAny repeat contactManager

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

MeasureTodayYesterdayNoteOwner
Money due todayDue ₹86,500, received ₹40,000Due ₹52,000, received ₹52,000Balance ₹46,500 is from Gupta Hardware; they promised transfer by 4 pmAccounts 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 →