Free Excel template · 50 editable rows
When a complaint is passed between a busy inbox, a phone call and a shift handover, the next promised update can be easy to miss. A simple log gives the team one place to see who owns the issue, what should happen next and whether the agreed action has actually been completed.
The Happy Customer complaint log includes a blank 50-row tracker, priority and status drop-downs, and three fictional examples. Download it, save a working copy in your organisation’s approved secure system and adapt the columns to your process. The log is a starting point: it does not replace your full case record, automatically send reminders or decide whether a complaint has been resolved.
Download the free Excel complaint log
What the template records
On a narrow screen, scroll the table sideways to see every column.
| Field | What to enter |
|---|---|
| Case reference | The identifier that helps authorised staff locate the full record in your approved system. |
| Received date and channel | When and how the issue first reached your team. |
| Issue category and brief issue | A short, non-identifying description that helps you spot patterns. |
| Priority and owner role | The urgency your own policy assigns and the role responsible for the next action. |
| Status and next action | Where the case stands and what needs to happen next. |
| Next update due | The date your team has agreed to update the customer. |
| Outcome and evidence reference | What was completed and where authorised colleagues can find the supporting record. |
| Closed date | When the complaint was closed under your organisation’s process. |
The workbook has space for 50 entries. If you need more, insert rows above the footer, then copy the formatting and drop-downs to the new rows. The example sheet uses fictional cases, dates and roles; it is there to illustrate the workflow, not to set response deadlines.
How to use a complaint log
1. Record the case and allocate an owner
Create a case reference and record the date and channel. Add a neutral summary, such as “delivery arrived after the promised date”, rather than copying the customer’s message into the tracker. Assign an owner role that makes the next handover clear. Keep contact details and the complete account in the system your organisation has approved for that purpose.
2. Agree the next action and update
An owner should establish what needs checking, what outcome the customer is seeking and who has authority to offer a remedy. Record the next action and a realistic update date. A date in a spreadsheet does not send a reminder, so use your normal task or calendar system to manage follow-up.
If the issue involves a safety concern, vulnerability, a request outside the employee’s authority or another high-risk matter, follow your own escalation procedure. The workbook does not assess risk or replace specialist advice.
3. Check the action before marking a case closed
An agreed remedy and a completed remedy are different stages. If a replacement booking has been promised but not arranged, keep the case open and give the responsible person a next step. Once the action has been completed and checked under your process, record the outcome and an evidence reference, update the customer where appropriate, and enter the closure date.
For example, a fictional booking complaint might be marked Awaiting action while a duty manager arranges an agreed alternative. The log should identify the next update; the full details stay in the case system. A manager decides when the organisation’s closure requirements have been met.
4. Review recurring themes
At a regular team review, look for repeated categories, missed handovers or actions that remain open. Investigate the cause before drawing conclusions: a handful of complaints does not establish a trend or tell you how many customers encountered the same problem. Record an improvement owner and review date using the free complaint trend planner.
Protect customer information
Use the minimum information needed for the log’s purpose, restrict access and apply your organisation’s retention and security rules. A case reference can let authorised colleagues find the full record without putting names, contact details or sensitive correspondence in a shared tracker. The UK Information Commissioner’s Office explains the data minimisation principle; its guidance notes that it is under review. Your organisation remains responsible for assessing the rules that apply to its records and sector.
Help staff practise the conversation
A tracker helps a team follow the process; the conversation still needs judgement. Happy Customer lets customer-facing staff practise difficult situations with fictional AI customers and receive feedback. Company owners can try three challenges free. Employee training is available on paid team plans, starting at £99 per month for up to 10 employees, with monthly practice limits. See team plans and pricing.
For the process, response templates and other planning tools, visit the free complaints toolkit.