I have a Customer Complaints Log Sheet on excel. I have about 20 columns in there, including Customer, product type, problem type, root cause, general cause, process category, problem type, corrective actions, date when opened, date when closed, credit notes given or not, training for the operators needed or not. I log every single complaint on this Log sheet and I am updating every day.
I have filters on the top of it and I am able to filter what ever I need and whenever I need. The most important to update it every day and to log all the updates on each of the complaint.
The Management likes it so much. Also I do the Monthly Presentation on the Power POint, which I like to do, as it is very easy when you have all the data logged on excel.
I have pies on Power Point where I show the percentage of Customer complaints by Process (production, shipping, supplier problem etc), by type of problem (technical, production, supplier caused, Administration caused) by root cause (operator error, administration error, machine problem, material problem etc.), then how many we opened per month, how many we solved and closed etc.
I think it works perfectly as I can get anything I need, weekly, monthly, yearly etc. Now I have everything logged from 2011, so I can compare 3 years data and trend them.
Please see the attached excel Log Sheet, where I copied all columns.
I hope it is helpfull.