The Complaints and Customer Recovery Handbook
Sales · Nº 43
The Complaints and Customer Recovery Handbook
Public Complaints, Bad Reviews, and Angry Customers, Handled without Improvising
You think you get about ten complaints a month. Have you actually counted?
24 tools, a spreadsheet, and a phone repair shop as the example from start to finish, so every complaint gets logged, answered on time, and settled by the same rules.
You get 24 tools to map every channel where customers complain, log each complaint on one line, resolve it with a written policy and clear authority limits, find the cause, and track five numbers. Plus a 5-tab spreadsheet and 14 ready-made templates.
A book explains the method. This handbook puts it to work: the tool, a worked example, and a spreadsheet with your numbers.
One-time payment of $29.00. The order form shows the final amount, with any taxes for your country, before you pay.
Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.
14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.
Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.
It's 11 p.m. and you're scrolling through a one-star review nobody on your team mentioned. Earlier today, one employee gave a customer a discount for a late repair. Another turned down the same request an hour later. The customer from last month is back with the same problem. And if someone asked how many complaints came in this month, or what they cost you, you'd have to guess.
THE SPREADSHEET
Complaints spreadsheet
Use the completed example as a reference and enter your business data in the marked fields. Check the instructions and the calculations before you make a decision.
SOUND FAMILIAR?
Three situations this handbook solves
A complaint shows up on a complaint site
You open the log, give it a case number, and post a public reply within 24 hours, signed by the person in charge. The fix happens in a private message. You ask for a rating only after the customer says it's working.
A customer at the counter wants something back
Your employee checks two things: is this something the customer is owed, or goodwill? Then the policy table and their own authority limit. Inside the limit, it's settled on the spot. Outside it, it goes to you with the log line attached.
First Monday of the month, 8 a.m.
Thirty minutes with the dashboard open. The five numbers against the target, the category that grew the most and why, up to three actions with an owner and a date, and a check on last month's actions.
INSIDE
What you'll find in each tool
Five parts, in the order the work happens. First, find every place customers complain and set a reply time for each. Then log and classify every complaint, with triage within 24 hours. Then resolve by written rules, with a cap and an authority limit for each person. Then trace the repeat complaints to the process that failed. Finally, measure, add up the cost, handle a crisis, and win back customers who left.
WHAT YOU GET
Everything included in your purchase
- The Complaints and Customer Recovery Handbook in PDF: 24 tools, each with a step by step, a worked example, and a short exercise
- The Complaints spreadsheet in Excel and Google Sheets, with 5 working tabs (Channels, Log, Policy, Causes, Dashboard), filled in with the example
- The Template kit: 14 ready-made texts, from a public reply on a complaint site to the one-page compensation policy and the win-back message
- 2 worksheets to fill in (complaint log and device check-in), a final checklist, and a 30-day plan, one week per stage
- Access to your handbook on the Consylion platform
Full table of contents
The 24 tools, in the order you'll use them
Part 1 · Part 1 · Where customers complain
- 01Complaint channel mapEvery place a complaint can come in, who watches it, and how often
- 02Response time by channelA first reply and a fix date for every channel, from the counter to complaint sites
- 03Complaint sites from start to finishThe business account, the public reply, the private follow-up, and the four numbers to watch
- 04Complaints filed with official agenciesDeadlines, written replies, and hearings, with your lawyer brought in at the right moment
Part 2 · Part 2 · Log and classify
- 05Single complaint logEvery complaint from every channel on one line, with a case number and an owner
- 06Type and severityEight fixed categories and three severity levels that decide what gets handled first
- 07Triage within 24 hoursWhat's solved on the spot, what waits 48 hours, and what goes to the owner
- 08Entitlement or goodwillSeparate what the customer is owed from what is your call, before anyone offers anything
- 09Card disputesThe dispute notice, the deadline, and the documents that defend the sale
Part 3 · Part 3 · Resolve by the rules
- 10Compensation policy with capsWhat to offer for each type of failure, with a cap per case and per month
- 11Each person's authority limitWho can give what without asking, from the counter to the owner
- 12Warranty returnThe repair that comes back: its own queue, a 24-hour deadline, and what to do if it fails again
- 13Unreasonable complaintThe signs of a request that goes too far, and how to say no in writing
Part 4 · Part 4 · Cause and prevention
- 14Recurring complaintsRank the categories and find the few causes behind most complaints
- 15From complaint to root causeFive questions that take you from the symptom to the process that failed
- 16Documented device check-inA checklist, photos, and a signature that end the "it was already like that" argument
- 17Quote approved in writingPrice, deadline, and parts agreed before the work starts, with the customer's written OK
- 18Delay alertThe customer hears about a delay from you before having to ask
- 19Products and suppliers that cause complaintsThe defect rate that decides what comes off the shelf
Part 5 · Part 5 · Measure and win back
- 20Complaint metricsFive numbers that show whether the system is working
- 21The cost of complaintsRework, parts, discounts, chargebacks, and the owner's time, added up for the month
- 22Social media crisisThe post that spreads: the first two hours, who speaks, and what not to do
- 23Winning back lost customersA message, 60 days later, to customers who complained and never came back
- 24Monthly complaint meetingThirty minutes a month to review the numbers, the causes, and the actions
Who it's for
It's for you if
- Complaints reach you at the counter, by message, in online reviews, and on complaint sites, and nobody adds them up
- You've already missed a reply deadline on a complaint site, an official complaint platform, or a card dispute
- Your team hands out discounts on the spot, each person by a different rule, and you only hear about it later
- The same complaint keeps coming back every month and you want to fix what causes it, not just calm the customer down
- You run a shop, a service business, a distributor, or a solo practice and want one system for every channel
It's not for you if
- You want service standards and scripts for talking to an upset customer. That's The Customer Service and Experience Handbook
- You want an after-sale routine that gets customers to renew and refer others. See The After-Sale and Customer Success Handbook
- You're already in a lawsuit. The handbook shows when to bring in your lawyer, but it doesn't replace one
- You want someone to promise you a top rating or a badge. This handbook builds the system and measures whether it works
Frequently asked questions
I don't run a repair shop. Will this work for my business?
Yes, if customers ever complain to you. The example is a repair shop, but every tool shows how it applies to services, retail and commerce, manufacturing and distribution, and independent professionals. A shop logs exchanges; a distributor logs the buyer's emails.
I only get a few complaints. Is this worth it?
Yes, with less paperwork. Start with the channel map, the log, and the compensation policy. The handbook tells you to leave the category ranking and the metrics for when you've logged 30 complaints.
Won't logging everything make our numbers look worse?
At first, maybe. The log starts counting complaints that used to disappear at the counter and in messages. The handbook explains why that's a good sign, and which numbers really matter: reply time, time to resolve, and how many cases reopen.
Will my team actually log complaints?
They will if it's fast and you check it. The handbook keeps the log on the phone of anyone who serves customers, has you check the counter count every week, and puts the numbers on the table at the monthly meeting.
What about consumer rules in my country?
They vary from country to country, so the handbook doesn't pretend otherwise. It marks every point where a local rule matters, like official deadlines and personal data, and tells you what to check with your lawyer.
How much time does this take?
About 2 hours and 24 minutes of reading, or 6 minutes per tool, plus the exercises. After that, the routine is logging each complaint as it comes in, a daily look at upcoming deadlines, and a 30-minute meeting once a month.
What do I get, and in what formats?
Each handbook is a PDF of about 100 pages with 24 to 27 tools. Every tool has step-by-step instructions and a worked example. You also get the handbook's spreadsheet in Excel (.xlsx), which opens in Google Sheets too, with the example already filled in. The message, policy, and clause templates are in the Template Kit inside the PDF, ready to copy and adapt. Read it in the member area or download the files.
How do I know if it fits my business?
Each handbook's page shows the problem it solves, who it is for and who it is not for, the full table of contents, sample pages, and the company used in the examples. The examples come from small businesses in several industries, with illustrative numbers. If it is not a fit, you can ask for a full refund within 14 days of your purchase, as described in the Refund Policy.
What is the difference between a handbook, an area set, and the Series?
A handbook solves one problem. An area set brings together every handbook and spreadsheet in one of the 6 areas, for less than the price of 5 single handbooks. The Consylion Handbook Series brings together all 100 handbooks and 100 spreadsheets, for less than the price of 8 single handbooks, and includes the next handbooks in the Series. Products outside the Series, from Consylion Life or Consylion Business, have their own price. They are sold separately and are not part of an area set or the Series.
Do I need to read everything before I start?
No. Each tool works on its own. Open the table of contents, pick the tool for today's problem, and start there. You can also read it cover to cover.
Do I need to know Excel?
The basics are enough: open the file and fill in the marked fields. The formulas are already built, and the handbook's example is filled in for reference.
How do I pay, and when do I get access?
By card or bank transfer, as a one-time payment with no subscription. Once your payment is confirmed, you get access to the member area by email. Approved card payments are confirmed right away. Bank transfers are confirmed when the funds clear. If access does not arrive within 24 hours of confirmation, check your spam folder and write to team@consylion.org.
How long do I have access, and how can I use the files?
Access does not expire, and you can download the files for offline use. The license is individual. You may read the handbooks, print them for your own use, and fill in and adapt the spreadsheet and templates with your company's data. If you are a consultant, accountant, or manager, you may apply the tools with your clients and deliver the result of your work, not the files. You may not share, resell, or distribute the files or the access.
How do support and refunds work?
Support is by email at team@consylion.org, on business days, with a reply within 5 business days. It covers questions about access, files, and payment. It does not include consulting or advice on applying the material to your case. You can cancel within 14 days of your purchase, without giving a reason, and get the full amount back through the payment method you used. Send the request to the same email. The details are in the Refund Policy.
CONSYLION HANDBOOK SERIES
The 6 departments of your business, for less than the price of 8 single handbooks.
This handbook solves today's problem. The Series solves the next one, and the one after that, with nothing more to pay.
- 100 handbooks with 2,403 ready-made tools, to read on screen and download as PDFs
- 100 spreadsheets for Excel and Google Sheets
- 6 business areas
- Lifetime access, unlocked once payment is confirmed
One-time payment of $197.00. The order form shows the final amount, with any taxes for your country, before you pay.
Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.
14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.
Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.
Sales · Nº 43
Stop treating every complaint like the first one
Complaints will keep coming. What changes is whether you see all of them, answer on time, settle them by the same rules, and fix what keeps causing them. This handbook gives you the tools, the spreadsheet, the templates, a worked example, and a 30-day plan to set it up.
See all 100 handbooks · $197.00
One-time payment of $29.00. The order form shows the final amount, with any taxes for your country, before you pay.
Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.
14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.
Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.