Why a complaint reaches the manager at all
There is one metric managers rarely discuss openly: how many complaints reach them personally each week. Not the system. Not the service team. You.
Every such email is a signal: there was a moment when the situation could still have been resolved. And nobody did. This is not a question of employee bad will. It is a question of the system.
In larger organisations, the complaint path upward often looks like this: the customer encounters a problem, contacts an employee, the employee has neither the authority nor a clear procedure to resolve it, the customer is disappointed — and eventually the message ends up in the manager's inbox or publicly online.
The problem is usually not that the employee did not want to help. The problem is that they did not know what they were allowed to do. That uncertainty — when the customer watches the employee go silent, make internal calls, or say "I need to check with the manager" — is the most expensive mistake in service.
"At that moment, the customer is not yet lost. But they are already counting."
The complaints management system — ready to use
The Excel system I use with clients. Not theory — a working tool built from real complaints-management practice in telecoms, banking and healthcare. Every euro is derived from assumptions you calibrate first.
Excel · 9 sheets · English
No registration · No email · Just the file
What is proactive complaints management
Proactive complaints management is the organisational ability to identify and resolve a customer problem before it becomes a formal complaint. It rests on three elements: employee empowerment, complaints data analysis, and a clear escalation procedure.
It sounds simple — and it is simple, when the system is built for it. Late delivery: the employee calls first. Produktas su defektu: komanda informuoja prieš klientui pastebint. Sutarties neatitikimas: atsakingas žmogus tai mato ir kreipiasi.
But this behaviour cannot be expected from someone who has neither the tools to notice the problem nor the permission to resolve it independently.
Does your team have clear authority to resolve problems on the spot?
Take the quick test and find out whether your complaints management system actually works — or is still waiting for the manager's approval.
Take the free testHow to build an employee empowerment system
One practical and frequently underestimated solution is to clearly define what each employee can do independently when a problem is legitimate.
An example that works across many sectors: the employee has the right to offer a discount up to a certain threshold — say, 10% — without additional approval, if the problem is clear (delay, defect, process error). Above that threshold — escalation follows a clear procedure.
This is not giving money away. It is an investment in resolving the problem at the right moment — while the customer is still talking to you, not writing a public review.
This system requires three things:
Clear boundaries
The employee needs to know specifically what they can and cannot do. "Use your judgement" is not an instruction — it is a transfer of responsibility without the tools.
A culture of trust
If the employee fears their independent decision will later be questioned, they will never use that authority. Authority on paper and authority in culture are two different things.
Data tracking
If discounts are being requested for the same three reasons month after month — that is not a service problem. That is a process problem that needs to be addressed at the root.
The complaint as a diagnosis
In larger organisations, department managers often present complaints as exceptions rather than patterns. "That was a special case." "The customer was difficult." These explanations may be accurate in individual cases. But when the same explanations recur every month — these are no longer exceptions. This is the system.
Complaints data tells you what surveys often do not — because the person complaining has already reached an emotional threshold and decided it is worth speaking up. This is not a random piece of feedback. It is a signal from someone who did not yet want to leave quietly.
Reading complaints systematically does not mean knowing about them. It means categories, frequency, recurring words. If for three months in a row customers mention the same stage — that is a diagnostic data point the manager can put on the table and say: here is the structural cause, and we are removing it.
The most common mistakes in complaints management
What to do tomorrow
Review last month's complaints as a data set
Look for recurring words, stages, situations. If three or more complaints mention the same thing — that is not a coincidence.
Ask your team: what stops you from resolving the situation on the spot?
The answer is usually specific: I cannot refund, I cannot change the deadline. That is your empowerment map.
Define one specific boundary the employee can resolve independently
Not "use your judgement" — but a specific scenario and a specific action. Start with one.
Create an internal complaints categories table
Every month — the five most frequently recurring causes. Against each: a responsible person and a deadline. That is the only way to ensure the same complaint does not return.
"A team with clear authority resolves problems before they become complaints. And managers receive fewer emails."
What's in the register
Most organisations log complaints. Few analyse them systematically — and fewer still check whether the corrective action worked. This file joins the daily entry, a cost model, a CAPA cycle and automatic analytics in one document. Nine sheets and three colours: blue columns are filled by the agent, yellow by the manager, grey ones calculate themselves.
Settings — the assumptions without which every euro is invented
Contact cost, annual customer value and churn probability by severity. Every other sheet calculates from here, which is why this one is filled in first, not last.
- The starting values (€12, €2,000, 1–40%) are assumptions, not your data
- SLA limits by priority and risk thresholds
- Until you calibrate, every COPQ euro is a guess carried to two decimal places
Lists — one place for the taxonomy
Departments, people, channels and the root-cause list. Change it here and every dropdown in the register changes with it.
- A single source for the taxonomy — nowhere to drift apart
- Replace with your own before the first entry
Register — the daily entry, about two minutes
The agent records what the customer claims. Whether it held up is a separate decision, in a separate column, made by a manager. An unconfirmed complaint generates no euros.
- "Customer claim" and "Confirmed justified?" are two different fields
- FCR, channel, process stage, root cause
- Risk score = Severity × Occurrence × Detection, with a severity floor
- Cost: direct damage + service cost + revenue at risk
CAPA — a correction is not a corrective action
Compensating the customer fixes the case. Changing the process is a different act entirely. They live apart here, because mixing them is how organisations spend years "solving" the same problem.
- A 5 Whys chain down to the actual cause
- Effectiveness check: closed only once the cause stops recurring across the monitoring window
- Closed ≠ resolved — and that is calculated, not declared
- Meets ISO 9001:2015 10.2.1 (d)
Dashboard, Pareto, Trends — they calculate themselves
Nothing to fill in. The only manual field is the manager's comment on the trends sheet.
- FCR, SLA attainment, COPQ, repeat share
- Pareto: which causes generate most of the cost
- Trends: month-on-month movement
Authority — who is allowed to decide what
The most common gap in complaints management: people do not know what they may settle on their own. This sheet drives FCR more than any training will.
- 10 scenarios, from a delay to a public complaint
- 3 levels: agent → manager → director
Get started in one day
The register is designed so you don't need training. Every sheet includes instructions.
Download and open
Works in Excel and Google Sheets. No installation.
Review the authority map
Adapt the scenarios to your organisation.
Start filling the register
Every complaint — a new row.
End of month — Diagnostics
Identify the 5 most frequent causes.