lamp.
ResourcesPricingAbout
3 min readBy

Complaint handling: daily operating review pack

This pack is a short daily meeting sheet for the person who runs customer service, or for the owner of a small business. In ten minutes it shows every open complaint, who has it, what happens next and which ones are stuck. It is for shops, distributors, clinics, salons and service firms where complaints arrive from several channels and are easy to forget.

When to use it

Fill it at a fixed time each day, ideally before the team starts outbound work. Use it every working day, not only when things go wrong. On a quiet day it takes a few minutes; on a bad day it shows which cases need the owner.

The template

Part 1, open complaints:

Complaint no.Received onCustomerIssue in shortSeverityOwnerNext actionDue dateDays open

Part 2, daily summary:

ItemCount or valueNote
New complaints today
Closed today
Open at end of day
Overdue against promised date
Waiting on customer reply
Remedy value approved today (₹)
Decisions needed from owner

How to fill it

  • Complaint no.: use the number from your complaint register so the sheet always matches it.
  • Issue in short: one line, in plain words, with the product, bill or job number.
  • Severity: use your own scale, for example high for safety, money or statutory data, medium for delivery or quality, low for minor service points. Keep the scale fixed.
  • Next action and Due date: one action per row, with a real date. "Follow up" alone is not an action.
  • Days open: count calendar days from the received date.
  • Waiting on customer reply: list these separately so they are not counted as your delay.

Example row

Complaint no.Received onCustomerIssue in shortSeverityOwnerNext actionDue dateDays open
C-01874 JuneShree TradersCarton of 40 units arrived with 6 damaged, bill 2291, ₹14,400HighMeenaSend photo to supplier, offer credit note6 June2

Review and sign-off

  • The service lead prepares the sheet, and the owner or operations manager looks at it daily.
  • Review daily, with a short weekly read of every complaint open for more than a week.
  • Escalate to the owner any high-severity case, any case past its promised date, and any complaint where the customer has threatened to stop buying or go public.

Keeping it up to date

  • Update the severity scale when a type of complaint turns out more costly than expected.
  • Save each day's sheet in one dated folder so you can see patterns later.
  • Keep the sheets for the period your CA or the law requires.
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 →